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!

Register Log in
  • Congratulations Rhinorhino 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: KyleS
  • Content: Threads
  • Order by date
  1. KyleS

    Linked SQL Server tables ask for password every time

    Well, it's been a while but I've got a question I just can't answer (even with searching this site, Google and msdn) I have an Access 97 dB (well, about 30 dBs actually) that I didn't write (pretty standard story really) which is connected via DSN to an AS400. That link works great. I need to...
  2. KyleS

    How to save an embedded object in VB 5.0?

    I have a VB form with an embedded Excel file so the users can change the file in Excel. How do I save the embedded object to a specific file path - C:\Test ? Thanks, Kyle
  3. KyleS

    SaveAs Method of Workbook Class failed - XL 2k VB 5.0

    Hi, I'm using the free eval copy of Excel 5.0 (don't ask, let's just say my work is a little cheap...) I've got my application all ready to go, it opens and edit Excel workbooks, and then when saved, moves the file somewhere where the user can't get to it and saves the pertinent data to my...
  4. KyleS

    More Webbrowser problems...

    Hi again, OK, I've been through this site (more times than I care to admit) and all over the net for quite a few days and have found NOTHING which will give me some insight on the collections to reference (or the properties their-in) in the WebBrowser. Obviously my Web knowledge is EXTREMELY...
  5. KyleS

    WebBrowser usage problem...

    Hi, I've looked throughout the archives and I can't find a solution to my only problem (so far) with the WebBrowser. I have a form (which I don't own) that I need to push a button on. I know the syntax is: WB.Document.All("ButtonName").Click But the problem is, there is no name...
  6. KyleS

    Excel as an OLE Object OR another way to display mult sheets on a repo

    OK, Let's start off with my current quandry. I can't seem to be able to locate the command to embed and Excel sheet into my Access '97 field (OLEObject). I know I can do it manually, and I know I can do it through a form one at a time, but this needs to be automated. there should just be a...
  7. KyleS

    Access into Project with SubTasks! Please help!

    Hi, Well the search engine is down so I can't find any posts and I apologize if this has been asked/answered before. I have an Access (97) database and on occasion we export some information into MS Project (98) to output a Gantt Chart. This is all fine and automated but now we are sending in...
  8. KyleS

    MS Project 8.0 Object Library Error

    Hi, I'm at the end of my wits here... I've got a database that connects to Project '98 and exchanges information, etc. So obviously I have the MS Project 8.0 Object Library selecetd under 'References'. Everything works fine, but for some reason, if a user does not have Project loaded on their...
  9. KyleS

    SQL Server compatability

    Hi, I'm running Access '97 on Win NT 4, and my company is contemplating (read: Being pushed by me) to go to SQL server, I was wondering if SQL Server 2000 would work in this environment of if 7.0 is the way to go. (We will be upgrading to Win 2000 eventually, but I'm not holding my breath)...
  10. KyleS

    Corrupted Database...

    OK, this is gonna sound weird but stick with me. I created a utility to compact/repair a whole slew of DB's accross our network automatically (I'm not responsible for them and those who are don't compact regularly and the Network guy asked me to do this for him to help keep the space down) I've...
  11. KyleS

    Use Registry Editor to disable (and enable) Virus Protection in Excel

    I know Word has the ability to diable the Macro Virus warning through VBA. But to the best of my knowledge to do this in Excel I need to go through the Registry Editor. I haven't used the editor before and was hoping someone could give me an idea of how to do this. I have an Access Report I'm...
  12. KyleS

    Manually updating unbound OLE objects throught code

    Hi, I've got a bunch of reports that contain Unbound OLE objects that I want to have update only "OnPrint" as they continually update whenever the report is opend, even in design view, which makes editing a pain. I have switched their Update properties to "Manual" , but now...
  13. KyleS

    References help required

    I have a question. My DB's are on a network, and there have been times when one of my users will open up one of my dB's and my code won't work all of a sudden. I get the call and go to fix it and it works fine on my machine. So I go to their machine and it won't recognize something like...
  14. KyleS

    Type Mismatch..Help!

    Ok, I'm completely stumped...why does this code give me a type mismatch on the second line "Set rst = Me.RecordsetClose"? This is the ENTIRE Sub: Dim rst As Recordset Set rst = Me.RecordsetClone txtRecNu = Me.CurrentRecord txtRecCnt = " of " &...
  15. KyleS

    Field list incomplete

    Hello again, In my query design, when I bring in either of two of my tables, they are both missing the last field on the field list. It doesn't matter which field is last, it won't show up. I have gone into the table design and moved the order of the fields around and the last one always...
  16. KyleS

    Microsoft Access can't represent the join expression...

    Hi, I'm absolutly stumped (and more than just a little frustrated) . I have 2 tables that are linked together with a one-to-many relationship. When I open query-builder, I can't see all the fields in the first table (including the linked one!), and when I bring in the second one they don't...
  17. KyleS

    Fields in table not showing up in query design?

    Hi, I'm absolutly stumped (and more than just a little frustrated) %-( . I have 2 tables that are linked together with a one-to-many relationship. When I open query-builder, I can see all the fields in the first table, and when I bring in the second one they link automatically like the should...

Part and Inventory Search

Back
Top