Replies

Hi Talltexan

Post 204033 contains this information:

I downloaded HijackThis, ran it and discovered some very dodgy looking registry entries, which I fixed.
I also downloaded SpywareBlaster, which prevents spyware Active X controls from being installed or running.
I hope this helps.

Cheers

Rob

Many thanks, Jan Karel.
Would you explain the cause of the error message?

Cheers

Rob

BigAl
Thanks for the info. Strange that the only place I acessed on the dat the files were created was the lounge.
I may have been attacked by a miscreant because my mouse is acting a bit strange. I’ll do a virus check.

Cheers

Rob

Thanks for the code, Dave!
By the way. What’s it like up in Stokeish parts these days?

Cheers

Rob

This will have been the subject of many posts but searching has proved fruitless.
The db I am trying to develop models a hotel that books out rooms for functions on a given date. One date:one room.
I have a Bookings form with controls bound to a Bookings table. This form has a combo box that displays Room Names and a combo box that displays Date. I also have a table that stores Room Names and all possible dates that each room could be booked. I would like that after selecting a room, only the available Dates are displayed in the Date combo box. I know it can be achieved with two queries and I have made many attempts but I cannot quite get to a solution.

Any help would be greatfully accepted.

Rob

Gary

Thanks for the input. I’ll look at your code and the website with a clearer head, ie, manana.

Cheers

Rob

Problem solved. I fixed missing references using the source file in A97. When converted to A2000, it now saves in prior version correctly.

Rob

Thanks John and Charlotte,

At the risk of asking a stupid question, how do I remove the data access pages?

Rob

Hans,

Many thanks. The first code example is exactly what I need.

Cheers

Rob

Thanks John,
Just one more thing (famous last words),

How would I modify the following code so that, upon opening, the form goes to a new record?

Private Sub NewOrder_Click()
On Error GoTo Err_NewOrder_Click

Dim stDocName As String
Dim stLinkCriteria As String

stDocName = “Order Form”
DoCmd.OpenForm stDocName, , , stLinkCriteria
Forms![Order Form]![Driver Surname] = DLookup(“[Surname]”, “qryDriverID”)

Exit_NewOrder_Click:
Exit Sub

Err_NewOrder_Click:
MsgBox Err.Description
Resume Exit_NewOrder_Click

End Sub

Cheers

Rob

Yes. The CustomerID on the second form is bound. I considered the After Update option. Would I just enter the expression as you typed it into the Event Procedure? Is there any reason why I cannot then enter another expression into the After Update event of the this control (on the second form)?

Cheers

Rob

Tom and Patt,

I’ve looked both at the Northwind db and Patt’s suggested table structure. I now see that I’ll need to include another table along the lines of the tblCustomerOrderDetails. What I will need your help with is:

Patt writes

Would you kindly give more instuctions.

Many thanks to all

Rob

Douglas

Thanks for the suggestion. Would you elaborate a little.

Cheers

Rob

Tom,

Thanks for the suggestion. My list of sample databases does not include ‘Northwind’. I’ve looked at an Orders and Invoices db which has been useful but not exactly what I had in mind.
My idea is for a new form to open when a Customer is selected. The form shows a number of check boxes (each with a quantity drop down list) that corresponds to the available dishes. The appropriate selections are made and the order saved.
Is it possible for each checked box to be saved as individual records for a particular customer?

Many thanks

Rob

Your attachment is corrupted. Edit your post, re-attch and re-submit .

Rob