Exists in Access

R

roma_victa

Joined
Dec 20, 2009
Messages
1
Reaction score
0
hi all,

I am developing an application in vb and access

my sql query in access please have a look.

str = "insert into details values('" & username & "','" & CDate(date1) & "','" & time & "','" & PrinterName & "','" & noofpages & "','" & _ Message.ToString & "') WHERE not exists (select * from details where Date1 = " & CDate(date1) & " And Time = '" & time & "')"I was trying to check the database before adding the records

For some reason its not working

Query input must contain at least one table or query

Is exists allowed in access or is there any other keywords in access

is there any other alternative for this
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access asks for parameters 2
Check if a date exists in a record 1
2000 vs. 2002 VB Problem 2
Date calculation in query with form variable 2
Call stored procedure in SSMS from Access 2016 doesn't work. 0
How do I have a listbox in a form update a query 2
Help with Union 2
Access 2000 Query very slow compared to SQL Query Analyzer 5

Back
Top