Search results

Thanks again pr2-eugin, that works just fine...I don't need the command as you stated. this is much simpler and works great! Thanks again!

Hello All, I have this code below that works just fine however, I don't believe I have it in the correct event. When I have it in this event it does not fire when record has been changed. I have to click to the new record, click back, and edit the record. Then I get a message that the...

Well, I believe I understand what you are saying but I am still a beginner. Still learning. I will keep trying though. thanks

Hello liamfitz, Thanks for your response. I do understand what you mean however, here is the entire code so that you can see what I'm talking about. What I am trying to accomplish is: Copy entire record, including the records in subform and paste them into a new record. So the new record is...

Thanks, This is what I put in. ssSeqNumber = "" & [Forms]![product]![RoutingSubform]![SequenceNumber] ![Forms]![product]![RoutingSubform]![SequenceNumber] = ssSeqNumber I'm still getting "Item not found in this collection" Any Ideas?

Hello All, I am trying to copy an entire record into a new record. On the current form it works just fine however, the subform is where I am having the problem. Im trying to refer the code to the subform and it is not finding it. Here is a portion of it. I am really stuck on this...

Hey buddy, Do you think you can help me with this one? http://www.access-programmers.co.uk/forums/showthread.php?t=228015 Thanks

Yes.....didn't think of that.....any Ideas on how to accomplish this?

Hello All, I thought that this would be simple but anyways.......I just need a default value of "New" in my [Product ID] field. I went to properties and tried to put in ="New" and I am getting an error. The only thing I can think of is that I have a event procedure on that field that look...

Thanks spikepl, Basically what I'm trying to do is copy the record that it is currently on and copy it to a new record. This saves the user time in generating similar data for a new record. Any thoughts?

Hello All, Just trying to find out if there is an easier way of doing this. I know you can do something like this: example Dim dbs As Database, Rst As Recordset Dim F As Form Dim scompany As String Dim saddress As String Dim scity As String Dim...

Hello All, I have the following code attached to a button Private Sub DraftPreview_Click() Me.Refresh DoCmd.OpenReport "draft quote", acViewPreview, , "ProductID = forms!product!productid" Not much to it however, I changed it to be linked to a SQL table instead. The table it is...

Hello All, I solved it myself...Woopeee! right? Still Learning...I found the out by searching the forum. If this is the error, then most likely there is a field that does not exist. So check the code again and wala! found the error. Corrected it and now it is working fine! Awesome...

Hello All, I have a questions. This code was working fine but, when I added more data to the table it would error "saying overflow" so I changed Dim pID As Interger to Dim pID as Long Now it is saying "Too few parameters. Expected 1. Its has an error on the line that says "dbs.Execute...

Thanks Again, I appreciate the help. This works great! You are the man!

Hello, Sorry the code above is working fine when it is just in access however, I have it linked to a table in SQL now. Now I get an error telling me I need to use the "dbSeeChanges" option. I just need to know where to put it so it work on the linked table form SQL. Thanks

Hello All, I have this code below. I am trying to figure out where to put the "dbSeeChanges" portion of it so it will update my SQL db. I have tried different places in the code and I get type mismatch, which I understand. Any Ideas? Thanks Private Sub Form_AfterUpdate() Dim dd As Date...

Thanks Pat, I did try your solution and it works! Thanks so much for your help! I hope to be as good as you guys one of these days. Take Care!

It Worked! Thank you so much! I added just a little to it and it worked! I just followed the same pattern that you gave me. I just added a couple more "As String" Here is what I added Private Sub Form_AfterUpdate() Dim dd As Date Dim dbs As DAO.Database Set dbs = CurrentDb Dim...

Hello Pr2-euin, I tried taking the $ out and Im still getting the "Compile Error Variable not defined". Can you post the exact code you have so I can compare it to mine? Pat thank you for your post! I will try your suggestion as well.. This is the code that I have Private Sub...