Recent content by andymartin3186

This worked. Thanks I just created a blank report rather than using the wizard. I still had to rotate everything 90 on, but that makes sense as to how it prints. Thank you!

Hi, I've created a report to print a single dymo label to my 550. The labels I'm using are 2112283 25mm high x 54mm wide and when using the dymo software they come out of the printer narrow edge first with the text 90 degrees on so the label is landscape when viewed. I've attached a photo of one...

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