Search results

it was design issues... i always split into FE/BE and it was the same DB basically i didnt want the user to enter in a loan number for each check, i just wanted that field to be inputted once, so that was on the main form and i made a subform with check information, and it was mismatching one...

i actually did it as you described, but it led to other problems, 2 users couldnt use the database at the same time, so this is what I came up with

thank you but that didn't do it for me, i don't know if you understood what i was referring to... There are 9 fields. Every record will have a different number of those fields with data, some will stay null. The report is bound to a query and it pulls a loan number and the 9 fields. I need just...

Hey everyone, I need to setup a search query where a user will input a check amount and it will search multiple fields. I have 9 check amount fields in a table and i need 1 input to query all the fields, I attached an example of what I need, Thanks everyone!

Hey all, I have 10 fields of check amounts in a table, Not all 10 fields will have amounts for every record, some customers will pay with different amounts of checks. i set all but the first's visible field = to flase on the report So I need somehow the fields with data in them for the...

Hey all, I need data in a table to be read only, once its inserted no one will be able to modify with the exception of a admin, how can i go about doing this/. thanks!

thank you very much! i appreciate all the help! happy holidays :)

ya thats a good point, im just going to leave it as is... but now... if the user actually does tab... it will go to the next record and not use the code. to avoid that... is there away to disable going to a new record by tabbing through all the fields? i.e. if you hit tab all day long it will...

still lookin for help, trucktime you still around? :(

:D thank you thank you thank you very much! but i have a question, would it be possible to avoid having to click that button and somehow integrate that code somewhere else so they can just tab onto the next record? It would be much better to avoid having to click. thanks again!

Hey all, I have attached here a sample of what im trying to do. Basically i set up a combo box in a subform where an employee will select his name. I want the selection to be made only once because that same person will be entering data for a prolonged period of time. I set up a linkchildfield...

there is a Datediff function that will do that for you... i dont have it off the top of my head... but you can just hit F1 anc use help.. as for the user putting in data... just use an input mask and that will ensure data can only be entered in one specific method...

bump? 1234567890

I appreciate the help Wayne! Here is the file in zip format for your convenience... I'm not really following what you meant While you're at it... im also trying to fix a record problem... when the employee is finished entering the loan number, check number and amount, if they dont tab...

I applied it to the actual DB I needed it on but It yielded to another problem... The Employee Field on the mainform is not updated unless the name was chosen on the combo box. I attached the real one here... Use the SHIFT to open it and the form im using is "NewForm" If you can aid me with...

thanks to you both, the reason behind it is because the mainform is the one writing the record... I want the selection to be made on the subform because I dont want the subform to update... The employee will be making many records and i dont want that person selection the name each time

So this is the only thing that was changed? Forms![Frm_Main]![Employee] = Me.Combo0 Thank you very much!

Hey All, I can't seem to get this to work. I've attached a copy of what im trying to do in a DB. What I want is for an employee to pick his name from a combo box in the subform. I want the name to copy onto a field on the Main form so I can write it into the Recieved Table. I'm hoping someone...

here is a link to the DB the main form is frm_MainForm if I could get any help I would appreciate it Thanks again! http://www.zaiderman.com/Payment%20Window%20Customers.zip

That didn't work for me either... Anyone have any other thoughts?