Search results for query: *

The code for the forms command button (OnClick event) generates the values for the report. So there is no two sets of code. It is just one. If you would like, I can attach the code but all it does is, it pulls values from tables and puts it in the report in a specific format.

I have a report being called for from a form. In the form, when the user clicks on the command button, the report will open and a visual basic code generates the values for all the text boxes in the report. When I click on the command button in the form, the report opens up blank. When I switch...

Thanks a lot. This worked as a gem. I am jumping as this worked. Tell me one thing. I am using a command button to add data from form to table. Is there a way in which, I can restrict the same data to be added twice to the table if the user accidently presses the command button twice.

Hi All, I have a form that uses some visual basic coding to generate data. I am not able to figure out how to add this data from the form to a table. The data in the form that I would like to transfer to table is in text boxes. As I see it, some data need to be added to one table and some data...

Where did you say, you want me to paste the code.....code module or create a macro and run a code. If I run a macro, I need to use form name instead of "Me" as in the code above. Please confirm.

How do I add roles and responsibilities for each person in the organization chart, and also have it look good. Does any have suggestions. Jennie

Thanks, AceMan

I have a table with a set of records: FiscalYear(format - Number, eg. 2004, 2005), CompanyName(format - text), ItemName(format - text), ItemPrice (format- currency). I have a form in which I have created four text boxes. First three text boxes are for FiscalYear, CompanyName and ItemName. The...

I have a table with a set of records: FiscalYear, CompanyName, Item1Price, Item2Price The table has this information for the year 2004. I want the form to update the information in the table for FiscalYear 2005 onwards. The Item1Price increases by 10% every year and Item2Price increases by 20%...

I have a table with the following information: "PersonName", "PurchaseQuantity", "YearOfPurchase". I am trying to prepare a form so as to represent this information in a matrix. I have YearOfPurchase (eg.: 2004, 2005, 2006...) as the column header and PersonName (eg.: Tom, Ron, John.....) as...