Search results

I can't see it. Do you want to try again. :p

Can you attach your database?

You need to link the child (field on subform) and master (field on main form) fields.

Try this query SELECT Table.CombovalueField, Count(1) AS Count FROM Table GROUP BY Table.CombovalueField;

Yes, but I don't know of a built in function for it. Check out this which might help. It's to check if a form is open but it should work ok with a report I think.

Questions like this should probably be put in the Microsoft Access Discussion section under the relevant forum (in this case probably Forms). This forum is for people to leave samples of code that other people might find useful to put in their own databases. :D

Do you mean you are selecting a value from a combo box and storing that value in a record? Can you post your db?

Not sure if you can refresh a form once it's open. You could however add some code the your proceed button that will close the report and open it again (you will need to make sure it only tries to close the report if it's already open though).

What is the error it gives?

Have you zipped the database as well? If you still can't get it small enough, just import the problem form into a blank database, zib that and post it.

You could set your computer up to run the database automatically when you turn the computer on, then you can see if any dates are approaching and close the database once you've dealt with them.

Can you post a sample database with your problem form in?

Have a look at my reply to your original post here

I've attached an example for you.

I'm guessing you can't use =isdate as a validation rule. What you could do though is use something like >=#01/01/1900# (or any other arbitrary date ages before any of the dates that will be entered). Thinking about it though, if you've got the data type set to date/time it won't allow...

Just need to change the onclick event for the run query button so that it opens whichever form you need. i.e. stDocName = "Form1" DoCmd.OpenForm stDocName, acNormal, acEdit Instead of stDocName = "Query1" DoCmd.OpenQuery stDocName, acNormal, acEdit and set the record source for the...

Also works fine on my test DB.

Have you tried compacting your database to make it smaller. You can also delete the records (compact it afterwards) although leaving a few examples in might be useful.

Is the priority being stored as a number or as text. If it is being stored as text then I think you will need to enclose the numbers in your if statement in quotes. i.e. txtPriority: IIf([Priority]="1","High",IIf([Priority]="3","Low","Medium"))

I would suggest something like >LA##LLL The > converts all letters to upper case All reg plates (new style and old style - since about 1983) begin with a letter hence the L (A to Z, entry required). New style plates have another letter next, whereas old style plates have a number. The A...