Search results for query: *

I have created a .bat file sometime ago to run a macro. "C:\Access\TestDB.mdb" /x macro I have recently converted that database from Access 97 to Access XP and now this command line does not work. I have tried many things including putting the path in, adding quotes, removing quotes. The best I...

that worked great but is there a way of making is public for the whole program? Right now I have code to set my path at the very top of the program but when I put this line of code in it complains about GetDrive("U:").

I am trying to find a way to get the UNC by using the drive letter. On our servers everyone has a common drive letter but depending on where you are it could be on different servers plus it is also includes your username. Does anyone know how to look this up in VB6? Thanks Andrew

thanks I got it to work..

I am sure this has been covered before but I can not find it... I want to attach multiply files to an email message from Access XP. Problem I am having is that the files names are stored in a table and I am not sure how to get the names from the table so I can attach them in my code. Thanks...

I have a Access XP database that can currently sent emails using Outlook XP without any problems. But what I am looking at doing is have that database generate a hyperlink to the database itself with a /cmd on the end of it to take it to a form. I can generate the hyperlink to just the...

No I don't but it is ok I figured it out. It is nothing to do with getting the value. It is how it is being pasted in the hyperlink or short cut. I have to specify the location of MSACCESS.EXE as well as the location of the DB. You can not just have the location of the DB with the /cmd. Now I...

Thanks for the help but I cannot get that to work. I have set up a hyperlink as well as short cuts but it will not read in the command line value. Is there something else that I have missed?? Andrew

Hi there I have developed a database where I can send an email from it with a hyperlink the database. Now I would like in that hyperlink to the database have it so that it will open a specific for and goto a record. Does or has anybody ever done this before?? If so your help would be greatly...

Thanks for your help that worked great.

thanks for your help I will try that.

I am flagging the employee with the date that they leave the company. When I do my check on that table I check to see if the date is null or is > then today's date then I know they are still employed with us. Also once the change is completed the row is flagged with a date that the changed was...

Hi there, I am working on a db to track changes and who did them. Right now I have a form that is filled in by someone and there is a combo box where then put there name or the name of the person doing the change in and it does a lookup on there name in a table to ensure they are still employed...

My company is looking at using the COMPRESS feature in DB2 and I was wondering if anyone else has used it and give me some feed back on it. I am also looking for more information on it but I cannot find much out there so any help would be great. Thanks Andrew

thanks for you help. I will be starting my convertion next week. so you might hear from me again.

I am sure this has been asked before but here goes. We are upgrating our version of Access from 97 to XP which means I have to convert all the databases over. This includes all the data, queries, forms, reports, macros and modules. Can anyone give me some advice on what to do and what not to...