Search results for query: *

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

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

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

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

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

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

I have said "no" to the control box and "no" to the close and "no" to Max and Min buttons of the report properties. However, the "box in a box) at the top right still appears and allows the user to reduce the size of the report. Basically, I want to give the option for the user to view or not...

On the form there is a calculation that is performed as the user enters data. For some reason, users are not noticing when "Over Budget" becomes visible, red, underlined, italic and bold. Is there a way to make the font larger?

Perhaps since the solution is most likely within the form, I should ask here...... The form I am using allows the user to select a facility and run a report via a button (code listed below). The problem is with the subreport (both main & sub share same query as control source). The main report...

I have a report and a subreport tied to the same query. To run the report the user selects criteria off a form and presses a button. The problem is that the main report runs with the criteria, however, the subreport does not. How do I fix this? Here is the current code: Private Sub...

Okay... With everything that can be done in Access, where do you change the background color of the buttons? Or do I need to make a button picture in a diffent program?

There is a text box CCS1 which allows the user to enter a 4 digit number to runt the report. However, I was thinking that if they were to delete the value and not replace it the report would go off. Instead of running incorrectly it simply says invalid use of null. Therefore I was thinking of...

In order to cut down on the number of reports to create. Basically 8 of each report. 4 per facility and 2 facilities, I would like to use to select cases which would enable the user to select: From Option Group: Location 1 or 2 and from Option Group: Labor 1, 2, 3 or 4 Location group 1...

Is there away, in a query, to count the number of week days between two dates? Field 1 = startdate field 2 = enddate I know problems will happen when there is a holiday, but it would be nice to have a helping hand 99% of the time.

This is a "nice to have" since we need to count the number of M-F, FSS, etc for a date range. Is there away for a calander to pop up on a form that will show what day each date for the date range? I.E. This weeks date range: 6/6/05 - 6/12/05 somthing to show 6/6/05 = Monday 6/7/05 = Tuesday...

I am tring to make a code that when the user clicks the button the current record, via report or just a snapshot of the record will be e-mailed. The below code is currently being used but it says the format is not currently available. docmd.sendobject acsendform, "frmexp","snapshotformat...