Search results

Hi, I have two forms, networkRefurbishment and addASpecialCode. After entering information onto the form addASpecialCode and exitng from this form I need the information contained in a field called newCode to be transferred over to a field called Code in the second form networkRefurbishment...

Hi, I have two subforms on a main form. In the "Tab Order" for the main form I have both subforms listed and both subforms have their "Tab Stop" property set to Yes. I have no problem using the tab button to tab into the first of the subforms but I can't seem to tab from the first subform to...

Actually there's a twist in the tail of this one and I feel like an idiot for not mentioning it sooner. I thought it didn't matter but it's probably why I can't get this to work. The second form networkRefuurbishment is actually a subform on a main form. I thought that this wouldn't matter if I...

Thanks for the help and I am getting there but now I have another problem. I get the following error : Run-time error '438': Object doesn't support this property or method Any ideas, to be honest I'm lost:-) Liam

Hi, I have two forms, networkRefurbishment and addASpecialCode. After entering information onto the form addASpecialCode and exitng from this form I need the information contained in a field called newCode to be transferred over to a field called Code in the second form networkRefurbishment...

I have a continuous form which has the following fields: Code Description Quantity Code is a combo box with a list of values from an underlying table. When I select a particular code I need the relevant description to appear in the Description field. I have managed this much by...

How exactly are they able to close the form if it is a required field. If I try this and set a required property to yes for a field in a table then I am unable to save it, I simply get an error when I close the form? I don't know much about VB programming but could you not place a default value...

When you're establishing the relationships with the other tables (the ones being displayed in your subform) just make sure you click on the "cascading deletes" option. When you try and delete the main record, all associated records from other tables (i.e. the ones on your subform) will then be...

I have a Combo Box on a form which allows me to select from a list of values that are stored in the field of a table. When I select a particular value I want the rest of the information from that record in the table to be dispalyed also but how do I set this association between the controls on...

Thank you for all your help and I hate to be still going on about this but unfortunately I'm still screwed! I like your idea about the underlying query generating a record that is too long or generating a record set that is too large but (and I hate saying this!), what's happening to me still...

Thanks for the reply! Firstly let me clear up "crash", when I try and open one of the reports they hang for ages and the program freezes. When I view it in the Task Manager window it says that the application is 'Not Responding' and I have to click 'End Task'. That is what I meant when I used...

I have a serious problem that I was hoping someone could help me with. I had an old database that was far too large (12mb) so I decided to get rid of all the features I didn't want and reduced it to approx. 2mb. However now when I try and open the reports the program "hangs/crashes". The...

I have a serious problem that I was hoping someone could help me with. I had an old database that was far too large (12mb) so I decided to get rid of all the features I didn't want and reduced it to approx. 2mb. However now when I try and open the reports the program "hangs/crashes". The...

Hi I have an If statement checking the value in a particular field. The format for the field shoulld be a date but if it is not filled in I assumed it would be null.( I have no other default value specified for the filed) Why isn't this piece of code working? If...

It's the name of the control and not the name of the form. I just don't get it! Must be doing something else wrong :-) Thanks for your help Liam

Hi, I need to refer to a subform to check if the contents of it have been changed. Even though I use the exact same syntax to check the main form(this works fine) it doesn't seem to work for the subrform. For example say, the main forms name was: Polling 20kV-Add a Record and the name of...

Hi, I'm using forms to display and update records in my database. However when a user exits/closes the form, Access automatically saves any changes made to that record without any prompt. I need to set up the form so that when a user exits the form, the changes they have made are not...