Search results

Yes and I get error 13. Type mismatch. MenuItemID is number and MenuItemForm is text. I want it to find the text that is associated to the number in then table.

It fails on this line. Set rst = db.OpenRecordset("SELECT MenuItemForm FROM tblMainMenu WHERE [MenuItemID] = '1'")

If I remove the "single quotes" I get error#13 Type Mismatch.

Hello, I seem to be a little crazy right now and cant figure out what is going on in my code that is messing everything up. I'm trying to open a recordset and pull a value in a text column based on the value in a numeric column and I'm getting "error#3464 Data type mismatch in criteria...

What about acSetToFront? Can you use that to call windows to the front to make it look dynamic? If so, what would the command be?

No I'm not. I'm asking if anyone knows of a way to set a listbox to have a dynamic submenu. IE. You click on an option in a listbox and in the same listbox a sub list expands or contracts.

Is it possiable to have a listbox that has a cascade in it? For example: [+]/[-] When you click on an item in a listbox a sub list appears in the same listbox under the item you just clicked and tabed in a bit? Thank You. Keith

Ok. I figured it out. I used the tabledefs to list the names and then wrote an if statement to exclude the tables I did not want it to check and the system tables.

I have an archive section for a split database. The archive copys some of the tables to an external archive database. I want to be able to run something afterwords that cycles through all of the tables copied and compaire the record count from the FE table to the archive table to make sure they...

Hello, I don't know if it's possible but here goes. I have a function that list's all the tables in it's database. I want to take that list and turn it into a record set so I can add it to a veriable. "ie. table1, table2, table." "rs.recordset.next" Or something like that where it will assign...

Hello, I don't even know if this is even possible or not. I have a create query button and a listing of all the quiries and what I want to do is somehow have the new query list in the available queries list so that it can be selected and altered. I'm not really sure on how to do this or if...

I have to databases. When the main database opens it imports a table from an external database for the users options and security and deletes it when the database closes. I have a form that the user can change some of there options and want an on close it updates the options in the external...

The database is getting to an ouragous size with all of the data in the tables (Over a gig) I don't want to link them because it will just make it bigger. I'm wanting to have the PROD database archive the tables, check them to make sure they were archived correctly and then delete the data in...

Hello, I’m back again. This time I want to compare two tables in two different databases. I have an archive database and I want to make sure that both tables are equal before I delete the information from the production databases table. I’ve been looking around and have been finding that I...

Am I suppose to change any of that as it pertains to my database because when I put that in it was just blank? Here is the module I was trying to use. Function ListQueries() As String Dim strList As String Dim obj As AccessObject For Each obj In CurrentData.AllQueries If Not...

Hello, This is an intresting one and I don't even know if it's possiable so please bear with me while I try to explain it in the best way. I have a form with a combo box that list's a list of queries that are stored in a reflist table. The EU can choose one from the drop down list and...

Would you be able to tell me that the SQL to that would look like?

Hello, Pretty much what the title says. I can use SQL to create a column in an existing table but just can't get it to populate the date and time in that new column. Here's my code: Function AddtblDate() Dim tblname As String tblname = "2006-12 Demographic Table" strSQL = "ALTER TABLE [" &...

Hello, The title says it all. I don't know if its possable but im trying to output from a table to a text file but I want the table's columns on individual lines and no headings. For example: I have a table that has two columns A and B. This table will only ever have on record in it at any...

Is there not a different way? I would rather the EU be able to browse for there folder because its all networked and very few people actualy know correct paths.