Search results

Not sure what you mean by "breakppoint" (!!must be because I'm in Finland!!) .... When I got the error I pressed "Debug" and got this Visual Basic code - yellow arrow on the left by "Total Cost ..." Private Sub cmdCost_Click() Dim TotalCost As Double Dim ThisDate As String, EndDate As...

Hi Shay, BIG thank you for that ! It looks like you have it just the way I meant .... only thing is that when I tested it, on pressing the "Cost" button I got an error message : "Run-time error '94' Invalid Use of Null" Is this something in the file or my computer or ...? :)

Currently I have the rates stored in a Products table: Product ID, Product Name (ie, Double High season), Supplier (ie, Hotel name), Price I then manually input the dates of arrival and departure and a calculation multiplies number of nights by price to give total. The dates themselves (other...

Hello again Shay, Currently I have a Form, which gives the general details about a Booking (ie, the customer name, OrderID etc. This "Orders" form then has a sub-form called "Order Details" which lists each part of the booking (eg, hotel name, date of arrival, type of room etc). At the...

Hello Shay, Currently I have a Products table, which lists the various products their prices, and the dates when prices are valid. This table is linked to the Suppliers table, which hold the hotels. So, I have a seperate ProductID for each seperate room type and date range : eg, Hotel...

I am trying to calculate the price of a hotel stay, for example, between 01 April and 06 April, when the price of the hotel room is 50 USD on 01 and 02 April, but 75 USD on 03, 04, and 05 April. I want to go to a Form, input the dates of stay (eg, 01-06 April), the hotel name, and then have the...

I have a Form which is used to input Orders, and a sub-form to that listing the Order Details of that order. What I want to do is create a Report that will extract just the information from one of those order details, and nothing else. Ie, I want to show a report with the details of just one...

Invoice report Hello again Ally, I don't know either why I had the second query (!). I deleted that, and put the [Forms]![Orders]![OrderID] directly into the OrdersID part of the Invoices Query that the Invoice report is made up from - don't know why I didn't do this first!! - now it works...

Invoice reports - Ally Hello Ally, Thanks very much for your reply. Just to be sure I am doing things right, I have done this : Form for the "Orders", with sub-form for the "Order Details" Query called "InvoiceReport", from which I made the Report called "Invoice". On the Orders form, I...

I am making a datbase for a travel company and want to add a command into a Form where the Order is kept, a command which will preview the invoice for that particular OrderId. I can't seem to manage to do it - just for the specific OrderId I am working on. Any ideas? Thanks

I am making a database for a travel company. When a new booking is being added I want to choose a Product, such as a Hotel, and have the price for that product automatically appear when its selected. ie, Mr Smith makes a booking at Hotel Sunshine - I go to the "Orders Form" and start...

Can anyone tell me what the code DISTINCTROW means?