Search results

...thanks thatlem; I am using 2002 version of Access... ...to gema-the-husky; Thank you for pointing this out but I failed to see a Print icon with an ellipse symbol or even ellipses...unless you meant "Print...". Now, I do recall that carelessly creating a shortcut menu and dragging a "Print"...

Again thanks for trying to help but positively could not duplicate what you have suggested...I do know that the following command will cause the dialog box to open: DoCmd.RunCommand acCmdPrint However, I want the print preview to occur, after that I want the user to be strictly limited in...

As I explained in reply to thatlem, it just isnt working like it should, for whatever reason the dialogbox will simply not open, no matter how and which direction I try to use menu command of PRINT. It only opens when I use CTRL+P from the keyboard. U see a macro can also be assigned to the...

Thank you but the report already becomes visible in PrintPreview. It can have 1200 pages; I want the user to choose print from the custom shortcut menu I have assigned to this report and for the dialog box to open...I have not been able to find the difference between QuickPrint and Print. Both...

Thanks for your continued help :) That's exactly what I have done; i have made a custom shortcut menu specifically for reports. When viewing the report; a user can either maximize the report or right click to view the shortcut menu, all other options are disabled. In this shortcut menu I have...

Thanks but yes the report is being shown in preview. It does preview properly, then user right clicks on it and views several options such as exporting it to Excel, Word, or Snapview. when the Print option is chosen it simply does not show a dialog for choosing specific pages etc, it just sends...

Thank you, I appreciate the response, however, this will not work. File Print is not an option as the database does not allow any part of the default menu-bar to show. It is Popup and Modal enabled for all its forms and reports. I temporarily removed popup and modal and tried File Print; that...

Hello kind helpers; I have made a shortcut menu to pop up when in reports. This customized shortcut menu consists of "Print" and "Page Setup" items (among other commands). Problem is; when Print is clicked on, it rushes out all pages to the printer without giving the option to print specific...

Richard Thank you! I appreciate your detailed help. I think this will be very helpful to me in more ways than one. Regards, Martin

THANK YOU!! I appreciate the great source of examples you have referred me to. I think this will not only help me with the cascade-combobox concern but will enlighten me in many more ways. Again, thank you! Regards, Martin

Thank you! Only problem is, the combobox could be showing more than one fields when clicked upon. I think the cascading concept appears to only work with a combo box which lists only one field. Any additional help will be appreciated.

Hello members... I would like a combo box list source to change based on a previous drop down. I mean, when I choose a type of item being purchased, next, I would like a combo box to populate its choice list from the specific table or query which contains inventory listing for the chosen item...

Jal, Thank you...this is helpful. I appreciate your help. Regards, Martin

Thank you Uncle Gizmo, I will review it now...Regards, Martin

Hello, I am creating a donations inventory table. Then I am creating a purchasers table. In a purchases entry form, under the purchaser's record, when I select an item from the inventory as having been purchased, I need a field for that inventory item in the inventory table to be updated...

Thank you Pat! I appreciate your example and thorough explanation. This has been a great help! Regards, Martin

Thank you Pat! I got the data I needed successfully by making Query1 for Table1 filtered records and Query2 for Table2 filtered records. I then made Query3 in which I did the 1-to-many relationship between Query1 and Query 2. This worked. From your statement this is what I understood from...

Anyone's help with this will be much appreciated: Table1 has one-to-many relationship with Table2 I want a query to show those records from Table1 for whom nothing exists yet in Table2, or if anything did, it is not current any more (I have an "Active" yes/no field for this under Table2). I...

Thank you Pat! Appreciate the tip, thats the solution and makes complete sense. Regards, Martin

Hello members... I have a unique dilemma; the database is made to open without any menus/toolbars visible and i have developed shortcut menus for reports and forms. I had to make some queries accessible via buttons to users to be able to modify the design and view data for printing purposes...