Recent content by Access nubie

We have an Access db with linked tables to oracle. I'm looking for code that will loop the below query and substitute the number 10 (the criteria) in the first line with each region (about 60 of them) listed in a table in the database and append the results to a table. Any help is appreciated...

wow, ok, thank you. I'll need to get someone to help me with your above suggestion. this would be done as VB code within access? and then setup the looping to read all MDBs in the directory & puts the results into a table that will show the db names that have linked DBF files (or maybe the db...

Plog, i like your idea, but unfortunately we are limited on LAN space - there just too many dbf files & some are very large which would make the db huge. i will look at the links that sxschech posted.

looking for a way to export the list of table names, table types & if they are linked (e.g. tbl Sales Linked .dbf or tbl Staff linked to excel) from a database - this has to be done for about 300 databases. in an individual db, I have a make table query off of the table MSysObjects to get...

2013 does NOT recognize DBF files, we are trying to find a solid work around to LINK to our DBF files. There are about 30 DBF files that get updated EVERY week. And there are about 60 employees that LINK to the various DBF files. Importing is not a realistic solution given these...

This is needed in anticipation of rolling our dept to access 2013 which does not support linked DBF files. end users have their own various databases that they have created with a number of tables linked to various DBF files (located in d:\data). The DBF files are downloaded every week due to...

In access 2013, I have a table that lists all of the linked DBF tables in the current database in the field "ForeignName". I need to create code that will delete all these tables whose names are in the "ForeignName" field (the table is created from a make table query the filters on *DBF names in...

yes, i need to display all records where the date is less than the date entered by the user. I would have liked to have been able to put the greater than/less than symbol in the prompt. if that's not possible, some advised to put the symbol in the query itself as follows: <[Enter desired date]...

When a query is run, i want a prompt displayed allowing the user to enter < DATE to find all records less than the specific date. e.g. < 1/1/2011. I know how to do that with a start date AND end date (Between [Enter Beginning Date] And [Enter End Date]), but that's not what I'm looking...

I am the only one who uses this database. I'd like to put the macro in place for the occasional times when I am out of the office & someone else needs to run the process, which occurs once a month. Also, this data is obtained through a report from a third party application. The data is...

i'm sorry, i am a nubie. i am not familiar with a DDL query or a DAO TableDef. in a different database, where an autonumbered field had to be added each time (also every month) *midway* through the queries, i used the function AddCounter(Files As String, ID As String) in a module. then, i...

Every month I import an excel file into a db. Each time, I have to add 2 fields (1 with text type, another as number type) with specific names. How can i automate the process of adding the 2 fields? Is there a VB function or macro function to do this? thank you.

Hello. I download data into an excel file every month. i bring that file into access, then add 2 fields, one as a text type and the other as a number type. after that, several queries need to be run. since it is the same format with the same field names every month, I'd like to automate the...

Hi all. I have a macro (access 2003) to export data from several queries into 1 excel file every month. When the excel file is created, I'd like the current date to automatically be added after file name. Is there some sort of code or field I can add to the end of the file name string? thanks.