Search results

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

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

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

A client had recently built a list of names in a temporary table for printing mail labels. There were about 2,000 labels to print. The labels were printing fine until about 3/4 (Page 46 of 56) of the way through the list. The following message printed on the label sheet and then no more...

I am working with a potential client where the original developer moved out of town and now the client needs his application to evolve. The problem is there is no documentation on the application at all. The front-end of the application is MS Access based and the backend is SQL Server 2000...

Customers who are using Acess 2003 seem to have what I call a goofy display of Tab Controls on forms. At a specific PC you can create a tab control on a form and set the properties to Transparent but the tab stays white while the form is another color. When I take control of the application...

I am creating an Export Function to copy all of the objects within an MDB file to another MDB file as a tool for providing application updates to various clients using the same program. It seems to be working for objects within the database container but there is one more "object" I wish to...

My ability to write code in the VBE has become very difficult and I am wondering if I have some options set incorrectly or if I need to do something drastic like reinstall Access 2003. When I start to type a simple docmd line of code in the Code Window and press the period key after Docmd I am...

I have converted an Excel file into an Access table and now want to break down information in this table into more meaningful fields. One of the fields I want to breakdown is a Emergency Contact text field that lists a name and a telephone number combined. Below is an example of the data in...

I have become the statistician for my son's hockey team. I currently can create a scoring report in Access and can print the report, use a scanner to create a jpeg file and post the jpeg file to the team web site. I was wondering if anyone has used Access to export a report directly as a...

Hello, I have a client who can export their membership information into a comma delimited text file. However during the conversion process the first line of the file produces an inaccurate header for the file. For example: ..."I MemberTo Activity#1 Category#1 BusinessName" should read...

Hello, I have a membership application for a client that allows users to register members for events that occur within their club. Events can be over booked and some members will be put on a Standby waiting list. When a member registers for an event the date and the time of the registration...

I am trying to create the First and Last Name of a person while registering them for an event. I am having trouble with the SQL syntax in VB. Whenever I try to create a space between the First and Last Name Visual Basic doesn't like it. In a query I can create a field like...

I am developing a membership database and am trying to incorporate a yearly phenomenon with our members. Many head south during the winter months for warmer climates and return in the spring. For our members to continue receiving their newsletter I could just have the database user go in and...

I am developing an application that tracks monetary pledges and payments for a charity event. I am having trouble in trying to create user defined errors. When a payment is received, the user opens an unattached form, selects a sponsor id in a combobox, and enters payment information in...

In several database wizards, Microsoft includes a neat feature when a user double clicks on a combo box a form will open up to add a new field of data to the list the combo box is tied to. As a donation, I am re-writing a Bowl-for-Kids Sake program for the local Big Brothers Big Sisters...