Recent content by Stemdriller

Thanks all for your replies, the subform becomes visible so it is already open so the code DoCmd.OpenForm "myform", acNormal, , , , acDialog is not valid, how can i change this code to work when the subform becomes visible. I have tried on GotFocus but alas no luck. Thanks GW

Hi all When a certain button on a form is click it makes a sub form become visible, I am trying then to make this form exclusive aka, must be complete and stop the user clicking on the main form until this sub form has been complete. I though it was something to do with show dialogue, I have...

Hi Bob I have attached a stripped down version of the database. If you run the 'frmAddPermit, it will complain about various missing forms but will eventually fire. Place a 2 in the 'Number in Party' field and then click onto Area and Description. This will fire another form, by clicking...

Bob Couldn't do it, so in the end I took the sub form out of the main form, and changed the docde to call it up outside the form. A bit more work involved i suppose in hindsight should'vr done that from the start. Just don't like to give up. Many thanks for trying to help, really appreciate...

I have not got a Header Section active just the 'Detail'. I have added a Form Header and Page Header and tried placing a label in both if that's what you mean. The form will display Detail, Form and Page Header but will not show the border. GW

Hi Bob, thanks for responding Already tried that, even if i place a caption in the title, when the sb form is opened on it's own it's fine but again in the sub form even this caption does not show?

:banghead:Hi All Hope someone can help me out. I have a form and a sub form The sub form on it's own is fine, but when I place it into a form I lose the Heading and Border. It's taken me all morning and I cannot figure out why? Pls see attached examples Regards Gareth

Hi My Main Form has a few sub forms within it, but on one particular form when a button is pressed another sub form is 'popped' up but as the sub form is ontop of another the border cannot complete itself. Please see attached. If I remove the border everything is ok, but I really need to...

I exported the data to Excel, then simply imported into Access creating a Primary key. I only need to query this old legacy data, a new table has been created for any new service info. It's for a Central Heating firm, keeping records for boiler services. Attached is a snapshot. Hope u can...

Hi all I have been given the task to convert an old Lotus Database into Access 2010. My main issue is all the data is on one record, so all customer data and service data. The service data has 6 fields all with dates in, what I am trying to achieve is a query that will bring back the...

Got around it by when the SubForm was activate i simply set the AllowEdits = False on the Main Form and set it back when the form closed. It worked so I happy Thanks for responding, it is appreciated Gareth

Hi All I'm sure i've done this before but simply cannot remember. My main form has a hidden sub form, when a particular button is clicked on the main form the sub form becomes unhidden. I now want the subform to be completed and prevent the user from clicking back into the Mainform, thus...

Thanks, work perfectly Gareth

Hi all I have created some code that creates a temp table in a db then deletes when required. This works fine on my local PC. But I want to be able to specifiy a db on the network for the temp tables but as soon as I try the code just errors. I am new to recordsets so it maybe something...

Hi all Not sure if this is possible but........ If I have a date from value and a date to value is it possible to list the dates inbetween?? So 01/06/2012 - 04/06/2012 would produce a result like 01/06/2012 02/06/2012 03/06/2012 04/06/2012 Thanks Gareth