Search results

I have an ini file which performs backups. I want to call this from an access form. Can anyone direct me to the correct site or methods to do this. It appears from my help file this can be done. I am trying to back up my backend.

Currently I am working on a backup module. My end users are a very simple lot, so I would naturally like a very simple procedure. Looking though this site I saw a previous post on backing up and this works fine. As long as the file is no larger than one floppy disk. How do I test the backend...

Previous posts have suggested this can not be done, however, I have had some morre thought about it. The desired outcome is strA= "Banana" strZ="Please add 16 " & strA The objective is to get strA to appear as Bold. Various attempts using FontBold property have amounted to nothing. I...

I am trying to write a delete query and it is driving me b......s. I have a table which contains date,address, FAC,pH,TA etc. I run a query to select the top 5 by date. I now want to delete the records not in the top 5. But I do not know where to start to write this. I have tried fiddling...

I am rewriting some code for some reports. Currently there are three reports, however, there may end up being five or six. All reports at some point use some of the messages, some of the reports have messages which are unique to that report. The decision on which message to use is based on...

After thinking some more how do i tell the software that if the time goes over 4.00 pm to go to the next day at 7.30 am and continue to calculate the end date?

I have a field called Start Date which store the start date for a job. I have a field called estimated time. The time we guess a job should take. I am trying to write a query to add the time to the date to ascertain the next available date. My time is in minutes. I convert this to hours...

I have a table that lists stock. A lot of the stock names are repetitive such as Pipe. However, each pipe is unique in Size, Class, or Material. The stock list also lists fittings. Some fittings have threads, some do not, some threads are BSP some are NPT and so on. In addition the stock...

In trying to make a query of sizes I have found a disconcerting flaw I do not know how to address. My stock lines include sizes from 15 mm to 700 mm in 5 mm increments. When I sort these ascending and group by. I end up with 80mm being greater than 700 mm. How do you sort strictly numerically?

I have a table which stores product codes and prices from various suppliers. For example: Code Price Supplier 101 $10.00 Someone 101 $12.50 Someone Else What I want to create is a query to find the cheapest supplier for the product. I can't seem to think of how...