Search results

so if i have a text field that is 254 bytes long, and a user type in a senetence that is 254 bytes long , so eacg type a key is pressed, the event will come on

what will happen in you have a text box that user has to fill in, would the form-keydown event allways come on?

that won't work because any key that you press it will execute that event

I would like to have a event for the left and right arrow keys, does anyone know how to do this?

thanks for all of your help do you know how to de-activate keys on the keyboard?

thnaks for your help, its work fine. I didn't want the user to add more records., but i still have a problem. when I press the next record buttom(on the last record of the filter table) its gave me a error of "you can't go to the specified record". What is the best way to trap that error ?

the problem i have is lets presume that I have 5 records selected in my query. i have a button on my form to advance to the next record. so when I get to the 5 record and press the buttom next record its create a blank record all the time. i don't used recordset so i do i determine that i'm...

Hi everyone when I open my form i SET UP A QUERY IN THE CONTROL SOURCE that would only selected records that I wanted. That part work fine. The problem that I have its when i get to the last record , how do you determine that you are at the last filtered record?

if you have a worksheet that contains 100 cells to populate, you would use a query plus the iff statement that you indicate in your previous email. don't you think that woulod take a long time to do?

i know how a query work in other software, but in access i'm new at it. so I did try and it work find. thanks for all your help.

can you explain to me how does the select work in access?

what is the best way to filter a table?

I have 2 forms. The first form is used to coding and the next on is for verification. On the coding form i have a check mark for verification. On the verification form i just want to filter the check mark for verification, its work sort of. It will filter only the check mark but it will look...

SIMONMT do you a example or do you know of a book or website that i could take a peak at. another question. i use Access in pivottableview to create what I need and export into xls. Work find but I want to used the pivot table to populate a new formatted worksheet. do you have any idea how...

Is there a way that you can manipulate a pivot table, (example adding more item in a list) after the pivot table is created.

the pivot table could change in size. i just want to be able to copy the values that in the pivot table into a formatted worksheet

what is th best way to populate a new formatted table from a pivot table? thanks

sorry if you misunderstand my question. I,M been using foxpro for a long time so i'm used to do thing a bit different. How do you add a new record to a table?

if i add the field in the design mode should that field appear on the form. this problem happen to me twice and I don't know why. I'm a new in access, so talking about record set still having a problem to understand that. if I could ask another question. what is the best way to add a new...

I just added a new field into a table. when i try to used in the vb code (me.test as a example) the field doesn't show up in the list when i say me. . i HAVE NO IDEA WHY. Doesn't anyone has a idea why? thanks for your help.