Search results

I have several forms that I would like to print a report from. The data on the different forms is common, so I want to have just one report that prints based on the form that is open. I put a button on each form to open a report called MY REPORT. I put a query behind the report that had the...

The Solutions.MDB application has a suppliers form that is filtered based on the alphabet charactor chosen by the user at the bottom of the form. How does the form filter records based on the selected alphabet charactor? Thanks in advance - John

Calendar to show values for days of the week I have various amounts of shipments planned for different days of the week. I would like to show a calendar on my form that shows the total shipments for any given day. Is there a way to display totals in a date box for each day, much like you would...

Thanks so much Rich (My Higher Power!!!) It worked great............

I have a report that contains two sub-reports. One sub-report contains current data and the other report contains past due data if there is any past due. If there is no past due data, then I don't want my report to print out a blank page. Is there a way to suppress printing a blank page if the...

Thanks for all the help... I guess I will do the form close and form open statement.

I have a main form with two subforms. Non of the forms are bound. On subform1, I have a list of items with a check box. If the user selects check marks on various items, I want the subform2 to display the items selected in subform1. If I close the form and reopen the form, then the selected...

I have a main form with two subforms. Non of the forms are bound. On subform1, I have a list of items with a check box. If the user selects check marks on various items, I want the subform2 to display the items selected in subform1. I have the following code in the Subform1 check box After...

I have a subform that contains city, state and store name. I want to count how many stores are in the sub form. Example: Miami Fl store A Orlando Fl store B Orlando Fl store B Orlando Fl store B ======================= I want the count of stores which would be 2. Any help would be appreciated...

I downloaded a great utility called PRINTKEY. It is a vary easy to use screen captue utility. You can capture the entire screen or define your own selection. I use the tool all the time for the same reasons that you need it. By the way, you can paste it in an e-mail and it works great without...

The re-paint didn't seem to work. Does anybody else have any ideas?

I have a main form with two subforms. Non of the forms are bound. On subform1, I have a list of items with a check box. If the user selects check marks on various items, I want the subform2 to display the items selected in sugform1. If I close the form and reopen the form, then the selected...

Thanks Steve... Your solution works just fine.

I have a combobox that the user can select a value then the report is filtered by the selection. In my query I have: Forms![Main Form].[Value] This works fine if the user selects a value. However I was hoping that if the combobox was left blank then it would not filter at all and give me all...

I have a field called length that is inches. The user inputs the length as 24. On my report I want to have it look like 24". I tried the following formula but it doesn't work: =[Length] & " " " Needless to say, the " symbol is to identify text and this is causing problems. Thanks in advance to...

Thanks FMM, your code performs exactly as I was hoping for. John

I have text box that the user enters a quantity. I want this value to always be a nagative value and I do not want to rely on the user entering the minus sign. Is there a way that the user can enter the value of 100 and after update use code to change the value to -100 ??? Thanks in advance -...

Is there a way to build a table based on the users input? I would like to construct a form that prompts the user to input whatever items he so likes. Each of these items that he types in would become a field name in a new table. In other words, I want to create a table without having the user...

Thanks for the tip Val but I need the table to be sent as an Access table not text. The customer uses this table as part of their application. Thanks - John

I have a database that is updated on a daily basis. There is a particular table within the database that I need to E-Mail to my customer every day. I want to know if there is a way in Access to send the particular table attached to an E-mail instead of going into Lotus Notes and manually...