cshayes | Sun, 01 Jun 2008 11:13:00 GMT |
paulshapiro | Sun, 01 Jun 2008 11:14:00 GMT |
albertd_kallal | Sun, 01 Jun 2008 11:15:00 GMT |
walker | Sun, 01 Jun 2008 11:16:00 GMT |
I'm hoping someone will be able to assist with this one. Using a schedulingprogram I'd like to run a batch file that runs a macro to creat e a copy ofthe opened database. Then, using batch again, Zip that copied file to thesame directory location and delete the copied file.The ultimate...
Hello,I am trying to zip a folder(this folder contains severalfiles), from access application.This is as a part of back upprocedures which I am writing.I have written the timer program forother functions .I wrote a code to utilize the WinZip exe.While itzips the folder ,the folder does not exist...
I have a problem. I have takens a spread sheet from excel and imported itinto access. There are 380 records, all but 47 are in 5 digit form. Theothers have the four digit extension. Everytime I import the spreadsheet, Iget an error message that says the records with the four digit extension dono...
I've seen questions about updating the city, state from a table of zipcodes. Where do you get that table? Is it something you have to buy ordoes it come with Access and I just haven't found it?Ken...
what is the best field type for a zip code?Thanks,...
Witam, zastanawiam sie jak mozna by zrobic znaczek "+" ktry by umozliwial pokazywanie szczeglw dla poszczeglnych rekordw. Chodzi mi o to, ze chce wyswietlac jakies oglne podsumowanie rekordw, ale jesli uzytkownik nacisnie na znaczek "+" przy rekordzie to uzyska skladowe wchodzace w sklad tego...
LIttle confused I think but im guessin that;you want to use accesss to copy a file into an existing=20 zip file.I think this may be possible in that access would likely=20 have a command to run an exe file. i.e. zip.exeAnd the zip program likely has some switches to allow you=20 to run the exe file...
Is it possible to get access to automatically run "send to a compressed folder" in order to zip files together which have been created?ThanksRay...
I want to type in the zipcode in a cell and have it fill in the city andstate cells. I was able to figure that out pretty simply in Lotus Approach,but can't in Access. However my online mailing list uses Access 2000 andit's a bother to transfer back and forth, so I'd like to just use...
i downloaded a manual that said it was zipped i then saved this to mycomputer and when i tried opening this it was just a load of symbols, i amusing windows me and trying to open document in word, any suggestions?...
i cant seem to print zip codes properly on access when i try to print them onlabels.for example 92105-4545 prints out 921054545 with no dash i storing the datawith an input mask of 00000\-9999;0;* and that didnt work so i deleted it andset the format to 00000\-9999;0;* and still when i create a...
I have (2) tables in my db, one is named ZipCode and it has ZipID asautonumber; Zip Codes as Text; City as TextThis table contains all the zipcodes for the cities in the us.The other is named States and it has only StateID as a text field,it has allstates in it already.What I need is a way to li...
PLEASE help me!! LOLI am looking for an add-in to where when I enter an address and a city, it will look up the zip code for me. If that's not too clear, here is what I am trying to do...I am going through the phone book and entering addresses in to Acces to put together a mailing, the prob...
Of course these posts are old and so is the data.I found a great website for inexpensive developer and marketing listsfor zip codes. Plus they give free updates.http://www.listfactor.comThey have lists for united states zip codes, cities, and counties. Ineeded the counties and found that there a...
Please advise:I am trying to format the zip code field in my report.There currently are no hypens in the stored zip codes.I am entering the following:Format([Zip Code], "@@@@@-@@@@")This works fine, but how do I get a correct format to dothis if the zip code is ######### (nine letters), but dono...