Search results

Thanks supercharge i thought your way looked the simplest, tried it worked. I was dreading make up lots of other forms!

I have a standard form but i would like it so that when a user clicks on the button from the main menu to open the form it changes the default view which i have set to data entry and change it to not data entry. Also another button to change its record source to a different query. Rather than...

Hi Richary the Release type and base are text values. Rich i dont know how to wriet his as an expression in the control source??

I have an unbound text box ReleaseDescrip on a report. I want to fill it with text from a dlookup Me.ReleaseDescrip = DLookup("[Release_Description]", "tblReleases", "[Release_type] = reports![RptEng1]![No1_Release] AND [Base] = Reports![RptEng1]![Base]") However i get the following error...

Thanks that works!!!!

here is the db i have been working on. Just click on airframe and then click preview report

Looking at it whe i created a report of the field on its own it does it, but why not the report that i have created?

I have a field on a report, i have set the properties to can grow and shrink. I have also set the properties of the Detail section to do so also. The field properties in the table is that it is a memo. However when i produce the report the field stops in the middle of what has been entered. I...

I have a field that if another field matches the criteria then a user must fill in that field. If that makes sense!! I have some code that if a user exits without entering any information on it asks them if they want to and if not undoes what the user has entered in the form. This works fine...

The real problem was that it was in the report open and not the format, Private Sub PageHeaderSection_Format(Cancel As Integer, FormatCount As Integer)

.visible or visibe is not in the auto complete featrue so thats why i wrote it.

I dont understand the error highlighted the If statement not the .visible?

Hi, I have a report with several fields and unbound boxes. I would like some to be visible and others to not be dependant if a field is true or not. Here is my code, but i get the error Run Time error '2427' 'You entered an expression that has no value' Code Private Sub Report_Open(Cancel...

Thanks that worked

I have solved this as i changed the properties of the box to grow and then change the data section of the report to grow and for some reason it changed the property of the box back to Gow = NO so once i corrected it, it does it!!!

I already have Me.AF_Approval.InputMask = "AAAAA/AAA/AA" But when the user exits the field it goes to AAAAAAAAAA I would like to keep the foward slashes.

I have changed the inputmask of a field based on an if statement. however i put / characters in place and it wont leave them there can anyone help. Me.txtbox = "AAAAA/AAA/AA"

I have a text field that has the full 255 field size. When i put this into a report i have set the properties so that it can grow and shrink depending on the amount of text is in the field. However it doesnt do it, so can anyone suggest why and how to get around this.

I have a field that has a property of text, this is because on occasions a user will need to enter a letter. However mostly they just enter a number. This number is usually 000925 and obviously it goes to just two 00 when above a thousands. I would like to set it that if the user just enter...

That worked thanks very much