Search results

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...

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...

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)...

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...

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...

I want to add a section to my report and control the visible value based on page (1st, 2nd, etc...) So: 1st page show 'Page Header' which has lots of detail, but dont show 'AccNum.Header' section. 2nd, 3rd, etc.. don't how 'Page Header' as I don't need lots of detail, but show the...

I have a form, which has a subform, which is a continuous form. In the footer of the subform it sums the costs and then the main form displays the sum. Pretty basic stuff 1. When the user changes a cost or enters a cost is does not change the sum on the footer until the record if complete and...

I have a very established DB and want to add the functionality that allows the user to email a report instead of print or preview. Have try sendobject, it works by get security 'Alloy', 'Deny' Has search the internet a lot and see the outlook can be called direct and sent this way. However...

This feel like a very basic question, but I just can't get it to work. What I want is if the 'CustRef' field is greater then 15, then to change the fontsize to 8pt. Below is the code I'm using... Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer) If...

I have a PC with Vista Premium and Office 2003 professional and is running a Access App I built. When I install my printer HP Laserjet 2600n I can print from Word. Excel, Notepad, etc... but on Access. When I try to print or preview a report I get - MS jet engine could not find component If...

Hi Have built DB App. in A2003 on XP. App. is basic but does the job and works fine on XP and Vista Ultimate. Got new DELL PC with Vista Home Premium; install Office Profressional 2003 added App. and it does not work. Can not even preview or print a report. When I try and access the form code...