Recent content by pbrown77

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...

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...

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...

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...

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.

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...

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...

That work perfectly! Thanks!

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] =...

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...

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...

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...

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)

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...

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...