Recent content by mcraven

  1. M

    Toolbars: View, Tools, Startup Menu

    Hello, I've read most of the General category on Toolbars and Startup Menus, but still can't figure this out. I have no VIEW or TOOLS on my toolbar, so I can't get to the startup menu, toolbars, or anything else. When I go to Customize, one option is Built-in Menus. When I try to drag the...
  2. M

    Filters

    Hello, I want the user to be able to filter his records in the database without interfering with other users entering data into their records. When someone sets the filter after doing a search on their name, no one else can access the database. Why?
  3. M

    Cut and Paste contents of a field with a Macro

    Is it possible to have a control button that when clicked will cut the contents of a field and append them to another field using a macro? What I have is a current reporting period field that has to be cut and pasted each reporting period into the hisorical field. It's tedious and inefficient...
  4. M

    count or sum?

    Count or Sum? Created a simple query - put group by in the TOTAL area - got back a list, sorted by name, then business unit. I can see that Mr. Jones has 5 if I count them, but I want the result to be: Mr. Jones 5 not Mr. Jones Mr. Jones Mr. Jones Mr. Jones Mr. Jones
  5. M

    count or sum?

    I have two tables - one is the inventor name, one is the #patents and the business unit. (in a nutshell - these are the only fields I need from each) I need a query to return the results: Inventor Name #Patents BU Joe Smith 28...
  6. M

    Hyperlink - more than one

    Hello, I created a button on my form for the user to click, take him to a common directory, and double click on a document. The doc is stored in a field on the form (hyperlink). I need the user to be able to attach more than one document, if that's the case. When I create another hyperlink...
  7. M

    form within a form

    llkhoutx Where do I put that information? Event procedure - macro - on click - ????? Also - I discovered that when the person clicks on the Country box, the second form comes up before they choose the one that the form is suppposed to come up for - in other words, it comes up no matter what...
  8. M

    form within a form

    I have a field in the main form called COUNTRY. It is a pull down box and the user chooses a country. If he chooses LACA, another form with a pull down box appears so he can choose a country in that category. Problem is, that's where it ends. I need whatever he chooses in the second pull...
  9. M

    Date in query

    Date in Query thank you - it worked!!!
  10. M

    Date in query

    I need to create a report where the termination date will be within 30 days of today's date (whatever day that is). In the query I have >=Now()-30 and I realize why I'm getting everything after today's date, not just the ones within 30 days, but when I try taking out the >, I get nothing. Can...
  11. M

    Tab Order help

    My tab order is the way I want it and when the user enters after the last field on the form, they get a new record. Problem is, the cursor is putting them in the last field on the form instead of the first one. I don't get it. The first field is first on the tab order list. Help.
  12. M

    Blank record upon opening form

    HELP When the user double clicks on the icon, the form automatically appears on the screen. That's good. But record number 1 is there. I want a blank record there so they can enter their data. This can't be difficult, but I can't figure it out.
  13. M

    Attaching WP, Excel, Adobe files to an Access database Form using a control key

    Attaching WP, ect... Ziggy, Let's say you are the user. You open the form and enter your record info. You get to the field that says "attach documentation". You press a button labeled "adobe". Adobe comes up and you find the document you created yesterday that shows detailed info regarding...
  14. M

    Attaching WP, Excel, Adobe files to an Access database Form using a control key

    Ataching WP, Excel, Adobe files to a form Ziggy, What I need the user to be able to do is click on a button, have it take them to an application (WP,for example) (and this I can do), but then I want them to be able to select a document from whatever directory, and attach it to the form. The...
  15. M

    Attaching WP, Excel, Adobe files to an Access database Form using a control key

    Is it possible to attach a WP, Excel, or Adobe file to a form, possibly by using a control key? How?
Back
Top Bottom