Search results

THANK YOU! That's what it was. When they re-imaged my machine, I forgot to go back and re-install the Gif89.dll. Since I didn't have any animated images on this one, I didn't think it was important. Now I know differently!! Thanks so much for your help!!

:confused: I had my database working wonderfully....until they re-imaged my machine yesterday. Now I am getting errors whenever I try to run any of my reports. The reports contain a line of code that pulls the Between () and () dates from the query and prints them on the top of the report. The...

I'm sorry to keep bugging everyone, but now that I have the basic design of my database, I want to keep making it better. I found some code on another site to make a form that you enter a password into to either open a new form (if correct) or return an error message (if not correct). I am...

Ok, it worked the first time. Now, whenever I submit the record and go to next it doesn't in this one field only. Here's what I have: Combobox (ID#) set to drop down on "got focus" some other boxes of info that are working fine an invisible submit button that is set to go to new record, go...

THANK YOU!! I knew there had to be a way. I just wasn't looking under the right things. J.McCaul

Thank you, but I need it more spelled out than that. I am still learning. If you can see it in your heart to help a newbie, then please give me more specifics. Thanks!! J.McCaul

I am currently using a parameter query to select beginning and ending dates to run reports and queries. I would like to get a bit more sophisticated and use a calendar on a form to make it easier for others to use. How do I connect a new calendar form to the query so it pops up when prompted to...

Is it possible to have the list box portion of a combo box always expanded, not just when you click on it? I have set up a form with a combo box that has three columns (last name, first name, id#), when you start typing in last name, it fills in matching the name on the list, but since it...

Go into properties for that field on the form. Under Row source, it should show where the data is coming from. If you click the three dots to the side, it will open up a window that looks like a query. It is actually something to do with sql (don't ask me). Change the sort properties for the...

THANK YOU!!!!! This works and seems so simple. J.McCaul

Thank you, but I think that creates a whole new problem. If I sort that way, all the people that received that service would be listed, but they would be listed for each service so when I went to total them it would still be counting duplicates. I need to leave it sorted by ID for other reasons...

PLEASE help me. I just can't make this work. I have read at least 4 books on Access and can't find anything to help me. If anyone has any ideas please let me know!!

I am having trouble finishing up the design for a report. I need to count total number of individuals who received a service. The problem is that the person could have received service in one or more areas. I have it set up now as =Count[ID], but that is counting the ID of those who received...