Search results

You get these symptoms if your app was closed whilst code was suspended for some reason. If this is what's happened, you won't be able to repair the app and just get the same "Connection lost" message. A sure cure, but a total pain, is to copy each form, query etc from the broken app into a...

I love combos and use them all the time to do what you are asking. I should tell you that I never use bound forms. To do what you want, have 2 or columns in the combo (I usually have 2) with the first column hidden. The first column contains the key field in the underlying table, the second the...

The Microsoft site may well have some samples. There is also a sample in Access help. If you can't find anything, come back to me and I will post a connection string I use.

Simple really, and you don't need an If clause. Private Sub List1_AfterUpdate() With Me.List2 .Visible = False .Enabled = False End With *********** If you want you could update your underlying tables and clear the form from here End Sub Private Sub List2_AfterUpdate() With Me.List1 .Visible...

Hmmmm, I obviously didn't explain too well. The first combo is based on a table of main categories: Fields in tblMainCats: CatNo (Key to table and first column, which is hidden in first combo), CatName (Second column in combo) Have a table of sub categories with SubCatNo,SubCatName,MainCat...

How about if in the AfterUpdate or OnChange event of each list box you hide and disable the other one? Your user simply cannot select both then.

I think the answer is Yes and No :-) If you hard code a connection string with a valid login to the ODBC source included, it doesn't matter who the user is because the security system will see the connection as being from a valid user.

I'm sorry I don't have time to look at your app but I assume that you have a table somewhere that records how many times your client has looked at whatever. A "Count" field. I would work along the lines of having the Count field of the main category being seen incremented in the AfterUpdate (or...

Hope you will forgive me but I think I would approach this in a different way. As I understand it you have 20 categories. Why not have a combobox on your main form holding the 20, based on a table rather than coded into the control so to allow for easy future development. The AfterUpdate event...

What you could also do is to create your temp table with ADOX then use an INSERT INTO SQL clause to export the required data directly from your source table into the newly created temp table. Admitted that the SQL code needs a bit of work but once you get it right the process is very quick...