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

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

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

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

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

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

Hi Y'all, I have a brainteaser. My(single line) Access Report prints the single line over and over into several pages. I would have expected it print only one line of one page. The "report design view" shows only one field and a label to print. The "Report Prieview" and printing process...

Hi All, Minor snafu. Have you ever inserted a field into a report, in "Report design view" and it shows up (unwanted) several times in the "Report print view"? There is only one instance of the field in Report design view. What is going on here? Bradley

Hi All, I have a brain teaser. I ask the user fill in a date and then several fields in the form auto-fill with code similar to: =[Forms]![SomeField]![Date1]+30 Since I have entered this code into the "Control source" property, it does enter the future date like I want it to, but doesn't...

I want to add a field to an existing form. This field is from a different table than what the rest of the form is based on. Is this possible? There are many drop down choices that would be dicey to rebuild so I don't really want to go back, make a join-query and build a new form. Thanks...

Hi All, I have what seems to be a simple question. I would like to call a form from another form. The two underlying tables are related by a field called CASENUM (foreign key.) How do I get the opened form to open with the data from the CASENUM in the calling form? I have commited the...

Hi All, I have curious problem. I have inserted a hyperlink inside a form which calls a report. When the report is generated it remains in the background (behind the calling form.) How do I bring the report to appear in the forground, in front of the calling form? I looked at all the...