Search results for query: *

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

One of our users is having the exact same problem, and I can't figure out for the life of me why. Did you ever get this figured out? Thanks! Paul

Thanks, guys! I'm always amazed how quickly I can get answers here!

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

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

Well, I'm trying to encourage other users to use forms for data access and not go at the tables and such directly. I do have the database window hidden on startup, but that hasn't been enough. I eventually want to secure the database and set up rights in that way, but for now I am just looking...

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

Hey! I've been searching for a way to do this and stumbled accross this post. I tried the loop for the forms, reports and macros and it worked like a charm. But I can't get it to work for the tables or the queries. Any ideas why not? Here's what I have: Dim tbl As Object For Each tbl In...

Perfect! Thanks! I have searched far and wide for how to do this. This website is great!

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

Thanks! You were right - I tried appending the data with a query and got the key violation error. So I looked more closely at my table, and I the GroupID was still indexed with no duplicates (Duh!). I had copied my table, removed the primary key designation, but did not think to look at the...

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

Thanks! The single quotes tip helped a lot, too, since I had previously tried what you suggested, but without the single quotes (GroupID is a text field). I've been knocking this around for longer than I care to admit. Thanks a ton!!!!!

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