Search results

O just tried it in the query worked first time thank you very much.

Sorry forgot to put thanks for your help

Ok I have just tried it but get a syntax error, I have tried it by adding the result to a text box as below Private Sub Report_Open(Cancel As Integer) =IIf([WK]=0, "STORE", [TEXT168]) End If End Sub

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

Ok I will try it tonight just one question in your code you have added a field called weekno, I have 52 of these fields

ok thanks for your help where would the code go in a form?

The DB is a Production Schedule, the week numbers table is a calculation tool for the number of hours in that week, loading is then produced from these figures. What i am after is the fisr week of manufacture this will come from the first week with a value. Not sure how i could have designed the...

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

Ok I have changed the field name, taken out the quotes"", double checked all of the code within the con form still only works from week 1-11 and 50-52?

Ok I will try changing the YEAR field the "" does not make any difference. The conditioning format is for one field WEEK 10, 52 fields in 2018 and 52 fields in 2019, all of which have there own format for that week number.

Screen shots below

1. ok I will change the year on a copy 2.yes double checked the weeks all have CF and all correct 3.The two forms are continuous forms and all of the fields run across the sub forms 4.The record source for the sub forms is from a query both of the fields WK and YEAR are in that query.

Ok thanks, to cut a long story short I have a main form called switchboard, in that form I have two subforms all liked (child/master) by order number. Each subform is for a year so at present it has 2018 and 2019 each containing 52 fields which are called week numbers. So if I select an order...

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

Ok will double check my master/child and look into insert action sql, this is new to me so i will have to do some research, thanks for your help.

problem i have is the one table id part of another system so i have had to add addition tables, it all works perfectly apart from a new record,

Hi june7 i have three tables, then a series or query s linked by order number to bring all the fields together, theform takes it control for this qry.

Ok the value is put into the main form i have master/child set up the master is the main form the child is the subform, when i add a new record and a new order number the record only goes back to the main table. I have three tables. Main form control is Table 1 both sub forms control are Table2...

Hi June7 when i say that the sub-form is not update-able i mean i have selected no additions which takes out the new line in the sub form, however it is update-able and has to be. When i select a new record all lines in the sub-form disappear, what i want is to add a new job number and append...

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