Search results

thankyou...this will help a great deal!!

yes there is a lookup feild "items" which originates from the products table

Sorry for my lack of terms… I have a table “purchases” that contains a lookup field. The lookup field displays the field “upc” from the table “red”. “id” is the primary field in the table “red”. The lookfield “upc” should only be able to except the values greater then 10 but less than 100. Do...

it doesnt work due to type conversion failure...the field is a memo.

i would like to update a field in my update querry to clear its data...i tried NULL in the update to but it didnt work.

i have tried this code both in the on load of the form and the after update of text25...the option buttons are always disabled.--and the enable property of each option is yes Private Sub Text25_AfterUpdate() If Me.Text25 = ">0" Then Me.Option7.Enabled = True Me.Option19.Enabled = True...

im trying to activate four option buttons after the user has inputted a number greater then 0 in the quantity text box. can some on help me with a after update code for the quantity text box...or is there another way?

THANKS GUYS!!! excellent info...for all others this is what i did Private Sub Command98_Click() On Error GoTo Err_Command98_Click Screen.PreviousControl.SetFocus DoCmd.OpenReport "invoice", acPreview, , "[event.id] = " & Me.[Combo2] & " And [client.id] = " & Me.[Combo0] & " And...

so i have a code to export a print preview of a report...i want to cahenge the code to export the specific report...the code is Private Sub AddDeleteEmployees_Click() On Error GoTo Err_AddDeleteEmployees_Click Screen.PreviousControl.SetFocus DoCmd.OpenReport "invoice", acPreview, ...

works like a champ!!! thanks a bunch!!

i have a report based on a queery. i have a form with 3 combo boxes and a button. i select info from combo boxes and hit the button...the form loads with filtered data. the on click for the button is as followed---please help me fix the code...i think it has to do with the expression of the...

i tried this Dim rec as Recordset Set rec = CurrentDb.OpenRecordset("EVENT NUMBERS", dbopendynaset) with rec .addnew !F1 = MCC !F2 =- .update end with set rec = nothing but get this Invalid SQL statement expected; ‘delete’, ‘insert’, ‘procedure’, ‘select’, ‘update’ can some one fix the above...

works like a champ....thank you very much

sorry...yes i would need your help

i think so

i click a command button and it prints a report...it then goes to the next record and prints that report. DoCmd.OpenReport "GUI spec 2", acNormal, , "[GUI ID] = " & Me.[Text16] DoCmd.GoToRecord , , acNext DoCmd.OpenReport "GUI spec 2", acNormal, , "[GUI ID] = " & Me.[Text16]...

is there a way to creat a on click event for a comand button that clicks another command button...example by clicking command button 1 it automatically clicks command button 2

Private Sub Command38_Click() If Me.Command38_Click Then Me.[PREP] = True Else Me.[PREP] = False End If End Sub can someone fix this

better yet what would i do to build a query or code to go through all my id records in a table and list ones that are missing

i have two tables linked in a query...one table is title the other is actor...i want to see what titles dont have actors but all i am getting are records that have both....how do i accomplish this