Search results

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

and you're being a jack ass. the question is simple. And of course there were forms involve.

Let's re-phrase the question. I have a table of records, each record has a "Last Reviewed" date. I wrote a query to show all records where the "Last Reviewed" date is older than "Today()-365". That returns the right records. Now I have a form base on that query and I made it a 'split-form' so I...

The first table is the result of a Make Table Query. (There's really only 1 table, since the 2nd one is going to be overwritten each time it is used). I want to be able to select one of the records on the form and run an update query so that the value updates in the real (permanent table).

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

ok. thanks.

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

thank you so much!

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

Thanks for everyone's suggestions. This worked: On Error Resume Next 'on the form, "txtJulDate" is an UNBOUND textbox that displays the string, the form is read-only If tCDblTime.Value <= 0.249305 Then ' subtract "1" from the variable "JD" Me.txtJulDate = PN & YR & JD - 1 & DC & "0" Else...

Got it. Thanks!

I meant that it is not our plant's policy to change the date code for production hours between midnight and 6am. We run 2 10-hour shifts and and second shift runs until 3 am, but 1st shift comes in at 6am. sorry for the confusion.

Thanks. Does it have to be "CDbl" specifically? Or did you use that as an example of a variable name?

Here's the actual VBA that displays the date code in a textbox . The bold line displays the code. The other textboxes below represent the expiration date, but they are not an issue here. Private Sub Form_Load() Dim PN As String 'Plant Number "5401" Dim YR As String 'last digit of the year Dim JD...

What I'm looking for is something like this: If Time( ) > 12:00:00 AM AND If Time< 05:59:00 AM Then... 'this could easily just reference the value of another textbox that displays the time, or read the system clock, whichever). I've the code to display the actual "DATE_CODE", it's the If-Then...

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

My work has 7 production lines, canning cooking sprays. On each line there are 7-9 positions that fill out a form for each product produced. For lack of knowing a better way, I made a separate form for each position, each form being linked to separate subtable to store the data. I created so...