Recent content by Dmonkyking

Thanks again PHV, worked perfectly. I knew there had to be an easy way to do it.

hey jebry, Yeah, that was my problem before is if I enclosed in # I couldn't use wildcards, because I guess Access didn't understand them as being wildcards instead if a non date character, which is found invalid. I'm hoping there is a simple way to do this within SQL, outside of doing a Like...

Hi, I've been trying to figure out how to have an Access query display only records with a certain date range, regardless of year. For example, I want the database to list records that have dates between June 1 and June 10, but using a wildcard as a year so it will show all years. Using...

Sorry, it would be best to post it in Access forum, because I am using an Access database, thanks for letting me know. :)

Hi, I've been trying to figure out how to have an Access query display only records with a certain date range, regardless of year. For example, I want the database to list records that have dates between June 1 and June 10, but using a wildcard as a year so it will show all years. Using...

Haha, I figured it was something stupid. I set a reference to DAO 3.6 and it worked perfectly. Thanks Tony and PH. I appreciate it.

Tried DAO.Workspace, still type mismatch error. The code does compile fine with no complaints. As far as the references being in order, I think Access 2003 did break a couple I had in there when I upgraded, but just 3rd party add-ins I added I believe. The only references I have selected right...

oops, sorry PHV, it's defined as such: Dim wrkDefault As Workspace

Hi, I have some VB code in my access database that is used to backup my database. Ever since this computer was updated from Access 2002 to 2003, the code doesn't seem to work now. The line below seems to get a type mismatch when VB tries to execute it. Set wrkDefault = DBEngine.Workspaces(0)...

I know this is probably beating a dead horse, but I was trying to find out how to link images to a form using relative paths. I have found lots of posts for doing this for records, but I have a switchboard with some pics linked to it that of course won't be linked to any specific tables...

Nevermind, I guess this method does work fine. Just tried it out by deleting the directory and it created the backup dir and the backup.mds. Tried it again and still worked fine.

Thanks a lot PH, might not be pretty, but works perfectly. One more question, is there a better way to kill the backup.mds file. Meaning, the code I have now only will copy the tables to that database if it exists, i.e.: If Dir("Backup\Backup.mdb") <> "" Then Kill "Backup.mdb" I know there...

Thanks again PH for steering me in the right direction. I actually have it working. The only thing I'm trying to work out is if the Backup directory does't exist then create it. I have the mkdir command all set up, but I haven't found the correct way of using an If statement with it, i.e. If...

Hey, Stupid question, but I have some code that backs up my database tables to another database, but in order to do that I had to put in the path of the databases when copying the tables. Now, of course, if this database was to move I'd have to change all the path locations. If I just input...

Thanks alot PH. It works, but the only thing is if the database doesn't exist it gives an error that the database is already in use, but it still creates the backup dataebase. So you'd just have to go back into the main database and pick to back it up again, which is fine, unless you might...