Sounds like you want to know the Order. You would then use the Order By in your SQL Syntax or pick Acending or Decending from the Sort line in the design view...
I have developped an Access Ap that runs in a Access 2000 Envrionment. I was wondering if I updated to office 2007 would I still be able to develop as though...
I have table contain a many record and I want access support me to give me what is the first , second, third like: 123 third 1222 first 1000 second ….ext...
I have table contain a many record and I want access support me to give me what is the first , second, third like: 123 third 1222 first 1000 second ….ext...
I have a function, NextCustomerId(),that adds 1 to the last customer number in my "Customer" table. It works. Debug.Print displays the number that I want. I...
DanT Try to enter =NextCustomerId() as the default value of the CustomerNumber field (in the property sheet). Open the form in design view. Right-click on the...
Does anyone know a source for an Access ZipCode table. I'm looking for a table with US ZipCodes that will give me the City when I enter a ZipCode on my form....
Hi Dan, This might help you: http://www.usps.com/ncsc/addressinfo/addressinfomenu.htm?from=zclsearch&page=ais However, there is a fee for it.... ~Izzy ... Does...
http://www.zip-code-database.org/Download/ There is a fee. I found it to almost comprehensive. I'd wish it were address sensitive, but it does provide city,...
Will a databse written with Access 95 be compatable with later versions? I would thing so. However, is a database written in Access 2000 compatable with Access...
I have a problem with grouping to show for 1 order with multi deductions in 2nd table and multi expenses in 3rd table linked together by a common field. The...
http://msaccess.batcave.net This site contains comprehensive, straight forward summaries of the major concepts,issues, and approaches related to databases. You...
http://msaccess. batcave.net This site contains comprehensive, straight forward summaries of the major concepts,issues, and approaches related to databases. ...
Hi there, You can have all the people in one table and have that table in a many-to-many relationship with itself: tblPeople ... [ID],[LastName],[FirstName] ...
Hi Eileen, You can't really simulate an office 2000 environment in Access 2007. You might consider installing the two side by side on your computer (in fact, I...
I have a table that has many null fields and I want to replace them with say a zip code of 30512. How do I write the query? something like: if zip_code -...
Hi Bud, I just wrote a response which I lost to a python error on the yahoo website. Here's the abbreviated version: 1: IsNull() is a VBA function 2: IS NULL...
I have a DB of customers some of whom I do business with multiple times but for different reasons each time. I need to be able to copy the record, "cut and...
I have a record in which I take Field "A" and subtact Field "B" and that creates the answer in Field "C". That works fine in the record/form, but when I then...
Hi again, It depends. Are you doing the merge in word? Are you basing it on a table (I guess so)? Is field C calculated on the form or in a query (I guess...
Hi Capital, First, if you need to create identical records then your database design almost certainly doesn't conform to basic principles of normalization. If...
Peter, My answers in yellow First, if you need to create identical records then your database design almost certainly doesn't conform to basic principles of ...
Hi Bob, The color didn't come through. Normalization is not specific to Access, but to relational database design in general. If you do business with some...
Yes I am using Word, and I really don't know if the result is only shown on the screen or saved to the file. How do I get it to save to the file? Bob CAPITAL...
On the data entry form CAPITAL AGREEMENTS CORPORATION Tele 888. 583. 0400 Fax 888. 583. 0401 Nationwide Commercial Financing & Leasing since 1989 ... From:...
Having problems with message search?
Fill out this form to ensure your group is one of the first to be migrated to the new message search system.
