Search results

Try this on for size

The first visible column, which is determined by the ColumnWidths property, isn't equal to the bound column" This means that the name you type (which isn't in the database) cant be found, therefore the bound column (the hidden column) cant find a record with a matching auto number. This has...

Ah, as I thought. But you want to books rooms in advance. You will need different records for different days.

My apprentice asked me this morning... Q. Did you hear about the baker that had smell hands? A. He kneaded a shit.

I think you need to work on your table structure. At the moment each box is related to one record (set navigation to yes in the form properties), so only one label per record would ever be a different color. Not sure if that is what your looking for. If you can do it excel, whip up and post a...

Good to see you got it working. Dave

Conditional formatting is the way to go. The image attached shows how I format a field to: 1. Turn yellow when it has the focus (I do this for ALL fields, so the user can easily tell where the cursor is on the form.) 2. Turn orange when the date is within the next 31 days. 3. Turn red when...

The format is set globally on your PC through windows.

Not sure, but TRY editing line 42 in the frmInputbox code to: sql = "SELECT * FROM [tblInput] WHERE (([tblInput].InputDate=#" & Format(f.[InputDate], "YYYY-MM-DD hh:mm:ss") & "#));" As the date format on my PC is different, I'm finding it hard to replicate. Dave

I hate it when "some a** hole stole my laptob" :eek: PS: what was the password again :p

I have seen several poor examples of similar things in access, but nothing as detailed as your screen shot. If this could be developed to a usable level, then you would be on a real winner. Dave

A Litre (here in Aus) is the modern equivalent of a gallon. (About 4.5 lt to the gallon) Just because a litre is only about 20% of a gallon, don't expect the price to be. :eek: Surprise surprise

Thank, after due consideration I decided to select this: Available from this mob http://www.acabion.com/ If I survive the weekend I will fill you in. Thanks for the great prize. Dave

Yep, but probably already gone (thus your involvment), then hire one of us at an hourly rate to clean it up. Dave

Easier to show than try to explain. Should be fairly clear, just need to set a reference to DAO 3.6 Dave

Harsh, very harsh Banana Oh and PS: Aye aye aye :D

08/25 2HR GTT(Q): GLUCOSE (FASTING, 1HR, 2HR) 83, 145, 69 WNL If this data is all in one field, then you are gunna get fired. Goodbye :p

"[Name 1/Last Name]= " & Me.Combo0) This piece presumes a numeric value (sorry) "[Name 1/Last Name]= ' " & Me.Combo0 & " ' " ) See how that goes

Do you want to keep the record place even after the Db is closed? If not, then why not set a variable and use that when re-opening the form? Create a module Presuming the reference is a number... Public iPlace as integer In the forms Unload event: iPlace = ME.IDName Then on the forms load...

Sure can.... =DCount("[Premise]","[D - QrySelect100]","[Name 1/Last Name]=[Combo0]") Premise = field name D - QrySelect100 = Query name (strange query name - should have no spaces at least) Name 1/Last Name = field that is used in the criteria. Once again strange field name. Presuming the...