Search results for query: *

Hi, all, I'm hoping you'll help me now as you have before. I have two tables--table A and table B. Table A has information that exists in a current database. Table B has information that may be used to update the information in the current database. In some cases, information in a field in...

Hi, all, I am working with Word 2007 mail merge document. The data source used for the document has some "ugly" abbreviations, such as 10ACP, etc., that are necessary to the database that feeds the merge document. Is there a way to automatically change the 10ACP to 2010 Annual Campaign (or...

I am planning to deploy a runtime Access database. The application will be distributed to different organizations. The primary use of the application is to connect to and report on a SQL server database on the backend. Though each organization has the same SQL database, it has a different...

Hi, all, The following line of VB code is supposed to concatenate fields to create a sql string: Where = Where & " AND [Year] Between + Me![Year] + And " ""+ Me![Year 2] +"" Year and Year 2 are text fields. I keep getting errors associated with the quotation marks. Can someone let me...

Hi, all, In my access database, I am using a form to allow users to enter parameters for ID, Constituency Type and Class Year. The command button on the form runs the following VB code: Private Sub RunQuery_Click() Dim db As DAO.Database Dim QD As QueryDef Dim where As Variant Set db =...

I am using a form to query a table in an Access database. The item being queried on the table would have a value of "Y" or "N" (meaning yes or no). On the user end, I would like to display the choices available to them in a drop down as "Yes" or "No" and then translate this to 'Y' or 'N' for...

I am working with a MS SQL database. The database stores various names for constituents. Each constituent can have multiple name types. Each name type is assigned an ID number. For example, I might have an individual name type, assigned name_type_ID 1. I may also have a joint name type...

Good day, all, I have created a query based on an Access Database. I would like to add a numeric field to the query results that automatically increments each item in the results list. Result 1 would have value of 1, result 2 value of 2, etc. It has to be an "automated" solution, meaning that...

I am new to SQL and Access, so I appreciate your patience. I have a table like the following: ID Adddress Type ID Address 1 1 2 123 Drop St. 1 4 456 Lemon St. 2 2 567 Jump St. 2 3 789 Pete St. 2 7...

I am writing a report in Access. The report is based on a MSSQL database. The query I am working on involves three tables: 1. Base 2. Characteristic Link 3. Characteristic The tables are connected as follows: 1. Base ID is linked to ID on Characteristic Link Table 2. Characteristic...

Hi, there, I am new to VBA and hope someone may be able to help. I have a database table that includes information like the following: ID Amount Sequence 1 $5 1 1 $10 2 1 $15 3 2 $8 1 2 $12 2...