Search results

Yes, txtGuestID is an integer. And for that matter so is the other value in the expression (iProductID). Correct - this is the subform that contains the field txtGuestID. And as a reminder the button that fires this code is located on the main form.

What is good practice concerning the naming of the subform control and the name of the form that sits in the control? I have named them the same, that is sfmMySubform, but perhaps this is confusing. Perhaps I should call the subform fmMySubform?

I am getting a syntax error on my SQL statement. On a form I have a sub form containing the field txtGuestID - whose control source is GuestID. On the main form I have a button that fires the code below. I am sure I am not referring to the control txtGuestID correctly. Can someone please...

If I understand correctly, I am utilizing the values in the text boxes because the subform and these values still have focus and their underlying values are still available.

I am trying to formulate some code to run an SQL statement but it is not working. The statement runs from a button on the sub form subOriginForm. Its intention is to collect the values from cboField1 and txtfield2 located on that form and insert them into tblTargetDB - but the whole thing isn't...

I was wondering about that as well. Deleting the BookingID field in the BookingProduct table I would think is the solution - do you agree? The Customer is the entity that is being transacted with - who is making the booking on behalf of the Guests. The Customer may be a person or an...

Guest table does not contain products. They are check boxes which launch code that inserts products into BookingProduct table. Customer is really the heading for a group of guests. Each one of those guests require products. I am tracking them by guest because as you have identified, the time...

I am constructing a database for a travel agent and was wondering if anyone can advise the suitability of this relationship structure. The narrative is; Customer requests quote for travel package Customer is created Booking is constructed assigning a Customer Guests are assigned to booking...

Here is a picture of my relationships. I believe I have what you describe in the form of the Guest table. However the first 3 fields in the guest table represent the composite index. Because individually none of them are unique in this table. This all came about because I am building a form...

In my tblOrders table each item in each order is listed. Therefore a variety of lines with one OrderID. Is this what you are suggesting? Is my design faulty?

How would this work? What would the autonumber in the transactions table relate to?

I am creating a database that tracks the selling of products amongst other things. The user will enter in an order and may delay invoicing until the customer approves the quote - at which time the order is turned into an invoice. In the transactions table the OrderID, ProductID and CustomerID...

I fixed it. I simply dragged the form footer up (decreased the height of the detail section) .

I have a main form that contains 3 tabbed sub forms. The sub forms present as datasheets. When I select the second or third tab the main form scrolls up a row - and I don't want this. Naturally when the user flicks from one tab to another they would want the main form to stay in the same...

I understand the joint type between the two tables but I still do not get the significance of being on the right...or the left. Right outer join for example only has meaning if we know what table is on the right. I think the joint type explanation is more meaningful. That is, for example, all...

Can someone please explain the significance of right versus left join of a 2 tables. When is it right...or left for that matter. Thanks

Sorry for the bother, this is complicated. So the current statement is; SELECT DISTINCT TransportBookings.CustomerName, TransportBookings.CustomerID, TransportBookings.BookingID, Guest.GuestName, Guest.GuestID FROM TransportBookings INNER JOIN Guest ON TransportBookings.GuestID = Guest.GuestID...

I have a form that contains 2 sub forms, lets call them subform1 and subform2. The main form contains a combo box (1st combobox) listing master records - selecting one populates subform1 with sub records of the master record that has been selected from the combo box. This is controlled by using...

I have identified that if a remove a particular table in the query it becomes editable. However that field provides a purpose. I am thinking that I could remove the table but replace the information on the form with a text box and DLookup formula. Is that a sound approach?

Thanks for that. The disapointing news is I cannot amend the query records. I went to the site you mentioned and saw; "It uses JOINs of different directions on multiple tables in the FROM clause. Remove some tables." What are joins or different directions? I should mention that the FROM...