Search results

I have a form that has combo boxes and text fields (as well as sub forms). There is also a button linked to some code that says' Private Sub cmdQuote_Click() 'Creates quote date and prints quote Me.QuoteDate = Now() Me.cbAgentID.Requery DoCmd.OpenReport "Quote", acViewPreview, ...

I am designing my first database for a travel agent that sells products such as bus tickets, accommodation, ski lift tickets etc. I started putting all of these items into a Product table. I have now realised these products have some differences. For example a bus ticket is only good for a day...

I would like to step through a macro. So I go to a form (in design mode) that has one, select the control and then open the macro. At this point I should be able to F8 through this however when I press F8 nothing happens. Then if I select Run (the green arrow from the menu bar) a box opens...

I am at the beginning of my first database and have a question - a recursive index - possibly. The business is a travel agent. Customers book activities for which the travel agent sells. Customer buys a package with items on behalf of the guests that will accompany his group. For example I get...

Good suggestion. These products exist in a table called Products and includes items other than lift tickets. For example accommodation, transport options etc. The table has a product group number which keeps like products together. However there are products within the same product group which...

I think I will investigate a procedure that entails a form whose purpose is to maintain these items - assigning a sort order index on the fly. The challenge will be for example to after update of each record's sort number the list to be reshuffled in accordance with any sort numbers I might...

I am trying to apply a sort to records that contain a description field that looks like this; Item ID | Item Name 166 | All Mountain Lift Pass - 10-Day(12Days) 165 | All Mountain Lift Pass - 1-Day The sort is applied to Item Name but ranks Item...

That worked. thanks

On a main form I have 2 sub forms. On the main form I have a command button that asks how many guests in a booking and depending on the response populates the subform with Guest Names. However it will only do this if I click on the subform and then click the command button. I want to include...

On a form I have a combo box with the following details; Control source = Customer ID Column Count = 2 Column Width = 0;4 Row Source = SELECT Customer.CustomerID, [Surname] & ", " & [FirstName] AS CustomerName FROM Customer ORDER BY [Surname] & ", " & [FirstName]; Bound Column =1 When I click...

Thanks Paul, I am trying to update the field InvoiceNo in the Booking table with the number this code creates. Is the only way I can do this is create a text box on this form and bind it to this code (as you suggest above) and then have the InvoiceNo field with its Source as this text box?

Another newbie question. I have a form on which I have added a button. On the On Click event I have attached this code; Private Sub cmdInvoice_Click() Me.cmdInvoice = Nz(DMax("[InvoiceNo]", "Booking"), 0) + 1 End Sub The purpose of which is to create a new invoice number. cmdInvoice is the...

I do not like a current form. I would like to create a new form that has identical fields and links to the same event procedures. Is there any way I can create a new form and save as over the original form while still preserving all of the links? thanks

On a form I have various fields that I would like to either use UCASE or ProperCase. I thought I would effect this using the After Update method. Using the expression builder to write the code what should the expression look like - I am having trouble with the syntax. Thanks for your help.

Am joining this forum because I would like to develop my skills for Access. I am experienced with excel and can even write some code - with substantial help. At least I understand what has been written! My first project is to write a Db for a travel agent so I will start making posts about...