Recent content by Tobasco1136

I have a database that I inherited, that doesn't have a good method of allowing me to track records. It has 150 records in it and what I want to print on a report the coresponding record number to the event. For example, if I want to work on record 15 of 150, how can I capture the #15 and put...

ok, I finally figured out what the issue was. Thanks for your help.

Ok, I finally figured the subreport out and built it. However, when I run the subreport, it asks me for the txtSumCount that I added into the details section. I know the txtSumCount in the footer works though.

Where do I put this totals query? I'm really new to access.

I am trying to put a count of how many records there are on a report. Title Count Dr 100 Mr 50 Mrs 45 Ms 5 I want to display the total count in the Header. Total Count: 200 which is a total of all of the counts. I tried an unbound text box stating...

I logged on with several users id's and passwords and they all had the same issue. I ended up recreating the file and everything was working. I still don't know why this happened, but I learned a valuable lesson to not only back up the database, but everything associated with it.

I have an Access 97 database with numerous groups set up for security. I had a user complain this morning that they no longer have access to a form that worked fine last week. I checked all the permissions and everything seems fine. I wonder if the .mdw is corrupt. Is there anything I can...

I just tested it the database after making your suggestions. I repaired then compacted it and it stayed steady at 19mb. Like I had said, it was growing to 30-40 mb just by running a report or two. Thanks for all of your help. I don't know what I would do without Tek-Tips.

This is a new database and should only be around 10 mb, however, as I run reports it has grown to 39mb and I want to make sure it doesn't continue growing at that speed. Also, it is the slowest loading database I have.

I have repaired and compacted and that helped a little, but I am hoping to stop the bloat. I replaced the Me.Recordset.Clone with Me.RecordsetClone and the compiler went past that, but got stuck on "Option Compare Database." Again, I don't know what that means. Here is the module...

I forgot to add that this is Access 97. I developed it in 2003 then converted it for another user. Here is what I found checked (I don't know anything about them though): Visual Basic for Applications. Microsoft Access 8.0 Object library Microsoft DAO 3.5 Object Library

I don't know anything about VBA, but I am having an issue with the size of my Access DB growing by several megs each time it is accessed. I read an article about trying to recompiling it. I finally figured out how to do that, but I get the following error: "Method or data member not found."...

Does anyone have a good template they use to gather requirements to develop new databases?

I don't know enough about Access to fix this issue. Is there something I need to do in 2003 before I convert the db to 97? It seems to mainly be an issue with the switchboard, but I don't know what to do now.

I developed a database in Access 2003 and then tried to convert it to Access 97 for users that only have that version. I have done this before and it worked fine. However on this current database, I get the following error: Compile error: Method or data member not found. It seems to hang...