Search results

HI, I am using Access 2007 and I have one something silly. I am near completion of my database, and I was trying to work out how to hide the menubar. I went into options - current database and clicked dont show navigation and menubars. I thought I would be able to reset this but I cant. I now...

Access 2007. I have created a calculation query, which when run gives me the total I require. How do I now get the total to show in the total field on one of my forms.

Hi, I am learning as I go along. I have attached the database. All I have done is create a table and form. I am just trying to learn how to use combo boxes to populate multiple fields.

Access 2007. When ever I try and use a combo box to populate numerous fields in a form all I get is "#Name?" in the boxes that I want popullating. Any ideas

Hi, I have created a form, but when I open it, it opens displaying the last record entered, How can I make the form open blank and ready to add a new record.

HI, thank you for your response, but I have never created a query so I do not know where to start

I have a table that shows payments made by different people on different dates. Each month the same people make new payments. I want to be able to filter my report to show only the latest payment made by one particular person at a time. At the moment it is showing all of the payments made by...

Hi, I did try that but got another error which I have attached. I have also attached a copy of the database.The database was created using a tempate which I am tailoring.

HI, My database is 15MB and the max attachment size is 2mb so I am stuck sorry. I have attached a picture of my form, as you will see there are 2 fields Cost and ex code. What I want to happen is when you choose an item from the combo box(ex code) for example weekly, it then enters the...

Hi, I am totally lost now, none of the suggestions work. I have tried everything but do not have a clue.

Hi, I have tried that, e.g. =DLookUp("Fee","Expense Code","Cost =" & "ex code") and still get an error, plese see the attached picture

Hi, This is what I am now trying - =DLookUp("Fee","Expense Code","Cost = " & [Me].[ex code]), but am getting an error, have a look at the picture of the error attached. Basically I have the following "Fee" is the Field which is in the "Expense Code" table that I want to be displayed in the...

Hi, Thanks for all of your help, but I am totally lost with this I have tried- = DlookUp("Fee", "Expense Code", "RecordID = Cost" & Me.ComboName. But it does not work

I am no tsure how this should look, I have tried - DLookup("[Expense Code]", "Expense Code", "Fee"). I know this inot correct ad does not work. [Expense Code] is the Field name & "Expense Code" is the Table name, "Fee" is the name of the field that I want to appear in the Cost box on the...

Here you go.

I will try and expain a bit better. On my form I have a combo box that lets you choose a billing option either, Daily, Weekly or Monthly. When you chose the option that you want, I want the form to look at my table called "expense codes" and depending on the option that is chosen then enter the...

Hi I have a form which has a combo box that lets you choose a record which then populates a field, how can I make it so that when you choose the record from the drop down box it also populates a second field with a second record from the same table as the first.

Hi Access 2007

HI, I am very new to Access so a novice is an understatement. I am using Microsofts Time & BIlling database to create a system where someone can bill people or time spent at a Nursery. The problem I am having is with Invoicing. The Invoice that is in the template adds all of the payments...

Hi thanks, that sounds exactly like what I want but I am no good with programing and would not know where to add it and what to alter.