Good day
I am very much a newbie, so please accept my apologies for any errors in posting etc. I will follow all guidance offered.
I have a web site that uses a form for customer details, this form is received in Outlook in a fixed standard format. I have a VB script that will copy the selected data to an Excel table, which I have 'linked' to an Access db table.
My problem is that I cannot append the data from the linked table, as a new record, to the main table because that has a primary key (Qno)
Using a form in my db I can add new data and create a new record using this script. This adds 1 to the previous record to make it unique.
Private Sub Add_record_Click()
DoCmd.GoToRecord , "", acNewRec
'Add one to previous highest Q number
Q_num = DMax("[QNo]", "[Damp_data]") + 1
Clients_status = "Interested"
Detail.BackColor = 15651516
Date_progress = Now()
MsgBox "This person is now an active customer"
Detail.BackColor = 15651516
Me!Title.SetFocus
End Sub
HOW can I append data from the linked table ("Email_customers) to the main table (Damp_data)?
(OR transfer the data direct from Outlook to Access? - Which would be brilliant)
Hope that someone can help PLEASE
TCor
I am very much a newbie, so please accept my apologies for any errors in posting etc. I will follow all guidance offered.
I have a web site that uses a form for customer details, this form is received in Outlook in a fixed standard format. I have a VB script that will copy the selected data to an Excel table, which I have 'linked' to an Access db table.
My problem is that I cannot append the data from the linked table, as a new record, to the main table because that has a primary key (Qno)
Using a form in my db I can add new data and create a new record using this script. This adds 1 to the previous record to make it unique.
Private Sub Add_record_Click()
DoCmd.GoToRecord , "", acNewRec
'Add one to previous highest Q number
Q_num = DMax("[QNo]", "[Damp_data]") + 1
Clients_status = "Interested"
Detail.BackColor = 15651516
Date_progress = Now()
MsgBox "This person is now an active customer"
Detail.BackColor = 15651516
Me!Title.SetFocus
End Sub
HOW can I append data from the linked table ("Email_customers) to the main table (Damp_data)?
(OR transfer the data direct from Outlook to Access? - Which would be brilliant)
Hope that someone can help PLEASE
TCor
