CDIH
Help!!!  with ms access - How do you work this fucking program???? - Printable Version

+- CDIH (https://www.cdih.net/cdih)
+-- Forum: Techie Geek Forums (https://www.cdih.net/cdih/forumdisplay.php?fid=5)
+--- Forum: Über Geek Zone (https://www.cdih.net/cdih/forumdisplay.php?fid=13)
+--- Thread: Help!!!  with ms access - How do you work this fucking program???? (/showthread.php?tid=396)



- Spitfire - 02-11-2002

::gasp:: This is a work-related issue..yeah, I'm being a slacker poser :p

But anyway, I have 2 different lists with editor contact information and I must pick and choose 300 out of these tables. Is there an easy way to do this besides cut & paste method? How do I pick names without fucking up the original tables? I really fucking hate this program!!!!!!

(but did I mention how much I :loveya: geeks Angel )


- NaughtyAngel - 02-11-2002

ill get back to you shortly, i took two classes on this i just need to refresh my memory


- Maynard - 02-11-2002

Turn on your IM.


- Metalfan - 02-11-2002

OK sweetie, for starters, go to the help screen and type in "creating a new table from data in an existing table or tables" this should lead you to a help screen...surprisingly, MS Access help screens are pretty good. The upshod is that you'll either have to do a "make-table" query to create a table, or go through the query wizard to connect the tables. Wish I could be more specific than that, but without the data you're working with...best I can do.

Or, you could send it to me and let me do it for ya ;-)
:bouncer:


- Keyser Soze - 02-11-2002

Run a query.


- NaughtyAngel - 02-11-2002

i hope i helped a little even though i was a little late, query is the way to go

Open a query in Design view
In the Database window, click Queries under Objects.


Click the query you want to open, and then click Design on the Database window toolbar.
Notes

If a form, report, or data access page is based on a query, you can open the query to modify its design directly from the form, report, or data access page. For more information, click .


If you previously saved a query while it was displayed in SQL view, that's the view Microsoft Access displays the next time you click Design on the Database window toolbar for that query.



Edited By NaughtyAngel on Feb. 11 2002 at 2:14


- Keyser Soze - 02-11-2002

The only problem is that there doesnt seem to be a rhyme or reason to which names you are choosing. Hopefully I am wrong. A query will simply return records that match a certain requirement. So all the records you want to create a new table with will need to share a common characteristic. Hope that helps.


- Spitfire - 02-11-2002

Thanks guys!!! I think I got it. I'm working with 2 separate Access databases...the last time I ran a query, when I deleted records, it deleted them from the original table.

Can I make a query from the 2 databases? There's no specific requirement I'm looking for in choosing which "database objects" I want.


- Keyser Soze - 02-11-2002

Combine the 2 databases and create one new database to run your query from.


- Metalfan - 02-11-2002

Spitfire Wrote:Can I make a query from the 2 databases?
Yes!


- Spitfire - 02-11-2002

How? I linked them, now what? Rolleyes

why the fuck can't we just get Filemaker pro arghhh!!!!


- Sephiroth - 02-11-2002

My BLT has gone AWOL.


- Maynard - 02-11-2002

:bouncer: I win!!!11! :bouncer:
:bouncer: :bouncer: :bouncer:


- Grumpy - 02-12-2002

Spit - IM me. I'll walk you through linking two databases and pulling the 300 records. It's not that difficult. You just need patience and some logic.

BTW - what version of MS Access are you using? 97 or 2000?


- Keyser Soze - 02-12-2002

Sephiroth Wrote:My BLT has gone AWOL.
IM me and i'll walk you through it.