Search results

No success so far. Fails on this line - fso.CopyFile sSourcePath & sSourceFile, sBackupPath & sBackupFile, True. When the backup path is to C:\ blah, blah, the winzip I agree form appears. Going to A:\ the floppy runs straight away with no winzip. After about 30 seconds an error - method...

Click the link and go to the 2nd message in the thread. Db

Ghudson posted a link to this code which created a copy of a b_e and zipped it . This works fine if the destination is C:\. I can not get it to send to A:\ Any thoughts on what it needs. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=56751

Eh! looks readable to me. David b

That`s unusual on here. No replies. I will have to try comp.databases.msaccess. <vbg> david b

I had a play around with your code at this message. http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=56751 It`s very good if the destination is C. However it doesn`t like the destination being A. Any thoughts on what is needed ? David b

The code below generates timeslots. it works fine apart from ignoring the start time. That is it always generates the 1st time as 1am not the time the user has entered on the form. Any thoughts on what is wrong ? Tia David b Private Sub OK_Click() On Error GoTo OK_Click_Error Dim...

Went to set a new customer off with an app on a machine running O97. Running Access error messages - SDM Error and Alert: FRetry SDM Error - were coming up. The customer said he had previously had problems saving Word files. A search came up with the probable cause as being Nimda virus...

Been asked to create an app to keep records for a horse business. Just getting my head round what it needs. Most is straight forward. Need to create a routine to deal with reservations. Some things, like a stable for your horse will be by the week. Others, such as use of the arena or the...

Don`t no which line of code. The problem system is a few miles away and I was hoping to have some clues before I went back to sort it out David b

I have an app running on a number of `puters in A97 with no problems. Has been running fine on 1 A2000 machine. Put an upgrade on last night which didn`t alter anything in this part of the app and got - 91 object variable or with block variable not set - message. when running the following...

I have a form with a list box. Double clicking a record sends that recordno to a table. I have the table set to no duplicates to prevent the same record being sent twice. If a duplicate is sent the confusing (for the user) standard access message appears - Access can`t append all records in...

Thanks for the reply. Tried the simple way, an append query based on the query that feeds the list box and that seems to work OK DB

What will the code look like to do that DB

I have a routine for selecting contacts that works like this. - 2 list boxes side by side. The one on the left contains all records or can be filtered by region. Double clicking a line stores the paperid in a table by way of the sql INSERT INTO temppaperid ( paperid ) SELECT...

I have some code which creates emails based on an address list . I would like a msg box saying do you want to include an attachment with these emails? yes no. If yes open a browse box to allow the file to be selected. Any thoughts on how to do this ? David B Hexham UK

I need to create emails from a list of addresses returned by a query, prompt for a word attachment and prompt for a subject and send to outlook. The attachment and subject will be the same for all the emails. Would appreciate some help with the code to do this. TIA David B Hexham UK

Have not got this going yet. Last time I tried I got file not found on this line - fso.CopyFile strFile1, strFile2, True David b

Thanks for the reply. Types is a control on the form. The set up that the focus starts in types, (sold, died, temporary). Next is the movdate,. Then the tagcombo where the animal is selected and the after update checks this code David

Any thoughts on why this code does not do its stuff. Using BPDATE as 05/04/2003 then any movedate where types = died between 06/04/2003 and 10/06/2003 should return the msgbox I think !! but it does`nt Private Sub tag_combo_AfterUpdate() Dim dbs As Database Dim rst As Recordset Set dbs =...