Search results

woman was at her hairdresser’s getting her hair styled for a trip to Rome with her boyfriend. She mentioned the trip to the hairdresser, who responded, ”Rome? Why would anyone want to go there? It’s crowded and dirty and full of Italians.You’re crazy going Rome. So, how are you getting there?”...

Simple when you know how. Thank you for your help IMO. Saintsman

Thanks IMO, Sorry to ask again but where exactly do you mean when you say the report's detail?

I've got a simple bit of code but I keep getting an error message. "You entered an expression that has no value.The expression may refer to an object that has no value, such as a form , report or a label control." All I wish to do is highlight the fact that my forecast date is overdue...

Perfect. Thank you very much.

I,ve been fiddling for ages so someone help me out please. I don't know VBA but I have got the following to work: Private Sub Form_Current() If Date_Forecast.Value = Date + 1 Then Date_Forecast.BackColor = 26367 Else: Date_Forecast.BackColor = 16777215 If Date_Forecast.Value < Date Then...

Try deleting the buttons and putting new ones back in. It works sometimes but don't ask me why.

If your query's result is no records, why would you expect a form not to be blank? It's doing what it's supposed to.

Thanks for your input and sorry for not getting back earlier. I think I may have solved it. I have used a page footer and a report footer with the Report Page Footer properties set to 'Not with Rpt Ftr'. It just needed some careful positioning to make sure that there was no gap between the last...

No, the page footer puts the info at the bottom of the page. If my last entry is halfway up the page I need the signature box attached to it. If I have records that take up two pages, I need a signature block on page 1 and another on page 2. For legal reasons (civil aviation) the signature...

I am designing a report where I want to print something attached to the last record on each page (a signature block). The problem is that it must be attached to the last record (not always in the same place on the paper) and I can do this by using a report footer. However that will only print on...

In the table design view, copy your autonumber field, delete it and paste it back in. It will now start at one. An autonumber will not know that you have deleted a record. You wouldn't want to have a whole series of numbers allocated which then would change if you deleted an earlier entry...

Maybe I am splitting hairs but it seems to me that even if you are just using the ID you are duplicating data albeit not so much. However, it seems I am doing it wrong so I will have a play (usually the best way to learn anyway) and I will see if I can sort it. Thank you all for taking the...

No I don't think I am doing it that way. I am using the combox box to take the data straight from one table and put it in another. The table my combo box refers to could have 4 entries in it saying A,B,C & D, instead they have 4 sentences in it. Is this not the correct way to do it as it seems...

No, there is nothing unusual. The report prints exactly what is stored in the memo field. ( I have just done it printing the report direct from the table). It still clips the last sentence. If I do the same from the table where my combo gets it's reference from it prints everything. Therefore...

Fizzio, Yes I think the way you described it is correct. Rich, I have printed it as a report but it does clip the last sentence. This is what I want: 1) Ensure all relevant Health & Safety requirements are read prior to work being carried out. 2) Ensure all relevant Documents are at the...

Fizzio, Due to the length of the text both are stored in memo fields. (althought the text is not huge it is more than 255 characters). I'm not sure on the parameter query. There are common operations (at the start and end of the processes) but the manufacturing fields are different in between...

Thank you Pat. Maybe I haven't explained clear enough (always a problem). The information in my main table is used to print a form which details a series of operations in order to manufacture an item. These operations are different depending on what is being made, however there are three or...

I have a form with a combo box where the 'Row Source Type' is a Table/query and the 'Row Source' is a Table (Table 2) which is used purely to provide the information for the Combo Box. This works fine but I have one entry that does not fill in all the information. Is there a limit on the number...

You need a sub report in your report exactly the same way as you have done your form.