Search results

Hi could someone please help me? I have a table With 4 fields Id,Month,Year,Total 1,jan,2009,51 2,feb,2009,44 3,mar,2010,77 On my form i have 3 fields Month,Year,Total Is it possible when i press a button on my form it will search the table for the same combination of Month & Year...

Please Please Please could someone help me. In my form i have this code that saves a report as pdf using lebans code and files and creates a new record. The problem is when it gets to the new record bit i get an error. "Cant use GoToRecord action or method on an object in design view" I have...

Sorry i dont really understandi might just be a little thick but, create numbers on a form? What numbers? Or the little red circle? To be honest i dont remember seeing a red circle and even if i did set up an if statement for the colour of the circle they still would not be able to select the...

Hi i have a Calender control 11 on one of my forms at the moment when i click on my combobox the calendar pops up with todays date already selected. This is my code that does this Calendar5.Value = DateIf i wanted to just have the month and year selected with no day selected. Is this possible...

I have a form with 6 textboxes, name, company, address, town, county, and postcode. I have a button that brings up a form with a listbox. I select a name from the listbox and it adds it and all its linked fields to the form. The problem is i have set the address textbox as no duplicates as i...

I have done that but then it does not update the table.

You are correct. I have created a query linking the 2 tabels which shows me the company name not the companyid. Great, but when i do a notinlist for the combo box to add the new entry if not in the table it does not work. here is my notinlist code Dim db As DAO.Database Dim rs As...

Hi could anybody help me with this please? I have a table called companynames which consists of companyID and CompanyName. I also have a table called invoice which is linked to a form . When i type in the invoice form it adds the data to the invoice table. On the invoice form is a combobox which...