Search results

Thanks Wayne, however, I am a beginner in Access. Can you explain further what you mean? I need to do a search on only the bounded fields on the form, becuase the unbounded fields (like the listboxes), after a user choose the value, it will automatically generate a code in another textbox which...

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

Thanks a lot!! It works great :D

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

Help! Please??! This is my "english" code: FOR range B2:B3883 FOR range F1:F3883 IF a match found THEN put contents in column G into column A put contents in column H into column E END IF Next row Next row Could someone please help me translate this into macro-language?? THanks...

I have imported the two files into my existing spreadsheet in Excel. They are in 4 columns, the first two are "description" and "name" from the first text file and the other two columns are the "description" and "name" from the second text file. They are in columns F, G, H, I respectively. Is...

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

Stupid me! All I need to use was simply: strCat = listCat.value strType = lstType.value strList = strCat & "-" & strType Thanks anyways! :)

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

Hi again, Does it make a difference because I am using SQL to pull data from a table to populate the cascading listbox. and by doing lstCat.value = 0(referring to the first element in the listbox) doesn't work quite right. and I keep getting error highlighting the line txtComp.value =...

Oh...the above code, I put it in the lstType_AfterUpdate()

Hello again, I typed in the following code but it is still not working(the proper text is not showing up in the textbox)....can anyone see if my code have errors?? If lstCat.Value = 0 & lstType.Value = 0 Then txtComp.SetFocus txtComp.Text = "Sony-Laptop" ElseIf lstCat.Value = 0 &...

Thank you Sam!! Is there a property or method that clears the textbox??

I tried the following but it gave me an error saying "You can't reference a peroperty or method for a control unless the control has the focus" txtComp.SetFocus = True txtComp.Text = "" If lstCat.Value = 0 & lstType.Value = 0 Then txtComp.Text = "Sony-Laptop" End If isn't the line...

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

Thanks! The form is for distribution so I'll lookup on conversion to MDE. All of the form's field is to be linked to an Oracle database. I just create the tables in Access for populating the listboxes. This wouldn't have a conflict with the value selected being saved to the Oracle database...

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