Search results

I don't know if this helps but I am trying anything. I figured out how to put the code Backupandzipit in a macro that I called zip. So now I made the command button run the macro zip, however when I click the button the backupandzipit code pops up and I would then have to execute it. Is there...

I currently was able get ghudson backupandzipit program to work. I saved it as Zipdb in the modules. What I wanted to do was run the program by clicking a command button in a form. The problem is I don't know how I would do this, I must mention that I am a little slow so even from the very...

I recently did a search to find out how I would send a database with linked tables so that they could read all the forms. In my search I came accross this site http://support.microsoft.com/default.aspx?scid=kb;en-us;159691ACC Procedure to Create Data Sources and Relink ODBC Tables (Q159691)...

OK, I just came to work this morning and ran the code again and for some reason it seems to have gotten better (at least I hope). Now I get a Winzip window poping up saying "Error: No files were found for this action that match your criteria-nothing to do. (C:\Documents.zip)." Heres what is...

OK I keep trying and trying and looking at old posts I have found some errors that I have made. Now I moved my database to the C drive and changed my code, now however I get "Run-time error '53' " and File not found. I saw an old post of someone who had the same error (...

I forgot to mention, that the path to sourcepath is a shortcut, could this be a problem? The parts I changed are sourcepath to where the file I am zipping is located, sourcefile to the name of the file I am zipping, sbackuppath to where to store the backup, for sbackupfile I did not know what...

Ok hopefully getting closer, I tried this and when I click the run(continue) arrow it give me a pop up box that says "path not found" with options to end or debug, so I clicked debug and it highlighted fso.CopyFile sSourcePath & sSourceFile, sBackupPath & sBackupFile, True Again here is the...

Thanks for your reply, I would love to check but like I said I am new to all this, what do I have to do to check and where do I go to check it. Also how do I know if it is correct or not. Thanks for all replies in advace.

Hi everyone, let me first start by saying I am horrible with programming and could really use anyones help. I have a database and I want to send it to some clients. The database contains a control panel that has a lot of buttons that link to different forms. I would like to have a control...

How would he go about relinking the tables and I figured to zip it would be a difficult code since I wanted to use a command button to mail the file. Thank you for your help

If I have tables that are linked to a database and I want to send those tables to a client how would I go about doing that. Since you can not view the forms unless the tables are linked properly the person I would be e-mailing the forms to cannot do anything. Here is where they are located...

I added a control button that when you click it, it mails a form. I also added a popup box that says "Would you like to save your changes before mailing", but when this comes up it has the choices of "Yes" and "Cancel", instead of "Cancel" I would like it to say "No", what should I do. Here is...

"Use the msgbox function Yes or No, if yes, save your changes in a table. You can create a table where you have fields: ID of record Change; fieldname; OldValue of the field; New Value of the field. Append your changes to this table." How would I go about doing this so that the box shows...

If I were making changes to a form and I wanted to send an email by clicking the command button and I want a box to pop up saying send with changes or send without changes so that it would either record the changes that I have made or not. How would I go about doing this? Also lets say I...

This is kind of what I wanted to know. Since there are certain amounts some costs can not exceed for example travel costs can not be > 500, so it would put travel costs at the needed price not exceeding 500 and the rest at the prices needed to obtain the correct percentage. Any ideas. Thanks

I have 6 records, with each of them having individual costs for either Germany or United States. On the bottom I have the overall totals, Germany totals, and US totals, with Germany at 42 percent of the overall total and the US at 58 percent. Is there anyway I can play around with the...

I will try to look at this later since I can not download files at work, so for now in the expression above is there a comma missing or something. I dont know what is wrong.

I tried this and it said "You may have entered a comma without a preceding value or identifier." Thanks

How would I go about writing this if I wanted just the end of this statement DATABASE=\\nawemugufs10vb\RV92_RV82\ML43ML\IPMSD-CL-FY05-RAM-2004218.mdb i.e all I want to show is IPMSD-CL-FY05-RAM-2004218.mdb in the text box. The expression I have now in the control source is...

I don't believe there is an extra " .