Anybody here good at 2007 MS Access?

[turbo_ls1_ss]

ya i figured that one out… but thanks man… when i need the relationships made (properly), and forms and whatnot, i might need some assistance by one of you more experienced fellas

[Jack]

@duck

part of my job is building access databases to be used nationwide.
It is on the share drive and yes, dozens of people go in at the same time and update it without problems.

as far as the original post. a mail merge is for exporting a table into forms, letters, or envelopes.
If you want to import your excel table into access, then go to the table section of access. right click. choose Import. change file type to Excel. bam.

No duck, you’re wrong. boxxa has 3 years of schooling on Access and it has no place in a professional environment.

@boardjnky4

lol @ people still coding in VB

… or maintaining code.

You don’t have to write an app from scratch all the time, ya know?

Also… not everyone needs to use VB.net… especially if the application is simple and is meant to stay that way. All the code would transfer over anyway (I believe).

[boardjnky4]

@Jack

… or maintaining code.

You don’t have to write an app from scratch all the time, ya know?

stop making sense

making fun of people is way funner

[Jack]

I just finished a couple thousand lines of code. it was so easy… and pretty… and did stupid tedious stuff.

[duck]

@Jack

No duck, you’re wrong. boxxa has 3 years of schooling on Access and it has no place in a professional environment.

no argument there! Access has no place as a database that needs to be used on a medium to large scale.
I just make the best with the tools we are given. I’ve been trying to get a SQL server for years. We finally had a guy with a server and developer we could use. then he quit and now we’re stuck with Access. yay red tape.

I feel like I’m pulling rabbits out of a hat doing VBA and Access for this stuff, but I’m using every trick I can think of to keep it running with all of the features we need.

[Jack]

@duck

no argument there! Access has no place as a database that needs to be used on a medium to large scale.

I have anywhere from 20-150 people in these apps at a time. Thats not a large scale, but it isn’t an office with 8 people in it either.

Its just so quick.

[boxxa]

@Jack

Its just so quick.

The IT statment of the year.

Quick does not always mean right.

If you want someone in a small business to have a small database on their computer to keep track of info, fine. Access it is but if you are still using Access to build databases for medium to large comsumers, you really need to learn SQL. MySQL, Oracle, MSSQL, etc.

[boardjnky4]

If it is an application, Oracle is usually (but not always) the database of choice. If it is a web development project, MySQL is usually (but not always) the database of choice.

[Jack]

Our shop doesn’t use Oracle.

.NET, VB,SQL, Sybase, IQ… etc. Hell, we still have Foxpro apps running.

Access is one of those apps everyone has Access to. Licenses for this crap isn’t free…

[turbo_ls1_ss]

thanks guys…

next question is… how do i make a link between tables in the same file, so every time i update 1 (or the corresponding other) field, it does so respectively in the other. also, is there a way to do this between an access and excel table?

thanks

[duck]

@turbo ls1 ss

thanks guys…

next question is… how do i make a link between tables in the same file, so every time i update 1 (or the corresponding other) field, it does so respectively in the other. also, is there a way to do this between an access and excel table?

thanks

this is access 101

Tools>Relationships
drag table 1 field to table 2 field. Change joins if necessary
and/or do this in each query

I’m sure you have primary keys set up in the tables…
If you have keys, then you wouldn’t be duplicating fields across 2 tables, so there would be no need to update the same data across another table.

You can import excel tables, but I’m not so sure you can link an excel table in realtime. And you certainly can’t input data back into the excel table.