Search results

I've go a 'make table query' that makes a table called [Certs Data]:[QC_Status_Code]. When this query runs I would like it to look at the [QC_Status_Code] field and IF there are any with a 'H' I would like to launch a MsgBox telling the user there is material on HOLD. This is probably simple...

I've got a field in a query that is pulling the Date/Time from a table in the db. I've added another field in my query ... Tran_Datetime: Format([dbo_t_PMCS_History]![Tran_Datetime],"mm/dd/yyyy") to format the Date/Time into text so I can use the Date()-1 command. Problem is ... the Date/time...

This may be simple but I'm having a real issue with it. I've used Format([Input Table]!Birth_Date,"yyyy") & Format(Format([Input Table]!Birth_Date,"y"),"000") to go from a date to a julian but now I need to go from a 4 digit julian date to a mm/dd/yyyy. For example ... Today is julian date...

I've got a field in a table called GenTime. It is in a Date/Time format, like 5/16/2005 7:00:00 PM. What I need to do is extract from this field the time, like 7:01:00 PM to 7:59:00 PM. I just can't seem to make it work?? :( Help!

Hi Folks: I would like to know what code I could add to the below code to make Access close if the report I'm exporting is NULL. The DailyQC report looks at a table called Daily_INV_Certs and exports it to a mapped drive as an Excel spreadsheet. If the table Daily_INV_Certs is empty I want...

Hi All: I have a form called QC Query. On the form I have a search field called Lot Number. I have a query that extracts the Lot number and I've added this to the Lot Number column. [Forms]![QC Query]![Lot Number] Why will the form not work with a wild card? I've tried "*", * and Like "*"...

Hi: I have a form command button that runs a make table query and then brings up a report in print preview that is populated from the table. If I forget to close the report window and click the command button again Access will bring up a Halt window and then display. The database engine could...

Hi: I’m having problems with a combobox on my form: I have a form called Orders. On this form I have a Combobox called Order Selection Box. My combobox pulls in from a query two lines (Orders and part no). Under my combobox I have a text field that shows the part no from the combobox. Problem...

Hi All: I'm new to the forum. What I'm having problems with is a forum with combo-boxes. What I need is a way to reset the form "like a F9" so one table will not be locked. I've tried all the stuff under "Options" without any luck. I do know, that all I have to do is hit F9 each time and the...

Hi All: I'm new to the forum. What I'm having problems with is a forum with combo-boxes. What I need is a way to reset the form "like a F9" so one table will not be locked. I've tried all the stuff under "Options" without any luck. I do know, that all I have to do is hit F9 each time and the...