Search results

If you can not find winzip exe that could be the prob. It is often on mag cover discs or you can download it from winzip web site. DB

Don`t give up. With a form open, press control and G - takes you to the debug window. Click Tools then References. Scroll down the list till you find Microsoft Scripting Runtime. Tick the box. Close everything and try again HTH David b

He must have gone to the pub <bg> copy the code and paste it into a new module. These 2 lines - sSourcePath = "C:\Database\" sSourceFile = "MyDB.mdb" - need to be changed to match your set up. Then you need a button on an unbound form with something like this in the onclick event - Call...

Thanks for the reply, but that wont do what I want. David b

Yep that is where I am now. I need the a record nearest to Date() to have the focus in the list when the form opens David b

In a reservations app I have a sub form (in datasheet view) that displays dates in desc order. As these dates are both in the past and present I would like current dates to appear when the form opens. ie. scroll up for future and down for past. Slight problem is that today may not be in the...

Search this forum for - backup and zip code - and you will find what you need to backup a backend as suggested by chenn in the previous post. HTH David b

I am creating invoices for an app I am busy with. The transactions for the invoice come from 2 tables which store Sales and Facilities Hire. The current arrangement is that I create a temp table using append queries to get transactions from the 2 tables between selected dates. then draw these...

Didn`t know that, Suits me fine. The simpler the better is my aim <bg> david b

using Hasdata method this is doing what I want. Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Dim total as Currency If Me![invoicesubsundriesrpt].[Report].HasData then total = Me![invoicesubsundriesrpt].[Report]![totsuns] End If Me![txtTotal] =...

Havn`t just figured out your set up So can you tell us what tables you have David b

Thanks for the reply. No that doesn`t do the trick David b

Not Nz ? I have a report with 2 sub reports on it. I am grabbing 2 totals from the sub reports for the main report footer. If there is data in each sub report no problem. However if one contains nothing I get error. I have been trying to use Nz to force a zero without success. This is what...

Having read through your previous posts on this thread (3 times) I think you may be on the wrong road with this. If I am understanding what you are doing correctly I would use a form with 2 sub forms to tackle this David b

Having probs trimming the app to a zipped size that this system accepts. Will sort it later David b

Ah just worked out what is happening. The times are all there but being displayed starting 1pm. So how do I order it to start at 8 or 9am David b

I am developing a bookings app which is similar to the resource scheduling example that comes with access. Each days timeslots are generated and the first start time can be specified. In the table that time slots are stored the first start time is as specified. However on the form that...

You need to store a number and "see" a meaningful name. If your number is in column 1 then bound col is 1. The column width property should look something like this - 0cm;2.54cm. HTH David b

Using this code with unreg Winzip no probs. The initial problems I had were to do with the code running faster than the backup files were being created. A stategicaly placed message box or use of 5 seconds sleep solved it David b

We are getting there now. Your sleep funtion does the trick. I think I prefer the msg box method though. A chance to remind the user to put a disc in the drive. and it seems (to the user) as though something is happening during the 5 or 10 seconds . Anyway I`m very grateful for your help on...