Search results

i posted already in Tables. and added my next challenge in filtering data from the comboxes

Hello All, I need suggestion on how to organize my Tables, Query, and Forms in order to have a better database. I have been told by one of the members here that I have done a lot of things that is not right in my database. What I am doing now is how to filter my drop down button. first drop...

wow. thank you so much vbaInet... yes i know my database is messed up. im not an expert with Access but im learning. can you tell me about whats not right about my database so i can post questions in the forum? my next challenge now is how to filter the items from the 2 remaining combo boxes.

i dont know what expression to create to make it open at the same time the value of the textbox is correct. i attached my database for further check. when a user click a Discipline on the top right part (drop down button), items will be shown on the ListBox. once the user pick/click on an...

oh i see. i have this on the property sheet of the Form: =[ListBox].[column(11)] there is a ListBox that holds all the items, when a user click an item, the information will appear on the textboxes below. challenge for me now is how or what to change with the expression that will change it...

it is not calculated in the Query. its just a text. a text in the Form; not in Table or Query. like, the issue was Open before then users wants to make it Closed since it was resolved already. They can't change it because the error says it is bound to an expression.

Is there a possiblity that a control CAN be edited that is bound to an expression? All of my Form properties are set to editable, no locks, allow deletion, allow addition, etc. I just want a text box in a Form to be edited by users if they want to update it but they CAN'T since it is bound...

okay thanks.... database is attached already. so my challenge here is the filtering of combo boxes at the right side and the COUNT.... @Uncle Gizmo: i watched your video and it was informative but i cant apply it in my database. im not an expert with access.

i want to attach my database but it says: Your submission could not be processed because a security token was missing. If this occurred unexpectedly, please inform the administrator and describe the action you performed before you received this error. i dont know why..... :confused:

thanks. but do i need to register to see the tutorials?

anyone knows what should i do or codes should i put? my problem is that, there are 3 drop down button that should filter category of items in a database: Category 1 Category 2 Category 3 whatever users choose in category 1, it will filter the items in Category 2. whatever users choose in...

so what can u advice? right now, the database is not created yet. im still getting ideas on how to do it. what they want me to do is to create a database for time in time out attendance..... the report should have id number, name, time in, time out, total, difference... wherein the time in...

but, is it possible that the entries will just be loaded to access database? because no data entry is involved here, there is other tool to get the Time In and Time Out.

Can anyone direct me to a sample database where its about Time In and Time Out Attendance. If not, can anyone give me an idea how to do this? It will just calculate the difference of Time In Time Out with employees Card Number. The Time In and Time Out attendance is provided (no data entry)...

I tried what you suggested John but nothing happens. I moved the codes into the Search Button that I created but it wont search anything. I know theres some codes I missed which i dont know, i tried but nothing happens still. I am doing this to lessen the slow searching in every key stroke that...

Thanks CJ_London... i tried your suggestion about snapshot. when i changed it to my recent database it cant give result i dont know what happened but when i did it on my older database (less function, less data) it is working though still the slow motion is still there. i dont get about the...

thanks John. will try this right now and let you know how it goes.

i have found samples of dynamic search databases also here: http://www.accessforums.net/queries/true-keyword-search-19909/index4.html#post167355 but, it can only search 1 column/field though it can search even mixed words unlike mine it should be in order. im not also sure that if i will...

Hello John, just want to ask if its possible to place a SEARCH button in your dynamic search database? i am using your database actually, but it slows down when it has lots of data already especially if it deals with calculation. what i want to do is that whenever you type (letter per letter...

does this database of yours CJ_London slows down when there is a calculation involved? because mine has a same function like yours but different approach and it slows down because of the calculations....