Search results for query: *

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

Thanks, that works nice (after a few tweeks): count = count + 1 Dim strSql As String Me.Refresh 'save any changes strSql = "SELECT TblPreProdAudit.* " _...

I am trying to use this code to copy the current record to a new one, but I get a message saying: "Some of the field names for the data you are trying to paste don't match the field names on the forms". But they do. I am stumped on this one... any body have a thought? DoCmd.DoMenuItem...

FYI Update: I also get this error when I open the database, though the database continues to load: Windows cannot find 'C:\Program Files\Database.mdb'. Make sure you typed the name correctly, and then try again. To search for a file, click the Start button, and then click Search.

I am running an Access Database on a terminal server (Windows2003) that connects to a SQL-Server back end. I am having trouble running this code: Private Sub Command13_Click() Dim strChange As String strChange = Me!ChangeNum DoCmd.OpenForm "FrmChanges", , , "ChangeNum =" & strChange...

How about some more info. Here is what i have so far: In my User Control is a datagrid where you can edit and add records. In the code behind page, I declare a delegate like so: Public Class add_group Inherits System.Web.UI.UserControl Private delReturnValue As System.Delegate...