Search results

Hi Folks, I've put together a simple planning query that checks the number of times that different sized moulds are required each week over a period of time. The problem is that formating the week number it only uses a single digit for week numbers between wk 1 and wk 9. Then sorting by week...

Hi Everyone, looking for some help getting the code on this one right. I could probably get this to work on my own, but I am self taught and would probably not be able to achieve the result in the most efficeint manner. I've put together a simple database to illustrate what I am trying to...

Looking for help on this one, hoping it's a simple solution for the more experienced users. I have a crosstab query that is part of a production report screen and we review this data on a week by week basis. From the Screen Dump in the attachment you will see that the query returns a count of...

There is probably a simple answer to this, but I can't find it right now. I have a cross tab query that takes the quantity of windows installed and tabulates them into quantities produced by week. The problem is that on Monday morning the first week column (20-32 in example) shos the total for...

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

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

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

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

Hi Everyone, Although I've used this forum for help over the years, this is my first time joining as a memeber in the hope of getting some help. I'm using Access 2016, am self taught and picked up a reasonable understading of VB over the years. At the moment I am working on a shipping...