Search results

I've got a table "Main" running on SQL which is linked to a local table "Bank Details" on an Access front end. They are linked by a field named "Sort Code" which is the primary key in Bank Details. I can add a new record to bank details but when I enter the sort code in the Main table i get...

I'm using the MkDir function on a command button which creates a new folder in the C: drive. Example: MkDir "C:\Export Folder" I'd like to be able to choose the file name and destination this is saved to so need to call the SaveAs dialog box if possible. Any suggestions how to do this? Thanks

I have one report I want to use as an invoice but have different record sources for it. For example I have a command button on a form which opens the report to show all of todays orders. On another form is a button to show the report for that particular customer. I need to change the record...

I use the following code on a command button to save "Table1" as an excel spreadsheet called Table1.xls in a folder called export folder. Private Sub Command14_Click() stDocName = "Table1" DoCmd.TransferSpreadsheet [acExport], , stDocName, _ "C:\Export Folder\Table1.xls", 0 End Sub This...

I have a field [Postcode] and I need to put a space in between the characters. For example: RG204QZ needs to be RG20 4QZ L75HG nees to be L7 5HG. As these are British postcodes the space is always before the third from last character. So I am using: Right([Postcode],3) but not sure how to put...

Sorry if this is long-winded but here goes: I have the following (example) recordset called "Import Query" that I am trying to update using code: First Name M1 M2 M3 M4 M5 James Y Y Y Peter Y George Y Y Y Y What I need to do is check each record to see which...

This may take a while so please try to stay with me on this: I have set up a query and a report (using label wizard) so that I can print a label of the current record viewed in a form. This seems to work until I get to the actual printing stage. The printer I am using is an Epson LQ-300...

Does anyone know if it is possible to transfer data from an old MSDos database into an Access 2003 one? If so any idea how you would go about doing this? Thanks in advance.

Hi hope someone can advise me on this: I've got a form with fields 1 - 12 on it. I've set up an autokey macro so that when I press 'CTRL1', field 1 is updated with a "Y". So far so good... The next time i press 'CTRL1' I want field 2 to be updated with a "Y" (as long as field 1 is populated)...