|
Re:Date field - solutions, ideas
Hi Rick,
Very quick response.
Unfortunately "date" data format is of no use for genealogists, because it
doesn't like dates such as "23 Jan 1711/2", and some even get muddled up
with older years such as 1798 or 1898, whilst being quite happy with 2007.
Will that still work on dates pre 1900?
Any suggestions?
Regards
Jeff
...
|
2 |
5/26/2007 6:00:44 PM |
|
|
Access Runtime
I have installed Access 97 Runtime on a PC that has open office. It imports
the dbase III files fine. Yet a PC with a later versoin of Office (Outlook,
Word and Excel) generates an error when importing from a dbase III file.
...
|
1 |
5/26/2007 2:23:50 AM |
|
|
Sum by day
Hey Guys,
How do I sum by day? I have the following fieds in my query.
Account Name
Shares/Contract
Commission Amount
Settlment Date
I'm trying to create a report, out of this, that says....
"Show me the the sums of the Shares/Contracts & Commission amount of each
individual account name between a defined Settlement Date."
Any help?
...
|
6 |
5/25/2007 7:03:00 PM |
|
|
Append query help
Hi,
I have 2 tables, let's say A and B. Both tables are basically the
same with a few differences. Table A has records from 1/1/04 to
8/13/06, the date/time field is one field with date/time format, about
10 other fields are in text format but need to be changed to number
format. All other fields are exactly the same and don't need to be
changed. Table B has records from 8/13/06 - 12/31/...
|
9 |
5/25/2007 4:06:09 PM |
|
|
Invalid Syntax
Hello again...
This is my third question in 2 days and I've not gotten a response to them,
so what'll I do? I'll just keep on trying! Really want to learn this system!
I'm trying to finish a report that I've worked so hard on. I have a field
called "Execution" within my report that is only calculated when the
"Blotter" field shows with 16 or 66. Here's the problem. I do not have t...
|
16 |
5/25/2007 3:34:00 PM |
|
|
Updating Table from Query - HELP !!!!!!!!!!!!!!
How do I go about updating a new value in a table using a query
I want to update the table - and not the Form.
I have 2 tables
1. CLIENT - Field : ClientID < Autonumber>
(Other field are not important )
2. INFORMAL - Field : ID <Autonumber>
Field : REFNO <Number>
This is...
|
3 |
5/25/2007 2:24:16 PM |
|
|
How to use 2 separate qrys in 1 form?
I'm still stuck on a problem posted earlier. I have an inventory db: tracks
in-stock materials, outstanding orders. All lab staff can order items using
corp. custom software but often confusing as orders are received. Creating
an inventory (vs. updating a running calc.) as no in-stock inventory stats
currently exist.
Product + Order tables related by autonum field 'Itemnum'. I need...
|
2 |
5/25/2007 1:28:01 PM |
|
|
Required information in text box VBA
Hello, I have a form that supervisors put information into threw out the
shift on about 7 new records a shift. The reason being they keep track of
diferent things happining to a machine we are running ect. and need to filter
threw the records threw out the shift. My question is that there are some
combo boxes that has to have information in them when the entire database is
closed. I cant...
|
5 |
5/25/2007 12:39:01 PM |
|
|
Search by Defined Month
Hey guys,
How would I search by a defined month. So, for instance, I have trade data
for 12 months. I want to be able to perform a report by month, that shows
only the current month. I know the search that would allow the recipient to
access the date range in which they are looking for. That's not what I'm
looking for. I'm looking for a way to code a report to only pull May's trade...
|
6 |
5/24/2007 6:21:00 PM |
|
|
help with error checking
I am using the code found on mvps.org, "API: Call the standard Windows
File/Save dialog box" in a small program, and am not sure how to implement
error checking in the case that the user clicks CANCEL on the File/Save
dialog box. Doing so in my program gives a run-time error code '2522'.
Following is the module that I initiate from a macro that is invoked when a
button is pushed:
***...
|
4 |
5/24/2007 4:02:06 PM |
|
|
Data Entry
I have two tables; tblEmployees & tblProjects. The primary key for each of
these tables is an autonumber that the user never sees (EmployeeID &
ProjectID). Each project is associated with one employee (he's the
salesman).
So in frmProjects, I have put a combobox that queries the tblEmployees and
lists all of their first names so the user can choose one. I'm confused now
because I...
|
4 |
5/24/2007 2:24:01 PM |
|
|
security in access 2007
Being completely new to access I need some help with the following.
Is it considered good/common practice to purchase third party digital
certificates for security purposes e.g. to get rid of the security message
bar when someone opens up a database ? or do most people get by without this.
The reason i'm asking is that having coughed up a lot of money for access I
wouldn't want to have ...
|
5 |
5/24/2007 1:29:00 PM |
|
|
How to create a small test db from a huge db.
I have a db that in total has 35million records. However, these have been
broken down into 5 different files. This still makes it very difficult for me
to make any progress on working with them.
I want to create a new, smaller db and fill it with a random selection of
records from one of the 5 huge db's first. Then crerate the Quries and Forms
that I can then run on the bigger ones.
...
|
2 |
5/24/2007 12:29:36 PM |
|
|
Can I list from 2 tables or qrys in 1 form?
I'm Working on a ~ simple database to track in-stock inventory, orders placed
+ ordered items received. The P.O.# on the boxes (generated with orders from
corp. ordering software) helps but with everyone in the lab placing orders,
still confusing as the boxes are received. We also get caught with no
stock, prompting panic orders.
Thanks Allen, Steve for help but still a bit stuck. I c...
|
5 |
5/24/2007 11:43:40 AM |
|
|
Access Runtime dBase III driver
I have created a Access 97 Run-time installation. However, the Run-time
installation will not import from dBase III files. I can on my full version.
How do I install this function without installing the full version of
Access?
Thanks,
J.
...
|
1 |
5/24/2007 8:03:38 AM |
|
|
Autonumber stopped incrementing to next highest number
I have been having this strange occurence on one of my relationship table -
not frequently but 2 times is enough for me.
Apparently the Autonumber seems to stop incrementing to the next available
highest number and begin to give a number
that's already in existence . That of course will give the error on "Unique
identifier - blah blah blah"
To temporary correct this problem I have bee...
|
12 |
5/24/2007 7:00:01 AM |
|
|
Sick app or sick environments?
I have an application which runs on 5 different computers. It's been
running OK for a couple of years. But this week, after making some
relatively minor changes, it began to behave "irrationally" on three of the
computers. These computers are the least powerful of the 5. Here are some
of the problems. They are happening on a form that hasn't been edited
recently, but which is more ...
|
6 |
5/24/2007 2:04:57 AM |
|
|
Backup Vista
I have 2 internal drive but am unable to use backup on Drive D. Is there a
way to configure the drive to accept system backups? I am using Vista
Ultimate.
...
|
2 |
5/24/2007 1:54:59 AM |
|
|
expressions (i think)
My boss wants me to build a database for people who donate money to us (which
I've never used Access until now). He wants me to set it by months, the
donation, the date the donation was given, nad the total year to date. On the
form we're using, he wants it where after the donation has been put in that
it will add the donation to the year to date and then equal the year to date.
At the o...
|
3 |
5/24/2007 1:53:26 AM |
|
|
Top 3 Records
Hi, Our Table (MAIN) has over 87,000 records. Here is the table structure:
SELECT
MAIN.Index,
MAIN.MTWORO_FINISH,
MAIN.MTWORO_WOPRE,
MAIN.MTWORO_WOSUF,
MAIN.MTWORO_OPER,
MAIN.MTWORO_OPER2,
MAIN.MTWORO_CODE,
MAIN.MTWORO_ACTHRS,
MAIN.MTWORO_ASETHRS,
MAIN.MTWORO_WC,
MAIN.MTWORO_WCDESC,
MAIN.MTWORO_STQTY,
MAIN.MTWORO_SQTY,
MAIN.MTWORO_DESC
FROM MAIN;
I need to query the top 3 Work...
|
7 |
5/24/2007 1:16:40 AM |
|
|
Access 2003 Reference Book?
Hello,
Any suggestions on a reference-style book for Access 2003? I have a few
"how-to" books and they're pretty good, but I think what I need now is a
good "go-look-it-up" book.
I've researched "Access 2003 Bible," "Microsoft Access 2003: The Complete
Reference," and "Alison Balter's Mastering Microsoft Access 2003" at the
online bookstores, but the reviews are more puzzling than r...
|
8 |
5/23/2007 11:37:33 PM |
|
|
how do i set up service call register in access database?
we a manufacture of machine and HI-TECH security equipments. we want to
maintain a service register to main our service calls received from the
customer end. that report should contains the following.
serial no.
date of call received
name of customer
product in used in their end.
installed location
date of installed,
product have warrenty period
nature of problem
soultion for proble...
|
4 |
5/23/2007 10:08:16 PM |
|
|
how do i allow more text to be typed into a text box
i have a access form and i have a text box, when i type in data i reach a
point where i can not enter more data, i want to change a setting to increase
the ammount of data that can be entered....
|
3 |
5/23/2007 8:15:53 PM |
|
|
Run Time Error -'2147352567(80020009)
Good Morning,
I had some issues earlier which were resolved but now I'm running into
another Runtime error stating {Prg Ctrl returned the error: Invalid Property
Value below in brackets:{Me.mainSyncProgressBar = i / rcCountInt * 100}
I am trying to have data sync to produce updated reports.
Dim wrkDefault As Workspace
Set wrkDefault = DBEngine.Workspaces(0)
strSQL = "S...
|
3 |
5/23/2007 6:38:00 PM |
|
|
import spec
Is it possible to import and export from one db to another in Access 2003 PE
SP2 ??
I have a spec in one database, and need it in another - it'd be great if I
didn't have to recreate it.
Thanks.
...
|
3 |
5/23/2007 4:01:34 PM |