Jump to content

Welcome to Geeks to Go - Register now for FREE

Geeks To Go is a helpful hub, where thousands of volunteer geeks quickly serve friendly answers and support. Check out the forums and get free advice from the experts. Register now to gain access to all of our features, it's FREE and only takes one minute. Once registered and logged in, you will be able to create topics, post replies to existing threads, give reputation to your fellow members, get your own private messenger, post status updates, manage your profile and so much more.

Create Account How it Works

access 2003

  • Please log in to reply



    Je suis Napoléon!

  • Administrator
  • 26,018 posts
  • MVP
i've created a form in access to allow my shipping dept. to print to a large printek printer that we have for shippers so that all the data would come out in the right places the form is actually in no way linked to a database because i don't need it to be (plus..if they press print when it's actually linked to a DB it prints the whole DB) i've got two questions here...

#1 how do i have a field in the form (it's just a text box) have an autogenerated number without having it linked to a db

#2 is there any way to get the form out of access so that they don't have to go all the way into the db to open it?
  • 0





  • Member
  • PipPip
  • 98 posts
Your opening statement seems contradictory as to whether the form is currently linked to the DB.
I'm assuming it is because you say the whole database prints out when they press print.

To avoid printing the whole database and only print the current record on the form, you could filter on the current record

If you want an auto number, by design it would need to linked to a table.

If you don't want the form linked to a data source and don't want to open the database to access the form you can publish the form to MS Word
  • 0

Similar Topics

0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users

As Featured On:

Microsoft Yahoo BBC MSN PC Magazine Washington Post HP