Search results

Hello, (I'm a Novice) Access 2010 I have supplied screen shots for you information. Trying to compile a report with total number of jobs, Total invoice amount, and Average amount. These three I believe(to the best of my ability) are working. Total Jobs: Control Source =Sum(1) Total Invoice...

Hello, Access 2010. I have a table that is tblLead... a form associated with same. On the frmLead I have a button that when I press I want the record to move to the tbleClients and associated form. How do I do this?? I have attached screen shot of tables and forms for your information...

Hello, using Access 2010 new user. Screen shots are: the form, the macros, The Problem MsgBox and the design view of form. I am using some macros on a form to search the records of client contacts. All search criteria is working except for searching the Company field.I get a message box asking...

Access 2010 Hello, I have several forms where I have the title being populated with the First Name and the Last Name. Then I want the Company to populate after their name. The company is a combo box on the form which is populated from a table with a relationship to the company. In this case...

Is this the better way to do it? SELECT tblSupplier.SuppName, tblEdging.EdgeColour, tblEdging.* FROM tblSupplier INNER JOIN tblEdging ON tblSupplier.SuppID = tblEdging.SuppID WHERE (((tblEdging.EdgeColour) Like [What Colour or ENTER For All] & "*")); See also Attached screen shot please. Thank...

Access 2010 Hello, I am trying to do a basic query where you are required to enter a colour or part thereof and have those items returned. In some cases I have asked 2 or three questions to be answered. But this example is just one. The query is returning duplicates of the exact same items up...

Thank you Sean All over it now ;-) I was under the impression that if I was using a query for the form that all information had to come from that query and not the tables themselves. Got all three issues working now. Thanks again. Jason.

Yes you are right mate, sorry for the confusion. If you look at the screen shots I have shown the table and the query set up. There is also shots of the form and the form properties. I know the control source and row source are not correct, I just don't know how to set these up. The confusion is...

G'day Beetle, Thanks for the quick reply. I made some changes to the properties, see attached screen shots. The company is now blank. The control source is ClientID from the query 'File As:' if that is an issue? thanks.

Hello, Access 2010. (Screen shots attached) I have created a query to feed a form. The query is from a single table client Contact. There is a relationship to another table clients via the clientID in the client contact table. I run the query and receive all the information from the table...

Thats full on! lol Thank you

Hello, (Access 2010) I have a several forms with an address field, Suburb Field, State Field and Postcode Field. I have the Suburb Field using a combo box to Look up a table which has the suburbs, States and Postcode Data. I want the State and Postcode fields to autofill AND complete the data...

Hello, Using Access 2010. I have a form (frmClientContact) with a field Company Name. It is a combo box the data of which comes from another table. What I require - If the Company does not exist and I type the new company name in the box, I want another form (frmClients) to open so the new...

pbaldy, Your a champion, thank you so much it was doing my head in.

My apologies, yes it is in the After Update section of the Check Box. I'm using Access 2010. and I am a newb.... In regards to the "Current event" is that the 'Before Update'? Thank you for prompt response.

Hello, I have a form with a check box. When the Check box is true I have coded for the Header to turn red. as below. The properties for the header back colour is #22B14C If Me.AccountOnHold = True Then Me.FormHeader.BackColor = vbRed Else: Me.FormHeader.BackColor = RGB(34, 177, 76)...