Search results

it's ok i already find it out.. thank JHB..your given code work great.. thank again..

thank JHB for reply.. i want to ask, the access can only store in c or can also be store in thumb-drive..? from this code "C:\Program " _ & "Files\Microsoft Office\Office\Samples\Northwind.mdb" thank in advance.

hye all... i want to ask is there any way to open another access database using when click button at form.. for example i have tracking.accb then at my switchboard form, i would like to have a button that can go to another access which is borrow.accb. can these possible for me to do it..? any...

thank Isskint for reply.. i will searching on a single field only which is fielddate.

hye all, i would like to ask is there anyone know how to search records by month and year. example i will have form that contain combobox that will list Jan-Dec. and also unbound box for user to enter the year. then, it will have search button. after the user click search button, it will show...

i figured my problem.. actually i don't have any function for returning the items. i only have data entry to key in the info about user, the item and also date taken and date return.. do you have any coding to make return button for example if i show all record that i have key in then it will...

tq mahenkj2 for your reply.. i'm use this code at switchboard so that the form will pop up once we open the switchboard. If DCount("ID", "Table1", "date_return BETWEEN #" & Date & "# AND #" & Date + 7 & "#") > 0 Then If MsgBox("Documents are due in a week. Do you want to review?", vbYesNo) =...

hye all, i would like to ask is there anyone here know how to terminate reminders. i have made borrowing system and it will have date taken and date return.. for now, my pop up reminder will pop up in a week before the date return. my problem right now is if the user return the cd early than...

hye pat hatman, i have see your answer in this http://www.tutcity.com/out/access/automatic-reminder.46854.htm i already follow what you have said and it will pop up the form but there is no alert message, it just pop up the form. my form also will show all the data that i have in table. i...

and one more thing, when there is pop up message, for example, do you want to view the info, click yes. after click yes, it will show you the reminder form.. or maybe you can give me other idea to make something like reminder.

hye pat hartman, thank you for your reply.. i want to make the pop up notification is just for reminders that i can call the borrower to return the book. for example, if i click at the switchboard menu button, it will show the pop up if there are borrower need to return the book. btw, whet you...

hye, i want to make alert message that will be pop up when the return date for borrowing book is one day before the date. and the alert message will also can show the information about the borrower. the alert message will be something like this. Tomorrow one borrower need to return the book...

hye Wayne and Raskew, i need your help.. i do not understand how to do the alert message.. can both of you explain it to me.. for example, i want to have alert message when the date_return is one day before.. your help is much appreciate.. thankz in advance..

hye John, thankz, it work but it work for text box only.. if i select from the combo box, it will come out with all data.. it's not search the want that i selected..

hye John, here is sample of my db.. can you take a look at searchForm. i have problem regarding textbox which description. when i enter keyword it does'nt work.. but for combo box it's working.. i dunno how to solve that.. the coding for description in query seem right to me.. dunno why it...

i want to ask again.. why when i insert list box and select the query, it said data cannot be retrieved from the source you have been select. you must select a different table or query to cont in wizard. huhu..i cannot proceed to the other step because of this.. do you know how to solve it...

and 1 more thing, if i put the code in criteria of query, some of my data is missing.. my data in query is not same in as data in my table.. why this happen huh..?? can you help me to solve this problem.. thankz in advance

hye John Big Booty, thankz for reply.. could you help me by explain this.. "Save and close your query and go back to our form FRM_SearchMulti, now put a list box on the form use your Query QRY_SearchAll as the source for the List box when promoted by the wizard, and follow the bouncing ball...

hye, i'm new in access..i have a problem regarding how to search data using query that can also be edited by user.. right now, i've already make query to search the data and it will came out as a report. so, i want add one new button to make data be edited once user search the data.. how i'm...