Search results for query: *

Hi, I have a large excel workbook consisting of 2 worksheets (which later on we may add more). Is there a way to have a search toolbar on the first worksheet letting the user type in a search string that will query all the rows in data worksheets and display it in the "results" worksheet...

Hi, I have configured my SSG520 to send a SNMP trap when it detects a link down, however, the trap that is sent looks like: Enterprise: .1.3.6.1.4.1.3224; Generic: 2; Specific: 0; Variables: [1] mgmt.mib-2.interfaces.ifTable.ifEntry.ifIndex.4 (Integer): 4 [2]...

Hello all, Will anyone be able to give me a list of all the commands that I can use with HTTP 1.1 servers? (example: GET) Thanks a lot. Lory

Hello all, I'm new to Oracle and need to output all the records from an Oracle table to an ASCII file. The problem is I need to format the ASCII file in a certain way... Each record has to start with the word BAND in uppercase letters then the first name field, last name field, address field...

What is wrong with the following function line? It works in A2K and AXP but now A97 which is what I am using... It keep saying there's a syntax error: Private Function Convert(str As String) As Long() . . . End Function Thanks in advance! -Lory

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, I would like to create a date in the following format 6/15/2004 07:20:32PM can I do that with Date() function? Thanks in advance!

Hello all, When I sort with the following code on a continuous form, it sorts...but it sorts the Upper case and Lower case separately. Is there a way to sort together? If Me.OrderBy = "field" Then Me.OrderBy = "field DESC" Else Me.OrderBy = "field" End If Me.OrderByOn = True Thanks...

Hello All, I have a search that is working perfectly now. It does a SQL query of the database looking for the matching result. My question is, when I do the query like: SELECT * FROM table WHERE field = txtfield.value it tries to match the whole value in txtfield. Is there a way to match any...

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, 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. When a user enters a criteria that doesn't match with...

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

Referring to this Post I am using Access 97 and it is connecting to an Oracle database but the data that is stored in the tables are unicode and of course, Access 97 does not support unicode. Is there a way that I can convert the data in Oracle to ASCII so that it can show up properly when a...

Hello All, my form is connected to an external data source in Oracle through ODBC. When I link my form to the Oracle table, it automatically maps the datatypes in Access 97. However, there is a field called "ID" which is an autonumber field but when I link it to Access, it mapped the datatype...

Hello All, Has anyone successfully convert Remedy dates into readable format that appears in Access textboxes without using Remedy ODBC to do the conversion? Thanks a lot! -Lory

Hello All, I am having this problem with my textbox's format. I have a field that stores information that a user types on a form, like extra notes that a user puts down. In Oracle, the carriage return character shows up as a square box, then when I view the records in the form that I created in...

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 listbox. For example: Project | Status A |...

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

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 For j = 0 To...

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