Search results

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...

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...

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...

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...

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...

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...

Hi All, I have created a Search button and it has the default code that Access create when I create a search button. Can I modify the code so that whenever a user click that button, it will search for only the bounded fields on the form? For example there are 5 bounded fields, and a user only...

Hello All, I have a command button "List ELement" and when I click on it, I would like it to open up a form in the same database which I have created and saved as name "Element". The main form "Code" is continuous which users can add to it and the subform "Element" is also continous and the...

Hello All, When I am in the "design view", I set the Back Color property of my form to green, but I want the form to change to red when the user clicks on the "Insert New Record" button on the navigation bar. And once the user saves the record, it will change back to green. How do I achieve...

Hello All, I have two text files (lets say A.txt and B.txt) and in each of these text files, there are two columns. One is "description" the other is "name". Furthermore, I have a huge spreadsheet with many columns and rows. In this spreadsheet, in columns B and D are the "description", which...

Hello All, Here is the code for displaying the text in my textbox: Private Sub lstType_AfterUpdate() Dim i As Integer Dim j As Integer Dim strType As String Dim strCat As String For i = 0 To lstCat.ListCount If lstCat.Selected(i) Then strCat = lstCat.ItemData(i) End If Next i...

Hello All, I have 2 cascading listbox working and since I am working from an already existing database in Oracle, I want the new form that I'm creating to save as the same format as before using another application. In the first listbox, it has items: IBM Sony Compaq Dell In the second...

Hello All, Will the form load function be executed when I switch from "Design View" to "Form View"? Thanks -Lory

Hello All, I want a drop down menu where users can choose however I want to save space. Is there a control or property that I can set to have a control that has a drop down menu but doesn't allow the user to add in items? Thanks in advance! -Lory

Hello All, I am in desparate help. I am a beginner in using MS Access :confused: I have an existing table in an Oracle database and I am creating a form in Access that allow useres to add/delete/modify records. One of the fields in the table is "Serial Number" and it stores computer serial...

Hello All, This is me now :confused: OK. I need to create this form in Accss that links to a Oracle database which has the tables for the records. The backend part is already setup (the Oracle database) now I need to create a form that access the database to modify/add/delete records. So...