Search results

hi hope you can help with this folks... i have a form which opens a subform. on the 1st form, the user puts in a Part Number when the subform opens, the PartNumber is prepopulated but a field next to the part number needs to go away and look at a list of BOM items and populate the child parts...

hi hope you can help with this folks... i have a form which opens a subform. on the 1st form, the user puts in a Part Number when the subform opens, the PartNumber is prepopulated :) but a field next to the part number needs to go away and look at a list of BOM items and populate the child...

I have a Form with a Button on. The form is a text input form that updates data on a table. The data i have pulled in to view on the form is held in a temporary table and the query i am trying to run, takes the updated data and puts it into the original table. temp table name - tbl_TempEdit...

Hi I have a Listbox on a form, i want to select (user to highlight a row) one of the list items and then click on a Button called 'Edit' to take the user to a form where they can edit the contents of the row. can anybody help please? do i need a docmd.openform (formname) and then put the...

Hi. I have a series of 3 drop down boxes on a form. each drop down has text data in such as tom, dick, harry etc. when you select, say 'tom' - the data table, when viewed after, is holding the value of the item on the list - ie 1 in the case of 'tom' or 2 inthe case of 'dick' - INSTEAD i NEED...

Hi. I have a series of 3 drop down boxes on a form. each drop down has text data in such as tom, dick, harry etc. when you select, say 'tom' - the data table, when viewed after, is holding the value of the item on the list - ie 1 in the case of 'tom' or 2 inthe case of 'dick' - INSTEAD i...

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()...

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...

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

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...