Search results

Thanks all for the valuable replies and feedback. I changed the size of my subform and it looks better now. Now I have encountered another question, how to display just one record for each page of the report?

I have a report based on a form and when I view the report in print preview, part of it has been truncated. I have attached a screenshot of it. Is there a better way for me to print the form other than as a report? If not, how do I show the entire report without leaving out any part of it...

I've added the code in the onExit event of ItemCode but it doesn't solve the problem. After filling in some fields on the parent form, I click on the subform and I get the same error. I tried adding the code to the onEnter event of the subform as well but it doesn't work too. The reason this...

Just to add on to this thread and to ask a question myself as well. Ryan, when you close the form, the data in the fields will be stored in the table. This happens regardless of you adding any code to save the data. This is a normal feature, I guess. I've the same problem as you and I've used...

no prob, glad to help :cool:

When I click on my subform after entering some data in the primary form, I get this error message: "The Microsoft Jet database engine can't find a record in the table <name> with key matching field(s) <name>. (Error 3101)" This is because I have not filled in a ItemCode, a combobox, on the...

Go to that form's properties and under the Format tab, set Navigations buttons to "No".

I have a combobox that sets a textfield PONumber by using the dmax() function. They are both on the parent form. The parent form and the subform is linked by PONumber. The problem is like this: I click on the subform and click back on the parent form again. If I choose the same option in the...

Thanks! Got some idea from your suggestion and got me moving on. :D

Help, anyone? :confused:

Report not displaying all records Not all my records are being displayed on my report. Only OutletB is being displayed and OutletA's records are not visible at all. Attached is my sample db. Note: Report generally shows all the purchase orders whereas mainForm_Report shows the records based on...

I have tried adjusting the page setup but it doesn't help. The reason I would want to print from the form is because I would want the user's input to be printed as well. Is there a way for me to import the fields, together with the user's input, to a Report? I have attached a picture of my...

After you click that, does it tell you to save the form to an external file or database or within the current database?

Are you referring to the "File - Save As/Export" option?

I can't find the option to save it as a report. I'm using A97. Is it only available to the newer versions?

The form is an interface for a purchase order form and after filling in, I wish to provide the user with an option to print. How do I print it as a Report, as you have suggested. :cool:

When my form has a blank print preview screen, does that mean it has exceeded the width and/or height of the document? What other reasons can account for this?

How do I get the last PONumber + 1? For example, there are 4 purchase orders for OutletA and 3 purchase orders for OutletB currently. The next purchase order for OutletA and OutletB will be 5 and 4 respectively. Thus, I would want the textfield to display A5 and B4, whichever outlet is chosen in...

The purpose of adding an alphabet to the front of the autonumber is to allow for easy searching and filtering. With the alphabet, I would be able to classify which orders come under OutletA and which come under OutletB. I was thinking of doing something like this...

Any ideas, anyone?