Search results

I was testing a button in a form with an OnClick event. I wanted to see if I could use a form to insert a new record into a table, I tried the following but got a Syntax Error: INSERT INTO Table1 (Org, Date, Name) VALUE ('#Me.Org#', #Me.Date#, '#Me.Name#') Org and Name fields are text fields...

I have a form in which all the fields are "unbounded" to any table. Thru the use of other codes and data entry, the fields are now filled. I now need to save all the fields as a single record into a table. I believe I need a "Save" button that will run the code below. Three questions: 1. Will...

I have a [OrgCode] text field and a [InvDate] dd/mm/yyyy field. My third field [InvNum] needs to be automatically filled in with the first 3 chars of [OrgCode] and mmdd of the [InvDate] field. Here's an example: "CASTOR" in [OrgCode] & 15/01/2007 in [InvDate] I need "CAS0115" in [InvNum] as...

I have two fields: [NoDays] & [InvDate]. An integer, such as 14 for [NoDays] and dd/mm/yyyy for [InvDate]. A third date field, also dd/mm/yyyy for [EndDate] needs to be filled in with [InvDate] plus the [NoDays]. I tried After update Event: Me.EndDate = Me.InvDate + Me.NoDays It does not...

Having used After Update event in an Unbounded form, I've managed to populate some fields from an Access table. After filling in the rest of the fields, I want to save all the fields on the form into another existing table as a record. Can this be done? If so, please advise. Many thanks.

I have two tables: Invoices & Organisations. A form called Invoices contains a field [Organisation Code] that is used to populate about 14 fields in the 65-fields form. The form is unbound (no Record Source) & so are its fields. With some help, I've gone as far as to develop the following VBA...