Search results

If by default, Access stores the date along with the time, in a field formatted as Short Time, then yes. Otherwise, I've done nothing to deliberately cause the date to be stored with the time. also, I realized earlier that when I tested this, I just typed in the 2 time values. Would it make a...

If I use: =Format([Time Down]-1-[Time Restart],"Short Time") to show the total minutes that have passed, even though it displays the value in terms of hh:mm, how do I Sum the field to show the total of all entries? When I used: =DateDiff("n",[Time Restart],[Time Down])*-1 I just surrounded it...

It shows the minutes correctly but drops the hour value. And 08:00 to 10:00 displays as 0 instead of 120.

I have a form that tracks when the production line stops, and when it is restarted. A 3rd (calculated) field displays the difference. a 4th field Sums up all the downtime and displays the total in the footer. Everything was working fine, until I noticed that if the line stops before midnight...

Hey bro. Here's a method I use and it's pretty easy to keep track of. Create a query on the table that holds the data that is entered when the quote data is entered. In the Criteria field, type: [Forms]![Form 1 name]![ID] - this will look only for the record number indicated by whatever...

This should be easier, but I'm in a panic and under pressure (lol). I have a form with a subform. The user will enter a number on the subform and I want to compare the User's entry with a number on the main form. If it matters, the number on the main form is displayed using the DLookUp function...

This should be easier, but I'm in a panic and under pressure (lol). I have a form with a subform. The user will enter a number on the subform and I want to compare the User's entry with a number on the main form. If it matters, the number on the main form is displayed using the DLookUp function...

Can Access send a Report automatically, at a specific time each day?

Hey everyone. I think this is the right forum for this question. I have a form that tracks Production Downtime. The table contains the fields: [Total Minutes], [Time Down], and [Time Restart]. A form uses the function: =Sum(DateDiff("n",[Time Restart],[Time Down])*-1) to show the difference...

sorry for posting in the wrong forum, I try to be more aware of that. I think you're right though, because when I just run the report, it shows just the 2 entries from the table. But I have a button setup to run the report for the specified record, attach it to an email, and send it to the...

I have a report whose Source = 2 tables in a query where they share a common field: "Order Number". There is a 3rd table that adds the package size information. The Report is set up shows the product that is being ordered at the bottom and a third table shows the shipping dimensions of the...

Can you show the Sum of the values in a calculated field?

I see. To this day, I have never successfully used a Function in VBA to do anything. Web pages don't answer all of my questions and I'm left hanging. I understand what the function is trying to do, I just have no idea where to put it.

Yes, but where, please? The last explaination wasn't clear about where to insert the DateDiff() code...

Hi again. Does anyone have a simple code to subtract one Time from another and display the result in Minutes? Ex: [Time Up]-[Time Down]=[Total Minutes]

there's a hidden text box on the form named "T" which is set to me.T.value = (CDbl(Time)). That's the value that is used in the comparison. But thanks, the previous suggestion actually worked.

Thanks Bud!

I want a User to click in a text box. Upon clicking, the current time appears AND I want the "Shift" textbox to auto-populate with either a 1 or a 2. I used CDbl to convert the the system time to a decimal, then made it a math problem. Midnight is 0.0, 6am is 0.25. 1st shift starts at 0.25. 2nd...

Has anyone ever built a number keypad? I'm talking, digits "0" through "9" with a Submit and Cancel button. I'd like to open a little numpad-like form, enter a 3-digit code, and click the Submit button to give the Suprevisor 'over-ride' access to change information on the main form. I have some...

Thanks. All good stuff. Turns out that the form I made, based on a query of tblBOM, will update the table by changing the date and saving so it was really easy. Another simple query and I opened a different form, on the Double-Click event, to view the entire record. Thanks again.