Recent content by knulisch

I figured it out and wanted to answer in case it ever happens to anyone else. I had the Allow Edits property on the form set to No - changed it to Yes and it would allow me to highlight records in the listbox.

I put a listbox on my form and pointed it to a table (using the wizard). However, when I run the form the data shows up but I cannot highlight anything - it stays on the first record and just outlines it. What am I missing? Thanks

I have a button that opens up the query area from my app using the following code: DoCmd.SelectObject acQuery, , True when I click the X on the query window to close it down it closes down the entire app instead of just the query window. How do I prevent this? Thanks

Thanks VicM - that worked great!

My form is not displaying the Min/Max or Close button at the top. I have the Close Button property set to Yes and the Min Max set to Both Enabled. Is there some other property I could have set to override these? There is no code written to turn them off. Thanks

Thanks for your help - I will probably try to get away from the DSN's. Is there a standard connection string that I should use for multi-user access?

It is shared.

I can run the app by itself on both PC's (actually more).

The database is located on a server. The ODBC System DSN points to that mdb on the server.

I am having a multi-user database problem with an access my VB6/Access 97. Via ODBC, I am using a System DSN with a Microsoft Access Driver called "judge". In my ADODC control on the form, I have the Connection String pointing to the ODBC judge. I have the CursorType set to...

I am having a multi-user database problem with an access my VB6/Access 97. Via ODBC, I am using a System DSN with a Microsoft Access Driver called "judge". In my ADODC control on the form, I have the Connection String pointing to the ODBC judge. I have the CursorType set to...

I have two tables linked by an id field. I would like to create a query that updates a field in the first table when the count of items in the second table (for that id) is > 25. Can someone help me out with this syntax? There is a one to many relationship between the first table and second...

I have a form with an SStab control that contains two tabs. If the user clicks on Tab2 while they are entering data on Tab1 I ask them if they really want to go to Tab2 (cancelling updates) or stay on Tab1 and continue updating. My problem is I cannot make the program stay on Tab1. Is there...

I am having a problem with cancelling an update on my form. My form consists of two tabs - a list tab and an edit tab. The data for each tab is driven by the same recordset - the difference being that the list tab is just a datagrid of all records in the recordset and the edit tab shows them...

I have the following formula in my report in order to concatenate two fields (the wine type field will always have a value, the other designation field may not). Sometimes the field will not print any value even though there is a value in the wine type field. Am I missing something? Thanks...