ms-access-2003

Access form, search for a record from another table and insert into field in current form

I have a table that stores invoices and a form based off of that table that looks like an invoice so that you can search previous invoices. Currently I am creating the invoices in excel and then exporting the data as a new record into the Invoice table. I was wondering if there was a way I could create the invoices from my Invoice form. ...

MS Access 2003/2007 - Import Specification for data import from csv file used in VBA.....validate field names?

I have an import which I made with the wizard, at least far enough just to save the specification. It imports CSV files, with headers, quote text qualifiers, and comma delimited. I then use the import specification in some vba that fires from a button click event. Here are some things I am wondering: So if the fields in the data are ou...

WTF is this Access bug?

Tested on Access 2003 Pro (build 11.8321.8324) SP3. Steps to reproduce: create a new database. create a new form. put a button on the form. paste the following code in the button's Click event procedure: Debug.Print Workspaces.Count Debug.Print CurrentDb.Name close the code editor and form, saving changes. do not skip thi...

How To Print A Single Record from a Microsoft Access Form into a Report

Hello! i'm very new to Access and VB, and im about to print a specific record.. but im getting an error with this code: Private Sub printEksternAVR_Click() DoCmd.OpenReport [Report_AVR Ekstern], acViewPreview, , [Report_AVR Ekstern].Rapport_nr = Forms!Form_AVR End Sub My reports name is AVR Ekstern, and the prime key is Rapport nr...

export to doc/other writeable file / force to print out empty report?

Is there any way to "force" my report to print out the "layout" even if the fields are empty. I have one report, which is always there. and 8-9 sup-reports which not always will be filled, but I want them to be shown anyway because they will be send out to a customer and filled, and then send back? is there any easy way of doing so? (and...

select something i cbo and change the text of another txt - #name? error

For some sort of reason, which i can't seem to spot, this fail and i get my #Name? error, when i tried to do this, i use pretty much the same code another place in my form, the only difference is the cbo and the names of my txt and alike. Private Sub cboVarenummer_AfterUpdate() Dim LSQLVareNavn As String LSQLVareNavn = "select V...

Error 3218 Could not update; currently locked -Msaccess

Hi, I got an error with my Msaccess DB. multiple users are using this DB's frontend. I do not know why I am getting this error message as follows Error 3218 Could not update; currently locked can someone help me please...... ...