Search results

i actually used your idea in another DB i made but i wanted to avoid that method and try to learn a differnt one.

i made the combo box get values from a query and it still has the same effect. What do you mean by use a seperate control? I cant make the combo box unbound because I need it to write to a table along with other fields in the form such as a loan number and an anount.. I dont want to make a...

the employee is the one who would accept a payment from a customer... This would be for a prolonged period of time so I want the field to remain the same unless a different employee covers.

awesome! thank you so much for your help! I also have 1 more thing in progress and this DB should be finished... If you could help that would be great http://www.access-programmers.co.uk/forums/showthread.php?t=78142 Thanks again

how would i do that

no calculations... this field is for input of check numbers... so this will range anywhere from 1 digit to about 12 digits..

thats the thing... i dont want it to display in scientific notation or decimals becuase this will be used to user end querying and scientific notation would be beyond some of them...

I need a field to permit only numbers. Upon selecting number for the data type I select Long Integer for a longer number... But it only allows 9 digits.. I need it to allow to enter in longer numbers... Any help? Thank you very much in avdance

Hey every1 in a form header I have a combo box to select an employee, when I go to the next record in the detail this combo box refreshes and clears... I need this combo box to keep the selection made and not refresh upon a next record Any thoughts? Thank you!

Ha I dont believe I missed that, you guys had the same idea.... sometimes its just the easiest things that seem so difficult It works for me.. Thanks a lot guys!

Hey Everyone.. I appreciate the help in advance.. in my DB the main form is 'checksreceived' the form is bound to a table "checksreceived", I added a combo box thats bound to another table "employees" I set the relationshop with the 2 tables but my problem is trying to get the employee's name...

i dont think he wants to hide the field after its inputted... why you dont just go to a new record... docmd.gotorecord,,acnew

ah i got it intead of = i put <> thank you VERY much for your help! :)

i want to take out the rows where the rowa = rowb

k im gonna try

what is tblTesting here's the exact scanario Table name: mbna Rows are TRNDTE and TRNEFD

im not quite following you... insert this code into?

I have two fields in a table. i.e. ROW A ROW B I need to filter out all the data where row a = row b anyone know how to do this... im sure its easy i just cant think of it any help is appreciated.. thanks!

I have two fields in a table. i.e. ROW A ROW B I need to filter out all the data where row a = row b anyone know how to do this... im sure its easy i just cant think of it any help is appreciated.. thanks!

i made a database like what you are referring to for a manager to calculate time... i can give you the DB if you want... and you can make whatever changed u want... u can PM me if u want...