Search results

I didn't get much further with this, but had a light bulb moment late last night. I was running the code on a job by job level, to generate a single line csv to import to xero, meaning if I had 5 jobs to invoice I would have to go into each job and run the function. I knew it worked when not...

Could you help me with where I put that and when I call it?

The tempvar is working, as after clicking the button to do the csv, I can close the job form, run the query and it knows the jobID without prompting. Private Sub XeroExport_Click() Dim Filename As String Dim Filepath As String Dim queryname As String queryname =...

Ive tried TempVars("jobid") = JobID.Value and changing the WHERE to WHERE Job.JobID= [Tempvars]![jobid] Back to original error

SELECT "INV" & Format([JobID],"00000") AS InvoiceNumber, Customers.CustomerName AS Contact, Job.OrderNo AS Reference, Job.DateShipped AS InvoiceDate, "" AS DueDate, Job.SalesNotes AS Description, 1 AS Quantity, Job.Labour AS UnitAmount, 200 AS AccountCode, "20% (VAT on Income)" AS TaxType...

I tired the concatenate WHERE but it doesn't like it and won't save, (missing operator)

Sorry to be a nuisance, I'm a bit new to this, How do I adjust the query to concatenate the form control value? Alternatively where do I call that function?

OK I got this to work. I had to remove from the query the criteria that makes it only display the current job ID that the form is on. It then output the CSV perfectly (albeit without a filename but I can sort that) and as the criteria was removed it contained every JobID I will use this...

I've called that sub with the queryname and filename and get 3061 Too few parameters expected 1 Debug is at this line Set rs = db.OpenRecordset(SourceName, dbOpenSnapshot) Sourcename = XeroCSVQuery dbopensnapshot = 4

Can you manually create a new spec and test using that new spec? I'm trying to eliminate a certain type of corruption. Either it works or it doesn't - but if it works, you're back in business and if not, the problem is not likely to be corruption in the I/E spec. Sorry please could you explain...

Sorry for the delay been a busy morning I exported the query to excel without issue. I didn't even think about the attachment fields being multi value. I will try recommended steps

I've also deleted all the fields which do not exist in the database and kept it to just invoice number, unit amount and contact and it still errors.

The fields do not exist in the database, the query creates these just for the purpose of the csv. I couldn't think of another way to do this?

Tell me about it! The query runs fine (when given the job ID) The VBA code was copied straight from another form which creates a csv from a query and works great. The only thing I changed was the query name and filename prefix. Baffled!

Hi, Absolutely no MVF in any parts of my database.

Quantity is purely assigned 1 as it is always 1, its 1 invoice line.

Hi, Can anyone help identify where the issue is here. I've created a query to pull job data to create a CSV to export to Xero which will automate invoicing my jobs. The query runs fine on its own and displays everything I need correctly. Some fields are "" as Xero requires them present as a...

Hi I have a field on my form called Manufacturer which was a standard text box. I decided to change it to a combo box with a row source as: SELECT DISTINCT Manufacturer FROM Job ORDER BY Manufacturer It works great, and suggests manufacturers whilst typing which is exactly what I wanted it to...

Hi, Just an update I decided to develop this further. Rather than clicking a button and it opening the main form at a new record with prefilled data from code, I decided to firstly open a small form which asks for key required data - customer, contact, description, ref etc and upon a button...