Search results

  1. D

    WORD Forms - Text Form Field

    I'm creating a simple form in WORD using the forms toolbar. I've inserted several text form fields, formated the background and created a protected template as explained in the online help. The form looks great until I go to use it. When I begin entering the text in the fields, my "protected"...
  2. D

    Display daily totals in a calendar format

    I was unable to open this database. An error message said it was read-only. There was no option to view it. I was unable to change the properties to remove the read-only status.
  3. D

    Display daily totals in a calendar format

    I'd like to format a report that shows my production totals in a calendar style format with the seven days of the week across the top and the production totals for each day of the month displayed like a calendar. Sometimes there is no production on Saturday and usually no production on Sunday...
  4. D

    Using a filtering form to display reports

    I have a screen showing several report icons. It would be nice if many of these reports were filtered by month and year to limit the size of the reports to data of interest. What I'd like to do is have the user select the report icon, bring up a small form so he can choose the month and year...
  5. D

    Access Application Deployment

    It sounds like (and I would expect) that the settings would apply for the database once they are set in the Tools menu but, in my experience, when I change these settings using the Tools menu for the database, the settings need to be reset for each and every user on each PC. I will try it with...
  6. D

    Access Application Deployment

    So I can have the short cut set up in the All Users folder for the PC - I will discuss this again with my ever friendly IT gang. How can I address the Access settings (Tools-Options-Windows in Taskbar issue) ?
  7. D

    Access Application Deployment

    I have created five simple access databases that are used by 25 people on 15 PC's. Any one of the 25 people can use any of the PC's to log in and run any one of the five applications. I've been using the Tools-Options menu to disable the Windows in Taskbar setting so that the taskbar is not...
  8. D

    Duplication of Records in Report

    Sub Report Headings not on Report I have a report with three subreports within. The subreport headings are not showing up on the report but the details of the subreports are being reported. Is there a propery setting I'm missing ?
  9. D

    Using a form for select query criteria

    If the value being stored is "01234" rather than "Mr. Smith" then the criteria being used in the query is "01234" ? I want the value used for the criteria to be "Mr. Smith" so how do I do this. Intuitively, if I select "Mr. Smith" from the combo box, I would think "Mr. Smith" would become the...
  10. D

    DB Design Concept

    Dear Crilen007, The concept is to keep track, by lot number, when antibodies are ordered, recieved, opened, and exhausted. There are several types of antibodies so when the user is working with one in particular, it's nice to filter the data so they can see the history for that one antibody...
  11. D

    DB Design Concept

    Pat, Your question about alternative sources for the antibodies is a valid one. I do anticipate a future where suppliers change. That's why I want to have a table for antibodies with their corresponding manufacturers. With this in mind, do the steps you've recommended still apply ? If I...
  12. D

    Combo Box

    I'm using a combo box from a table for a pick list to fill a field in another table. The text comes up and I can select my choice and this all looks good but the text isn't being stored in the field, the key number is being stored. Why is this happening ?
  13. D

    Report not sorting data correctly

    That was simple enough !!!! Thanks!!!
  14. D

    DB Design Concept

    I have a Table that will record chemical (antibody) use in fields as follows: Antibody_Name Lot_Number Order_Date Received_Date Open_Date Exhaust_Date There are several chemicals, each from a specific manufacturer. So I have another Table as follows: Antibody_Name Manufacturer I want a form...
  15. D

    Report not sorting data correctly

    I have a report based on a query. The query sorts records by year and month, both in decending order so that the most recent records appear first. When I run the query - it works great. When I run the report, the data is not in this order. The correct query is shown in the report properties...
  16. D

    Using a form for select query criteria

    The following properties are set up for the combo box: Bound Column = 1 Column Widths = 0";2.448" Column Count = 2 I'm not sure what the values should be ..... Is this the source of the problem ?
  17. D

    Using a form for select query criteria

    Uncle Gizmo - When I replace [Forms]![Antibody_Pop-up]![Antibody_Select] with a value, the query and 2nd form work correctly. I believe my problem lies in programming the 1st form that uses a combo box to select the query criteria. After the combo box is used to select the criteria, I...
  18. D

    Using a form for select query criteria

    I have a form with a combo box that I'm using to limit data shown on another form that's data source is a select query. Once I've selected the filter criteria on the 1st form, how do I get the query to run so that the results are displayed on the 2nd form? This seems like Access 101 to me...
  19. D

    imported text file with variable name

    Mailman, Your post, while providing encouragement that what I need to do can in fact be done, doesn't really tell me a whole lot. Please offer some advice to point me in the right direction...... Where do I hook in the VBA? I am currently using the macro to import the file and perform a...
  20. D

    imported text file with variable name

    I'd like to use a macro to import a text file that has the date as an integral part of the name such as WL-Jul13.txt or WL-Jul14.txt Each day, I want the user to start Access, have the user select the file to be imported (usually the for current date - but not always) and then Access will...
Top Bottom