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 Chriss Miller 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: ScorpioX
  • Content: Threads
  • Order by date
  1. ScorpioX

    Find matching Cells, then copy data over to another Worksheet

    ScorpioX (MIS) Ok here we go. Not sure I'm explaining this right. So I will try the best I can. I have Two Worksheets within the same Workbook. One is named Sheet1 the other is Sheet2. Sheet1 Has six columns (A, B, C, D, E, F)with 1000 rows. Sheet2 Has three columns (A, B, C) with 2000 rows. I...
  2. ScorpioX

    Find matching cells on two worksheets, then copy the data over

    Ok here we go. Not sure I'm explaining this right. So I will try the best I can. I have Two Worksheets within the same Workbook. One is named Sheet1 the other is Sheet2. Sheet1 Has six columns (A, B, C, D, E, F)with 1000 rows. Sheet2 Has three columns (A, B, C) with 2000 rows. I would like to...
  3. ScorpioX

    Windows did not start sucessfully

    HI All, Does anyone know what tells Windows it did not start sucessfully on the last attempt. Basically I have a sysprepped image and don't want to have to rebuild it or repackage it. Everything still works it just waits at the Advanced menu options until a choice is made or it times out. More...
  4. ScorpioX

    Check to see if network path exists

    Hello, Sorry I have been searching and can not seem to find what it is I need. I think I have come close but seem to get errors everytime. I am looking to check and see if a network path exists. If it does I want to populate a box. If not, show a message and end the sub. Below is what I have...
  5. ScorpioX

    Trim Search value on Data Access Page

    Hello, What I want to do is trim the search field down to the last 7 characters, then search the records with that value. For example now I have a text box (SBSN), that a user puts in a serial number. Then clicks a button and the matching record is returned, if there is one. What I would like to...
  6. ScorpioX

    Sum of a Column in a List box

    Hello, This one is driving me nuts. I am trying to get a field to populate the sum of a specific column from within a List box. I can not figure it out. Anyone got any ideas? The form is: frmMain The List box on the form is: List58 The Column in the List Box is: Column 6 The Unbound box is...
  7. ScorpioX

    Open form with specific record based on List box selection

    Hi All, I have a little issue. I am trying open a form, showing a specific record based on the selection in a list box. The form I am opening is "frmWork_preview", which is opened by double clicking on a list box, named "List58". The List box is populated by "CNumber" in the Main form. I have it...
  8. ScorpioX

    Method not Found error

    Hello, I have a user who is trying to import data from a Olap Cube on a Web page, into Excel 2003. Once excel is open and it actually imports. It gives the following error: "The Http server returned the following error: Method not Found", after clicking ok. You then get the following error...
  9. ScorpioX

    Lotus Notes 6.5 closes all by itself

    Hello, We have several users here. 5 to be exact which are having Notes close all by itself for no apparent reason and gives no errors. They then have to reboot or run Killnotes to reopen it. The client side is 6.5, Server side is 6.5.2. All are running Win XP Pro SP2 w/up to date patches...
  10. ScorpioX

    How to compare Data on a form to data in a record

    Hi All, Having a little trouble here. What I am trying to do is take the value entered by a user and compare it to data in a table, which will then pop up a message box that tells them the data is already there and to please use a different Asset number. For example: Form Template opens up. The...
  11. ScorpioX

    Open a form based on a query, based on Combo box choices

    Hi All, Is it possible to open a template form, based on a query? Which will contain data based on selections made from three combo boxes. Basically the user will choose a Category, type, and model. Which will then open a template form, populated with the data from a query based on the say the...
  12. ScorpioX

    Entering 2 values into a table, in the same record?

    Hi all, Need a little help here. This has been driving me nuts, not even sure it can work. I look to be real close with it however, so I am thinking it might. I have a form with two combo boxes on it. i.e Type and Model, by choosing a Type, certain Models will showup. All works well until a new...
  13. ScorpioX

    Visible form based on Combo box selection?

    Hi All, I have a problem which has been haunting me for a long time now. I am trying to get a subform to open (become visible) when a certain value is chosen in a combo box. Anyone have any ideas on how I can do this? I have included some info below. Combo1 is for: Truck/Car Combo2 is for...
  14. ScorpioX

    Open a from based on a condition?

    Ok, here it goes. I am rebuilding a database for work. What I am trying to do is have a subform open based on the value of a combo box. Basically what I am looking for is when the combo box is changed to lets say "Software" it would open a subform for the "Software". I have been looking through...

Part and Inventory Search

Back
Top