Search results

Hi All, I am currently using Access 2003 and have an unbound text box in a report with the following code: =Count(IIf([Complaints Table]![Month]=1,IIf([Complaints Table]![Decision - Our Favour?]="Y",0))) The problem that I am experiencing is that I keep getting a "#Error" message in the...

Hi All, I have many forms in my database, three of which completely freeze the database if I edit the slightest thing on them. These forms are all the same, and are unique to any other type of form in my database. An example of one of the forms is the following: The form is an "Edit...

Hi all, I'm trying to show the modal value of a column in a query that only has text in, not numbers. I want to present this in a text box in a report. My report already has a query as its record source that only shows data for a given year and given month, these are chosen using parameters...

Hello all, I am having trouble creating a chart within a report. Let me start off by explaing my report. I have many unbound textboxes on my report that all have the code very similar to this: " =Count(IIf([Complaints Table]![Month]=1,IIf([Complaints Table]![Decision - Our Favour...

Hi all, I have a form with various input boxes, three of which are combo boxes. These combo boxes need to affect one another. So let's call these cmb1, cmb2 & cmb3. Hypothetically let's say: Within cmb1 the list is A, B, C & D If the user was to choose A, cmb2 would show the options 1...

Hi All, Bear with me as I'm am relatively new to access. I have a search query that searches for different results based on 3 criterior. I have set up a form so that the user can input the text into the form and then once the Submit button (that i created) is clicked the query table will be...

Hi all, I'm looking for a button that cancels an entry on a form. I want everything within that form to be cancelled including the Primary Key field. I currently have a button the uses the me.Undo code and then automatically closes, however this only clears the data that has been entered by...

Hi All, I am relatively new to access and am trying to covnert a spreadsheet in Excel into an Access database. So far it has gone well until i have reached cells that have formulae. I haven't got the slightest idea of how to recreate this in access. The the formulae in question are as...