Search results

:confused: Pretty easy to follow what I need. I just don't know how to do it. The only thing I wanted to do is have a popup message box (MsgBox) if a field in a table has a 'H' in it.

I have know idea why this was made this way. The only thing I wanted to do is have a popup message box if a field in a table had a 'H' in it. This is all I wanted to do

How about if I show the QC_Status_Code on a sub-form? How can I launch a MsgBox then? I have know idea how to write the code to do this

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 would work but the 4 digit Julian field I need to change to a date is a text field. When I try this I get an error on mismatch type. Thanks

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...

Never mind! What a brain fart I had yesterday :eek: :D

I've tried TimeValue() but I need al row with times from 7:01:00 AM to 7:59:00 AM. How could you use TimeValue() to do this? Thanks :)

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!

Thank you! Work like a charm!

Not sure how to do this? Any examples? Thanks

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...

This worked! I kept playing with it and this worked: Like "*" & ([Forms]![QC Query]![Lot Number])

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 "*"...

How do you share the code to fix this locking up problem? Thanks

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...

Thanks Tim That worked! Much nicer reply from you than I got from my other post..:)

What a way to greet a newcomer Sorry I messed up and posted twice. Hope I didn't hurt anything.. Also, thanks for all the help.