Search results for query: *

This is my first time creating a DAL for a website, and I am running into a sort of hairy error. I am attempting to perform an update of a smalldatetime field in my table, but when I do so, I get an error that reads: Conversion failed when converting character string to smalldatetime data type...

Ok, here is the skinny. I have a textbox on a webform (asp.net 2.0) that has it's text property set on load to data from a sqldatareader (I read the data into a string variable, then sent the text property equal to the string variable). This is working well, except for one problem, I want to be...

Ok, so here is the deal. I have a dataset that I want to export to excel using XML/XSLT. I have a fairly general idea about how all of this should work, and have found many resources on the 'net, but none seem to really get me going on how this whole thing should work. So here is what I...

Ok, so here is the deal. I have a dataset that I want to export to excel using XML/XSLT. I have a fairly general idea about how all of this should work, and have found many resources on the 'net, but none seem to really get me going on how this whole thing should work. So here is what I...

I am having an issue getting a case statement to work withing a custom function that I am writing to add dashes to a SSN within my application. I have written the function as such: USE HRDev GO CREATE FUNCTION dbo.fn_FixSSN (@SSN as char(11)) RETURNS char(11) AS BEGIN CASE LEN(@SSN) WHEN...

I have a client on my network that is trying to send an email out to a customer and she is getting a rather odd error message/bounce back whenever she sends the message (note: I changed the @ in the email address under final recipient). No other client on the network gets this error when sending...

Hello. I am using ADO to import some data from an AS400 table to an excel worksheet, and I am having some trouble getting the dates to convert properly. When the date gets imported, it comes in in this format: 122005, which to me would mean December 20, 2005. However, when I change the number...

Hello, I need a little help with an import I am doing from some SQL Server tables to my Access 2000 database. Using a VBA module, and some ADO, I have a connection to the SQL database working properly, and a select statement that when run in an Access query pulls all the records I need, but...

Hello. I am trying to set the recordset of a form on open using an ado recordset, and I get Runtime Error 2455 - You entered an expression that has an invalid reference to the property Recordset. Below is the code I am using to get the recordset for the form (I have omitted my SQL statement, as...

I am trying to use an ADO connection to pull a couple of records from some SQL tables and populate a few fields on my form. I am getting an error in my sql statement that says "Invalid object name dbo_IMINVBIN_SQL". The query runs fine when run directly from the access, but not from code. Here...

Hello all! I have a question about ADO, as I am entirely new to it and want to be able to utilize it in my database (I would like to eventually get rid of linked tables, but at this point I feel like I am dreaming! Hehe!). I am currently using DAO, and seem to have a hold on it, and have coded...

I need some help finding articles showing how using vb instead of access is much better for the company I work for. This is critical to me keeping my job... please if anyone can help point me in the right direction!!!!

I have an Access 2000 database that is linked to some SQL tables from another program within my company (Progression Workflow Explorer/Macola), and whenever a user is accessing one of those tables from my database, it locks up other users using Macola. Is the access database responsible for...

Hello all, I have a quick question. I use the code from faq705-1634 to send multiple report attachements via email, but I would like to know if it is possible to make one of these reports the body of the email. Can anyone help me figure this out? Thanks!

Hello, I have a question regarding some subtotal code I have on a form. This code calculates a subtotal for the status of each product returned for repair (taken from a backlog query, which show all products in house, and their status). The code is as follows: Me.WarWIP.Caption =...

Hello, I have a really quick question...I tried using the TransferDatabase command to transfer some tables from my database to another (to create backups), but it only creates links in the backup database, rather than exporting them. here is the code I am using... DoCmd.TransferDatabase...

Ok, here is my dilemma. I have 3 forms in question, RMA Base Form, Parts Transactions (a subform of the RMA Base Form), and frmRejectParts (a form that opens when you click a button on the Parts Transactions subform). When I click a button on the Parts Transactions subform, I need to have the...

I need to know if the FireGL V3100 and the Tyan Thunder K8S Pro are compatible with each other. Has anyone here tested this setup, or know if any information is available that would help me? The ATI and Tyan websites seem to describe their PCI-X Specs differently, and I want to be sure they are...