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

    OutPutTo

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

    OutPut To

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

    Between x and x not working

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

    Criteria based on iif statement (Delete Query)

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

    Between x and x not working

    [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...
  6. shart00

    Between x and x not working

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

    Between x and x not working

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

    Update Query

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

    Update Query

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

    Automatic update queries

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

    Update Query

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

    Automatic update queries

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

    VB Font Size

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

    VB Font Size

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

    Display Month

    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?
  16. shart00

    open form based on criteria

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

    open form based on criteria

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

    Export Data only (do not export headings)

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

    Export Data only (do not export headings)

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

    default date

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

Part and Inventory Search

Back
Top