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

FYI... Code fixed! >=IIf(Weekday(Now())=2,DateValue(Now())-7,DateValue(Now())-Weekday(Now())+2) And <=IIf(Weekday(Now())=2,DateValue(Now())-1,DateValue(Now())-1) Had to separate the between to different parts of the code but it seems to work so far. The real test will be on Monday when...

Hi, To throw a twist in things, the code for this is now working, but I am tring to modify this code for a different purpose but am having loads of trouble. Starting simply, there is a make table query driven by (2) tables (Base (which has the records) and DSRDATES (which is basically a...

[monday], [Tuesday], etc are fields in the table DSRDATES. Those fields are populated with actual dates such as 1/24/05 is currently in the field [Monday] and 1/25/05 is currently in [Tuesday] and so on. What I am looking for the Make table query to do is look through Base table and make a new...

This is a Make Table Query. The 2 tables involved are: Base Table (Has all the data) and DSRDATES (Simply is a table with the field names Monday, Tuesday, Wednesday, Thursday, Friday, Saturday, Sunday, etc.) What I need is to make a table (Reporting Table) that has all the data from base table...

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

I agree, however it has taken me months to get approval to create DB2. Use to be that DB1 would run the query once a day and download the data into an excel file then the other users would copy the file and use excel to create the reports. I was able to prove that this was taking time away...

Here is what is going on. DB1 is in Access97 linked to the SQL server. (Conversion to 2003 is not economically possible at this time - this DB was created with outsourcing and they want too much to convert to 2003.) IT says there are server issues if we tie more people into the SQL server so...

Hal, Can not download, another "security" feature installed by IT. Seems they want us to do more of our own programing only as long as it consists of using the wizards ...lol... Thank you anyways it looks as if it would have done the trick.

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

The problem is that me.notes.fontsize=6 is not working. The font size is not changing under any circumstance. But the rest of the code is working.

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?

I tried this on a button that is next to a text box named occurence DoCmd.OpenForm "frmdowntimeandpartsshortage", acNormal, , Me.RecordID = Me.occurence also tried putting it in the filtername but it does not work, it simply opens the form on the first record

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

That would still mean that everyday when the CTRL C is used they would have to go back and delet the row of headings that is copied over. Trust me, I need to make this as simple as possible or else all the work will be trashed.

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