Forms

Running Apend,Delete and Make queries with VB
I have a macro that I run 4 difference query updates with. qrydeleteopencounts (Delete Query) qryMakeTableCYCDATECOPY (Make Table Query) qryAppendProductionMSList (Append Query) qryAppendFGList (Append Query) Is there a easier why to do this so I do not have the click "Yes" a dozen times while running this... 10 May 2010 14:21

Filter Form on Combo Variable
Hi, I am needing some help with the code below. It is not filtering what I need it to and not sure what to do. I have two comdo boxes that I have the user clicking on to filter the form. Dim strlistlookup As String Dim strstkidlookup As String strlistlookup = cmblistlookup.Value strstki... 10 May 2010 14:21

onKeyDown: ¿how to call my own function?
Hello everybody: Actual situation of my form: onKeyDown= "[Event procedure]" Desired situation: onKeyDown= "myFunction" I know that myFunction must be in a module, and must be public. But I don't know the syntax for doing this ! I want to call myFunction from a lot of forms in my application, so, I want... 27 May 2010 18:11

Run Time Error 429
Hi Guys, I developed an access 2003 program, is working fine in all stations but 1, I am getting a Run Time Error 429 – Active component can't create object, the error is in this command: Set db = CurrentDb This computer has installed Access 2003. I would really appreciate if someone may help me wilt this.... 10 May 2010 13:13

Baffled by missing data on printout
I have a bunch of subforms that the user will fill out from a main form. I then save all that data into a local table, then read it back from a report. The report loads the same subforms which reload the data. All that is working fine on screen, and on print preview. Then, when sent to a printer, all te text ... 12 May 2010 23:40

update cascading forms
Hi This has probably been asked a number of times but I couldn't find a resolution for my issue. I have a form that calls a second form. Form 1 displays the client information (name, address, phone) in view only. The 2nd form allows the client to change the information. The information updates correctly to t... 11 May 2010 12:18

Problem in a query with DLookUp
I have a query that take the Data_Nascita value from table Anagrafica. In Expr1 i calculate the value in year, no problem. Then i am tring to get the correct value of Categoria related to age value i have the problem. With this code a get always the first value in the table that is not correlated to the age calcul... 10 May 2010 07:41

MouseUP is firing when Form is Loaded
I have a bound listbox control on a form whose MouseUp event is firing for some reason between when I double-click the Form to load it, and when control passes to the user. I am *not aware* of anything going on in the code to cause this, and there is no call to the MouseUp event nor any class modules which hook... 10 May 2010 21:02

Can a DCount be done within SELECT DISTINCT?
I am attempting to set a filter on a subform using Filter and FilterOn. Below is the SQL for that subform. If I leave "DISTINCT" out of the SQL, the filter on the subform will work (no errors) but it does not return the records correctly. If I add DISTINCT back into the SQL statement then I get an error. Run-time e... 9 May 2010 16:31

How to add records to a subform from a listbox on a different form
Hi Guys, This is driving me insane..... Normally one would select products on an orders form from within a subform that is linked to OrderDetails, this subform being linked via its PK to the main form based upon Orders (say). I have way too many products, of too complex a nature to select in this way. So I ha... 9 May 2010 20:55