|
Creating a new form for existing table & update ext. tab w/ new fi
I am not a big Access user. Nor do I have experience with discussion groups.
I apologize in advance if I break any discussion group rules.
I have created a new form. I would like to update an existing table with
new fields and make some changes to existing fields and then associate the
updated table with the new form.
At the moment, 98% of the fields display "#Name?". I assumed th...
|
2 |
07.08.2006 15:59:25 |
|
|
problems
I'm trying to make a invoice using access. I am making a invoice for a
fishing lodge. What my invoices include is name, address, phone number what
lodge they will stay in, date of arrival, date of departure, price per
person, and total price per group. I would like to be able to look up a
person by there name for furture bookings. Can this be done? I'm not sure
how to do this and is ...
|
3 |
07.08.2006 14:58:25 |
|
|
messenger closes when i try to go to chat
name is wrong on messinger, and messinger closes when i try to go to chat...
|
2 |
07.08.2006 11:23:58 |
|
|
extract
How can I extract the 1st 4 digits from a string,
eg 20040506,
So i'm left with 2004.
Thanks
David...
|
2 |
07.08.2006 10:30:21 |
|
|
Birthday sort criteria
I have used advice from previous threads to produce a birthday table
listed on day and month numbers.
I am now attempting to add criteria to a query to give me the next 14
days records only.
This:
>(Format(Date(),"mmdd"))
gives me everything after yesterday.
But this:
>(Format(Date(),"mmdd")) And <(Format(Date(),"mmdd")+14)
does not give me 14 days.
What have I ...
|
3 |
07.08.2006 09:51:59 |
|
|
Access VBA Books
Hi
Can anyone recommend an Access VBA book, I'm not a true beginner, but not an
Intermediate either?
--
Kind Regards
Ricky
(Access 2003)
...
|
5 |
07.08.2006 08:32:21 |
|
|
can we create and insert reference from endnote library
...
|
2 |
07.08.2006 05:13:14 |
|
|
query blank fiels and creat two tables
I need to query a table with three columns, Authors, Songs and location;
In the Author Field, it has many Author names and with 1.. to many empty data
or nulls in the authors field [authors] too.
Need to know how to creat two relational tables, one authors and one songs
with my data. Can some one show me how ?
Email me at doug@handiangler.com
Thank U...
example of table;
Author ...
|
2 |
06.08.2006 21:45:18 |
|
|
Searching for paper files
I thought it would be simple to make a table of all our paper files in
our office, then set up a switchboard that would allow someone to
login, then search by a keyword to find a file and Voila! all the info
on where to find it etc.... would pop up. In theory it sounded simple,
but somehow I can't seem to be able to do this (probably because I
always hated Algebra :-).
Can someone tell me ...
|
4 |
06.08.2006 19:13:34 |
|
|
How do I match two large files to find matching telephone numbers
We are a call center that receives very large lists of business telephone
numbers. The lists are scrubbed by the company we work with, they then send
back a text file with just the telephone numbers and many records missing and
others with approval to call them. We need to find a way to match the
scrubbed list to the master list.
Any suggestions?...
|
3 |
06.08.2006 16:03:48 |
|
|
date format
im sorry for my ignorance but i need help with i suppose a quite simple
problem.
i got two imported text fields.
These two text fields got date informtion presented in yyyymmdd ie 20060802
(the shortdate in my zone is yyyy-mm-dd)
I understand i need to change the format to Date/Time before calculating the
datediff. I cant use the shortdate and therefore been trying to use the
forma...
|
3 |
06.08.2006 09:11:01 |
|
|
Changing title of form, report, table etc
--------------------------------------------------------------------------------
Hi,
I am using office 2003 pro. I have an Access database that I would like to
change the title of. I would ilke this change to be applied to forms, reports
and tables. I have done this in the past but can't recall how to do it. By
title I mean the text that appears in the blue bar at the top of each windo...
|
2 |
06.08.2006 06:12:48 |
|
|
Format date as "d mmm"
I have a birthday list which I need to publish without the birth year
displayed.
How do I show 1st Jan 1970 as 1st Jan?
Thanks,
Robin Chapple...
|
13 |
06.08.2006 03:31:20 |
|
|
Opening files is very slow. Anyone know thw solution?
I just installed Access 2003 as an upgrade from access XP. Now, in all office
programs, files and folders open very slowly (15 to 40 secs.) Anyone know of
any solutions?...
|
3 |
05.08.2006 02:23:55 |
|
|
Connecting to external database provider
I am trying to connect to a KB_SQL database provider, and I can connect
fine, and can get a connection to the server. I am using ADO to do all
of my connection is VBA. Once i connect to the server, I am able to
use the "Connection".openschema method just fine to retrive any
information concerning a dataset, but as soon as I try and use an open
method to open a record set, I do not get any re...
|
1 |
05.08.2006 00:01:23 |
|
|
access database with Raw Material and Finished Goods
we need a database that has raw material as well a finished goods. and the
raw material needs to be relationed to the finished goods....
|
2 |
04.08.2006 23:25:31 |
|
|
Relationships
If the foreign key is just a link to the other table how do I get the Data
transfered there without retyping all of it?...
|
3 |
04.08.2006 19:29:29 |
|
|
Relationships between two tables
I have two tables created and I have a one to many relationship on them. The
table I am using in my report has two foreing keys to draw information from
two places in the other table. Why is it that when I view the report it just
shows the autonuumber i used to call it with? What do I need to do to get the
information in the report instead of the number used to import the
information.
E...
|
2 |
04.08.2006 17:53:15 |
|
|
finding same fields in access tables
Ok, a request, plain english replies with a minium of code, thank you.
Now, I have a linked mdb to a SQL server application which has around 150
tables.
I need to find out which tables contain a particular field, in this case
'Custodian'.
Once that's done I then need to edit some data so all records in that field
are the same.
Now, from basics, Do a use a query or a form?
O...
|
4 |
04.08.2006 15:39:03 |
|
|
hot key
i think i'd like to use a hot key combo to invoke an error reporting tool.
when the hot key is pressed i'd like a form to open that would automatically
recieve a value from the form that was currently open and in focus.
i just need a tip how to use a hot key combo, open a form, then grab the
value i need.
tia,
mcnewsxp
...
|
3 |
04.08.2006 15:09:59 |
|
|
no prompt for object members in code
Just opened an access db (Access 2003) that I have been working on for
some time. when I am in a code window and declaring objects, for
instance Dim db as DAO.Database, it no longer prompts me for the member
that follows the full stop. Previously, if I entered DAO., a list
appeared to show me what objects belonged to DAO. Its not doing that
any more.
Im sure its a quick fix option somew...
|
4 |
04.08.2006 05:01:48 |
|
|
Access97 Run-Time .mde Application
Hi everyone,
I have made a aplication in Access 2003. I know when I buy Access Developer
Extension 2003 I can make .mde run-time aplication and distribute it to my
Customer. This Application can work without Access 2003.
But I do not know if I can make with Access Extension 2003 .mde Application
ver. Acess97. Application from Access 2003 I can convert to .mde file ver.
A97. Can Access Dev...
|
6 |
03.08.2006 21:03:26 |
|
|
memo field
I thought I posted this, but can't find my posting so please forgive if this
is a duplicate. I have a field that I need to change from text to memo to
allow additional characters. I have gone in under table design and changed
it to memo, but it will still halt the characters at 255. What am I doing
wrong?...
|
4 |
03.08.2006 19:53:01 |
|
|
Toolbar troubleshooting in Access 2003
How can I unshade a toolbar so I want to be able to use the buttons?...
|
2 |
03.08.2006 18:18:14 |
|
|
Using the "Switch Function"
I am trying to use the switch function to recognize a value in one
field,(USER ID), and based upon that value change the value in another feild,
(text box 43). The user id feild is a drop down type feild and the switch
function does not seem to recognize the values in the drop down field. I get
an error that says (Name?) in text box 43 field.
Is there a way to get that function to r...
|
3 |
03.08.2006 17:35:34 |