Search results

I am trying to open a form with a Where Condition. I am working in an ADP project, so I cannot build the query on the fly. I am trying to set the where condition on the Docmd.OpenForm code line to select the correct records. Here is my code: Dim strWhere at String strWhere = "[Tape_Number] >...

Works like a dream. Thank you :)

This should be easy but I cannot find anything on my following problem. I am creating a query to select records based on what users select from a list box. Here is my code: For Each intIndex In lstLongJobs.ItemsSelected If Counter = 0 Then strWhere = "Where...

My bad everyone and thank you for your help. The user just e-mailed me the database (I was only going off of memory before). In this database if you click on the "Details" button on the top of the DB window it hides all the icons. I am not sure how this is done, then when I click any of the...

Does anyone know how to hide the MS Access DB Icons within the database. I had an MS Access DB that when I held down the Shift Key to open it up, and the database window would display none of the Icons showed up. It looked as if the database had no tables, queries, forms, reports, etc. To get...

I only have MS Office (MS Access) 2000 installed on my machine. I will keep looking to see if I come across anything else, and if I do I will let the message board know. Thank you, T.J.

Thank you for your time, I am sorry I didn't explain that in the original post I have compacted and repaired the database a few times. After each compact and repair the error appears again (once it tries to open itself back up).

I have a large database that was created in MS Access 1997. When I tried to open the database with MS Access 2000, it said I could not make changes to the database because it was created in an earlier version, which is fine. Then I got an error that said "Disk Or Network Error", if I click...

I got a tough one here. I am creating a Labels report in MS Access. The users would like a button to click to export this report to MS Word and then in MS Word they can do what they need to do to work with the report. If anyone has any ideas about how to best start or work on this let me...

I am sure this is simple, but I cannot figure out how to allow the Export Dialog Box to open through code. The Import Dialog box will open by running the following code: DoCmd.RunCommand acCmdImport But I cannot find the correct code to open the Export dialog box. If anyone has any...

I have a table with a unique ID (auto number) field. The autonumber is not incrementing correctly. The table has over 550 records, but when I try to enter a new record the autonumber starts in the mid 90's (should be greater than 550). So I get an error of a duplicate Unique ID field value...

I never found a reason for this. I continued to work and research the problem and never found a reason that this occured. But I did find a way to fix the problem. I copied every single table, query, form, and module into a new MS Access Database and resaved the database and everything worked...

I have an MS Access database that is running ADO code to work against a SQL back-end. I have a form in which the users can delete records out of the database by clicking a button. My code runs correctly and deletes out the record as I expect, but if I either run "Me.Requery" or if I just close...

I am new to ADO so any advice I can receive would be very beneficial. I have code the runs correctly in DAO, but I am having trouble converting the code to ADO. On the click of a button I am updating a record into Table1 and then inserting a record into Table2. I have tried some code, and I...

Thank you very much for your help, using the System table allowed me to figure out a way to accomplish what the users requested. Thank you again. T.J.

I am trying to write code that will count how many tables exist in a database. If there are more than 5 tables, I would like to delete out the oldest table (according to the table create date property). Here is the code I have tried... Counter = 0 I = 999 Do While I >...

I have an MS Access database set up with a FE .mdb and a BE .mdb file. I want to add the ability to archive a table in the BE to a seperate database by the users clicking on a button on a form in the FE .mdb. Here is what I would like to accomplish.... User clicks a button on the FE .mdb file...

Thank you Thank you for your time on this, I will try it out and if anything else comes up I will post a new topic. Thank you again, T.J.

Thank you for your response. The database I am asking about has a MS Access BE .mdb file, and the FE .mde file is the file that is showing this error when the database is opened. Thank you again. T.J.

I have an .mde file stored on the network with several users pointed towards the .mde file. When one user in particular opens up the database they get the following warning error: "There is no object in this control" -OK- Once the user clicks -OK- the .mde file continues to open up and work...