|Microsoft Access Forum||customer service database by Catrina Jones: I have a customer service database where employees record transactions with customers and each entry is date stamped. I also have a table where users record their hours worked so I can keep track of productivity. Users have to log in using their ID and password. Here is what I want to do:
When users log in every day, I want more...|
|Microsoft Access Forum||Searching for specifics on queries by Felipe: I have one field where I describe some properties of the object (i.e. round shaped). I want to produce a query in which just objects with "round shaped" quality will appear. So I went to query, selected the field which contains this characteristics and as criteria I chose "round shaped", I press tab, then I go to the more...|
|Microsoft Access Forum||OLE s by Michael B: I followed the directions in lesson 6 and converted the pic from jpg to bmp. However, upon attempting to drag the bmp to my Form, it won't allow me. The bmp turns into a circle with a line through it and nothing happens? Any help? I even tried copy and pasting, but that only works in design view, than I get the same picture for all my records. I need each pic unique to more...|
|Access Calendar Seminar||I get the following error Enter Parameter Query by Gioia Heiser: I get the following error: Enter Parameter Query
on both the MonthlyCalendarF and MonthlyCalendarR even though I created an entirely new database and transferred your objects into my Access 2016. Can you please post the db code that works for Access 2016 more...|
|Microsoft Access Forum||Combo Box by Anamaria: I have a form we have created to keep track of contracts, which also means in the combo box for partners is a long one and from time to time we have new ones that need to be added.
My problem is it seems that I have maxed the amount of words I can put in the combo box..
Is there a way to make it unlimited so I can add whatever?
I was told I could change more...|
|Microsoft Access Forum||Add multiple recipients to Email by Gioia H: Hi I'm trying to figure out how to get a form to fill in email addresses from a ListBox. Is there a video that teaches that? Reply from Alex Hedley: I'm not sure which one covers it but I'm sure it has been
|Learning Access VBA Programming||Learning Access VBA Programming by Toporan G: 1.about the first topic, yeah, something like that, except for the fact that I would like to get A, B AND C.
2. about the second topic, what I'm realy interested in is getting a part of the document form one source, and a second part would be a collection of information. For example, let's say that I want to write a more...|
|Access Loan Amortization Seminar||Access 2013 by Alvaro Berrio-Caratt: Hi,
I am using Access 2013, none of the icons works, would you please advise.
Al Reply from Alex Hedley: Are these icons in the Ribbon?
Is this an Office 365 copy? Is it licensed or is there a red warning bar along the top? |
|Microsoft Access Forum||Managing Multiple Instances of a Form by Robert R: Can you open more than one customer form? Example---Im speaking to a customer, but then I get another call from a different customer. I want to "search" for the 2nd customer and have a new customer form open on top of the already open customer form Reply from Alex Hedley: Allen Browne explains it more...|
|Microsoft Access Forum||Microsoft Access Forum by Charles F: I'm trying to set up a counter as described in Expert 29. The name of the field I want to increment is 'rosteridnum'. It is a number field in my table 'ctramrsm-t'. The field is on form 'ctramrsm-f'. The set value code I entered in the Before Insert property of the form seems to save okay, but when I try to add a new member, I get an more...|
|Microsoft Access Forum||Calculate the data of Subforms under Datasheet Vie by Allen Z: Calculate the data of Subforms under Datasheet View of the main form.
I am learning Access on 599cd while designing a simple inventory management database for my company. I was wondering if there are any methods that I could, under the Datasheet View of the main form, to more...|
|Access Tip: Check a Form for Blank Controls||Access Tip Check a Form for Blank Controls by ted: perfect|
|Microsoft Access Forum||Requery by Robert R: I tried this does not seem to work....also put Me.Requery after the code suggested and still not working.....im putting in in the "clear listbox" code. So right after clear = ""....under that im putting in the code suggested and Me.Requery....I think its requerying the list box.....how do I requery the form from this button? Reply from Alex Hedley: more...|
|Microsoft Access Forum||Lesson 3 Collection Letters 3 Access Expert 6 by Tiziano F: I have repeated on my computer the instructions of the lesson.
After the setting of the Control Source to =Forms!LetterF!LetterText (ref.ce page 14 of the handbook), in the report I obtain the same letter repeated 3 times, that is the number of the records in LetterT.
I would expect this more...|
|Microsoft Access Forum||Crashing Form by David S: That worked, it seems. Thank you.|
|Microsoft Access Forum||F11 by David S: No thanks. It seemed that if I opened and then shut the vba window my code would work. So I wanted to do that automatically, but a debug/compile served the purpose.|
|iOS App for 599CD||App Test by Diane P: Hi Richard
I've been 'off' for a while but now back to continue my learning. If you are still looking for 'field testers' please let me know ? I have iPhone, iPad and can also access a few android devices too (depending on what your are short on testing results)? Reply from Alex Hedley: Hi Diane,
I'll add you to the list.
I'm looking at making an more...|
|Microsoft Access Forum||Budgets by Sally Day: Budgets- I have 12 months across the top and acct#'s down the side. I have a form to input salaries that go to an expense table. I want to calculate payroll taxes (.062 for Social Security) and save it to the expense table under a different acct#. This would have to include a running total because when the salary reaches a certain $ amount for the year Social more...|
|iOS App for 599CD||iOS App for 599CD by Alex Hedley: Build (1.0.9) has been sent out.|
|Microsoft Access Forum||F11 by David S: Can I force my form to open and shut the vba program. Alt and F11 opens the vba program and I can then close it in the normal way, but can I force my form to open and shut the vba program when, for instance, the form itself is opening? Reply from Alex Hedley: So you want the Form to close the VBA editor that you've manually opened? |