Search results

Thanks for the suggestion, it's not what I'm trying to achieve here though

I had an issue with a database last week. The tables are lined with SharePoint lists and I currently have 10 different PC feeding data to and from the SharePoint list, the system has been working well for about 6 months until one day last week when our internet dropped for an hour. All the...

That works - thanks

Guys/Girls, I’m looking for some help with SQL for a query in Access 2016. I have department with different employees recording a task on access every time they fit a component on the factory floor, the data is simply their name and the date that they completed the task. Table...

Hi Everyone, I finally found a solution, there were a combination of a number of factors to overcome before finally getting it over the line. 1. Instead of using Code128, I downloaded one of the many free Code39 (or 3 of 9, depending on the font) that were available online and swiched to...

That's a useful tool. However, it is only brining up the barcode fonts that are in the Windows/Fonts folder. I did find plenty of fonts in the WindowsApps folder, but no barcode fonts. I'm wondering if there is some kind of an add-on or encoder that I may have inadvertantly loaded onto my computer

I had already tried Code39 and can't get it to work at all. I've followed the link that you suggested and what is recommended their doesn't work either

Yes I did, that was my first thought - I reckoned it would be easy to just copy the font from one machine to the other. No dice

Even though the font is available on my computer, when I look in the C:\Windows\Fonts folder it's not present. Apparently in Windows 10 there is a second restricted folder that I wasn't able to search. I thought that I could just find the working one on the internet and download it as well...

I'm working on a production monitoring database that at one particluar stage a label is printed using an MS Access Report. In the label I have the Primary Key for the item in barcode format Code128. On my computer I have two Code 128 fonts, if I choose one of them I get a label with a...

Although the Requery worked, if I close the report and then tried to open it again I got an error becuase the code was looking for a hidden report and couldn't find it. I could have change the close button to hide it again, but I was thinking that if I had multiple reports then would I need to...

I gave it a try, and although it resolved one problem, your solution created another. Because the report was open, and hidden, when the form was loaded, it did not update with the data generated in the form and therefore had blank lists or errors in the text boxes.

Yes I did, thanks

I've localised all the tables (they are normally on SharePoint) and had to removed most of the data to get under the 2Mb limit. There's nothing confidentail here, so knock yourself out. Thanks

Yes, I have the following code On Load for the report Me.AutoResize = False It makes no difference though. I have just noticed that if the main Access Window is minimised then the report only opens as the title banner, if main Access Window is open or maximised then the report opens...

The Pop-Up property is set at yes

When I change it to acViewPreview the report doesn't pop up, but opens in the main access frame in a frame only manner as well

Hi All, There is probably a very simple solution to this, but after a couple of hours of experimenting and google search, I can't find it. When I open my DB in design mode, i.e. pressing the "Shift" key, I have no problems. The form opens ok and the report opens correctly from the CMD button...

My last post made me think of somthing. I changed the [Ship Wk] date format in the query for the main list to "yy-ww". When I then group these in the sumamry list it all fell into the correct order. Thanks for your help

I had considered that, but ran aground becuase orders have different status. First status is when the order is placed by the customer - these are the furthest out orders. Once the customer decides when they want the product the status chages to "carded" (as in a production card is created), this...