Search results for query: *

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...

Mph1, That is the error message that I am refering to and the buttons are on the error alert. I am not sure you understood. The records are locked and I need to unlock them. There locking was created by using the old (well functioning) form to try and update records stored in a new...

Hi All, During a forms rollout some of my users used an old copy of a form on a new datatable definition. The old form works fine to make new records but there are issues when they go to update old records. Those issues include locking the records they tried to update. The Error/Lock message...

Should I do an update query that sets all null fields equal to "Some Value" before making the field required at the DB level? Bradley

Hi All, I have a form in which I have added new fields. I have also added new fields to the underlying DB table. I would like to make the fields required. How does one make a field required at the form level? Should I create a message if the form field is null? Or will the database accept...

Final resolution = put the stuff you don't want to repeat in the header or footer of the report. Rookies' mitake. Thanks for the help!