Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: bpitche
  • Content: Threads
  • Order by date
  1. bpitche

    Check for open applications

    I am using the Shell("G:\Max411\impmeter.exe") command to start an application. The impmeter.exe imports data into my database, then closes automatically. This works fine, but I do not want my code to continue until the impmeter.exe application is closed. Is there a that I can do...
  2. bpitche

    Data Report Problem - Not Displaying first Record in Recordset

    I have problem with my data report. I have developed a search program that displays the query results, from an Oracle database, in a data repeater. Then I created a report to print the results. When I preview or print the report for the first time, all of the records are displayed on the...
  3. bpitche

    Data Report Problem - Skipping First Record

    I have problem with my data report. I have a search program that displays the query results in a data repeater. Then I created a report to print the results. When I preview the report for the first time, all of the records are displayed on the report. But if I close the report and preview it...
  4. bpitche

    Comma/Tab Delimited Text File

    I am using ADO to query a comma delimited text file. I have run into a problem. Some fields that I am using, have a comma(,) or quotes (to represent inches) in them. This is breaking up the one field into two or more fields when the records are diplayed in a Flex Grid. Any suggestions? I...
  5. bpitche

    DataRepeater Problem

    I am working on search tool in which I would like to display the query results in a DataRepeater. I built the .ocx ActiveX control, assigned the properties (let and get), and created the bindings. Repeater is linked to an ADODC user control. My problem is that no data is being displayed in...
  6. bpitche

    DataRepeater

    I am working on search tool in which I would like to display the query results in a DataRepeater. I built the .ocx ActiveX control, assigned the properties, and created the bindings. Repeater is linked to an ADO user control. My problem is that no data is being displayed in the repeater. I...
  7. bpitche

    Compact on Exit (when flagged)

    I know how to make my database compact on exit, but I need to do something a little more complicated. I have a database that I use an import procedure with. The database is strictly used for reporting. I am using a flag that is set to "True" when the import is run. I want to use...
  8. bpitche

    Searching database with advanced search

    I would like to know if anyone could help me write some code so someone can enter words or a phrase in a textbox, then select whether they want to search for the exact phrase, any words or all words. I know how to search for the exact phrase, but I don't know how to do it the other two ways...
  9. bpitche

    Microsoft Query question using MAX function!!

    I have been researching the max function to find out the last service date for each piece of equipment. That part of my query works wonderful, but what I also need to see is the pieces of equipment that have do not have a last service date (in other words, have not been serviced yet. I am...
  10. bpitche

    LIST BOX WITH CHANGING ROW SOURCE

    I have a list box that I am using in conjunction with option buttons. I am changing the row source depending on the option selected. The problem that I am having is that I am unable to select anything in the list box (not even one record). The enabled property is set to "yes" and...
  11. bpitche

    Selecting in a listbox?

    I have a list box that I am using in conjunction with option buttons. I am changing the row source depending on the option selected. The problem that I am having is that I am unable to select anything in the list box (not even one record). If anyone has any suggestions, please help me out...
  12. bpitche

    Column Widths Property

    How do you change the .ColumnWidths property for a list box using VB. I am using one list box, but the RowSource is changing as a different option button is selected. I know it should be: Forms!frmEquipment!lstLISTBOX.ColumnWidths = ? I am just not sure how to put the widths in so it will...
  13. bpitche

    Updateing Table Info from Delimited File

    As we have just upgraded our database to Oracle, it is taking a lot to learn everything. What we have been doing is pulling price data on inventory and sending it to our purchasing department to send out for bids (in excel). They are making changes to prices and sending it back to us (also in...
  14. bpitche

    How do you search for duplicates (not on primary key)

    I have a database that keeps track of all of our equipment in our plant. It's purpose is to track maintenance information. For example, we will be entering filter changes on machines. There is unique number assigned to each entry with an equipment number and a date of the filter change...
  15. bpitche

    Forcing Caps Lock On

    Is there any way to use code to turn caps lock on if it is not already on? I am trying to keep consistency in the data entered in the database. I need it to be entered in all caps and stored in all caps. The ">" format does not store it in the tables as all caps, it just makes it...
  16. bpitche

    Forcing Caps Lock On

    Is there any way to use code to turn caps lock on if it is not already on? I am trying to keep consistency in the data entered in the database. I need it to be entered in all caps and stored in all caps. The ">" format does not store it in the tables as all caps, it just makes it...
  17. bpitche

    Searching Criteria Separted By Commas

    I have a text box in which I would like to enter values separated by commas. All values are equipment numbers which are all the same field in the table. Is there a way to create a sql statement and create the reports for those specific numbers?
  18. bpitche

    Multiple Select List Box Without Holding Down Ctrl

    I know how to create the multiple select list box! Is there a way to select multiple records with out holding down the control (ctrl) key? Thanks in advance, Brad bpitche@hoover.com

Part and Inventory Search

Back
Top