Custom DLookup Error Message
Wed, 27 Aug 2008 10:18:01 -0700
I am attempting to use this code to DLookup a field before it is updated.
However, I cannot seem to get my syntax correct around the "[StuID]='" &
Me.StuID &'" area. StuID is set as a number field in tblStudents.
If ((DLookup("[StuID]", "[tblStudents]", "[StuID] ='" & Me.StuID & '")))
Then
MsgBo ...
|
Combo Box Form Query - Erases Existing Fields When Formatted
Wed, 27 Aug 2008 10:05:49 -0700 (PDT)
I have a .mdb table (TreeDatabase2008_Points_sp) Linked in to my
access database.
From that linked table I have created a form (with the form wizard)
that will be used for adding and editing values in the table.
By the way, this table has approximately 15 fields and 18000 records
in each field and i am using Ac ...
|
DLookup Question
Wed, 27 Aug 2008 09:45:01 -0700
I have looked at this until I am cross-eyed. Hopefully, someone will help!
I have a table [StateAbbv] that has State names and the postal abbreviation
[Abbrev]. I have another table that I want to take the State identifier
[Statey] and verify it is correct. So I wrote a DLookup in an IIF statement
like t ...
|
Quitting Microsoft Word
Wed, 27 Aug 2008 09:09:01 -0700
Normally when I quit Microsoft Word, it closes all documents that have been
saved and only alerts me when if these documents have not been saved.
When I try to quit Word now, I have to close each document separately. Is
there someone to close all the documents at once?
Thanks for the help.
--
Tracy ...
|
update field from another table
Wed, 27 Aug 2008 09:01:39 -0700
I have two tables that are nearly identical, table 1 has 2 fields
ISBN10 and ISBN13
table 2 has the same fields, but field ISBN10 in table 1 is empty.
I'd like to update ISBN10 on table 1 but I don't know how to do so. each
ISBN13 is a unique number so between table 1 and 2 there is a way to match
them up ...
|
Populating Records
Wed, 27 Aug 2008 09:02:07 -0700
I have a downloaded excel report for export into access, the County name is
in cell B1 with the list of cities in C5 through C how ever many. Then
another County name appears a few rows after that to start another batch of
cities. Question is, I need the County name to apear next to the city name
automatic ...
|
Database keeps corrupting
Wed, 27 Aug 2008 08:55:00 -0700
I have an Access 2000-2003 database that is continually corrupting. Even if i
make a copy and open the copy on a single machine, just doing a single action
like opening a table or a form can corrupt the database.
I have tried compacting and repairing which doesn't help. The database is
quite a complex one b ...
|
|
|
Tab Control Problem
Wed, 27 Aug 2008 08:45:01 -0700
Hi
Iâ??m having a little trouble. I have the following code on a form and it
worked great until I moved the fields that I am enabling to a tab control
named â??Page1â? now the fields on the form wonâ??t enable. Basically what I need
is the correct syntax to change the â??Me.field name.enabled to point ...
|
Calculated Field
Wed, 27 Aug 2008 11:25:01 -0400
I have a combo box that has a list of years, i.e. 2008, 2009, 2010, etc.
What I would like to do is have the calulated field to display the first day
of the year after the combo box updates.
Is this possible?
Thanks in advance.
...
|
Terminal Server and Access printing or saving files to users drive
Wed, 27 Aug 2008 08:20:01 -0700
Hello All
i have a situation where i need to figure out the best way to handle the
printing of reports from my apps terminal server to the users printer. at
this point we have been using the standard terminal server printing back to
the users printers. the problem is that it seems so inconsistent.
at one ...
|
