Use relationship or not?
Tue, 23 Dec 2008 07:38:41 -0800
I have a very large main table (over 100 fields) that I can easily make into
other "main topic" tables ... that is I can make it into 3 instead of having
just the one. There would only be a 1-1 relationship. Is there ever the
time when this is ok to use?
I've never had a table this big before and it is ki ...
|
Changing MainID Autonumber into auto added number YY0000, incl. ye
Mon, 22 Dec 2008 23:21:00 -0800
I am running into the dilema not beeing able to use my current autonumber as
my mainID, primary key....
I need to use a six digit number which has to inlcude the last two digits of
the current year the record is added, 090001, 090002â?¦.
The dBase already contains 10,000+ records in a dz tbl's and need to keep ...
|
Insert Into?? Add record to an unbound table??
Mon, 22 Dec 2008 14:18:03 -0800
I'm not sure how to do this. I'm using Access03; I have a workorders form and
then a workorder parts subform. The subform is bound to the workorder parts
table.
I also have a table called "InventoryTransactions." This is from one of the
MS example templates. If a user creates a PO, the quantity ordered and ...
|
Filtering using a button
Mon, 22 Dec 2008 12:51:00 -0800
I have a continuous form with a button on it. What Iâ??m trying to do is when
the button is clicked open the record of the button that was clicked. Iâ??ve
been playing, but the more I play the worse it gets. Would someone point me
in the right direction?
--
NotGood@All ...
|
Constant expressions error
Mon, 22 Dec 2008 07:28:01 -0800
I'm sure I'm missing something simple in this, but needs some help.
I have a form with 3 drop-down combo-boxes, which a subform is populated
with a list of questions (which has another subform which will populate the
answer, but not got that far yet) from the selections made from the
drop-downs.
I had a ...
|
Automating Importing files?
Mon, 22 Dec 2008 07:08:03 -0800
Is there a way, maybe using vba code, to pull in the saved imports from a
table creation? I create a table and save the import steps and then need to
reimport this file later in a macro. I need to do this with about 90 tables,
so I want to automate it. Any suggestions on how? We don't run Outlook at
this po ...
|
form not opening
Mon, 22 Dec 2008 07:07:02 -0800
hi,
i have a form that took me 2 days to design and code. then this morning
when my supervisor logged (the database is on my desktop. i am hoping this
is coincidence rather than trying to sabotage) in i noticed that i got an
error message after I added an IIf statement to one of the fields... the
error ...
|
|
|
Automating a rename of a table?
Mon, 22 Dec 2008 06:27:01 -0800
Need a methodology for automating (either in VBA code or inside a macro)
renaming a data source (the problem here is that when you import a filename
with the same name as an existing data source, the imported filename gets
subscripted with a 1 - in order for the queries to run properly, we have to
rename the ...
|
OpenForm action cancelled error using Vista
Mon, 22 Dec 2008 06:10:15 -0800
I have an 2003 access database that works fine on Windows XP, but errors out
on the docmd.openform line of code (OpenForm action was cancelled) after
upgrading to Vista. Strangely enough, this is only a problem for one form, so
far. All the other forms that have identical code work fine. Basically, I
have th ...
|
Download File, Copy Text To Clipboard
Sun, 21 Dec 2008 19:41:01 -0800
A Web site has 1,000 hyperlinks, each pointing to a different text file with
a .abc extension. I have loaded the document names into an Access table,
intending to write a program to download the files. To that end, I have set a
reference to the Microsoft HTML Object Library, so I can create and control
an in ...
|
