Search results for query: *

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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

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