Recent content by Steven Deetz

I found my solution to the crosstab problem. In reviewing other posts I came across "Display zero values in a crosstab query" and followed the directions of labeling the fields that I wanted displayed in the crosstab. When there are no values for a field, it still shows in the crosstab. Then...

I am having a similar problem to Gezza. My cross-tab, and I think it could be happening within Gezza's, is breaking out data from one column and putting it into two columns. In my case, employer deposits for their employee health reimbursement accounts are classified as either an employer...

I am using a crosstab query to total the amount of bills paid for the current year and the prior year. I need the totals for the current year (2009) and prior year (2008) to use in calculating outstanding balances. The problem is that when I call the crosstab as a recordset and try to access...

I am working with a scanner from IDAutomation.com. They seem to have some inexpensive options that might help you. :)

I have been taking several different supplements to help with my energy. A B-vitamins supplement and a Panthenine supplement have given me a lift so I do not snooze away in front of my current Access project. :) The quality of the supplement is always an issue. Some forms of B-12 are part...

You can install an MSDE server running on your laptop and create a SQL Server database on your laptop. You can use Access 2003 to walk you through the setup of the SQL Server database and the security portion of accessing the database. Once you are happy with the database you shut down your...

I am finishing up developing an Access 2003 FE and SQL Server 2000 BE project and came across something I have never before seen. I routinely use ADO to add a new record to tables residing on the SQL Server BE. I have created an unbound form and added the ADO code to post the contents of the...

I am trying to create a view where I am only trying to look at transaction data for the current year-to-date. I have a field in the view called TransactionDate and I am trying to apply 2 types of criteria. My first question is quite simple, do I need to create two views (one for each criteria)...

pdx_man, Thanks for the tip! It works perfectly. I went into the SQL language and built the following WHERE clause: WHERE (DATEPART(Month, dbo.tbl_TransactionsMain.TransactionDate) = DATEPART(MONTH, GETDATE())) AND (dbo.tbl_TransactionDetail.DepositAmount = 0) AND...

Fofa, Thanks for the function idea. I got it partially working with this: BETWEEN CAST(MONTH(GETDATE()) AS varchar(2)) + '/01/' + CAST(YEAR(GETDATE()) AS varchar(4)) AND CAST(MONTH(GETDATE()) + 1 AS varchar(2)) + '/01/' + CAST(YEAR(GETDATE()) AS varchar(4)) This returns a beginning of the...

I have been searching through the forum for a way to create a View that only lists transactions that have occurred in the current month. I was able to create an Access Query that used DateSerial to create the following Criteria under the TransactionDate field: [INDENT]BETWEEN...

I am redesigning an Access front-end SQL Server back-end for a client and I am pulling out of a SQL Server table information on employer monthly contributions for an employee medical spending account. A set of records is appended to an Access table for viewing and editing. In Access I have...

The append query appears to be working properly right now. I think the ODBC connection had something to do with the query failure. I had previously edited the fields in the SQL Server based table and then in Access deleted the link and manually re-created the link through a DSN. I do not...

I am rebuilding an application for a client and I have an Access table that I am using as a temporary table. Once the user is done entering information into the temporary table through a form, the user presses an update button that appends the records using an Append Query in Access to an SQL...

I have a client who has an Access application where there are several linked ODBC tables from an SQL Server through a DSN that connects to the SQL Server through an IP address. I can manually use the DSN and enter the User ID and Password to see the list of tables and link the ones I want. I...