Search results

Not clear on your question. You state: "What I need to do is take the information form (sic) the next line (LineNo = vReporting_ID + 1)..." You will get that info on the next increment of your loop. Are you trying to get the record number on the current increment for the NEXT record? What...

An update query will do it. I assume that you are updating all records in a text field [here called "MyLinkedField"], from a folder like c:\MyFolder\MyOLEs\ to Z:\MyNewFolder\ Add a new field to your table [here called tblLink], call it something like "MyNewLinkedField" Create a new...

Maybe... :{B First create a Union query that will join all of the 100 tables under one roof [presuming that you have compatible fields]. Then create the append query to append all of that data into your target table. Hopefully, you can get creative with cut and paste when setting up the large...

I assume that you already tried a compact and repair.... In my experience it is almost always better NOT to embed the file, but rather link to it. To protect files, I would discuss this with my LAN manager, and see if I could set up an ACL on a protected drive. see link for more info...

Did you look at a union query?

Did you look at the DatePart function?

Have you looked at the DateDiff function?

http://www.peterssoftware.com/abs2.jpg

Check the Access Help file for Nz function.

If you have any volume of traffic, I would suggest that you not rely on Access. Take a look at SQL Server. Since your boss is a tight-wad, you probably should start with SQL Server Express. It will make him happy since it is free. ;-B

junction table You need to set this up with a junction table. See Help file in Access.

Use the Access Find Duplicates Query Wizard Should look something like this: SELECT TableThreeID.Test1 , TableThreeID.ID1 FROM TableThreeID WHERE (((TableThreeID.Test1) In (SELECT [Test1] FROM [TableThreeID] As Tmp GROUP BY [Test1] HAVING Count(*)>1 ))) ORDER...

Sorry, don't have time right now to get into this, but here is sample code that will create a table with an auto_increment field, and it should start at 0. CREATE TABLE Friends ([FriendID] COUNTER NOT NULL PRIMARY KEY, [LastName] text, [FirstName] text, [Birthdate] date, [Phone] text, [Notes]...

You've got the enable/disable code in the wrong place/basically you are asking the command button to disable itself. The above is correctly placed in the OnCurrent Event.

So what is the problem with your code? :confused:

Assuming that you only want to see unique values, a union query might work. Something like: Select ID1 from TableOneID union Select ID1 from TableTwoID union Select ID1 from TableThreeID HTH :cool:

Assuming that ALL queries in your db need to be exported, try something like this: Sub QueryDefX() Dim dbs As Database Dim qdfLoop As QueryDef Set dbs = CurrentDb With dbs ' Enumerate QueryDefs collection. For Each qdfLoop In .QueryDefs Debug.Print...

Glad that it worked out for you :-D

The Security Wizard will be the easiest way for you to go. Experiment on a backup copy of your db. See the Help file under 'Security'.

The NW Customer Phone List form has a great alpha filtering system that is very efficient. Check it out.