Search results for query: *

Hello, I'm trying to loop through values in an above node to get the "columnname" and can't seem to get the syntax correct. Any help is appreciated! XML: <Data> <Check> <DetailedData> <ColumnNames> <ColumnName>UserName</ColumnName>...

Hello! I currently am able to send a lotus notes email from access. Now I need to add hotspot buttons in the body of the email that polls the recipent for various responses and emails out their response. Can anyone help with this? I need a button to use this but don't know how in VBA...

So I'm a bit confused and obviously this is my first attempt at xsl. I have an xml file that I need to import into MS Access daily. I've created an xsl file to transform it into the format I need. How do I automate the xsl transformation to create my file so I can have it for my Access import...

Hello, I'm having a problem with the syntax of a subquery. This is what I have: SELECT tblErrorDetail.ID FROM tblErrorDetail WHERE tblErrorDetail.[Reason Code] In (select [tblReasonCodes].[Reason Code] from tblReasonCodes where [BA]= "P"); I'm getting a type mismatch error. Reasoncode is a...

Hello, I'm looking to create a table dynamically from a recordset that I created. For example, I have a select query from an external database and have the results in a recordset object. For my project, the fields of this recordset are different based on the different datasources that I am...

Hello, I have 2 tables that I need to link based on dates and I'm not sure the most efficient way to do it. One table is contains: Table1 Type Dateofoccurance 1 1/2/06 4 3/8/06 1 6/9/06 the other contains rates for each type and an effective date: Table2 Type Rate...

Hello, I'm having trouble creating a new group in crystal. Currently I have a report that displays billing data and is sorted employee, project, date. Then it displays a total for each employee. There are multiple detail lines per day that i suppress and display totaled in group footer for each...

Hello, I have a pdf made in Professional 7.0 that was enabled for commenting in reader. In Reader 7.0 notes and comments were added. When you try to print "document and markups" in reader all you see is text edits, but not the notes that go with it. When this file is opened in Professional 7.0...

I'm new to crystal so I hope this makes sense and someone can point me in the right direction, b/c i dont know where to begin. I hope it's a simple solution. I have a report that groups phases of a job and displays their totals: GH1 Phase Name : Shows Phase Name (alphanumeric field, not in...

Hello I'm getting the error "error 3001 - Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another." when i get to the .find line in my code when i hit a line where the criteria is not numeric. It works fine until I hit a vendor that is alphanumeric...

Hello I have table on the sql server that has 5 primary keys. When I link it in access it only shows 1. This is causing problems with my delete queries b/c I have duplicate values if only 1 field is listed as the key. The 4 other keys are listed as indexed in access. What can I do? Why doesn't...

Hello! I have a linked table from a sql server that I am appending to. The table is blank. I have an append query to add records to it that fails due to key violations. If I take the data from the query view of that append query and copy and paste into the linked table it works. I'm going crazy...

Hello! I want to find a way to send just one sheet of an excel document exactly like the send to mail recipient as attachment feature. Where it brings up the outlook email and I can choose a recipient from my contacts and type a message. Is there a way to do this? Thanks!

I have the task of adding and deleting users for an access 97 database with a mdw file that someone else created. I know nothing about the workgroup information files. I can't find any faqs to tell me how to edit this file. Can someone point me in the right direction?? Thanks!

Hello, I'm trying to create a DTS package that updates a table in one database (A) from a table in another database (B) and also adds new rows. I've been able to populate the table in B with the original data, but I can't figure out how to make an update statement with a DTS. And I think I'd...

Hello, I'm having a problem trying to figure out the proper formula to use, or even if its possible to do. Here's what I need: When a value is entered into a cell, the formula looks at what was entered and changes it. So if I enter "reg" into A1, i want the formula to change A1 to "regular" and...

I have two dates date1 and date2 in mm/dd/yyyy format in a table. I need to find if date2 occurs between date1 and one week after date1. I don't know how to compair based on month and day only. Can anyone help? Thanks!

Hello! I have a package that deletes all the data in a table then imports new data from access. I want to first check to see if the access table has data in it before deleting the old data. Is there a way to do this? Thanks in advance!

Hi! I want it to return all records when left blank, but it only returns records that aren't Null in this field. Help! Like IIf(IsNull([forms]![frmA]![selectC]),&quot;*&quot;,[forms]![frmA]![selectC])

I have an update query that runs and says its updating all the rows, but actually does nothing. UPDATE dbo_ACCOUNT_RES INNER JOIN AB_RES ON dbo_ACCOUNT_RES.ID = AB_RES.p_empno SET dbo_ACCOUNT_RES.CODE = AB_RES.P_JMISC1 WHERE (((dbo_ACCOUNT_RES.CODE)=IIf(([P_JMISC1]) Is Null,2,([P_JMISC1]))))...