Search results

I have a database named NewUpdate.mdb. I have another database named MainDatabase.mdb. Almost all the tables in NewUpdate.mdb are linked tables that are in the MainDatabase.mdb file. I've written a simple make-table query in NewUpdate.mdb that makes a backup of a table that is located in the...

Hi VodaFrog, I tried implementing your recomendation, but was unable to successfully run it. It returned all valid and invalid records as false. I was able to use the code you shared and modify it so that I worked. It varies somewhat from the original code you submitted. It may not be the...

I have a table with close to 1 million records. Somewhere in this table are a handful of records that have characters we consider "illegal". I'm trying to write a query that will display these records. The "Legal" characters are as follows: 0 1 2 3 4 5 6 7 8 9 - / Here is a query that I've...

This may be a dumb question, but how can I determine if the db was created in Access 2000 format? Thanks, CR Junk

I have an Access db that is going to be shared by two different users. One user has Access 2003 and the other has Access 2002. Will there be any problems using this setup if both the users are accessing the MDB file at the same time? Thanks, CR Junk

Thanks for the info. The Nz function is just what I needed. SELECT FirstName+" "+ LastName AS JoinedName, Address, City]+", "+State+" "+ Nz(Zip,"") AS CityStZip, from MyTable. Crhodus

In the database that I'm working with, there are a few records that have null values in the zip code. I've created an expression called CityStateZip that I'm using for an address line on a report. SELECT FirstName+" "+ LastName AS JoinedName, Address, City]+", "+State+" "+Zip AS CityStZip...

Thanks for the info. That will probably be the easiest thing to do.

Normally, this is what I would do, but this report is being used as a mail merge letter. The mail merge letter is 2 pages (the details section is two pages long). After the first complete letter is printed, I need to "reset" the page number back to 1 for the next letter that is created in my...

I'm trying to create a label on a report that will display: "Page 1 of 2" if the page number is odd or "Page 2 of 2" if the page number is even. I'm having problems just figuring out how to reference my lable and assign it a value. I've tried: Me.lblPageNum.Report.Caption = "Hello" but...

Thanks Mike! That did it. CRhodus

Hi everyone, I'm having problems with a query. I've got a table with the following fields in my Employee table: EmployeeID, FirstName, LastName, SupervisorID I'm trying to create a query that will pull the following information about all the employees: FirstName, LastName, {Supervisor...

Arhh!! The last name was not being displayed in the query results because there were trailing spaces after the first name. After widening the column and adding a RTRIM to my query it worked. Thanks, CRhodus

I'm sure this is easy to do, but I'm not sure how to word my search criteria when trying to look for a solution. Let's say that I have 2 fields in MyTable: FirstName, LastName. I've been trying to use the following query, but obviously it does not work: Select (FirstName + ' ' + LastName) as...

Thanks for the info! Crhodus

Hi everyone, I'm having problems trying to figure out how to write a query. I have a table that contains employee information. Each employee is assigned a unique employee id. Each employee is also assigned a supervisor. The supervisor field contains an employee id. I need to write a query...

I need to run a query for a particular time frame. The only problem is that the CurrentDate field in the table has its data type set to Text. I thought I could do something like this but it didn't work: WHERE cdate(myTable.CurrentDate) >= #01/01/2004# Isn't there a way to "convert" this...

I have a SQL table named UserMaster that I linked into an access mdb. Inside the mdb, I have a backup of UserMaster from a couple of weeks ago. I'd like to update the SQL UserMaster.LastModified date with the date that is in the Acdess Backup UserMaster.LastModified date where the UserId is...

Does anyone have any suggestons? Here is a sample copy of the query I'm trying to run.

I've got a record in the PROJECTINFO that has a county named 'Adams'. Let's say that this record's project number is 123. At one time project 123 had several records in the CONTACTS table and the several records in the RECEIVEDREC table. These child records have now been "deleted". The way...