Recent content by bradleyhorn

Hi All, I got the message "you can only run one instance of the combo box wizard at a time" when trying to use this wizard. This happened to me before and I can remember how I solved the problem. Can anyone help? There is of course only one instance that is being run. Bradley

ssecca, No actually there are not records that meet the criteria. But then again because the form is a medium to insert data into this data table, shouldn't it return active fields that I can enter data into, existing data or not? This is the problem. The form looks fine (has labels) but...

Maybe there is a differnce between the SQL Server SQL and ACCESS SQL?

All the Boolean fields have a default, yet the form refuses to return any data fields. It returns only labels. Let me ask this. The way I return the related records in this form containing child records is to base the child form on a query. This query reads the "casenum" field from the...

The answer is yes, there are Boolean fields. I will set the defaults, give it another try and report back. Thanks, Bradley

Hi All, I am having some trouble with a linked form. This form(2) is opened from another form(1) which lends it the parameter called "casenum". The second tabular form should open up and show all the records with the related "casenum". Now when the form(2) opens up all the data fields are...

Thanks Ronnie.

I think I will just rebuild the forms on the new SQL-Server tables. Deadlines have me by the nose/neck. I know I can re-build what was lost in the coversion in half a day. So sad. Thanks for your help, Bradley

Thanks for the clarification. Much appreciated.

Ginger, The recordsource of the form is a query. When I run the query there is no data as it is an empty table. There is no white space under the query fields when it is run. I am not sure if there is a problem with the query or if it is just because there is no data in the table. The...

Hi All, In some tables brought over from Access into SQL-Server I have some auto number fields. They were brought into SQL-Server with a datatype of Int, length of 4, precision of 10. Since the length is 4 does this mean that there are only 10,000 possible values for this auto number field...

Hello All, I have several Tables I just brought into SQL-Server from Access. When I open up the Access forms that report to the new tables, they have labels/headers but no active form fields. What are the possible issues here? Is it something about the database? Or the Form? Bradley

Thanks Denny. Worked like a charm. Bradley

Hello All, I have some tables that I have brought over from Access into my SQL Server Database. The Autonumber feature doesn't seem to have translated over to the SQL database for some fields. How can I take the existing SQL Server tables and add an automatically supplied number to individual...

Matthew, Thanks for your story. I was thinking it was some sort of Access problem as I couldn't fix it in the larger SQL database with enterprise manager. I ended up doing was deleting all the records that were locked, in SQL query analyzer, and recreating them later. My job was not so hard...