Search results

Earlier posts and site search have led me to the captioned vb code. This works fine,and I thought I had solved the problem but , it returns the 'CREATED DATE",so that if I have extracted say 6 (zip) files then all of these have the same created date. So it has become difficult to rename the...

Sorry for the repost but maybe I didnt make the situation clear,so obviously i didnt get an answer,and i need to resolve this. Simply what i want to do is From a directory with multiple files where a number is the only seperate identifier eg abcd88.lzh,abcd95.lzh,etc I want to "Get" a file move...

I currently have some looping vb code that extracts selected lzh files from multiple parent files,using lha or lhark These are relatively easy as the parent files and sub directory files have individual file names eg: abcd1505 (filename/date) However buried 2 further directories down in the...

Can anyone tell me if I set a security password...(Admin).......can it also be opened with the same password etc,if I install the access db on another remote computer Tks

Currently i have a query that uses a date as part of the query eg 31/7/2003. However I want that date to change to 2004,after 31/7/2003 has expired Is there anyway to have the computer update according to its own time the query ruuns like IIf <than 31/7/2003 then do this. So it is not a...

Tks Pat As far as I can see the field I want to populate is in table that the main form is based on The form comprises the main and a subform. However the main form is derived from the table am trying to populate. I suspect that u r probably on the right track,so i will have a closer look at...

I have a text box on a form,into which I enter a number. (The form only displays 1 item at at a time from a table with multiple items.) That automatically poulates the equivalent item table!field with that number. However I want it to populate that table!field for ALL ITEMS in that table,from...

With more research,I have discovered that when I run the "event function" in access,it is copying the files to documents and settings. (XP).When I run the bat file independently it does what it is told,and copies to the nominated directories. The problem with Documents and settings is it is...

This is an update to an earlier post which was not clear. I am shelling out to a bat file that extracts and imports an lzh archive. On boot (Or manually) the procedure works perfectly. However if I try to import further files (On a button press command) I get the message "file exists" and the...

Subsequent to previous posts under "archive extraction" I now have it all running in a rudimentary fashion When the Pc is first booted the call shell command works fine and executes the macro. If I try to repeat it ,I get a message that file already exists and is skipped. The files r deleted...

Many tks. That help file is much more extensive than the 1 i got with my version lha255. So I will have a good look at it Captnk

Many tks Neileg. Unfortunately I am still struggling with this. No matter what i do the thing will only find the archives in c:\downloads...(e:\is my main drive) and it extracts to the folder wherever the .bat file is located,regardless of what I type as the work directory in the .bat file. It...

Using vb i am trying to extract some *.lzh files in a "download" directory in access I am using a freeware prog.called LHA.EXE This extracts the above files fine...however I am having serious problems getting the syntax right . Yep it uses a .bat file that I shell out to in VB A bit of good...

Jon K Many Thanks. That works brilliantly Regards Captnk

Tks Neil. Probably yr first suggestion is best. I dont think I made it totally clear. The main table has only 1 set of "code" reference data. The append table has multiple code data,ie a copy of evrything that has been lookd at in the main table. So deletes from append are only partial,when the...

I have a table to which I append data,(as a quick restore feature,to save redoing calcs from the main table). However if I alter the main table I may want to resave the changes,but an append query doesnt replace existing data. SO i need to set up a Delete query that will delete data from the...

Good Luck! I posted a similar quesrtion a while ago and did not get a satisfactory response. Fotunately I was generating the same number of error tables per import,(10),so I simply wrote a macro to delete the 10 tables. I think this could be a problem if u generated a random number,because the...

I appear to have solved my own problem,(After a day and night of cursing) The solution was to simply insert ="Modulename() into the on click event of the command button box Sounds simple,but for those unfamiliar wuth code and modules it wasnt Thanx anyway

I have a button on a Form That runs a module. However I am clearly missing something in the button code. Every time I run the button I get the message "Runtime error 2516 Microsoft access cant find Module '0.' " The command i have attached to the button is Private Sub Command55_Click()...

Lookup Table Nearest value Tks Rich et al. I appear to have resolved my own problem,finally with a bit of reconstruction from this handy little Zip file I found in a much earlier post. So I will repost for others...Sorry I would acknowledge the original author,but I am unable to recall.