Making 2 colums into one2981 (6/3/2010 9:03:32 PM) AfrosheenI have an excel file that I imported into Access. There are 5 fields.
The item names are in column 1 and column 3. I need to combine the two
columns in to just one column. Can this be done?
Demise of News Group Forum2716 (5/25/2010 12:24:05 PM) UtfAssuming Microsoft are not going to listen to their customers and go ahead
with the demise of this excellent forum, perhaps we could have some
suggestions for alternative (non-microsoft?) sites that are ava...
My database loads but disabled?4678 (6/3/2010 1:18:01 PM) UtfHello
I have a database on Access 2003 - works !
Opended it in 2007 - does not work?
Converted it to 2007 - does not work?
All the forms and tables load okay.
I have a switchboard with command buttons - ...
"Click to add" column in Access 201023086 (5/20/2010 6:34:01 PM) UtfHi,
In Access 2007 you are able to right-click on the "Click to add" column in
Datasheet view of a table and hide it so that it's removed from view. Cannot
find where I can do that in Access 2010... Are w...
Hyperlink datatype41055 (6/1/2010 5:59:01 PM) UtfHello,
I'm not sure if what I'm doing is right because my user keeps getting the
error "Unable to open V:...... .pdf. Cannot open the specified file."
My database is still Access 2003, I haven't upgra...
2 Designers3902 (5/27/2010 9:00:14 PM) UtfAll,
how would you handle having two persons who work on
creating/designing/editing a DB?
FYI I'm not in this situation but just in case.
Thanks2927 (5/30/2010 11:38:46 AM) MikeRThanks to all those who contributed their time and knowledge is such an unselfish
manner. I'm really going to miss my daily read here.
2003 to 20074776 (5/27/2010 11:42:01 PM) UtfMy understanding is that if I upgrade a 2003 format .mdb to 2007 all security
settings will be gone. Can someone elaborate on just what that means? I
presume no login, no workgroup. How about database passw...
Allen Browne's 'Library Resource'81096 (5/28/2010 6:43:01 PM) Utfhello gurus
I have learned a lot by studying the 'Library resource' example on Allen
Browne's web site. This offers a lot of good advice on the organization of
tables for a Library database. Is an actu...
Changing values2816 (5/28/2010 11:43:47 PM) JeffreyI have a many-to-many relationship between Outings (with a primary key
of EventID) and Members (with a primary key of MemberID). There is a
table that ties the 2 together, tblAttendees that holds the EventID
change cell color0974 (5/28/2010 11:22:01 PM) UtfI have made a drop down box, but now want to make when I select a specific
word it will change back ground color in whole row. Say I pick UT for Utah in
my drop down box I want the row to change background ...
Need help with table set-up and Thanks!4761 (5/27/2010 9:28:26 PM) UtfI’m about to finish my first database and am in the planning stages to create
another. I want to express my gratitude to all that helped me with this. I
learned more with the help of this group in three m...
Populate a new field in an existing table32707 (5/27/2010 8:59:37 PM) UtfHi all
I have an existing Access table, containing 10,000+ rows called "Printing"
and I have decided to insert a new column called "Financial Year". However,
I am struggling of finding a...
Upgrading an .mdw to 2003 format?2923 (5/27/2010 11:38:01 PM) UtfI have upgraded my frontend & backend .mdb from 2000 to 2003. Do I also
upgrade the .mdw in the same way?
Thanks so much.
Export Table Records to txt file01003 (5/28/2010 8:29:31 AM) KHi all, I have Table "T_Data" in my database. In "T_Data" I have
220000 records. I need to export them into txt files. I need some
kind of macro which should export chunk of 60000 records into one txt
Employee Training Help3757 (5/27/2010 9:30:22 PM) UtfHey Y'all,
I am creating an employee training database where I can run reports and
queries about who has taken what type of course.
What kind of relationship should be created between the tables? Based ...
Auto Increment by 1 Letter81585 (5/27/2010 9:01:33 PM) UtfSimple question, hope I can get an answer....
Ok, I have created a table and form for our company to keep track of incoming
inventory. Being that we work with metals, each piece that comes in is
Accessing Database design mode5777 (5/21/2010 9:40:01 PM) UtfThere is an DB that was create well before my time at my job and I have very
little experience with Access and need some help here.
Access 2003, XP SP3.
The first issue:
I need to get into the For...
How to add record in Subform which is in another Subform1840 (5/25/2010 2:41:59 PM) KHi all, I have Subform "SubA" on another Subform "SubB". And "SubB"
is on Form called "Main". On "SubB" I have button called "Add New
Record" and I got macro (see below) on this button's click event.