Search results

can you empty the table before importing the text file or is the text file meant to only overwrite certain data

if an error occurs closing the form then it will be handled by your error trapping,but not if its outside the error trap

steve on reflection it may be better to move the docmd inside the error handler procedure DoCmd.OpenForm stDocName, , , stLinkCriteria DoCmd.close acForm, "filtanksearch", acSaveNo Exit_go_Click: Exit Sub

try this Exit_go_Click: DoCmd.close acForm, "filtanksearch", acSaveNo

set each text boxes controlsource =me.[comboboxname].column(1) =me.[comboboxname].column(2)

is the query a stored query or a sql string that you build in code if its in code then you would need to refer to the form control a little differently,if the certno is a number WHERE (((Equipment.Scrapped)=False) AND ((Equipment.Lost)=False) AND ((ConformancyCerts.CertNo)=" &...

in design view of your report select 1.view 2.sorting and grouping in there you can select what field to group on,group header or group footer etc the built in access help files is a good source of help for just about everything in access

why not use an option group instead of 3 buttons then use the after update event for the option group, to select the report to print Private Sub det_AfterUpdate() ' Dim rond As Integer select case me.det.value case 0 docmd.openreport RptName case...

add grouping to the report with a group header and footer and sum the values of the group in the group footer,similiar to what you are doing in the report footer group your reports on PO

open the windows print dialogue box DoCmd.RunCommand acCmdPrint

glad you got it working,a picture is worth a thousand words when you are trying to communicate

Sorry leerlap in all my waffle i forgot to answer your question yes i did mean controlsource,not recordsource

Hmm not sure why you would get that error maybe my instructions were a bit vague try this 1.right click on afterupdate and select build 2.select codebuilder 3.paste the code 4.on the top toolbar select debug 5.select compile and save 6.close the form and save the changes You may Be better off...

no its not the same.I wouldnt recommend you do this with out backing up any db you do this to,but i guess if yours is corrupted and cant be used anyway 1.in windows start menu 2.select run 3.type in msaccess /decompile 4.select ok 5. select which database you want to decompile 6 a dialogue box...

sorry for not being more precise.i used the word yourdatefield because i dont know what control name you have used you have to substitute the word YourDatefield with the name of the textbox that holds the date you are trying to manipulate

"Accounts Received Between " & [Forms]![frmABC]![txtBeginDate] & " and " & [Forms]![frmABC]![txtEndDate]

it may be of more use if i attach it !!!

this is a small demo db in access2k

i am getting confused, see if i have it right you have a search form with a subform the search form has many possible criterias that may be selected when you click a button on your form it builds your sqlstring and populates your subform.the code for this resides in your searchform code module...

im not sure what you mean. identical code original form?? the sql code should only appear once- i.e in your seachform code module.when you click your print button it should run your sql then open the report. Is this what you are doing, i will stay on line for a while if you like