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!

  • Congratulations TouchToneTommy 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: *

  • Users: pjtarheel
  • Content: Threads
  • Order by date
  1. pjtarheel

    Network folders moving themselves to another directory

    This is a strange occurrence that we've had happen about once every three months or so (with no apparent cue). It's a little hard to explain so bear with me. A set of network files and folders, starting in the middle of one folder, will be relocated to another location on the network share...
  2. pjtarheel

    link to text files with non-standard extentions

    I'm trying to link to some text files on a CD that do not have standard extentions that Access recognizes as text. Is there a way I can make that work (other than copying and renaming each file, which is a pain)? Thanks!! Paul
  3. pjtarheel

    "Filter by Form" form

    Hey, I want to set up a form for end users to be able to select records based on any combination of filters on any records. In other words, pretty much the same thing you get when you use the "Filter by Form" option in the table datasheet view, only I don't want them to be accessing the table...
  4. pjtarheel

    Hiding all database objects

    I'm looking for an easy way to hide all the objects in a database without having to do each one individualy through their properties menu. I found an earlier post which suggested the following code: dim frm as object for each frm in currentproject.allforms application.sethiddenattribute...
  5. pjtarheel

    First day of month

    Hey, How do I get a query to return the first day of the month for a given date? I've got a membership table with member start dates that land on all days of the month, and I want to group them all by the first day of the month. Has to be the first day because we have other tables where the...
  6. pjtarheel

    INSERT INTO does not append new records for existing IDs

    Hey, I'm using a table to track all changes made to another table (through a form). The corrections table is identical to the main table (except that the GroupID is the primary key in the main table and I have an autonumber primary key for the corrections table, because I want to be able to...
  7. pjtarheel

    INSERT INTO - "Too few parameters" error

    I am trying to track all changes made to records in a table by creating a duplicate of the updated record in another table (with the same fields and field names) I'm trying to use the following code to insert the record: Private Sub Form_AfterUpdate() Dim db As Database Set db =...

Part and Inventory Search

Back
Top