Search results

Hi i have an access database for tracking quotes and jobs, this includes a job memo section for any addition info on the job which is a memo field in the job table, tbljob. One of the staff claims that some of the info is just disappearing out of the memo field which i find hard to believe. I...

I want to embed web images into an access report. I have an access report that currently works perfectly pulling images in and displaying them from a local drive for each record. I want to keep this and add functionality to include images from a web site but it doesn't work when i put in...

Hi I have a database with many staff members and each staff member has many Customers assigned to them. I want to export customer details to a separate excel file for each staff member. I don't want to have to do this manually as its going to take up time. I'd like to name the files...

Im having trouble with a running sum for my VAT analysis section of a report. Whats happening is the vat is calculated and rounded appropriately. But the running sum seems to be calculated on the pre rounded figure, is there anyway to rectify this. So i have following figures 245.70 at 21%...

I have a querey used for a report that lists quotes from certain dates. Within this query i have a IIF function that displays whether or not the quote is Live. Live is true or false. From the form that generates the queries i have a combo box to select live, not live or both. The Live field in...

i have 3 subforms that give a summary of costs for a certain job. when the main form is refreshed 2 of the 3 subforms refresh but the third doesn't. the 3 subforms are set to display 0 if there is no value to display. so i don't get #error displayed, purely for user piece of mind. The user...

i have an access report with two sub reports. A text box in the main report adds 2 values in both sub reports together. One value is 10.22 and the other is 13.08 which should amount to 23.30 but the value is coming out at 23.29 which is off by one cent. i have all text boxes set as currency...

Hi, im new hear and at access programming for a ear now. I'm looking for ways to improve response time on or access CRM here inwork. Currently we have a frontend(forms and queries) and a backend(tables) stored on the file server, the users here(about 25) use access on terminal server. i was...