Search results

There is one other thing you might be able to push me in the right direciton on... If I wanted to have this function accept a variable of the file name rather than hard coding the file name, where should I start looking? What I think I want to do is call this function in a macro, supply the...

Excellent! That worked like a charm, as always!

Team, I'm trying to use the TransferText function I found listed here by several users. I have set up my own version and it woirks very nicely except that I now need to call a stored value to get the file path for the function. My first example shows the function in it's working form based...

Nope... I've run the query dozens of times today and I get a different set of records every time. I've seen a lot of postings that suggest this method will give the same set of records but for whatever reason, my query works perfectly every time... :D:cool:

Gang... I'm sorry... I'm a complete idiot... I just figured out what I was doing wrong! All I need to do is change the RandomSelection query to use the TOP 10 Percent method and all works perfectly! I guess I was over-thinking it... This is the new query: SELECT TOP 10 PERCENT...

I'm sure you follks get tired of hearing this type of question but I am struggling a little with a Random Record Selection query. I've read much of the information here and searched other sites but I am still having a problem with one small part of my query. Basically, I need to select a...

Leigh, Your changes worked PERFECTLY! Thanks so much for your assistance! :D:D:D:D:D:cool:

I am working on an Access 2007 database. This database links to source data (via linked text files) from another system. One of the fields in the source data may possibly be null. When that condition exists, I want the query to look at another table and return the data from there. The...

Actually, I think Access 2007 does open the forms concurrently but it minimizes the first open form when the second opens. If they are using full screen or very large forms, they might not be able to see the minimized form at the bottom. Try looking for the minimized form and opening it along...

All - I have an Access MDB that was created in Access 2003. We recently moved to Access 2007. Everything seems to be working fine with the database except for a small problem with the switchboard menu. The switchboard opens and performs normally until you click one of the buttons that...

I am sure this is a very basic problem but I just can't seem to make it work... I have a form with a combo box. The values for the combo come from a table listing available month and year of various data. When the vlaue is selected in the combo box, the form refreshes the data to display that...