Search results

If your Popup form is named 'Popup' then this code will open the popup at the correct record: DoCmd.OpenForm "Popup", , ,"[EstadiaID] = " & Me.EstadiaID I have assumed that EstadiaID is a number... hth, Jack

Hmmmm. It is hard to know if your tables are normalized or not, but if sounds like you should have a table for Doors and a lookup for the type of door it is. And the 12 options should be a look up as well. Without seeing your tables it is hard to know if you have them properly normalized so it...

Hmmm. Why do you need to create a temporary table? Can't you use a query as the Record Source for your subform? It just seems like you are going to more work than you need to.... Jack

tblMain EstadiaID (PK and Autonumber) Descontos MemoField ...Other fields... tblSubTable SubTableID (PK and Autonumber) EstadiaID (FK long integer) ...other fields... Do not name the Memo and Yes/No fields with the same names. The subform will automatically assume the correct Foreign Key when...

Are you sure your links are correct between subform and form? Can you add data directly to the related 'many' table? (I assume the relationship between your main table and Bldg and Door tables are one to many.) Also, tables Door1 and Door2 sound like they should be in one table called Doors, or...

If Me.ControlName = Me.ComboBoxName Then MsgBox "You have already selected " & Me.ControlName End If ControlName is the name of the control on your form that has the value that you want to enter from the combo box. Also note that 'function' is a reserved word in Access and you should not use it...

Create your database as you normally would. When it is finished use Tools > Database Utilities > Database Splitter to split your database into Tables (backend) and everything else (frontend). Search Access help for more information on the advantages, etc. of a split database. hth, Jack

I am not sure how the subform figures in but code like this in the After Update event of the list box will put the value selected into a control on the form: Me.MyControlName = Me.MyListBoxName Change the names above to the actual names of your control and list box. hth, Jack

You are welcome. Continued success with your project... Jack

Try this: Me![txtResponse].Visible = False Me![cboResponse].Visible = False Select Case Me![QuestType] Case "Text" Me![txtResponse].Visible = True Case "Select" Me![cboResponse].Visible = True End Select hth, Jack

Pat - Thank you for that valuable piece of information! Jack

The relationships are in the back end. They should not have changed after splitting and you do not need to make any changes to them in the front end. hth, Jack

Create a combo box on the form using the Wizard. On the Wizards first screen select the 3rd item, "Find a record..." Finish the Wizard. Now you can start typing in the number you want and when you find it that number and the description will be displayed in your Text boxes assuming they are...

If you have Access2000 or above you can compact on close by selecting Tools > Options > General and checking Compact On Close checkbox. Access97 does not have this ability... DoCmd.GoToRecord, , acNewRec will do the trick in the code that you use to print the record. hth, Jack

I am not sure why you are mixing Excel and Access, but be that as it may I would suggest that you use only one table for accounts. I do not see a reason for multiple tables... tblCustomer CustomerID (PK and autonumber) LastName FirstName ...other fields... tblAccounts AccountID (PK and...

If you have tens of thousands of compounds then there are ways to still use a combo box. If you only have a few thousand then when the user starts to type the compound into the combo box it will automatically go to the first record it finds based on the character your user enters. The more...

I am glad you got it working!

In your table of compounds you can add a Note field where you will add the notes you want the user to see if they select that compond. If you used a combo box to display your compounds for your user to select you could have code like this in the After Update event of the combo box: If...

It looks to me like creating a new Table is the only way you are going to find out if that is the problem. You can try copying the table, but it should not take long to rebuild it from scratch. Once you have it working you should be able to copy any data over from the old table to the new...

If you validate the users input in either the Forms or the Controls Before Update event you can pop up a message using MsgBox to tell the user what they did wrong. Place the cursor in the Before Update event and press F1 for some basic code to validate the input. hth, Jack