Recent content by jhob

That worked a treat! Thanks ever so much hullbee!:) I had already delivered the final version to my client with the form skipping down problem in it and have just now sent them the updated version with the fix in place, I sure they'll be pleased!

Worked a treat, thanks!

I should add that I am expecting the answer to be no, but if someone could confirm that it will save me a fair bit of fiddling time.

I was wondering if there was any way of making the headings on tab controls to be controlled by variables set elsewhere? cheers!

The tab control is long and does not fit entirely on the visible screen area, unfortunately there is no way to make it any shorter. Are there any hacks to get around this?

The first control in the tab order is right at the top, it's within a tabbed section if that makes any difference?

I have a form and for some reason when it's opened the form skips down the page by about a centimetre. I have no idea why it's doing this and I certainly haven't done anything to intentionally make it do that. Anyone got ideas as to why this is happening and how I might go about fixing it?

Cheers RuralGuy - that link was a great help! The simple Me!ControlName worked. Is it just me or is the access referencing system rather arcane?

I have a subform called subfrm_Sites which is a child of a form called frm_ContractorsAndSites. subfrm_Sites is a datasheet view. In subfrm_Sites I have the following code which populates some of the fields just before a new row is inserted. Now this code works perfectly when the subform is...

Awesome! That worked a treat! Cheers for your help on this one Uncle Gizmo!

I have a dependant combo box on one of my forms that works fine when a record is loaded directly. However when using the next/back controls at the bottom of the form to move to the next record it does not correctly load the value for the dependant combo box and it is just shown as being blank...

I got it sorted in the end. Turned out that it was because I had disallowed the 'Allow Additions' property so when the 'New' button was clicked access was getting itself in a bit of a tangle. If anyone's interested I just went through the form and deleted groups of fields until the problem...

The same form used to work and has only had minimal changes to it since it was last working properly. It also works fine when using existing records, it's just when creating a new record that it fails. I can see it draw the form and then the error comes up and the form is blanked. I have set...

I am getting the error 'You can't assign a value to this object' when opening a form to create a new record. The form then goes blank. The form is reasonably complex with 5 sub-forms and a over 50 fields on the page. My problem is that I can't figure out what is causing this error. How can I...

Would using a recordset be more efficient that DLookUp? I have it all in a function so can easily switch over if one is more efficient than the other. Pat - the tables are already normalised about as far as they can go, the application is just *very* data heavy, which in turn makes it quite a...