Search results

just another option. this does not move the label but has fixed label and only change the color or hide the label. open form frmMapStatus.

the format is: hh:nn:ss you can create a form (datasheet or anything) against that table and set the format of the Textbox on design view of your form.

the field is Date/Time (so it is Date + Time). you can suppress the Date portion by Editing the table structure and adding hh:nn in the Format Property of the Date/Time field. but this is Only for display, the Date portion is still there.

isn't it Dec-30-1899? since this CDate(0). and Format(CDate(0),"mm/dd/yyyy") = 12/30/1899 this is what CoPilot explains: In Microsoft Access, 01/01/1900 is often seen as a default or placeholder date—but it’s not the true "zero date" in Access. That honor actually goes to December 30, 1899...

add an "anchoring point" in your map. you can add 50 invisible label controls on each States on your map. name them same as the State Abbrev they are in, eg: "lblWA". then you can just "move" your labels/checkbox to the "anchoring point" if checkbox WA (chkWA) is checked and want to move it...

how does the listbox get pupolated by the combo, show us the code.

with those numbers, sad to say, it will soon, and you need to backup often.

the usual disclaimer applies that it is at your own risk..

i was guessing to do the DCount() on table tblShiftsMachinesRan? and add the EmployeeID on the Criteria: DupDateCount: DCount("1","tblShiftsMachinesRan","ShiftDate= #" & Format(tblShiftsMachinesRan.[ShiftDate],"mm/dd/yyyy") & "# And EmployeeID = " & tblShiftsMachinesRan.EmployeeID)

as i remember, Nicole is the one who is trying to work on your db, you should ask her.

how did you saved the filter?

it is. since it only add Space on each character and not really justify the text.

that means to Re-open the report. you can remove the: subform.sourceobject="" to minimize the flicker.

I tried it but it does not Refresh the report with the new "filter"

I maybe wrong, but, you can't change Recordsource/Recordset of a Report once it is already Loaded. your best option is to use subform for your report and just mimic the design.

You might be interested on making the 2-Column contract in MS Word. then use Mailmerge to put the Info to the word docs. Or add Bookmark to word doc and fill it up from Ms Access.

wearing big hats. :LOL:

expect volumes of refugees flocking in..

How about (Query1): SELECT [Master Data].* FROM [Master Data] WHERE (NOT ([MATERIAL SUPPLY DATE] IS NULL)) AND ([TPA DATE] IS NULL) AND ([DD_RECEIPTNO] IS NULL);