Search results

So is there a way of un-enabling the subForm when you change to a new record? I don't see a function in the main form's event tab that would do this, as in an OnNewRecord() function. Is there something else that would do the job? I would imagine that the BeforeInsert() function would be best...

Yo, I'm using Form_frmEmployeeInformation.lngStaffIDPK cause as I'm opening the report from a seperate window to the main form, as in a window that only shows you the option's for which report you want to open, I assumed you had to reference it that way. The main form is still open in the...

Is there any way I can disable a subform in my main form until the user has entered some data in the main form and thereby created a primary key? If the user decides to enter data in the subform first it gives an error and obviously I don't want this!

When I open my report from the main form using the code: my ID card report opens fine. But I want the user to be able to click a button on the main form, opening another window that allows them to select from the various reports available using option buttons, I use this code To me this...

:rolleyes: :rolleyes: :rolleyes: Stupid question, have a button in the main form set as default button do the job, I assumed it wouldn't work because the focus was on the subform. I was wrong. Rule number 1: Never make assumptions.

Hi, I want a user to be able to create a new record in the main form, after they have finished filling in the boxes in a subform by pressing the Enter key, rather than having to click the 'new record' button on the main form. I reckon I need a 'default button' on the subform but I have no...

Just realised there, don't even bother.

With a regular label you can make it a hyperlink to open a file but is it possible to use these to open another form or is there any other way of doing this?

VB useses the FileExists funcion as follows: object.FileExists(filespec) Which returns true or faulse and where filespec is the file name and object is the name of a FileSystemObject. What I need to know is what exactly a FileSystemObject is and if anyone could possibly give an example piece...

Absolutly nothing as it happens.

...but I'v got a picture and I want to put a red box behind it so the picture looks like it has red borders, the problem is that the box always appears above the picture, I'm sure there must be a way to prioritize them or something but I can't find it!

Cheers boss!

Is there any way, either through VBA, or queries or whatever to implement something similar to a Java String Tokenizer in Access? What I want to do is change a big mad list of names, like "John O'Brien" to a list something like "johnobrien", for the purpose of accessing image files with names...