Duh - Thanks plog - I had already done that elsewhere and it was working - I'm going to tell myself that I was tired and not thinking, however you know bettter :o
I have a very simple database for tracking movies. One Table has Theater Information, which includes Name and City.
In another related table I track attendance - when I choose a Theater name I'd like the City field to be populated, but I can't for the life of me see what I'm doing wrong ...
I can manually stop the AutoExec macro from running by holding down the shift button - how do you do it by VBA? I'm opening the db from Excel, and I don't want the Switchboard to display ...
Here's another attempt at describing my challenge - I have an Excel Model that is running a looping calculation. As it loops through the dataset, I'd like to be able topass a value its currently processing into an Access query (The Database is loaded and open) as a criteria value and then...
Thanks for your response, G!
We're opening the Access database to verify (visually!) that the contents of a report are properly reflected in the Excel calculation. Ultimately, the goal will be to totally automate the process, but for now, they're wed to their status quo process.
So...
I'm running a VBA routine in Excel that loops through a lot of data. As part of the process, I'd like to pass a variable from Excel to an Access database that is open and have it run a query based on that value ... anyone ever done it? Is it feasible?
It's not how I would do this project if it...
Somewhere in there is the Capitalism v Socialism battle.
Anyhow, I felt that I was getting value from the forum and was happy to contribute - it seemed to me the correct thing to do.
And somewhere along the line you must have missed that I happen to part with money in an effort to sustain an Access related forum - I can find plenty of "political discussion" for free - which as about what its worth.
OK - I can get the Code window to open when I run the program by using
Application.VBE.MainWindow.Visible = True
To be honest, it's not a lot of use as it sits there doing nothing ... Far better for me to have the "Immediate" window open ... How do I do that from within VBA ...
I can then...
The Field in the Table is [Processed_File] - The table Name is "Vault" ...
so my criteria should be [Processed_File]= strFile ?
I looked at the syntax earlier {expression.DCount(Expr, Domain, Criteria)} and thought that expr was enough - obviously not!
If (DCount("Processed_File", "Vault", strFile) > 0) Then
dbs.Execute strSQLVaultDup
Kill strPathFile
strFile = Dir(strPath & "*" & strFileExt)
End If
So this was working in a prior incarnation on Friday but today I seem to have screwed it up (again) ...
strFile is the variable that I'm...
Friday afternoon and I'm not thinking very well ...
I have a process that reads a list of files sequentially and then processes them .... As each file is processed, its name (strfile) gets written to a Table (Vault.[Processed_file])
I want to verify if the file exists in the table prior to...
I'm in the process of migrating some Access Tables to SQL as we're approaching the size limitations of an Access table.
I created a SQL table by using the Upscaling wizard and it worked fine, however, since I created it the original table has "grown"!
With very large tables the Wizard is slow -...