Search results

Hi Ranman, We have had a severe weather event in my area last Saturday and power is yet to be fully restored. Once I can fire up the PC I shall implement your code. Thanks for the quick response and I shall keep you posted on the outcome. Cheers.

I wrote an invoicing system in Access many years ago. I produce an invoice that i then send to Outlook using the default email button in the ribbon of Usoft Access after specified the format as PDF format. It does this ok and opens the new Outlook mail document (IN PLAIN TEXT Format) with the...

Hi Crystal, It works perfectly now. Many thanks.

Hi Crystal, I tried what you suggested and checked the unblocked, applied same and then rechecked properties again and unblocked message had gone. However I still get the same error message as before. I then decided to download the next file from you site, being the contacts management template...

Hi Crystal. I tried several times but MyContacts would not unzip

I live in Adelaide in South Australia. I installed 5KW of panels 8.2 years ago They cost about $6K AUS at the time. The Government and Power retailer were offering a rebate of 23c per KW hour which later reduced to 12 cents then 9 cents and is currently at 16 cents. So cost wise it is hard to...

Thanks for this and other weekly postings. I have always linked to a Drive letter for my backend dBases, so I had to reserve that same drive letter on each user's PC. I had not used the UNC connection methodology before. It is fantastic and would have saved me hours over the years when I have...

FWIW:- I seem to remember having this problem about 15-20 years ago. I wanted to have a database on the main PC in the office and a copy on my laptop that could be used on customer visits. The intention was that when they would re-connect on the network they would synchronize with each other...

Thank you it looks good and appears to work as you indicated you wanted it to.

Hi, I would like to see your end result please!

Hi typing Currency in the format field solved another problem for me. I didn't see that option which is why I formatted the calculated fields. Once again a big thank you!!

Many thanks Arnelgp that did the trick! I probably wasted 2-3 hours trying to find out what I was doing wrong. I really appreciate all the help you give to myself and others

Thanks I missed your edit so will try same!

Thank you for your prompt reply but it doesn't seem to work as totl = 0

Hi There, I am trying to understand what I am doing wrong with the attached Query. I extract and calculate a number of fields from two tables. When I multiply one field by another it works perfectly. See field "CubeCost" However when I try to add a number of fields the result is that the fields...

Hi Bob, Thanks for your input. I used the following which directly referenced the correct table:- Nz([Forms]![Allcrete-Report-Date-Range]![Employee],[WorkOrder Labor]![EmployeeID])

Hi arnlgp, Many thanks I simply prefixed the field name with the table name and the problem was solved. Thanks ever so much.

Thanks for replying ARNLGP This what I received back after installing the code. The date picking works well standalone but the employee selection is not working

I am having a mental blank I am trying to pull payroll records in a query based on a popup form that asks the user to enter StartDate, EndDate and EmployeeName The employee field on the form is based on a combo box tied to the employee file which brings back fields EmpID and Employee Name As...

Hi Arnelgp, FWIW This is what I am seeing from your latest version. There is no multiple pages with separate heading for each month.