Search results

I am a little stumped and could use some help. I can find my way around Access 2000 alright, but recently I have been moved to a new department and they have 97. I can not as easily create and debug the things I want in the database. I am hoping that someone can help me see the forest through...

I have been reading threads about archiving and cloning but I am still lost. What I have are multiple tables, each with questions for a specific application. I need to find a way that users can copy a question from one table to another. Previously users would copy and paste directly in the...

Every morning I back up my databases and compact and repair them. The last few days, my backend has been giving me this error: "Microsoft Access can't delete L:\KEYSupport\Maintenance Agreements\KTBackEnd.mdb after compacting it. The compacted database has been named...

I need reference books! I have been crowned the "Access Guru" at my office only because I know more than any of them, which doesn't mean much. We had a fairly simple database that 2 or 3 people were using at the same time. It houses client data regarding their equipment and support status...

Help! I am trying to educate myself as well as my co-workers on how to use this database without corrupting it. What we have is an Access 2000 BackEnd with the data linked to an Access 2000 FrontEnd with all the queries and such. Just now one of my co-workers had the main form opened to a...

What makes library references disappear? We have been using this particular database for a while with no major problems. Then yesterday, of course after I left for the day, a user recieved a VB compile error - can't find project or library. We have run through this code every day. Why is...

Somebody please help me. I am getting errors when opening my database that says it is not a database format and needs to be repaired. I seem to be gettting it more frequently lately as well. Here is my situation: I have 3 databases. One backend with all the data that is 25.7MB. One...

Help. My main form has a tab control of 4 pages, each with a form and subform. I added me.requery to the timer events of each main form of each page. The requery works but when it runs the user is sent back to the first record. I don't want that to happen. This is my new code: Private Sub...

I am confused on what my Val() expression is doing in my query. Can somebody try to explain this to me please? My database imports a text file and convernts most of that data into values. I have a query that has two identical expressions of Val([Calls]) where Calls is a text field and they...

I just began receiving this message when I run my database: "Cannot find the file 'L:\KeySupport\Certifications\Stats.mdb' (or one of its components). Make sure the path and file name are correct and that all required libraries are available." I have run this database just fine for at least 6...

I am trying to create a "TripID" with the area of the trip and leave date. For example, say you are visiting the West on 7/5/02, I would like the TripID to become West070502. I have tried DatePart("dd",me.BeginDate) and I get this error: Run-time Error '5' Invalid procedure call or...

I have a make table query that pulls records from Table1 to Table2 based on criteria given by the user. The user updates those selected records in a form. I originally had a select query that prompted the user, but when I added code to the form to refresh it, the user was prompted for the...

What I would like to do is update one record in a table with a field in multiple records of a different table. Let me try to explain. Table1 contains 100 test questions with each question being a different record and having an unique ID number. (The info for this table is input with a...

I have a database that creates a test based on criteria selected by the user. The second portion of this database keeps track of employees, when they took each test and what their score was. There are 17 tests each employee will take. And, each employee can take the test a maximum of 4...