|
Position Announcement, FT Permanent
The University of Tennessee is searching for a person with solid VBA
experience in Access or whose programming background will enable them to
come up to speed quickly. This is a pemanent, full-time position with
generous benefits. The link appears below.
I am retiring from this position in February, and I will not answer
questions about the job. Those should be directed to the chair ...
|
1 |
15.08.2006 18:51:25 |
|
|
datatype conversion
Q - How do I convert a datatype text field (yyyyddmm) into a different table
under a date data type?
Story
I am receiving a large text document that has the date format as yyyyddmm.
I import all the data from the text file int a table and then I run a query
to only take the relavant information and put it into a table that makes
sense. The date currently goes into a table with the datatyp...
|
2 |
15.08.2006 14:33:00 |
|
|
Is there any way to make Access only save at the user's command?
We use a very simple Access spreadsheet for our database - no forms. We don't
use any VBA (and I don't know how any of it works), so I'm basically using
Access as a labelled and linked version of Excel spreadsheets. As such,
everyone who works with this database isn't used to using a program that
saves automatically without the user's request. For instance, I've designed a
query, then re...
|
12 |
15.08.2006 14:21:01 |
|
|
test 3
...
|
1 |
15.08.2006 13:29:59 |
|
|
testing send
My last msg didn't send. testing settings sorry.
...
|
1 |
15.08.2006 13:26:16 |
|
|
Re: date format
testing outlookexpress.
"Chris" <chris@abc.com> wrote in message news:...
>Q - How do I convert a datatype text field (yyyyddmm) into a different
>table under a date data type?
>
> Story
> I am receiving a large text document that has the date format as yyyyddmm.
> I import all the data from the text file int a table and then I run a
> query to only take the...
|
1 |
15.08.2006 13:23:21 |
|
|
what if i lost my activation code
what if i lost my activation code...
|
3 |
15.08.2006 12:52:41 |
|
|
Publisher/Word/Access
I'm such a neophyte! I've looked through the Access Discussion groups, but
can't find a situation quite like ours.
We print all our letterhead from a Publisher file. When we book a tour, the
name, address, date and time of scheduled tour, etc., is entered into Access.
We then print a Word form letter on our letterhead. Is there any way to
streamline this three-part process?
I ...
|
2 |
15.08.2006 08:55:02 |
|
|
Closing and Restarting my Access Application
Is there a way I can use a command button to close my application and restart
it without using a menu bar?
--
Thanx!...
|
2 |
15.08.2006 04:37:05 |
|
|
The Autonumber is missing when I update the forms
My order number 38 showing on the database is autonumber. When I input some
data onto two forms for this order and saved them, there was a warning saying
some data will be lost. I thought I could update it again. However the form
with this order number 38 was disappeared. Now after 37, there's only 39.
When I looked the table of order details, the 38 records are still in there.
Question:...
|
2 |
15.08.2006 04:36:36 |
|
|
Forms and option boxes information
I apologise for my lack of Access knowledge but this is my first attempt at
setting up a database.
I have designed a form to make it easier to put information into my main
table but when i use the option box in my form the information that is
transferred into the table it appears as a number.
How can I get the information in the main table to show the selected option
as a word?
--
T...
|
9 |
14.08.2006 20:29:00 |
|
|
date format
Q - How do I convert a datatype text field (yyyyddmm) into a different table
under a date data type?
Story
I am receiving a large text document that has the date format as yyyyddmm.
I import all the data from the text file int a table and then I run a query
to only take the relavant information and put it into a table that makes
sense. The date currently goes into a table with the dat...
|
3 |
14.08.2006 18:35:47 |
|
|
Pulling Back Data
Hi,
This is probably really obvious, but not to me.
I have been sent a text file that has two columns. I created a table using
this information. One column has a company number and the second has a
product number. The problem is that there can be several products for one
company and each is attached to the company number. Like so:
Co. Product
19 2200
19 1400
19 ...
|
2 |
14.08.2006 18:25:01 |
|
|
Database Confusion
I am fairly new to Access and am working on a project for work. I know how to
get around in access but when I try to build the database I get all confused.
I have about 80 - 100 employees I would like to track labor hours for.
Currently I have a excel Spred sheet that gets filled out every day and
saved. Of course now I have tons of these files saved. I want to make an
Access database for...
|
13 |
14.08.2006 17:41:02 |
|
|
Not In List Event
Greetings from the backpackers hostel in Panama.
I have gotten for the most part my forms and tables OK, and now I am just
suffering with unnecessary repetition of data entry which will be the subject
of further posts, I am sure.
For now, can someone walk me through in a detailed fashion, how to do a "not
in list" event so I can simply enter a new guest name, and if it does not
appea...
|
10 |
14.08.2006 16:26:02 |
|
|
Where to locate front end / backup question
I've been reading various posts regarding front ends and back ends. I've
created various (very simple!) single-user databases in the past so this has
never been an issue. However, I'm now creating one for a team of 3 people who
may all need to access it at the same time. I understand the principles and
necessity of splitting, but don't know if I should put front-end copies on
their c:d...
|
3 |
14.08.2006 15:59:02 |
|
|
password protect
i need a suggestion on how to best setup a password.
i will have a dialog that asked how the main form is to be viewed.
a password will be required if the user wants to access the main form
in using an admin role.
if the password is valid all fields on the main form will be unlocked
and editable.
otherwise they won't get passed the login form unless they accept a
lesser role.
so the ques...
|
14 |
14.08.2006 15:23:40 |
|
|
Primary Key Textbox Linking to Subforms
I have an issue that I can't quite figure out. I have built a database that
will be used to store equipment information. The main form/table contains
general information about the equipment. I have set the primary key as a
specifically assigned "Equipment Number". I have a subform/table that will
contain motor information for each particular "Equipment Number". Since each
"Equipment Numb...
|
3 |
14.08.2006 14:32:32 |
|
|
Number of Registered Copies Needed?
I am setting up a database that will be eventually used on a LAN, for now
it's used on a single PC that has a registered copy of Access. Do I need to
buy a copy of Access for each pc in order to make it work, or do I need to
register multiple users. If someone could clarify what I need to have to be
set up correctly I'd appreciate it. Thanks....
|
4 |
14.08.2006 05:34:01 |
|
|
How do I eliminate two incorrect servers in Network Passport?
Keep getting Network Passport dropdown telling me to enter password. They
keep listing incorrect servers. Cannot delete incorrect servers. How can I
correct this problem?...
|
2 |
13.08.2006 22:49:23 |
|
|
Date Entry from Calander Control
If I add an activeX Calander to my form, How do you link it so the Date field
gets filled if they click the calander control for the given date?
Also if I was using the calander control to be part of a Control Panel and
select a date on the calander for the form to look up the data for that date?
any help?...
|
2 |
13.08.2006 20:03:33 |
|
|
Many to many? not sure
I am creating a database and I am totally stuck.
I have a table that has a lot of information in it.
Profile, Screen, Description
There are several profiles that use the same screen and Description.
How would I pull that into a query?
I have 10 Profile Names. Not all employees have those profiles. At most they
will only have 4 profiles.
I want a query that will say Employee Pro...
|
2 |
13.08.2006 07:55:21 |
|
|
How to get a combo box to display a different value
Here's an "easy" question, I'm sure. How do I get a combo box to display a
different value than the field it is bound to?
Thanks
T
...
|
8 |
12.08.2006 22:56:26 |
|
|
Trim function
Is there a way to use VBA to trim and entire record?
I have a table that has 37 columns, each column need to be "trim"
I know that I can create a update query, but I would be really handy if VBA
can be use it.
Regards,
Bre-x
...
|
10 |
12.08.2006 18:06:22 |
|
|
Control Button to Print Forms in Word Mailmerge
I have an Access form linked to the Word Mailmerge to multiple documents.
How do I create an Access control button for printing multiple Word Mailmerge
documents? Can I also have it print 2 of each and/or reprint specific
documents?
Thanks
...
|
1 |
12.08.2006 15:40:02 |