Search results

Yes - all three fields are bound to visible conrols on the form. WOHOO! Your suggestion worked great. Thanks!!

Hi RuralGuy - Yes - they are all in tblPartStatus

I have a subform that displays part information on a master form. (The subform is on a tab display). In the AfterUpdate event of the Serial Number control (on the subform) I have this code: If Me.SerialNumber <> "TBD" Then TransactionDate = Now() StatusId = 2 DateReceived = Now()...

Um.... okay - I'll read it again. In my db - each line item in a purchase order could be a consumable item or a non-consumable item. If the item was not consumable, an x number of entries would be made into a part inventory table with a status of "On Order" where X = quantity entered. A...

Conclusion to this long story.... I was working on this database just before Thanksgiving holiday. I came back from holiday and ended up having to drop this project to work another. A couple of weeks ago I came back to this database. Not sure how but my database ended up getting corrupt and I...

Hey Thanks for the suggestions... HiTechCoach - I think I will try incorporating the SMTP code! :)

Thanks for the reply wiremonkey. I was just curious to know what other people out there were implementing. I have an automailer working... and I can schedule at task for it.. but I seem to be running into other issues. When Access uses Outlook to send the mail I encounter the MS Outlook prompt...

For those of you who have implemented auto emails from Access - I'm assuming it's necessary to have an instance of Access and Outlook open at all times in order for the emails to get sent... (??) Is there any way to accomplish auto emailing without having to have either application open all the...

Sorry...it's not that I didn't trust your advice, it's just that I kept getting "Run-time error '94': Invalid use of Null" at Private Sub Form_Open(Cancel As Integer) ===> strConsumable = Me.OpenArgs End Sub After trying different things I found that if I created a module called Globals...

Nope. DoCmd.OpenForm stDocName, WindowMode:= acDialog, OpenArgs:= strConsumable I'm trying to pass the variable to the subform from the dialog form. strConsumable in the OpenArgs argument of the dialog form? It's null and it will be null until the user clicks yes or no. (crashing). I need...

First, thank you trying to help. Second... no luck. Here is what I have so far.. Events from the subform "sbfPurchaseOrders" that contains the Before and After events... Option Compare Database Option Explicit 'Is the PO line item a consumable? Y/N Dim strConsumable As String Private Sub...

The Before_Update event opens a form that asks the user the Y/N question. I want to read in that Y/N response into the After_Insert event of the originating form. In response to your question, the Before and After events are on the same form. By opening the other form in dialog mode, I can at...

Thanks I'm trying that right now but it seems as though the Before_Update and After_Insert are firing off at the same time or the After_Insert code is firing before the user has a chance to answer the question.....

Hi Everybody, I've been searching the forum for information on passing variables but I'm not sure how I would apply it in my case. Can someone help? I have a subform of a purchase order form. As the user enters the first line item, I have to check what type of line item the entry is. In...

pbaldy - that was it! I didn't realize the on change event would fire with every keystroke - I thought it would only fire after the user tabbed to the next field or saved the record. I moved the code to the on Dirty event to capture the data before it was modified (since I'm tracking history)...

Issue #1 This problem still exists... not to sure why it continues to append several records when I expect only one record to be appended.... I appreciate any help as I keep trying to solve this issue. :) Issue #2 I finally figured out issue #2 by refering to each field as follows from...

Issue #1 Here is the SQL from the append query.... INSERT INTO tblPART_STATUS_HISTORY ( SerialNumber, TransactionDate, StatusId, PartInvId, PO_Number ) SELECT Forms!sbfPartsInventory_PS!SerialNumber AS Expr1, Forms!sbfPartsInventory_PS!Date AS Expr2, Forms!sbfPartsInventory_PS!StatusId AS Expr3...

I ran with this idea that I grabbed off this board and now I ran into a dead end... :D I wanted to track the history of 2 specific fields on a subform. I saw an example that used an append query to do this. I created an append query that actually appends the entire record into a history...

Awesome! That did the trick - Thanks!!!

:confused: I'm kinda stumped right now.. After the user updates a subform, it inserts a record into another table. The transaction date, which is the OrderDate from a parent form, keeps getting inserted into the table as 30-Dec-1899... how can I fix that? Dim strSQL As String strSQL =...