Recent content by slovell

if me.txtCurrentTime = "9:00:00 AM" Then msgbox "Phrase goes here",vbexclamation if me.txtCurrentTime = "10:30:00 AM" Then msgbox "Phrase goes here",vbexclamation if me.txtCurrentTime = "11:00:00 AM" Then msgbox "Phrase goes here",vbexclamation if...

I hope I'm answering your question right here: I have an unbound text box named .txtCurrentTime. I have the form timer interval set to 1000, and on the OnTimer event I have the following code: Private Sub Form_Timer() '// update current time With Me .txtCurrentTime = Time() End...

Stuck!! O.k. I have the On Timer event working to track the current time. I have multiple If statements telling a message box to pop up if the text box value is equal to a specific time which are not working. I'm looking for the correct syntax for possibly a Case statement for the following...

Thanks for the quick answer. I will play around with this.

Hi All, Newbie question for you. I have a form that holds the current time (running time) and what I would like to do is at certain times have a reminder text box pop up that tells the user to check a certain report. So when .txtCurrentTime = 11:00 A.M. I want a message box to pop up reminding...

Hi, This may be a dumb question, but I've got kind of a question about adding values. I have a subform that contains a department name, and it's waste totals (in Kilograms) for the day, for a particular company. The company information is the main form. Whenever I start a new department, the...

O.k. Keith...so if I get you right...this is what it should look like Yearly Total Weight KG is one of the fields right now. it should look like Nz([Total Weight KG],0) Right? Btw...thanks for all the help so far.

where do I put that statement?

There will for sure be null values in the specified fields, but I just noticed that it looks like I'm getting duplicate returns from my query...exact same information, except the second row is erroring??? ugh...sorry. Here is my SQL: SELECT MainInfo.[Company Name], [Waste...

Both actuall:confused:

O.k. I have a query working, and it's calculating perfectly and I'm reporting on it fine. However I noticed that when I run the query it doesn't populate the equation for all the results. Let me explain further. I have a main form for tracking company information, and a sub form that tracks...

Next Step O.k. I have the query working, and it's calculating perfectly and I'm reporting on it fine. However I noticed that when I run the query it doesn't populate the equation for all the results. Let me explain further. I have a main form for tracking company information, and a sub form...

Success!!! :)Thanks odin1701 the first suggestion you made worked perfectly. I just need to format the field to show less decimal places and I'm all set. thanks a million for the quick response.

Sorry I think I might have mis-stated what was happening...Sorry. The calculation is actually happening on my form in an unbound field.

Hi, I'm very new to Access DB developing, but I'm learning loads, thanks to this site. What I'm trying to do, and it's driving me crazy, is the following: I have a Table that has to fields (Total Daily Weight) and (Total Yearly Weight) and I have a field that calculates the percentage of yearly...