Search results

@Pat Hartman That is what I was thinking about if you check my previous post..... Maybe something like open a recordset for the new records that need to be appended and run an append query for each individual record till EOF? I'm I, right? Trying to learn :) Just trying to do it because I end...

Here, I change only some criteria in order to work as there is no order at the moment. Check form1

Yes, I manage to implement your code/module in my DB but the issue is that the query that Appends data to the table returns multiple records (depending on the ready orders at the time, it can be 1 or 2 or 3 or...101) and it gives the same next number to all (!docnum = Nz(!docnum, 0) + 1. ) and...

Thank you both. As I am new to access I am trying to understand the workaround of your proposals. @Pat Hartman. I am not using any form. Just after orders from different clients are made and are ready to be invoiced the Append query inserts multi records to the table invoice and needs a unique...

Hi, I'm using a query to append data to a table for both invoices and credit notes in the same list. On this table, I need to have a document number field increased based on the document type. In this table, I have fields, DocType (values INV or CRN) and DocNumber For DocType Invoice, I need...

***** 5 stars from me..

yes, my friend.....It worked....... You are awesome........

sFile = "c:\"test.txt" But this will overwrite the old one I'd like to keep all files

also, the .txt file in the temp folder is empty..???? and there is no update in the table with no error. Should I add any references?

Can I save the file to a specific folder instead of temp Like sFile = Environ$("c:\") & "\test.txt" instead of sFile = Environ$("Temp") & "\test.txt" It is not seems to work, should i change something else?

Yes this works db.Execute "update invoices set Invoices.UID ='" & UID & "', Invoices.MARK = '" & Mark & "' WHERE ((Invoices.InvID)= " & idx & ");" as UID is a short text and MARK is a number

Also, Can I save the responseText text to a specific folder in C:\

Man, you show me the way. I paste the code inside my code (at the end of the loop after "req.send myData") and I receive the following errors: 1. duplicate declaration in current scope for Dim DB As DAO.Database When I put a ' before it I receive the next error as it is already declered 2...

I appreciate your help arnelgp. Will try and let you know of the results later........then I can buy you a beer :)

So the idea is to save the responce to file first then open the file and use it to update the table?

I am new to Access and VBA. I'm POSTing some data using the bellow code I receive an XML response. Sub POSTreq() Dim req As New MSXML2.XMLHTTP60 Dim reqURL As String Dim Db As Database Dim Rst As Recordset Dim Tbl As String Dim restxt As String Set Db...

I decided to go by mail as there must be pieces of evidence of what has been ordered to be shipped. So mail is for me easier to handle and code. I will share more details when done. Thank you for your kind help.

Dear Pat First, thank you for your reply. No, they are not on the same server. Does ftp need static IP? If so there is not. So email is one way.

Now I have to check what wildcard is :-)

Dear The Doc man. Highly appreciated your help. Honestly, my skills are not that great but I've already managed to do a LOT with some help. Your guide is quite interesting. I will try it I will ask for help when stuck. I have already build a module to end auto emails. I love to learn and am...