Search results

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

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

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

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

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]

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

I want to update a table by entering a new date on a form. The form itself is based on a query that looks at a field named "Last Reviewed" and returns any records older than "today - 1 year". The form shows the Spec Number, Product Name, and Last Reviewed fields. And there is a command button to...

Can someone help? This is real easy, I just can't seem to get it. I have a table (named "Reviews Needed" with 2 fields: "MaxOfFINISHED PRODUCT NUMBER" , and "LAST REVIEWED". A second table named "tblBOM" has the same 2 fields and more. I want to write an update query so that when I change the...

This is my first time to post in Reports. I'm usually more concerned with forms. I keep running into this scenario: say for example, there is 1 table and 1 subtable (or more). the first table table [tProductInfo] has (1) entry. The 1st subtable [stLots] contains 2 (or more) entries that...

my source gave me this: <customUI xmlns="http://schemas.microsoft.com/office/2006/01/customui"> as the first line of the XML when creating a new ribbon, but it is not current. Does anyone have a more current reference to schema?

So if I have a Public Function named "LCode" in Module1, and Form1 has 2 textboxes: tbox1 and tbox2. When a numeric value is entered in tbox1, I want the function in Module1 to be applied to it, and display the result in tbox2. Can anyone please just tell me how to do that? help files seem to...

Hey everyone. I'm looking for opinions here. I have a string of text (which is built by piecing together pre-defined variables) which represents up to 5 different variables. In all, there are 3 possible combinations of variables. On a form, there is a number 1-2, or 3 which represents the...

Hi everyone. I have a situation (doesn't everyone in here? lol). I have a form that displays a lot-code date for a manufacturing process. In my plant, on 2nd shift, it is our policy that when the time passes midnight, the code does not change dates but keeps the same date. So I need to write a...

I've heard about 'cascading' forms, or subforms, but what I need to do is open the same form twice or more times, on the same terminal, where each instance of the form inputs data for a different production line but still stored in the same table, and any instance can be closed without closing...

Hello, can anyone tell me how to copy a record and save it with a different name? The primary index field in the table is Text-formatted but contains the sku numbers of a list of products. The table holding the records contains a lot of fields, 82 ti be exact, and one sku can vary from another...

Does anyone know the code to display the date as Julian in the format: yddd, using the system clock? I have tried variations on the 'Now() function but I'm missing something...thanks.