Recent content by PShiers

Thanks for the reply. I'm printing a delivey confirmation note, so it is one record. But depending on the number of lines of the customer address, warehouse address, number lines of notes and other information, the report may spills over to a second plage. If I know it is going to go on to...

Hi, what I to be able to do as the report as it is formating: if total number of pages is going to be > 1 then AddressSize endif Function AddressSize() Address.fontsize = 9 end function Just kind find a way of know if the report is going to be more then one page to I can to some...

Thank, made change so address in displayed (locked) on the contact screen, added button 'Edit Address', so address screen shows and allows edit. Seem to have solved the problem, just need to apply to everything else.

https://community.spiceworks.com/topic/1961724-audit-trail-for-access-database

It 100% not a new record, attached is screen shot of contact form and address name is populated with 'House', also screen shot of beforeupdate code showing its doing edit, and screen shot of table row showing the addnme is 'House'. I've try deleting and rebuilding the screen, deleting and...

I found code for creating detailed field level audit funtionality and I copied. It is really good as I can added alot of additional details about who, what & when in the audit table. However, I've spotted then the form has a Rowsource that is a One to Many Query, the functionality doesn't work...

Excellent, Thanks for the help

Wonder if someone can confirm if the following is possible, and if yes then how to do it. Backgroung: I've setup a table call 'Towns' to how hold list of all towns, and in the customer table the town in the customer address is a key e.g 20 which is e.g. 'Dover' in the Town table (20 = Dover)...

Thanks

When you manually create a new field in a table it is possible in the properties section are to set field size e.g. Double, and the Format where it is possible specify padding e.g. '0000000000'. I want to be able to do this using SQL or VBA? I know how to use ALTER TABLE to create the field as a...

Thanks Simon I'll give this a try in the next couple of day and post how it went. Cheeers

Simon, Could you explain a little more, not sure what I should be counting and how. Thanks

Workaround is a good idea Thanks

If it possible to change if a group is visible based on what page a different group is printed on. The report I'm working on is a Invoice and it has subtotals in one group and totals in another group. If the totals are going to print on page 1 then there is no need to print the subtotals...

Thanks Yep, I was being lazy and just want to add a section into an old report, but sound like I might have to create a new version. Cheers:)