Search results for query: *

im not too sure what to change, he is the VB code at the moment Private Sub Command39_Click() On Error GoTo Err_Command39_Click Dim stDocName As String stDocName = "close all" DoCmd.RunMacro stDocName Exit_Command39_Click: Exit Sub Err_Command39_Click: MsgBox...

i have a button on a form which when clicked runs a macro. But i want to add a prompt msg when the button is clicked, which states "do you wish to run the macro". When they click ok they will run the macro otherwise if they select cancel then they just go back to the form thanks

in my table Stock i only want 26 records at a certain point in time.. i created my table in access thanks

sorry im a little confused.. when i click a button i add all the information in the txtfields of that form(subform3) into the table(stock) but if sometimes clicks the button twice the error messages occurs.. This is because the primary key has been entered twice.. the txtfield(pallets_ref) in...

when saving information from the form to a table i sometimes get a prompt msg which states. "mircosoft access set 0 fields to null die to fail conversion failure...1 fields to to key violation etc etc". I understand what this means, as the primary key information has been entered twice into the...

update a table which automatically assigns a new reference number for each individual record. i assign 6 values to the table and i want the 7th value to be the primary key which has a different reference number for each new record

i need to update a field within a table with the results displayed in the combo box. all the fields in that particular table are to be updated with the combo box results thanks

i actually have a button on the form which runs a macro the code is Private Sub Command29_Click() On Error GoTo Err_Command29_Click Dim stDocName As String stDocName = "save transfer" DoCmd.OpenQuery stDocName, acNormal, acEdit Exit_Command29_Click: Exit Sub...

when i save information from a form to a table.. 2 prompt msgs occurs.. Is the anyway i can just save the data from the form without the prompts thanks

actually just one more question??? how to you get rid of that prompt about ammend???

thanks for your help i finally got it working don

or if its makes its easier just a button which saves the data from a form into a table

thanks heaps for your help i have never used VB before so im sorry if this may sound stupid do i need to add any information to this part DoCmd.OpenForm stDocName, , , stLinkCriteria, acFormAdd such as the file to save it to.. etc what is the name of the database file which the information is...

yeah.. that makes sense but how would i save the data in the 7 fields inside the form to a table.. Basically everytime i run the query and get the results on the form i want to have a button on that form which saves all this data to a table sorry if it sounds confusing. thanks don

Hi brief description of what i want: the query takes a reference from form1 then opens form2(the one i want to add the data). The fields all come from different tables but all are related in some way. Example.. the job number number is in one table but i need to find out several different things...

i created a form which is opened by a query. it displays several fields. I need to find a way to export/add these results into a new access table. I need to do by using a button.. thanks

thanks for the help i ended up using your first idea and created a sub form which shows the query results But my new problem is my form displays the query results, it shows a number of fields such as JobNo, Description and Customer.. all this data has come from different tables i want to...

I have created a sub form which is opened through the main form. The sub form shows the following results from a query. REF, JOB NUM and description. When entering the job number in the form then clicking on a button the sub form opens and displays the results which i require. The only problem...

Hi again im sorry to bother you, im quite new at access so im sorry if i sound so confused Basically want i want is a form which displays the results of a query. When i enter the job number in a text field(textfield2) and exit the text box i want the results (job number, ref and description)in...

thanks for the help i will try that but is there anyway the results can be placed in a text field on the same form as the button. i have tried entering into the control source of the text field = dlookup("exp","Part1").. but im confused as to what the expression would be.. as i have never used...