Search results

Nope still not happening. Last time I had this issue I made all the text boxes invisible except the combo box, until the Combi was populated then made the text boxes visible.True Was kinda hoping for a easier solution though.

Doing thats indeed blanks all the text boxes and allows me to select from the Combo box but no longer populates the text boxes once I have selected a client from the combo

I have a query that basically pulls up client data through a form (You select Clients surname via Combo Boxon a form) This all works fine but when the form opens there is already a record on the form and I would like the form to be clear until an name is selected in the combo box. I have had...

Just cracked it using Forms!frmAddClub.frmEnquiresViaAddClub.Visible = True Thanks for pointing me in the right direction.

The subform visible Main form is called frmAddClub, 1st sub form is frmAddContact, when the contact is input and saved another button is trying to make the 2nd sub form (frmEnquiresViaAddClub) open. Both sub forms sit on the main form (frmAddClub)

Hi I have a form that has two sub forms. The first subform is not visible until a button is clicked. The second sub form also becomes visible when a button is clicked within the 1st sub form. I am using Me.frmAddContact.Visible = True All I get is Compile Error: Method or data member not...

Currently whenever I want a user to select anything i simply use the [Enter Name] within the query, convert this to a form so that when the form opens, a pop up box asks the user to 'Enter Name' Can this pop up box be changed to a Combo Box so that the user can look for 'The Name' rather than...

in 'Default Value' of 'CustomerNo' on tblCustomerContacts' form set to = [Forms]![frmAddCustomer]![CustomerNo]

Hi Everyone, I got a simple problem, but just can't put my finger on. Two tables, tblCustomers and tblCustomerContacts When adding a new Customer, via a form, I put there company name and address and generate a 'CustomerNo', then click a button that takes you to another form to add all the...

Is it possible to move the postion of the Form Footer. I have a Form Header, stuff in the detail section, now that I have added a Form Footer, the Detail section goes really small. If I could lower the position of the Form Footer, but I cannot for the life of me find how to?

DB attached Thanks

I am currently creating a database for Work Permits. The main form has the Contractors name and Company in the Header, and the Detail pane has 7 Sub forms with various tick boxes that the contractor has to tick depending on what his task is. This all works like a dream however when it comes to...

Of course, I always forget the #. Thanks Namliam Gemma, I know what you mean, but on this occasion all the data gets imported from our ERP system and is only looking at about a 6 month period.

This is only for invoices from now back to September 2008.

I need to distinguish VAT rates for invoices, and I believe this will be done via the IIF statement. If the invoice date is before 01/12/2008 then rate is 17.5% after down to 15%. I would then be able to calculate the VAT amount on invoices. Any help would be appreciated.

Uncle Gizmo, Thanks for responding. I have got a bit further, but come up against other issues. I do believe it is something simple that is causing it. I have attached the DB hoping that you could cast your expert over it. frmOrders - Currently allows you to select a customer...

I thought I was getting the hang of this database thing, however........ Trying to create an orders form. User can select a Product from a drop down and if they just want the 1 product thats ok, but when they want to order 2 or 3 different items on the same order number I have major issues...

I can't get the stupid thing too work. The combo box works and I can select the category I want, but It will not display all relevant records.

Alan, Thanks for that, yes a big help, the query now lists all the products. But can I get the query to give me a list of available categories to select from rather than the user having to type specific ones. So that if add a category the query will see rather than me telling everyone that...

Trying to use a query to select a 'Category' from a table. eg. Soccer posts, the query will then show all records for 'Soccer Posts'. At the moment I simply use the [Enter Category] within the query, but would like to be prompted to be able to select a 'Category' automatically when the query...