MS Access Help ??? - DFWstangs Forums
 
LinkBack Thread Tools Display Modes
post #1 of 4 (permalink) Old 03-31-2004, 01:51 PM Thread Starter
 
Join Date: Nov 2002
Posts: 5,831
MS Access Help ???

I have a database that I created yesterday and started working on. I have 4 tables... blah blah blah

anyways... I decided the autonumber was not going to work for my primary key, so I switched it to a field I have labeled as JobNumber... the problem is I wanted everything sorted by the order that I put it in (i.e. the auto number) but isnce the switch on the PKey... now im stuck with it defaulting to sorting by the jobnumber field...

is there anyway to change that behavior?? I've looked and searched, All is to sort it by that? any ideas?

thanks
trey
trey85stang is offline  
Sponsored Links
Advertisement
 
post #2 of 4 (permalink) Old 03-31-2004, 02:31 PM
Texas Rangers #1
 
Kenny_Stang's Avatar
 
Join Date: May 2000
Location: Funky Town
Posts: 10,592
Give me a call and I'll transfer you to PC Helps... I'm sure they could hook you up.

817-615-2610
Kenny_Stang is offline  
post #3 of 4 (permalink) Old 03-31-2004, 02:47 PM Thread Starter
 
Join Date: Nov 2002
Posts: 5,831
Quote:
Originally posted by Kenny_Stang
Give me a call and I'll transfer you to PC Helps... I'm sure they could hook you up.

817-615-2610
Sweet deal kenny!.. although I just figured it out, I'm useing a form.. So I added the autoid id field to the form and saved the form to sort by this field.. then I hid the field.. worked perfectly!

Ill keep you number handy!

thanks
trey
trey85stang is offline  
 
post #4 of 4 (permalink) Old 03-31-2004, 03:00 PM
Texas Rangers #1
 
Kenny_Stang's Avatar
 
Join Date: May 2000
Location: Funky Town
Posts: 10,592
Quote:
Originally posted by trey85stang
Sweet deal kenny!.. although I just figured it out, I'm useing a form.. So I added the autoid id field to the form and saved the form to sort by this field.. then I hid the field.. worked perfectly!

Ill keep you number handy!

thanks
trey
I'll be glad to help anytime.
Kenny_Stang is offline  
Sponsored Links
Advertisement
 
Reply

Bookmarks

Quick Reply
Message:
Options

Register Now



In order to be able to post messages on the DFWstangs Forums forums, you must first register.
Please enter your desired user name, your email address and other required details in the form below.

User Name:
Password
Please enter a password for your user account. Note that passwords are case-sensitive.

Password:


Confirm Password:
Email Address
Please enter a valid email address for yourself.

Email Address:
OR

Log-in










Thread Tools
Show Printable Version Show Printable Version
Email this Page Email this Page
Display Modes
Linear Mode Linear Mode



Posting Rules  
You may post new threads
You may post replies
You may not post attachments
You may not edit your posts

BB code is On
Smilies are On
[IMG] code is On
HTML code is On
Trackbacks are On
Pingbacks are On
Refbacks are On

 
For the best viewing experience please update your browser to Google Chrome