Search results

Hi I have a macro that does some calculations on a sub-form. I'm using it as an invoice. As I enter hours in the Time textbox the macro calculates the dollar amount in the Price textbox, triggered as I change the hours. The problem is that the results are not up to date. The access help said...

Hi Build your sub-form with two text boxes and make it a continous form. Place a sub-form on your main form, by selecting the wizard on your toolbox and then selecting the sub-form button. The larger you make your sub-form window on your main form, the more info you will see at once. Also make...

Popen You can merge tables in a Query then search the Query. 1. build a new Query entering the fields from the tables you want. 2. build a macro (triggered by your button) that searches the Query. If I understand correctly what you are doing, this should work. Tom

Try changing your photo to a bitmap. It might help. Tom

Cheeky If you are having problems with only two records, I would guess that the problem is with the two records. Try deleting and re-entering the two records. Its something to try anyway. Tom

Hi I am trying to write a macro that finds a text box on an imeded form that is on a tab page. If it were a text box on an imbeded form I would use [Forms]![MainForm]![SubForm].[TextBox] With this syntax I get an error that says this is not an OLE object. What am I doing wrong Tom

Hi I have a form with two text boxes. Box1 is for the date, Box2 is a comment. I want to have an 'on exit' event in Box2 that triggers Box1 to fill with todays date. This way I will know what day the comment was made. I am using a macro to do the job now, but I would like to use code. Thanks Tom