Search results

is "Rows.Count" referring to something in your database or your workbook object? Either way, since it has dual applicability, it probably needs to be fully qualified. Try that and update back. I have a meeting and will look more later...

you seem to be describing something different than I thought you were describing originally. Are you: 1. wanting to count matches for the first record's column 1 value in all other records of the same table or; 2. wanting to count matches for column 1 that exist in the other columns of the same...

If that doesn't work, I did a search using "FindWindow() VBA" in Bing and came up with quite a few good articles and threads that may be useful and adaptable for you. In particular, this one: http://www.everythingaccess.com/tutorials.asp?ID=Bring-an-external-application-window-to-the-foreground

Well, therein lies the problem and that particular challenge is discussed in more detail further down the thread. And, that in particular is why I'm tempted to think AppActivate might actually work. If, for example, all you do to correct the problem (as it is now) is to select the Outlook...

hmmm. I've done some work with a few of these APIs and I'll read up on this one. In the mean time, have you tried AppActivate? Look it up in the VBA Library and see if that might work for you.

are you doing this in VBA or in a Query?

Lets say you have a table with an AutoNumber field You populate it with 100 records You delete the last 10 records (91-100) Now, I certainly know you can refresh the AutoNumber sequencing by compacting the database so the next record entered is 91. HOWEVER, THAT IS NOT MY QUESTION My question...

Is there formatting and/or non-text items in the small word documents which you wish/need to retain when placed in the larger document? If there is ONLY formatting, and it preserved/restored your other application's access to clipboard, would you be ok with reformatting once everything was in...

I'm confused analyst. It sounds like you have laid out your plan and provided screen shots (now). What specifically is it that you need? Someone here to actually build it for you?

Here is a very basic example:Sub UseFSO(CurrFile As String, LookingFor As String) Dim CurrFSO As New FileSystemObject Dim CurrLine As String Set CurrFSO = CurrFSO.OpenTextFile(CurrFile) Do While CurrFSO.AtEndOfStream = True AtttemptCounter = AtttemptCounter + 1 Loop Do Until...

One way is using FileSystemObject Open the file in memory using FSO and read it line by line to EOF. Can be tricky with some scenarios as sometimes it may throw an EOF by error if the file has not finished loading. You may have to put in a error handler to make sure the file actually loads...

well, before anybody else does it, I'll spank myself. Bad Bilbo, bad bilbo. I actually went and opened Word and doulbe checked and it actually will pull up queries as a source. I thought it would only do tables. Message to self, check it out before inserting your foot in mouth... Sorry...

A regular "Mail-Merge" from within Word, sourcing from an Access Query, would probably be difficult if not impossible. I've done quite a bit of mail-merges and I do not recall ever seeing this option as a source of field data. On the other hand, there is no question in my mind that it could be...

ok, well, I'm going to correct a little of your terms. "Auto" implies that a field in a table is set to "auto Number" type. In that circumstance, EVERY RECORD gets a sequentially higher auto number. In your usage, I think what you'll need to do is write some code that determins the next highest...

what is shown in the picture is NOT a table design, it is a set of table RELATIONSHIPS. The answer to a literal interpretation of your response would be NO. in tblUsers, each user has a SINGLE record with his/her own unique UserID in tblCompanies, each company has a SINGLE record with its own...

as a few aside notes: This is really a funky way to get the job done (creating an Excel data connection to a text file from and for Access). There are any number of better ways to get this done. Recorded VBA can, from time to time get the job done, but as you have just seen first hand, it can...

ok, the problem is the Range in the Connection String Change:With xWs.QueryTables.Add(Connection:="TEXT;C:\AWF\MK PHA.txt", _ Destination:=Range("$A$1"))To:With xWs.QueryTables.Add(Connection:="TEXT;C:\AWF\MK PHA.txt", _ Destination:=xWs.Range("$A$1"))Also, after the With/End...

On my way home, but you may need to close/delete that connection too. Sent from my Nokia Lumia 1520 Running Windows Phone 8.1

I think you'll need to look at: ActiveSheet needs to be associated with xWb In fact, I'm not even sure why you're using ActiveSheet since you've set xWs to be xWb.WorkSheets("Sheet1") and then activated it. But whatever, it will assuredly need be associated with xWb For example...

of course What you're looking for is NOT where you try to quit. You ARE looking for the Excel methods used on the Excel Object.