Search results

I want my reports to open in %75 view. I dont want to simply specify "maximise" in the macro. How cud i do this ?

i could yes but how would i do this in a macro ? Also it would be fine for it to print it they way it looks on the form

no, the data is on the form and saved to the tables but once it has saved i wasnt it to print is as well

yes, i have the form brought up with a macro in "add" mode. Now, the button to add the record is in place, but once the data is entered into the form, i then click the add button and it saves the record but the data vanishes. I want the button to add the record, and print it when it vanishes

would this be best done using a macro ? if so what options would I use for it ?

i used the wizard for the initial add button so now im improving it i want to use the same button to print

i want to have an option for add and print on the same button. At present when you add a record the record vanishes from display. I want to be able to click the button, then for it to add it and print at the same time how is this done ?

In box 1 the user can select either "hardware" or "software". This information is taken from a dropdown menu in a table in box 2, the user can see options displayed depending on what option was selected from box 1. That all works fine.

the 1st and 2nd box works fine. The 3rd box however displays nothing when clicking on it. Nothing at all. No error messages either

Ive got 3 bound combo boxes on my form. I have managed to get the 1st and 2nd combo box to work but i cant get the 3rd one. box 1 is simply a dropdown menu with 2 options so no coding requried. box 2 I have the following code which works fine : Private Sub fault_type_detail_1_AfterUpdate()...

thanks for that. Il be sure to reference my source.cheers

just says it cant save the record at this time because the field cant be left null but do i want to close anyway. i dont want to change it so it can be null otherwise when entering data, things wil get missed. isnt there a place i can look to modify these messages

no i mean i have a command button named "back" to take me from a form which the user would be filling in. the user changes his mind and clicks "back" to return to the previous form. when clicking back access gives errror msg.

I have a form for which to submit an item. On filling partially filling in the form and selecting the "back" button it throws up the error message. i want it to say somethingmore helpfull to the user. i tried to use the "on error function" with no luck. a macro is in use for this cmd button...

oh I see. At the minute they are only applied in the tables. So I just need to open the property dialog box for the controls on the forms and enter the masks. Thanks, il give that a try

ive set up my database and now that it seems to be working correctly, i want to give it input masks. Ive put in the masks but for some reason they dont implement when running the program. I used the following masks ASSET TABLE Asset tag number 0000000 – Auto number Asset make !>L< Asset...

Error message : CANNOT COMPLETE THE COMPRESSED (ZIPPED) FOLDERS EXTRACTION WIZARD the compressed (zipped) folder is empty: before you can extract files you must copy files to this compressed (zipped) folder

the zip file is invalid

could you be a littel more specific ?im new to access. do i need to set up seperate tables for the levels required? or have 1 table with each field labeled as a level NOTE: were not doing this in code we are using the built in propertie functions and menu options

i think so. Basicaly the system has 3 levels and navigates like a tree structure. So the options that appear on level 2 depend on the level 1 selection. and level 3 options depend on level 2 options. do i need to create a table for each level then use filters or something like that ?