Search results

Thanks, this worked great. The only bit that got me was the setfocus to "GF" line of code. Turns out "GF" was a text box but was 0cm x 0cm so couldn't see it anywhere but it wasn't hidden. I added one and it worked great.

I believe the issue is because its unbound. Do I need to add a field to the job table and bind the control to this? I didn't really want to store this in a table as its just temporary one off when running the report

Hi, I have a form where I can choose a customer, and then a subform displays all jobs currently set to "For Delivery" I have added a control on the subform which is an unbound yes/no check box. A query then looks at this check box status to decide whether to include this item on the delivery...

Whayhey this worked!! Its also showing 0 now when there is nothing Thank you!!!

Yes I currently have one result for testing purposes, and OrderID is the first column

No, its not on the main form as its a dumb form used as a main menu. This could be the issue. The TotalOpenPO query is basically returning all orders that "received" = False. The count is to count the number of lines in the query, Am I doing this the wrong way? Is there a better way?

Sorry I was stupidly mixing it up with thinking it was a text box! I've created a label on the main menu and put this in the main menu on load Me.LblOpenOrder.Caption = DCount("1", "TotalOpenPOQuery", "[OrderID] = " & Nz([OrderID], 0)) It errors with 2465 can't find |1 in your expression

I wasn't sure how to do this as its on the main menu and there is no control source. Each subform has an associated control source as the related query If I create a label on my main menu with control source =Count([ComponentOrderQuery]![OrderID]) It shows Error

Sorry no joy with this

Yes I agree, I was wrong in what I said earlier. I would like it to return 0 if there are no instances but can't get this to happen.

Legend! That sorted it. Such a simple fix! Many thanks

Hi I have created a small dashboard showing certain statistics of my business. This is comprised of small subform squares on my main menu. These subforms are based off queries, and the forms control performs a count or totals this various data. Attached screenshot 1 showing a blank subform, 2...

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