Search results

I don't post on these forums often, but I'm on here searching through all the great questions and answers listed here all the time. I just wanted to send out a great big THANK YOU to all of you who support this forum and take the time to offer your knowledge and wisdom on building better Access...

I don't post in the forums often, but I search through them for help on a regular basis, and I always find the answer I'm looking for, and learn new ideas along the way to finding my answer. I just wanted all of you who contribute to this forum to know how very much I appreciate all you do to...

I'm sure I'm just missing the forest for the trees here, but I'm trying to make a utilization report from the attached data with the following criteria. I need the parent level to be sorted by the Home Dept Descr and then by Full Name. This is like a utilization report to determine how many...

I'm building a company phone directory in Access to make updates/changes easier (since they previously spread it over 8 Excel spreadsheets *aack*). I have a table for employees, one for phone numbers, and one for location information. Some employees have multiple phone numbers, and some phone...

I put a command button on my main form, and want it to pop open a (sub)form with data that is synched with whatever record is currently displayed on the main form via an unbound text box. In my software inventory DB, the main form data pulls the Manufacturer's name. From there, I link the...

I put a command button on my main form, and want it to pull up a "sub"form with data that is synched with whatever record is currently displayed on the main form via an unbound text box. How do I do that? If you need me to attach any specifics from my DB, let me know. -Jessa

None of the Access VBA help files are showing up within Access help. Instead I get an error message that says to check to be sure they were installed properly. I checked and double checked that all the needed links to help files were installed correctly. I even uninstalled and performed...

New problem. I'm trying to display the fields & field info (not records) within my table, but when I run it, I get the error message "Run-time error '3021': Either BOF or EOF is true, or the current record has been deleted. Requested operation requires a current record." See following: Sub...

This is the code I took directly from a book I'm learning VBA from, and when I run it, I get a "Compile Error: User-defined type not defined" on the second line - "Dim Table As New Table", as well as any of the lines with "ADOX" or "ADODB" on them. Sub CreateTable() Dim Table As New Table...