Search results

thanks for your efforts guys... I will give those a blast .. watch out for an update regards Paul

Rabbie thanks for that. I am aware that the OnClick event would be the event to use, However, i dont have enough VB skills to write the code (syntax wise).... I think what i am looking for is help with the vb syntax or a code example to 'clone' for my requirements. Paul

Hi all what I need to do is have a form that inputs a series of answers to questions and then save the data to a table and then summarize the data into an excel spreadsheet. i have got the form, inputs, Vba for the update of the table and the command to open a new or existing excel...

Hi ... fairly new to this... I have the following code but when it runs, it drops to debug with the runtime error '3020' Update or cancelUpdate without AddNew or Edit and i cant figure out what i have done wrong (or havent done):mad: Option Compare Database Private Sub Command15_Click()...

Chris, changed the ) to " and took out the error trapping and it seemed to work. also :- no Click Event??? only GotFocus LostFocus MouseDown MouseUp MouseMove KeyDown KeyUp KeyPress any ideas why that would be ??? - but thanks for the answer above ! Paul_Birm

hi all I have 5 query's that i want my users to run from a menu ( not a switchboard). so when then click on option one... report one runs ... simple he??:mad: when i click or on option radio button NOTHING happens the VBA behind the option is :- Private Sub opt_report1_GotFocus() On...

thanks Pat will give it a go...

hi all... I am quite new to writing Access Reports, but I know how to do it in Crystal reports. Is there a way to call a pre-written Crystal report from within the Access syntax??? thanks Paul:D

pbaldy thanks chap, great response. regards Paul_Birm:)

hello world, newbie to the forum here.... i am writing my first access report . I have the data i want, BUT (and there is ALWAYS a but isnt there! ) I am getting all the data and I need to only have specific data and i dont know how to filter. i have a table called questionnaire and a table...