Search results

I have a report that has week numbers within each week are cranes that have a delivery date, I have identified that all cranes go into storage has a week "0" Within the report I want to replace the "0" with some text "STORE", I have tried VBA using an if statement, conditioning format just cant...

Hello i have a DB called week numbers it consists of a order number and 52 fields from Week Number1 to 52. I also have various forms, sub forms and query's. What i am after for each order number the first week from left to right that contains a value (number field), once a value if round the...

Hello I have 52 fields in a form all of which have the following format based on week number, if it is true the back colour changes colour. I have used the following expression [WK]="1" And [YEAR]="2018" if both are true then the back colour should change. Some of them work some don't? Can you...

I have designed a database to produce a loading chart for the manufacture of cranes. To cut a long story short I have a form that I have named Switchboard which has two sub forms all of which are linked via a field called [Order Number]. I also have a button to create a new record, I then add a...

Hello i am a Production Manager of a large crane manufacturing company, i have been designing databases for some years mostly in Access 2013. I am starting a new job role in January and need to get back into databases, i have been involved in a lot of VBA although it was 1980-1990 code where a...