Search results

Another quick question does anyone know the syntax for opening/closeing the header/footer (I have a couple of bookmarks there that need to be used)? Thanks Eric

What I did was point to a template based on a combo box ' Specify location of template strTemplateLocation = cboTEMPLATE.Column(1) & cboTEMPLATE.Column(2) Where Column(1) was the template's path and Column(2) the template file's name. In this example I gave those columns a width of 0...

Presuming you have bookmarks called CaseText and ItemText (not just the words), I don't see anything wrong.

I'm a bit confused as to what you are trying to do?

I'm not an expert on VB, but I think that the following will work... Set dbs = CurrentDb dbs.Execute "Your SQL" dbs.Close

I'm trying to figure out if there is a way to refresh a single record in a datasheet subform (based on a query) using a VB statement. Currently I have a FormA (a series of test/combo filters) which launches queries/reports based on input (never closes). FormA also launches seperate FormB, which...

Update: Ok I've changed the database so that the relationship is many to one between the data in the subform (many) and the mainform (one). I think that the whole thing would work if my mainform and subform were reversed, but I need to have it display as a datasheet view. Any Ideas on how I can...

I'm having a bit of a problem figuring out how to do this... I have a form (single form) and a subform (datasheet which is based on a query which includes the data elements [via outer join] in the single form). What I'm trying to do is have the data sheet form include (view only) all records...

Thank you kindly that worked perfectly.

It will be a date field in a one row table ("LAST_UPDATE"), but I don't think it would matter much either way. Also if anyone has a better way of implementing this idea (without using a table) I'm open to suggestions. -Thanks

I have a form in my database that opens by default. I want to trigger a yes/no (yes would run a query, no would end) popup based on the value of a field in a table or query (i.e. if "now" is fifteen days past date in the table/query). Any help would be most appreciated. -Eric

I'm trying to find a way to export my query results to a new blank workbook (some might call this an excel instance). So far all I can do is export the result into an excel file then open it using the following; Private Sub cmdEXPORT_EXCEL_Click() DoCmd.TransferSpreadsheet acExport, 8...