Search results

Have you tried... Me.[cboTapeNbr] Otherwise if you use the full name i.e. Forms!YourFormName.cboTapeNbr

Is there a reason that you don't want to use the subforms? If you reference them correctly then you should be able to do what you want using them. If you're confident w/ your VB then I'll give you some suggestions, but to describe exactly how to do this using VBA would take too long. Declare...

This is the query that I'm using... "SELECT DISTINCT TOP 9 t.Category FROM tblMenu AS t LEFT JOIN (SELECT DISTINCT TOP 9 Category FROM tblMenu ORDER BY Category) AS q ON t.Category = q.Category WHERE q.Category Is Null;" It's the same as the previous query w/ different fields, table names and...

Thanks for the help, Pat. I'll give that a shot.

Hello everyone, Using a UNION statement, can I retrieve records that are mutually exclusive in each SQL statement? Something like this, but where all records are returned, but the TOP 5... SELECT Products FROM tblProducts '<<returns all products UNION SELECT TOP 5 Products FROM...

Thanks for the help, Nouba. It's amazing the level of complexity that can be applied to SQL. Pretty Smart. I should be able to get it to work from here.

Hello, If I use a TOP 10 query to get the top 10 results from a table, can I somehow retrieve the next 10 results in the list w/o too much trouble? I could count the records and then use a TOP "whatever" percent, I think. Is there any easier way to do this? I can't seem to find the answer. Thanks.

try at the end of your commandbutton code Me.YourFieldName.Setfocus HTH

I've tried the following code, but it gives me an error that MS-Access cannot add, delete, ...the control. Can someone direct me to the Reference that I'm missing here? code.... Dim cmdTest As Control DoCmd.OpenForm "frmTest", acDesign Set cmdTest = CreateControl("frmTest", acCommandButton...

try... [Forms]![frmTracking]![cboActivity].Column(1) if that doesn't work then try... [Forms]![frmTracking]![cboActivity].Column(1, 0) For this to work, the combo's properties must be set up to show 2 columns. For more info. search in help under column. HTH

Hello all, Can someone give me direction on how to create command buttons by using VBA? I would like an interface where buttons are based on the values in the tables. I can access the tables with no problem, but I can't figure out how to create the buttons on the fly. Any ideas or sites that...

I wrote a longer response last-time, but deleted most of it while I thought I was rambling. Thanks for your guidance, John. You seem to speak my language. You're right, in that, the subform's "re-set" is a built-in response to the mainform's recordsource requerying. I've got a solution that...

look here... http://support.microsoft.com/default.aspx?scid=kb;en-us;208778

Combo requery after change You can put the following code in the Combo's OnChange Event... Me.Requery Since it refers to itself, you should only need the above... If it doesn't work, then try the full name again.

When you reference a subform, you must include the name of the MainForm that houses your SubForm. I know it's confusing, but it's logical. Make sure that the names are the actual names you have given your forms. See prior post

I'm sorry.... I didn't see you had a subform.... Reference the subform control by.... Forms!YourMainFormName.YourSubFormName.Form.YourComboBoxName.Requery

you need to replace YourComboBoxName w/ the actual name of the combo(click the combo...view properties...Name) if that doesn't work use a full reference... Forms!YourFormName.YourComboBoxName.Requery Try that....

You could put the following in the Form's OnCurrent Event.... Me.YourComboBoxName.Requery HTH

1.)Both form's recordsources need to have the EmployeeID included. 2.)When that's done, you can drop your subform on your mainform and Access should find the common EmployeeID link. Since that doesn't seem to be happening, you may need to adjust the forms' recordsources. If your subform is...

Set the combo's Allow AutoCorrect property to Yes.