Recent content by NightZEN

I need to calculate a weighted average cost from Purchase Order History. this is what I want For each part number and PO, mulliply the qty by the cost to get a total. Then sum all purchases together, and divide by the total purchased qty. Pretty straight forward in theory... so if i have...

That is indeed a sweet site. I am still, however, stumped.[banghead] Can you change a table's link from SQL Server (via ODBC), to another access database's table? thanks

PHV - thanks for the reply, That's part of my problem... When I manually attempt to change the link I am thwarted: I open the "Linked Table manager", select a table, select the "Always prompt for a new location" box, and click "OK", and then the "Select Data Source" dialog box comes up...

I want to programmatically change all of my table links from their existing links to varius SQL Server Databases, to a local Access Database. What is the best way to do this? I can't seem to change the tabledef.Connect value using this type of logic: With tdfLocal .Connect = ";Database="...

I am trying to determine, via vba, if ther SQL server is running or available. Does anyone have an easy method to do this? I am writing a routine to handle either the SQL Server being down, or the user running the database off the network (ie, a laptop on the road). Thanks for any thoughts or...

Yes I can ping the IP address, but not the Computer name.

I know there are several people who frequent this site who have integrated the Kodak controls into ACCESS databases for varios imaging and scanning needs. This issue came up about 6 months ago due to a windows update, and I cannot find any references to the registry fix. I hoped somone...

I use the Kodak Imaging for Windows in a database for scanning documents to the network from a form. some time ago it stopped working due to a Windows update. At the time it was fixed by making a registry change, but I cannot remember what I did and cannot find any information about it. I...

I am running SQL Server on a WinXP Home Machine. I have a DB I connect to locally via an ODBC driver for an Access Front-End. Works Fine. I used to be able to connect via my laptop and wireless network using ODBC but cannot anymore. I am using SQL Server security with the same SQL account...

Perfect! That makes sence. Thanks!

I am working on an Add-in that will (among other things)set the print area and other pageSetup options of the active calling worksheet. When I run the code I get an "Object Variable ro With Block Variable not set" error which is being caused by, I think, the add-in not referencing the Active...

That did it Mike, Thanks!

I am trying to create and add-in that will add a menu item for users to click and call a macro called "HotList_Formating". I have the following code saved in an add-in file (hotlist_formater.xla) in it's "ThisWorkbook" Object. I did not include the called subroutines here to save space, but...

I am trying to create and add-in that will add a menu item for users to click and call a macro called "HotList_Formating". I have the following code saved in an add-in file (hotlist_formater.xla) in it's "ThisWorkbook" Object. I did not include the called subroutines here to save space, but...

I am having trouble with the following code: Private Sub ir_code_NotInList(NewData As String, Response As Integer) Dim intNew As Integer Dim strQry As String Dim stLinkCriteria As String intNew = MsgBox("The IR Root-Cause code '" & NewData & "' is not in the list...