Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. pbrown77

    DLookUp

    I know that I can use DLookUp when I am looking up something when based off of one item but I need to do it based off two. Below there are 3 fields involved. 1) DST 2) Make 3) Zone What I need is for the zone to be automatically filled in based off of the value in DST and Make. Several DST...
  2. pbrown77

    Making Directories and downloading via code

    Here is the problem. With 3 facility options (TN, MS and TN&MS), 31 reports and 5 different ways a report can be ran (Direct, SDirect, Maintenance, PreAct, All Labor) there are 465 possible reports. At first I was simply going to download all reports into one folder, however searching for a...
  3. pbrown77

    Automatically open all combos of select cases for report criteria

    FYI... I was able to open the reports as needed by using the below code (might help if anyone else tries something like this...) Private Sub Command69_Click() Dim strWhere As String Dim strwhere1 As String Dim strwhere2 As String Dim mdofreport As String Dim dirDate1 As String Dim dirfac As...
  4. pbrown77

    Making a MDE file

    FYI... Found it.... I had to create a small database that does nothing but make mde files. A button on the main dB says to make mde file, which closes the file and opens the mdes.mdb file. When it opens there is a screen which asks the user which database they are working on. When the...
  5. pbrown77

    macro warning appears when I open database?

    The only way I have found to cut the msg is to set to Low. I have tried "playing" with other tools in the control panel, however, Low is all I have found so far... Sorry I could not help more.
  6. pbrown77

    Making a MDE file

    Just tried and this appears: Run-time erro '7807': you can't make the open database into an MDE file while running a macro or visual basic code Any other ideas or versions? Do I need to open a separate database that would have this code only? That way the file I want to make an MDE is not...
  7. pbrown77

    Making a MDE file

    Since we have split the DB to a BE and FE, we now make the FE that is copied onto the individual PCs a MDE. The thing is that I am attempting to automate this and perhaps it is not possible. When finished updating the FE mdb file, is there code or a macro, or anything that I could write that...
  8. pbrown77

    Use option group to go to specific record.

    That work perfectly! Thanks!
  9. pbrown77

    Use option group to go to specific record.

    A form was created that has 1 month per record (with, you guessed it, a total of 12 records) At the bottom of the form there is an option group named "SelMonth" with 1 - 12 options (Jan - Dec) Next in code I put: Dim strwhere As String Select Case Me.SelMonth Case 1 strwhere = ([Month] =...
  10. pbrown77

    Update table information (formatting question)

    There is a table that currently has the following fields: CurrentMonth Month 1a 1c 1d 2a 2c ... CurrentMonth is a place for the user to 'X' the current month Month = Jan, feb, etc 1a, 1c, ... = number of work days What I would like to do is create a form that will open and display the data...
  11. pbrown77

    Automatically open all combos of select cases for report criteria

    Here is the problem. There is 1 report per item with several reports. (1 report for summary, 1 report by day, 1 report by month, etc) The users select criteria from the cases that depict how they want the report to run then select the report and it opens. Therefore, I do not have a list of...
  12. pbrown77

    output a report

    okay, this has officially driven me nuts. The current code looks to see if the folder "mmmm-yyyy" (i.e. June-2005) exist and if not creates the folder and downloads the reports (8 of them) into the folder with the date attached to the end of the file. The problem is that now since I am going...
  13. pbrown77

    Automatically open all combos of select cases for report criteria

    Output to is exactly what I was thinking of. What is this "table or array and cycle through them"? Could you help or do you know of some place that could help in this set up? (from a basic start)
  14. pbrown77

    Automatically open all combos of select cases for report criteria

    To make the FE smaller, I reduced the number of reports by using select cases Case1 = 5 options and Case2 = 2 options. However, now it has been determined that we need to save, "electronically" a copy of each possible combination to a server folder. Before using the cases, it was simple...
  15. pbrown77

    Prevent resizing of a form

    I thought of driving everything from forms, but how would a person open a report then print? (sometimes users just need to view not print the report) Also, when the report opens and then closes the main form does not come back maximized. I have tried Docmd.maximize on the On Open, On...
  16. pbrown77

    Updating Data using a form

    Best way I have found is to make a form based off a query and under the name or id field in the query = [Enter name or number]. That way the form will only open records associated with a particular person.
  17. pbrown77

    Prevent resizing of a form

    That may be the problem I found. The form opens great, but now the custom bar is gone. So the users can not use the bar(print, close, e-mail) when the reports open. Also, since I have disabled the ablity to exit access unless they go to the form and click "exit" there is no easy way to close...
  18. pbrown77

    Prevent resizing of a form

    THANK YOU!!!!!!!!!!!!!!!!!!!!!!!!!!! This is a question I have asked at several "Microsoft" groups at microsoft.com, but never received an answer that works! You have no idea how much this helps, and it appears from your post you knew the answer "off the top of your head" :)
  19. pbrown77

    Prevent resizing of a form

    When the form opens (max/min buttons = none), (close button = no), (control box = no), so instead of 3 icons appearing for the form (_, box-in-a-box ([)], X) only the ([)] appears (along with a dialog box that says "Type a question here for help". Is there away to prevent the ([)] from...
  20. pbrown77

    Viewing and printing reports

    Check the default printer. We had the same problem and found from microsoft sites that unless the PC has a valid default printer the access reports can go astray. HTH

Part and Inventory Search

Back
Top