Search results

WOW! Thanks....that is an excellent sample. Thanks a lot!

Thanks WayneRyan! It worked perfectly :) I think the encryption might be very complex and complicated to do. I'm trying to see if there's other solutions available.

Hello All, I have a logon prompt for working where it will check the passwors against the username that is entered. my questions are: 1) How can I set the text box where the user enters the password to only show stars (the * character). So that when a user types in their password, only stars...

Thank you Lou! I received the sample DB, although I was missing some object or libraries for it to compile properly, but I was able to look at the code. So, it all worked out and my DB is working perfectly now! Thank you so much :D

Thanks Lou, Sorry for the late reply, I have sent you an email!

Hello, I saw that thread but it doesn't work, I get an error saying I'm making an invalid reference to the recordsetclone property. My search form have controls that are unbound, my search results form has controls that are unbound. It shows record becuase I have set...

Hello all, I have a "main" form with a search button on it and when a user click on the search button, it will perform a search and open up a "search results" form and display all the records matching the criteria entered in the "main" form. THe "search results" form is a continuous form. When...

Hello all, I tried to set a date to a variable by: Const date1 As Date = "1/1/1950 12:00:00AM" but it only stores 1/1/1950 in the variable, it doesn't store the time! How can I declare it so that it includes the time? Thanks! :)

Hello All, Does anyone have a good example of a search result list and when the user click on a row it will open up that record? I tried searching but can't find a good example that will illustrate how to do it. Example: On the main form there's two text fields "A" and "B". The user type in...

Hello All, Is there a code that will open a default form when a user opens a .mde file? and that form's size is maximized? example: I have three forms: main, search, search results. When a user opens the .mde file, I would like form "main" to be opened automatically and the size is maximized...

Stupid me! I should use the lock property instead! Thanks anyway :)

Hello All, When a control is disabled, (assuming I didn't change any default font properties), the font color becomes grey. Is there a way that when the control is disabled, the color of the font can still be black? Reason: I do not want my users to click on some of the textboxes on my form...

Hi stargate, The two zip files are very useful! Thank you! In the SearchingOptions.zip.... I'm having trouble with the line: stLinkCriteria = "[Name ID]=" & Me![lstNames] this is located under Private Sub lstNames_Click() in frm Wild Search. This is actually my first time using Access, and I...

Thanks!! It's working perfectly!! :D

Thanks! I'll try them out now. Thanks again.

Hello to all Access experts, Can someone tell me how to put and code a "Find Record" button on a form? I tried putting the default "Find Record" button and tried it out but it's not exactly what I need. Is there a way, that I can create a command button, then when a user clicks on it, it will...

I'm sorry, let me rephrase my question........ I have a database table in Oracle and I am creating a form in Access to basically read the information and perhaps add new records. In the Oracle table, there is a field called Status and it stores the index number of the selected value of a...

Hi, I'm sorry if this has been posted earlier but I can't seem to find any post that I totally understand as I am new to Access. I have a listbox which stores status of a project. In the listbox, the values are: Requested In-Progress Cancelled Completed In a UI that my co-worker created, if...

It's alright :) I got it, I forgot to set the RecordSource Property. Stupid me!!

Hello All, I'm new to Access and I have created a form and imported external database so I can see them in the tables tab. Now, when I go into the property of each control on my form and choose the Control Source Property with the expression builder and point it to the table and the field. All...