Search results

Hi I built a quotation system which has worked fine for my purposes over the last year. I now need to update all the pricing against all the products in my product table. I have a complete list of the new product prices but am struggling to update my original table using an update query...

Hi All I have a database which currently collects service visit data. I need to attach the subject line off the original email request to each record. Currently it is a manual process but this is prone to human error far too often and as a result ideally I could do with automating this...

I'll give it a go. Thank you for the help :cool:

Hi All Does anybody know a nice simple way of calculating the number of working days (monday to friday) between two dates in either a query or with some VB. Currently I am exporting the data into Excel and using the "Networkdays" function but this is not ideal for my purposes. Cheers

Cool, Sounds good to me. Only got about 100 fields in total so should be ok cheers

Thanks for that Gary. I'll give it a go. Not sure it will work in quite the way I need it too though as I assume that this code requires all the data to be pulled from a single query or table? Currently the report I use is constructed from two subreports and in effect 3 queries. Do you know...

I have an access database which collects data from our engineers visits to site. I have successfully integrated the database with our PDA Comms network through but am having trouble with the signature capture. Due to limitations of our back office I am restricted to storing the signature...

Hi I have recently developed a database for the purposes of reporting service technician visits. Using the ODBC connection to our AS400 I am able to collate the relevant visit information and display it in a report. I am having a problem with the output. Currently it creates a PDF document...