Search results

I have changed the code to stLinkCriteria = Me![txtNCRNumber] DoCmd.Close DoCmd.OpenForm "frmNCR", acNormal, "", "", acEdit, acNormal [Forms]![frmNCR]![cboNCRNumber] = stLinkCriteria [Forms]![frmNCR]!cboNCRNumber.SetFocus This closes the secondary form and puts the NCR Number into the...

It seems like it is returning to the main form in a different way than it is initially called. What I would like to do, (maybe I'm way off base with my method), is from my main form, navigate to another form based on the record that is currently displayed. From there I would like the option...

I copied and pasted into the window and the double quotes translated into %22. Odd. Anyway that is what they should be. Pat

I will elaborate. From the main form I have a button that opens the second form (not a subform) and displays records that match the part # from the main form. The second form displays multiple detail recordss for that part # and I have a button to select a different record or return to the form...

I have a form with a combo box to search for a specific record. This works beautifully until I navigate to a popup window and return to the main form. Once I return, the combo box does not find the record I try to search for. I am sure I am missing something small, I hope someone can help me...

Yes I can, but there are four records with dates and only 3 in stock. I would to find a way to eliminate the earliest record. This is of course a simplified example. I might have 6 records with the dates and only 1 in stock so I would need to ignore 5 of the records. Is this clearer? :D...

I am trying to identify how long inventory has been in a specific location. The information that I have is the current inventory level and movements that have put the inventory there. Assuming FIFO I would like figure out the following. ex: I have 4 movements with various dates AND I have 3...

it seems that my tab control was too large and was scrolling. I made it smaller and now it is OK.

I have a main form that displays four lines of data. I have a tab control with 3 tabs. The form displays perfectly until I navigate to one of the other tabs and back to the main tab. It appears to scroll down a couple of lines and I loose the top line of data. Any idea what is happening or...

Try DateValue(left([datetext],4)&"/"&mid([datetext],5,2)&"/"&right([datetext],2))

I have a linked table to an exchange folder. My access application appends records to this table. When I work on my local machine the "Link Table Manager" says the path is: C:\TEMP\TMP\Inventory Adjustment Tracker I also have a server that has a scheduled job to append the records to this...

I almost have this working. :confused: This is my code: strBody = "<A HREF='<Outlook://Public%20Folders/All%20Public%20Folders/Production/z%20InventoryAdjustmentsApproval%20(under%20construction)>'>This is the text that will appear for the link</A>" This puts what appears to be a link in the...

I would like to send an email with a hyperlink to an Outlook folder. This is part of the code I have so far. .Subject = "Inventory Adjustment Approval" 'Forms!frmMail!Subject strBody =...

Here is my code for #4. If I run it with the red line commented out it behaves this way: When the Status is changed to "Closed", the calendar form pops up, I double click on the date, which then populates the txtDateClose control and then the focus stays in that control. If I un comment the...

I am almost finished this project. :p There are just a few things left that I would like to do and I need some help. 1. Add an email notification when data on the form has been edited 2. Filter the form for only OPEN orders, status not equal to 6 or 7 3. When an order is closed (status field)...

Oh, I see. Thanks again!

:D :p :D :p Thank you so much!!! Can you explain why that behaved the way it did?

:eek: Oops, Thanks It was too big. I have removed alot of the supporting tables so the combo boxes won't work. Just try to edit the text fields.

The date field isn't triggering a new record. When I edit the date field on an existing record, the other fields become editable. Before I edit the date the other fields have the appearance of being editable, but they are not. When I scroll through the records and attempt to make a change...

This property is set to "Yes"