Search results

To store the SQL, simply dimension a string variable, and use that: Dim strSQL as string strSQL = "INSERT INTO tbldst(dst_date, dst_user, dst_num_req_rec, dst_num_req_pro, dst_time, dst_task_id) VALUES ('" & Me.date & "','" & Me.user & "','" & Me.rr & "','" & Me.rc & "','" & Me.time & "','" &...

A woman went into a store to buy her husband a pet for his birthday. After looking around, she found that all the pets were very expensive. She told the clerk she wanted to buy a pet, but she didn't want to spend a fortune. "Well," said the clerk, "I have a very large bullfrog. They say it's...

:confused: :confused: I'm confused by Wayne's reply. I'm running a holiday database which contains various queries where I want to bring back records between two dates - and it does just that. My dates are stored as short dates (i.e. 30/06/2003), and if my end date parameter is 30/06/2003...

Yes. i.e. if you search for 1st April to 31st April it WILL include data entered on the 31st April. If that isn't happening, I'm guessing you might have problems with how your date is stored. I think I'm right in saying that if your field also stores a time (i.e. 31/04/2003 11:31:05) then...

Check out this thread - here

Use an IF statement or a Select Case: Select Case CmbSupplier Case "Tom" Call Tom Case "Dick" Call Dick End Select

If I understand correctly: Referential Integrity: You can't add a pupil to your subject tables if they do not exist in your master table Cascade Update: Change the data in any of the fields in the master table that are part of the relationship with the subject table (i.e. pupil id), and the...

"Cannot find the file '\\......' (or one of its components). Make sure the path and filename are correct and that all required libraries are available." Some of our users are intermittently (sp?) getting the above error message. The database is there and is fine (other users can see it no...

I had the same problem, and could find no way to prevent the message from appearing. However, one of our tech guys wrote a small .exe program. It was quite basic, in that all it did was sit in the background waiting for the message to pop up. When it did, it simulated the user pressing the...

I don't believe it will be that easy, if it's possible at all. The only solution I can think of is to have Access open up whichever copying software it is that you use (i.e. Roxio, Nero etc..). This would still require user interaction. If you wanted to fully automate the process of backing...

It's always a good idea to have a back-up copy of a database. It might seem like 'belt and braces', but one day you'll be glad that you do it!!:D

To delete the original use the wonderfully titled Kill command! Dim strName1 As String ' Current name/location of DB Dim strName2 As String ' New name/location of DB strName1 = "C:\DataFiles\MicaPharm\MgmMethBe.mdb" strName2 = "C:\DataFiles\MicaPharm\MgmMcBeCompact.mdb"...

Merging the two tables into one and having a type field with D or L in, like Pat suggested, would certainly solve your problem. I don't quite understand why the union query does not give you what you want though. If you want to get it working that way, stick the tables in a small mdb, zip it...

So the order_no and delivery_attempt no make each record unique (i.e. order 1, attempt 1 / order 1, attempt 2 etc..)?

In that case it probably is as simple as running an update query. Maybe I was trying to over-complicate things - I think I need to lay down in a dark room for a little while.:rolleyes: :rolleyes:

To run an update query would require some sort of uniqueness on the records, and I think that is SteveE's problem: I'm not certain, but unless some sort of ID can be added at source, I can't see any other way to do it. :confused: Matt.

If I understand the structure of your tables correctly, the SQL should look something like this: SELECT Dept.[Dept ID], Employee.[User Name], Desktop.[Make Model], Desktop.[Date Purchased], Desktop.Value FROM (Desktop INNER JOIN Employee ON Desktop.[User Name] = Employee.[User Name]) INNER JOIN...

OK. Firstly, if your table/field names have spaces in (try not to do this - if you must use underscore _ ), you have to include them within brackets, i.e. [Desktop Table]. On to the SQL. You're selecting everything from the Desktop table, and everything from the Laptop table. What does the...

Can you post the SQL?

You will have to create a custom function. Do a search on this forum, specifically for posts by Mile-O-Phile. This has come up numerous times, and Mile-O has provided many (great) examples.:)