Search results

Trying to get vba so that my AR Collection person can click on past due customers, look at their account, make comments and then send an email with the account attached. I seem to have that process working well. My problem stems from the fact that we run two companies with two different...

I have attached a copy of part of my program where a user inputs a date to get the next 10 days of expected customer deliveries. I input a criterion that the date input must be in the future, ie > today. When I input an earlier date and hit the arrow on the Customer drop down box, I...

I have created a report in landscape that appears nicely on the screen (see upper image on the attached file). However, when I go to print preview, it has HUGE print and now appears to be a portrait orientation (see bottom image on the attached file). Any assistance would be much appreciated...

I have a table where there are various size measurements in one textbox. They are delimited with an x and I have managed to find code to split them into columns on the form and, hence, the table itself. My problem is that I cannot get VBA code to loop and perform the same operation on each...

I am trying to supply my sales manager with a report that will compare unit selling price for what was quoted versus what was actually billed. Our quote table is based on items and these can be quoted at various levels of production, e.g. for 100 units, 300 units, 500 units, etc.. I have...

I have attached a file that contains two images of the same report. This is in report layout and the command buttons to the right direct the user to another report that they may wish to view. As you can see from the top report prior to any of the command buttons being clicked, it is a clean...

I have set up a report that shows records that satisfy certain criteria from an input form. For each record on the report, there is an option to get Order Info, Prod Info or Sales Info. Clicking on one of these boxes brings up a report that gives more detail of that particular record. When...

I am trying to produce a form where someone can enter data that will retrieve records that match the criteria. The form will have many different variables, and if some are left blank, I want the query to show all applicable records for the overall search. So far, I have created a form that has...