Search results

Doh! I didn't think of that! thanks

I want to add a record through a form, but I have to check if the value already exists on the table. The value composed of a client number and account number. Now, I can run a query in VB and add the record if the query is unsuccessful i.e. no current records match the record I am trying to...

How can I enter a record in a form1 then navigate another form from within form1 form to add a records that are dependent on form1. I'm not sure if this is possible - should I just exit form1 then select the option to enter the servant form?

Thanks - i'll try that

Is that a parameter i can set at form level to stop it happening for users?

In a form enter a value in a field on a new record. I decide I don't want to add the record after all, so I blank the field and press enter. Access tells me I have entered an invalid value in the field. the only way to escape is to close Access Why, and how do I get around this as thre will be...

Thanks Boblarson Just wanted to get the thing off my chest - the link and details are just what I was looking for Cheers

boblarson Thanks for your comment Why does it always happen on forums. You have a question you need an answer to and some smart ass just has to get a dig in to try and come across as some superior geek - not able to give any help or assistance mind. We have a word for these people in the Uk...

Been codin' since 1981 my friend - and real programmers don't regard generating basic Access forms as programming. That's why it's so frustrating when you want to do a simple like change a field length and nobody knows how to help. So, unless you are telling me that Wizard generated form...

So Iset the zip code integer to 8 on the table. I set the Surname field to char 25 on the table. I create a form using the Wizard - and hey presto all the fields are the same (long....)length and can't be adjusted - they change en bloc. If I create the form manually I can have the DISPLAYED...

I want to change the size of the input fields - so that a 10 long 'phone number field is not the same length as a 25 long address field. I wonder if I have a control on that means all field lengths are tied together somehow. I'm new to this - so thanks for your help

if I try to adjust one of the field lengths all the other fields adjust to thjat size?

I have created a form but I have to scroll down to see the bottom 2 input fierlds. Is there a form parameter I have set up incorrectly?

I'm new to Access so I hope you'll all bear with me Is it possible to change the field lengths on input fields in Design View if the form was created using the wizard? If so, how?