Search results

Try take the PM out and it should work it is down to the formatting of the code

Have you looked at this example odun.

Have a look at this example and it should show you a way forward. I have forgoten who wrote it in its first instance but it was in Access 97 i think, but feel free to correct me. Alastair

Have you deleted a field called "Description" from your database, the other thing that i have come across is the in a field some were access in it wisdom has placed a strange entery into the table. If you can attach a copy of your database i will have a look for you. Alastair

Are you a red head Selena?

I think it could be due to a fresh copy of the database been sent back to you, some of the internal info is corrupt. If i was in this situation i would, start a new database and then import the tables and forms e.c.t. Alastair

A Grey box = Even Rating

What does a grey box do? on your Reputations mean

You will be asked to input "intSegment1" & "intSegment2", just press the following buttons: intSegment1 = 1 intSegment2 = 2 This will allow you to sort the colums in question, i hope this will help you in your quest and good luck.

If you want to post your Database here i will inclose a query that will split your data for you. Alastair

This is true, You have alkways help me out were needed.

OK Sorry Selena

selena, Are you talking about me!

selena, You beat me too it.

If you go to Tools then Startup then goto Display form/page find your openning form and place it in the box then untick Display Database Window. If you need to by pass the openning screen you need to click once on your Database then holding shift double click. Hope this helps if not get back in...

When you click on the comb box and go to properties, under table/query you should see your table that the comb box is using, then click on the three dots next to your table this will take you to a query builder (SQL). Select your table from the list and add the fields you need, the you will see...

If you search Access help files under the following "Microsoft Access database specifications", it says Access can deal with 255 users at any time, i have used it on ten users and it goes slow. Alastair

The Insurance company's they like taking your money but when you have a need to claim on your insurance there is always a loop hole they get away with not paying out.

Has this resolved your problem?

= Forms![Main Form Name Here]![FRM_UPDATEVAL_sub]!SUPPCODE") Try it and see if it work OK