Search results

So I have this form with a combo box which successfully displays a range of items from which I would like to select from - but unfortunately I cannot. I cannot select anything from the combo box. I have checked the form and table to ensure I have edit rights - which I do. The form is based on...

Here is the SQL string; Note that the AirplaneTransport.IsInternational is the field that contains the checkbox. SELECT BookingProduct.BookingID, [Surname] & ", " & [FirstName] AS FullName, Guest.GuestName, Product.ProductName, AirplaneTransport.FlightCode, AirplaneTransport.CTSArrivalTime...

I have created a query and one of the columns of the output displays a check box because this is the data type of the underlying table. I would like the query to output either Y or N rather than displaying the checkbox. How would I do this? thanks

Think I might know the problem. There needs to be statement that sets the label caption to their default value. How would a write this?

On a subform's Current and After Update event I have this code; 'Change title of Date out/In labels depending on Product Type If Me.cbProductName.Column(2) <> "3" Then Me.lblDateIn.Caption = "Date" Me.lblDateOut.Caption = " " End If It's...

Thanks. I am now getting an error message "Invalid use of Null" when I start entering on the main form. Is an error handler such as On error resume next the correct treatment? Or should there be some sort of statement about if null then...

Thanks, that looks like it will work but I am having trouble referring to the value of the combo box. This is my statement txtDateOut.Enabled = cbProductName = "Arrival Flight" Am I referring to the value Arrival Flight correctly? I have confirmed; txtDateOut is correct cbProductName is...

I have a form containing a sub form. On the sub form I am selecting products that I am selling to a customer whose details appear on the main form. The products on the sub form are selected from a combo box. This section is in datasheet format. Depending on the product sold some of the labels...

So I have built a form and added a field using the expression builder which is returning #Name? Why is this so? There is a relationship between the table on which the form is based and the record I am adding to a control.

Yes, I was able to modify and delete what I needed to, but now I am left with some blank cells that show up in the properties window with names like "empty cell 49". Can those be deleted? Also it has left one control un-selectable by clicking. Can only select from the properties window drop...

Thankyou JHB for that incredibly well laid out explanation. Appreciate your effort.

No, it is a single form

Pardon the gumby question; I have created a form using Create|Form. I have now opened it in Design view and wish to adjust the width of the controls - text boxes etc but when I try to adjust one, all of the text boxes in that column are adjusted. How do I individually adjust the widths? thanks

Yep, that form is subject to a filter; [ParticularRecord]=1 I suppose I can start by deleting this and see what happens...

Your a legend and thanks for the tip.

I am receiving this error when trying to run this code. Can someone tell me what I am doing wrong please. Private Sub txtGuestName_AfterUpdate() 'Format first name to Proper and ignore formatting on last name Dim fName As String, lName As String fName =...

I have a database a friend started for me which I am working through trying to understand. On a form there is a sub form. On the form I can only cycle through the records that have been created since the last time the form was opened. I cannot cycle through all records. Is this normal for a...

I have some code behind an access db. For example: in VB editor I have some code that looks like this; Private Sub chkBusArrival_AfterUpdate() 'Add BusArrival to Product table If chkBusArrival = True Then AddProduct "Bus Arrival" Else DeleteProduct "Bus...

I have a main form that has 2 sub forms on it - one below the other. Because I did not like this layout I created a tabbed form on the bottom of the main form (2 tabs) and would now like to move each sub form onto each of the tabbed forms. What is the recommended way to move them. thanks

I am using expression builder to specify a field in a report but it is acting more like a filter. How to fix this? So I have a report based on a query. However I want to add a field that is not in the query but is in a related table - called tblAgent. So using expression builder I select the...