Search results

...But now I have managed to open the file, I see there is an opening square bracket missing after one of the As statements

I can't read this file, I'm afraid. But what are you trying to do exactly? You say you want this on a form. Why? Can't you just design a query and run that? You can do what you want with a crosstab or totals query without the hassle of deciphering SQL syntax. Send me the table concerned and...

You go into a new query design, select SQL and then paste the staement there.

All you have to do is store the last record 's value in a variable. Then you can compare that variable with the new record when it's entered and make the necessary adjustment before updating the new record.

Set rsValidate = projectdb.OpenRecordset("Select * from raw_risks where cluster_id=" & lst_clust.Value & " and raw_risk_description Like '" & txt_raw_risk & "'") If rsValidate.EOF Then ----------- It is opening a recordset (rsValidate), which takes all records from a table or query called...

sure you've read the message? If no records are appended, the error message will stipulate how many and why. Key violations are the commonest cause. Read the message CAREFULLY. If you still have doubts, please post your SQL statement for the query;)

If you're not getting any data, it's because there is a join between your tables and one of the tables doesn't contain any related records. The default join is really a way of saying "Show me records that have corresponding (eg) Customer IDs in BOTH tables ". If you investigate joins you...

Sorry, I got the impression from the field names (txtMasterProductID & lstSelectedOption) that these were string expressions...

Rich is right, of course. By using the date information, you can put: "reserved until 1/1/2099" . This is much more informative than just "Reserved" . And given what you have told me, it is a one to many relationship between Commodity and Reservation. And the Reserved field should be in the...

stsql = "DELETE FROM tblProjectLockOptions " _ & " WHERE [OptionDescription]= '" Me![lstSelectedOption] & "'" _ & " AND [MasterProjectID]= '" & Me![txtMasterProjectID] & "'"

Is the * missing from your SQL or is that a typo: "DELETE * FROM....."

Now, do you mean that on any given occasion, one commodity can be reserved once only?(which is what I originally asked?). Obviously, a commodity can be reserved more than once on different occasions. Sounds more like a many-to-many relationship to me, in that many commodities can be reserved...

How dare you suggest that I indulge in self-titillation....!:mad:

FOR COL So do I Col, so do I! Anyone got a white flag avatar handy? Colin

FUN IT's NOT! I call FUN being in good company, laughing and carousing, enjoying wine, food and flirtation! Not much of that when you're stuck deciding which event procedure to use and finding that none of them work anyway! But I will concede to a certain weary satisfaction on the odd occasion...

don't get your sporran in a twist.... Databases are FUN???? I think not.....unless you are very good at them, which most of us are not.:( If you are dead set against combo boxes, there are still ways to accomplish what you want. BUT, if you allow free entry, rather than using a list, you're...

not rational I can't understand your aversion to combos. The doc types in a Number or Name or DOB and up comes the corresponding results. Where's the difficulty? He/she doesn't have to search the list!:confused: You'll have difficulties anyway if you're searching for a non-unique string...

If one commodity has many reservations, shouldn't the status field be in the reservations table? Or does the first reservation lock the commodity out?

What's wrong with a combo box, O daft one?:D

I see no flaw in your logic. It should work as you describe. You might want to add "As Boolean" at the end, so the function returns a value...