Search results

Hi I have had a look at the sample you posted I think the problem is that you are trying to save the record from the pop up form. I commented out the save line and it works OK. You don't need to save from the pop up form as the RequisitionAdd form is the place where the data is held, and the...

Hi Here is a slightly different approach I have used sucessfully many times. My popup form has an unbound control in which you enter the value you eventually need to go onto your main form. This unbound control can be a text box or combo box or whatever you need to get the correct input. On...

Hi I have a form where I enter customer orders, the main form containing customer name address etc. On this form I have a sub form which holds the individual line sof the the order, part no qty etc. I need to number these lines starting at 1 for each new order, and increasing for each line of...

Thanks for this suggestion I have tried this, both in an independant module, and in the module behind the report. It still doesn't work. I have solved the problem by opening the selection form hidden in the background before I open the report. This does work and the client does not see...

Hi Rich Thanks for the answer, but it still doesn't work. I tried putting the isloaded function in the expression I am using in the sorting and grouping dialog box, but the function is not recoginsed here. I didn't think it would be but was happy to try. I tried to set up the value of a...

Hi I have had another look and have an answer for you. You were very nearly right, but just needed to put the name of the control who's value you wanted to compare the total to, instead of the calculated value. ie [Avg Of SumOfUnits] ( the name of the control for the daily average) instead of...

Hi Going back to the jpg with the error message saying first name could refer to more than one table, you need to change the name: field to name:[tblemployees]![firstname]& " " & [tblemployees]![lastname] this is because you have firstname and lastname fields in two tables, so you need to...

Hi Geoff I tried to look at your report, buth because the tables are linked, and therefore not on my PC, I can't open the report to see what the problem is, If you can post some sample data in the tables I will have anothe rtry Sue.

Hi I may have missed something, but I think you need to have the employees table in your query, with the employeeid field linked to the service employee field on the orders table. The name field you have in the query at the moment seems to refer to the name of the customer contact. If you...

Hi I have a report which I want to use to produce a list of parts with a date expired, both sorted by part number or date. I achieve this using a form to select the sort order, and then call the report from this form and set up the sort order in sorting and grouping using the value on the...

Hi I have done this in one of my databases. What I ended up doing was to create a query based on each of the tables with the value I wanted, ( in my case it was a sum but in your case it will be count in the totals row for the field you want to count). you will then end up with a query with 1...

Hi This is a real pain because although you can set the number of decimal places in a currency value to 2 for display, it always stores 4 places, and I havn't found a way to force it to round to 2 places. The method I use is to multiply the answer by 100, take the integer value and divide by...

Hi Dan Thanks, that was the answer I was looking for, its works now. Thanks again Sue

Hi Dan Thanks for your reply I have created a new form and put 1 text box on it. I changed the font of this text box to be the format I want for all text boxes. I saved this form and called it helvetica I went to tools / options and changed the forms template to helvetica. I created a new...

Hi I have a written a database for a client, where they want to use their corporate font style and size for all forms and reports. How do I set up a new template to replace the normal template for forms and reports as specified in options forms/reports form template and report template...

Hi No the form and subforms do not have to be from the same source, but there must be 1 field that appears in the source of each from and subform, so access knows which record from the subform relates to which value on the main form. Eg, If the value on the main form relates to a product with...

Hi, Could you set the automatic delivery time to include the date, and maybe have a date field defaulting to todays date on the form where the arrival is recorded. Then if the arrival was before midnight instead of after, the date would still be correct. You would of course have to include...

hi, You need to make sure that the master child links between your main form and your subforms are correct. The master link will be the name of the combo box on your main form, and you need to have the same field on each of your subforms so they can be linked together. The name fo the field...

Hi, I have a combo box containing the names of contacts for a supplier, and I would like to populate this depending on the supplier I select from another combo box. I am doing this using a query, with the supplierid set to the value of the first combo box. This works fine and gives me what I...

Hi, I agree with Pat, I have just had a look at your database, and you don't have anything set in the link child fields / link master fields properties of your subform. You need to enter the field names of the fields that links the master and subform in these properties. If you create the...