Search results

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.

Good - in that case I can cancel my recurring PayPal subscription.

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.

What has this question to offer to the mission of this website? Let's stick to Access and its challenges, please!

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

Have you set up a File Import spec? Do you tell it that your first row contains headers? You can limit the columns you want to import in the Import Spec by checking the boxes for each field you don't wnat to import ... so CL -> EJ won't get into your Access table ...

Design view for the table - select the field you want to expand and change the size - 255 characters is the maximum size - but that should give you enough room - unless that is your current size ... :eek:

Well - have you thought about expanding the size of the Table fields to allow the headers to fit?

Once you create a dropdown box for one cell it can be repeated in every other cell. You can limit the cell contents to the options in the dropdown, or the user can be given the opportunity to add their own - I don't think you want the latter in this case. DaiDropDown.xls has a q&d example for...

The best place to start is with a subscription to Ancestry.com, or if you're a parsimonious sort, the LDS Church has a free site. There are several Genealogy programs out there that are very easy to use - I use the one that works with Ancestry.com but the name escapes me currently ... I am...