Search results

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...

That works, thank you!

I've tried that but still nothing. I've tried setting default customer and contact ID's to 1 but no change When the form loads its like its not created the record yet as everythiing is blank including the autonumber and the check boxes are all ticked, once you click into a field an autonumber...

Hi, I'm trying to open a form from my main menu to a new record and pre insert some fields. The form opens at a new record however I'm not sure why nothing happens from there on, it opens with everything blank including the autonumber, is there something I need to add to create the record...

Many thanks for your help. Both worked great for me.

Hi, I have a textbox formatted to put a prefix letter PUR and make it 5 digits total so ID 7 for example would be PUR00007 The textbox displays fine, but when clicked to copy this, the "PUR" formatting disappears leaving just 00007 This is a nuisance when I need to copy and paste from the box...

Hi All, As always thank you for your support and guidance. So, to clarify, I shouldn't be storing "qtyinstock" inside the component table, instead I should create another table called stocktake, create a relationship with the components table and store the qtyinstock in this table along with the...

Thank you for the help on this. As my system is dealing with services rather than supply of goods its a little different to a system that orders goods and ships them out. For the interim I think the existing system will suffice with how it is designed. One question I would like to ask is, if a...

Amazing!!! Thank you so much