Search results

There is not much point in having a database full of information that you cannot use. Queries allow you to use the information you have stored in your tables in the way that is most useful to you. Therefore, think about what you want to see and what order you want to see it in (ie numerically or...

Try compacting the database

In your table design, set the 'required' property to 'yes'.

Assuming the text is a title and will not contain information in your table, write the text in an Excel field. Adjust the alignment to 45 degrees and copy and paste it into your form / report.

Interesting. What sort of person goes through all the trouble of registering just to write abuse? To all geeks and non-geeks. Your help and advice is very much appreciated. Thank you.

I usually give all my tables,queries etc a code so that other people will find it hard to fiddle (in also makes me a little more indespensable in these difficult times). To keep track I just keep a record in a book of what they all mean.

I don't understand why you would not want any duplicates. Surely the combo box is there to allow specific data to be added.

Rich, We use Access 97. I had a database that we had used for some time when this date problem occured a year or so ago. It was happening with various people and it was during a period of expansion so we were continually buying new PCs for them to use. I got one of the new PCs and one of the old...

This came up a few weeks ago when using Date() for todays date. For some reason the more modern PCs don't like it and it should be replaced with =DateValue(now()). Hope that sorts you out.

Sorry I don't know if Access can do it but one workround is to number your inserts with a suffix, page 12 (a) etc.

Have you set the field's "can grow" property to yes?

Simple eh? Thanks very much

I've tried lots of different variations but still cannot get it to work. I need to highlight a field containing a date with a colour if it shows that the date has passed. (ie highlight if it is overdue). I have tried variations of < "Date()" but can only get it to work if I put an actual date...

Why not have two forms, one with and one without the subform. Just make the one with the subform available to the administrator.

I've had this problem before on a database that was being used for some time. I was given a more powerful computer and the problem appeared. If I switched back to the old PC then the problem went away. It seems that the more modern computers don't like Date() I got around this by substituting it...

Rich, At last! Yes that finally worked. Thanks for all your assistance, It's much appreciated. Saintsman

Try saving as HTML and then pasting onto word.

Still no joy. It doesn't seem to like two expressions in the same "If" statement.

Rich, Thanks for the suggestion but it still does not work, although I can't fault your logic. When I write what you say I get a compile error looking for an expected expression before the <= symbols. I'm sure that I am doing something wrong. The code is written in an event procedure but I...

I am trying to get a certain colour displayed for different value ranges (a traffic lights system). Although I can get 3 colours displayed using basic code (and I am not an expert in this) I am unable to get it to work when using BETWEEN. For example if I write the following I get a compile...