I am trying to write a script (which i have done) that sends a meeting request out from Access to users outlook. When they accept it adds that meeting to their outlook. But if a user declines it...

Let me know and i'll post an idea up here for you. cheers

thanks, I must have forgotton the later [ marks.

cheers

The statement above does work. I would have thought that the below would work. All I would do is place the column names in quotes.

SQLText = "INSERT INTO issues1 ("title", "time", "Opened",...

Hi all,

I have this sql line (below) and where it works fine at the moment. But I have columns with 2 words i.e. opened by. I would like to add this colum to the statement below but everytime i...

I have it working, how going to add in more field headings.

Manythanks

ignore that last one. what I have is:

Private Sub Command78_Click()

Dim SQLText As String

SQLText = "INSERT INTO issues1 ( [title], [time], [status] ) SELECT title, time, status " & _
"FROM...

thanks for that _ believe were getting somewhere.

I have now:

Private Sub Command78_Click()

Dim SQLText As String

SQLText = "INSERT INTO issues1 ( [title], [time], [status] ) SELECT...

I have edited it and I have:

INSERT INTO issues1 ( title, id, time, status ) SELECT title, id, time, status " & _"FROM issues where id=" & issues.id.text

it errors though. it wants end of...

cheers for the reply. Your helping a lot.
You mention replace helpdesklogtable with name of table but in the sql statement it says helpdesklogtable issues, isn't issues the name of the table?

I...

So I need to insert data from the issues table into the issues table of ms daily log.mdb. But I need to only transfer the data where is id is the same one that is on the form. (the id field auto...

This seems fine but im am having problems with the criteria. I have edited the below. can you see where it is going wrong please.



"INSERT INTO I:\IT\Documentation\Helpdesk Log\helpdesk log.mdb...

thats sounds excatly like what i am after. can you give me anyideas on where to start with the code? I think can do the button. Thanks.

All,

I have an issues form in a database (MS Daily log) and when you fill in the form it save the data into an issues table. Everytime you do this it gives each issue an ID number (auto number). ...

I can insert into the database the form is on but its the copying that record then to the other database

the form is just an access form and im doing the whole database in access 2003.
Does my first post above help?
Thanks

it is kind of. I dont want every entry I make into the form to be copied across to 2 databases. I want it so that I can choose after I fill in the form whether I want to copy to to the other database...

how do you mean?

All,

I have an issues form in a database (MS Daily log) and when you fill in the form it save the data into an issues table. Everytime you do this it gives each issue an ID number (auto number). ...