Search results for query: *

What I am trying to do is output a report as a snaphot to a folder on the server. The problem is that since these reports change daily, I would like to put the date ran in the file name somewhere. I.E. Attendance 021805.snp (The format of the date does not matter, only that it is there) As a...

I would like to set up a macro that when ran will output reports as a snapshot to a folder on the server. The problem is that I do not want the files to be overwritten each time the macro runs. Therefore, I am looking for a way to include the date in the file name to be saved. Such as when it...

I tried the following and also tried using Between [x] and [x]. But both result in 0 records and when I check the base table there are records. [Monday], [Tuesday], ect are field names in the table DSRDATES that have dates for the corresponding day of the week. IIf(Weekday(Now())=2,([Base...

There are 2 databases (DB1 & DB2) Since there are security issues only a few people have access to DB1. However multiple people some of the info, therefore "append" and "update" queries were made in DB1 to update "non critical data" tables in DB2. A form in DB1 automatically opens when the DB...

See if I can even explain this without getting confused. One user authorized to be connected to SQL server. They are currently running update queries to update tables in another database that everyone has authorization to use. The problem is that the data on the server is updated constantly...

Trying to write code in access 2003 to something of the effect: Private Sub GroupFooter1_Print(Cancel As Integer, PrintCount As Integer) If Me.Balance <= 0 Then Me.Notes.FontSize = 6 Me.Notes.Visible = False Me.Exhausted.Visible = True Me.Text131.Visible = True Else Me.Exhausted.Visible = False...

There is a field [Edate] that currently has an exact date. In the query, I need it to display as the Month. I.E. 4/25/04 to display as April any suggestions on how to do this in the query?

on frmSwitchboard there are two buttons. (1) for opening a new record and (1) to open a form to a specific record. The problem is that how do I make the second work? If the user clicks on the second button, I need a pop up or something to appear and ask the user which record# they want to...

A query runs. What is needed is for the user to take that data and drop it into an excel spreadsheet without carring over the column headings because the excel and database do not share the same headings. Currently the user must anticipate that an extra line will be copied in when using CTRL C...

The query is set to pull all areas despit if they have data or not ( this is so that those who download the info into excel do not need to constantly change ranges in the linked files). The problem is that if there is no data for an area, the field [Reportdate] appears null. This is not...

Starting with a crosstab query. row is set to [zone] and group by column is set to [date] and group by value is set to [overtime] and sum additional row is set to [roll] and *Here is the problem* Before any adjustments made... the results would look like Zone Monday Tuesday...

3 check boxes named: 1) downloadbox 2) printbox 3) emailbox Not in a option group since the user may want to download and print or print and email, any combination. For the on click of the report run button the code starts with: If Me.Downloadbox = 0 And Me.printbox = 0 And Me.emailbox = 0...

When the database opens the form frmlog automatically opens which then automatically fills in the username / date and time inwhich they opened the database. Currently the timer is set so that the form will then close on timer and open the splash screen and the user can continue. The problem is...

The query "qrySummary" has the field [CC] that is currently being updated by each user by criteria that always start with: Between xxxx and xxxxx what I need to do is allow the user to enter data on the form "frmEntry" that fills xxxx xxxx the only thing is that it would be helpful to have a...

There is a delete query that currently ask the user to input the Start and End dates for dates to be deleted. In an attempt to update the database a new table DSRDATES has been added that has the fields Monday, Tuesday, etc with the field values being the actual dates (Update weekly) What is...

At the bottom is the code that I wrote but keep getting syntax errors so I thought if I broke it down, someone may have a better chance of helping: The code needs to use the formula: if [CC Description] = *Decherd* & [Shift(D/N)]="WE": -(Sum([Roll])-Sum([Outside Total])-Sum([Offline...

When using 97, if Access sent an e-mail through, it simply was e-mailed. However, now since the 2003 conversion, outlook keeps asking if you are sure you want to allow a outside program to send an e-mail. Due to the number of reports and number of people who use these sendto functions, the...

Before, when the button was used, the report would open then automatically be sent to certain persons. However, now a message box appears which tells the user that Outlook is attempting to send an attachment, do you want to allow Yes / No. Then opens an email that allows the user to edit the...

In Access 2003, is there away to modify the below code to only check the current record? DoCmd.SetWarnings False 'turn off system warning if spell check returns no error' DoCmd.RunCommand acCmdSpelling DoCmd.SetWarnings True 'turn back on the system warnings' It has been suggested to use auto...

This is messy... I am in the process of converting the FE from 97 to 2003 however it seems some of the coding is not accepted in 2003. Therefore, I am haveing to fix it one error at a time. Is there any quicker method? Anyways the first error encountered is that 97's code is: [NetworkID] =...