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

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

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

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

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

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

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

I have been reading about using delegates on a few posts here and msdn, but still don't quite get it. Here is my situation: I have a "mother" page add_customer.aspx and a"child" user control add_group.ascx. On the mother page is an "add group" button that makes the the panel inwhich the...

I have a DataGrid with an Edit/Update Column. I press the Edit Button and the row changes to Text boxes and DropDown Lists as designed. When I then press the Update button the following code runs: Private Sub dg_press_detail_UpdateCommand(ByVal source As Object, ByVal e As...

Right now, we have a database on SQL-S with an Access front-end. Some users need to be able view a snapshot of data while at a remote site not connected to the internet. I am trying to setup pull subscriptions from our SQl-Server to our sales-force's laptops. I want to have a button or an...

I am trying to concatonate an nvarchar and integere value like so: SELECT TOP 100 PERCENT cus_key, cus_dataworks_num, CAST(cus_dataworks_num AS nvarchar(10)) + ' - ' + cus_name AS name FROM dbo.tbl_customer_detailed ORDER BY cus_name But cus_dataworks_num can be NULL. When it is...

We are trying to get a terminal Server up and running for our remote users. I am having trouble with a database crashing and shutting down. Here is the senerio: Viewing a form that shows a list of records (continuous form), a button is selected for a certain record opening up a detail view...

I need to test a number to see if it is a multiple of 5. Any Idea's? Thanks,

I have this here script that copys a database front-end (.mdb) to the local machine from the network. My 1st problem is that the copy method is stripping the file of the permissions it has, and not allowing it to inherit the permissions of the destination folder. I want to end up with the...

I have the following script that has worked on several Windows XP machines for 6 months, but fails at line 18 (FSO.CopyFile...) on Windows 2000. It may not be 2000 related, but I suspect it is. The 2000 user has the full admin rights that I do, so I am a bit lost. Can anyone help?! Thanks...

Hi, I am having trouble figuring out how to do this, I am a bit green so there may be a better way than my approach. I have a series of queries (2) in an Access Front-End that are quite slow. The first is a UNION that joins 2 views, the second is an update that sets a flag in a table. I...