|
IF...THEN statement on pop-up form: possible?
On a pop-up form I have a combo box whose choice needs to be compared to the
information in the field of the LAST record in the subform for the CURRENT
record in the main form (make sense?)
Generically, what would my IF...THEN statement look like?
Cheers in advance...
|
8 |
04.09.2006 15:06:01 |
|
|
relationship and a form
hi...i have a problem..if i have build a relationship for different
table,can i view it as a form so that i can see the result for the two
table in one form only...is there any solution for that?can anyone help
me..
...
|
3 |
04.09.2006 07:36:41 |
|
|
OfficeLinks and Ole Automation/exporting reports to word
Hi,
is there a method to export Access reports to a RTF file just bei
calling functions by ole automation.
The DoCmd.TransferText does only work for tables and queries (except I
did something wrong) and using the CommandBars doesn't work because
there is still user interaction required.
Thanks + Regards,
Martin
...
|
3 |
04.09.2006 05:53:23 |
|
|
Errors while installing Packaged application
I used the package wizard to create setup cd for my application with runtime
version. Package wizard worked fine. When I tried to install on an other
computer I received the following error:
Error configuring ODBC DATA SOURCE: MS Access Database, Excel Files, Visual
Fox Pro Database, Visual Fox Pro Tables, DBASE Files, ODBC Error 6: Componet
not found in the registry. Verify that th...
|
1 |
04.09.2006 05:21:02 |
|
|
Auto Save and Close excel spreadsheet
Hi, is there a way to auto save and close an excel spreadsheet if it
has been inactive or has not been keypressed for one hour. Thank you.
...
|
1 |
04.09.2006 01:39:28 |
|
|
Variables from Table
Hi All--
I have a form that pulls from a table. I want to have several system
variables that the user can change such as a desired path, client filter,
name filter, etc.
Basically, I want to take the value in each of these separate fields (values
are stored in the table) and be able to call them from VBA.
Is there a way to do that?
Also I have four linked SQL tables. I setup ...
|
4 |
04.09.2006 00:58:58 |
|
|
Can I do this?
I am wondering how I differentiate between two input boxes in the same event.
I have one input box fire, the user enters the string which populates
correctly into the table the form is using as a source. Then I want another
input box to fire and populate a different field. Is it possible?
Thank you
--
Jeff C
Live Well .. Be Happy In All You Do...
|
3 |
03.09.2006 23:42:02 |
|
|
How do I display MSysObjects?
In Access 2000, I use the MSysObjects table to find, modify and refresh
connections to ODBC tables.
Where is MSysObjects in Access 2007?
--
LLKHOUTX...
|
5 |
03.09.2006 23:29:02 |
|
|
ימי הולדת
have application of Access And users in him 10 workers The application is
built from a chart of workers ( number of worker, there worker, birthdate,
and the start of work in the office And a chart of tasks is compound from
date and automatic hour when open a form of task is new And also
specifications of the task And in the end of the task is this that executed
the task writes his name....
|
1 |
03.09.2006 20:05:01 |
|
|
checking for correct Chr in string
I have a cbo in which are entered surname,prename;Date of birth. It is
important that the comma be a comma, and that the semicolon be a semicolon.
Is there any way that I can analyze the characters entered (as they are typed)
, to insure that they are not, mistakingly, a period (instead of a comma) or
a colon
(instead of a semicolon). Any help would be appreciated.
TIA, Richard
--
Mes...
|
9 |
03.09.2006 17:37:07 |
|
|
Open form based on group
I am wondering if there is a way to make access 2003 open a form based on
what group you are in. I know I can do this per each user, but if there was a
way for access to check which group the user was in that would make it
easier. Example would be if the user is in the admins group then open this
form else open this other form. Thanks for the help.
...
|
2 |
03.09.2006 17:10:54 |
|
|
Programmatically assign a value to a hyperlink field in Access 200
Hi,
I am trying to assign a value to both the visibile value and the address of
a hyperlink field in a table in Access 2003. I am using the fillowing
attributes:
rsappend.link.Caption = rs.Fields("Link")
rsappend.link.HyperlinkAddress = rs.Fields("Link")
rsappend.Update
The rs.fields("link") is a text string pulling its value from another table
according toa certain complicated cr...
|
3 |
03.09.2006 14:49:02 |
|
|
DAO Object Model - Intellisense ?
Hi,
Access 2003, DAO 3.6, ADO 2.8
Intellisense works great all the time for ADO, but not for DAO. e.g.
enumerations like RecordsetType and RecordsetOption enumerations. Unless I go
to Object Browser and search for these, is there anyway to get Intellisense
work here ?
--
Sreedhar...
|
5 |
03.09.2006 12:48:01 |
|
|
Capturing Variables
I am trying to build a simple automated question and answer form. My
questions are in a table and grouped. I am using a query to define each
group that I use as the recordset. My input box captures the answer values
but I am having trouble with two other things:
Most important is capturing the QuestionID (QID) in the answer table along
with the answer.
If possible the other thing ...
|
1 |
03.09.2006 12:34:02 |
|
|
Emailing report data
Hi guys
I am using the Issue database template from Microsoft and are making some
enhancements.
I want to be able to generate an email and have the body of the email
contain the report data.
I can create attachments ok but I really want to be able to "merge" the
report into the body of the actual email.
Any help is appreciated.
Regards
Greg...
|
11 |
03.09.2006 06:50:02 |
|
|
getrows only getting one row?
Can someone please tell me where I'm going wrong? I've used getrows
before without any problems, but today, it's just not playing ball (or
more likely I've just forgotten how to do this).
Dim rs As Recordset
Dim arr As Variant
Set rs = DBEngine(0)(0).OpenRecordset("SELECT fdPersonName from
tbPeople")
Debug.Print rs.RecordCount ' Returns 3 as expected
arr = rs.GetRows
Debug.Print UBo...
|
5 |
03.09.2006 03:20:50 |
|
|
Timed Events
How do I create a timed event? I want to have my database to open email at a
specific time and send a one sentence statement at a scheduled time....
|
5 |
02.09.2006 18:27:01 |
|
|
Security-Is there a better way?
Does anyone know of a better way to secure an Access database than
Microsoft's built-in security system? Although the Microsoft Access Database
Security system works, it is cumbersome. If one is trying to open a secure
database and is not set up for the right ‘mdw’, then all he/she gets is a
message saying that he can’t open the file. If he sets the mdw to the one
for the secur...
|
13 |
02.09.2006 06:32:44 |
|
|
Calling a UDF from a VB SQL statement
I need to call a user-defined function from within a SQL statement in VBA. I
need it to go something like this, assuming my user-defined function is
called UDF :
strSQL = "SELECT NAME, UDF(ADDRESS)" & _
"FROM TABLE1 " & _
"WHERE.... "
If I take the UDF(ADDRESS) statement out of the double quotes, VBA seems to
recognize it, but I really need it to be part of the SELECT statement in my...
|
9 |
02.09.2006 04:33:42 |
|
|
system failure
can anyone tell me why? on startup,1.phe.tech f1,too setup,f2 too
continue,diskettes failed errror code (88), 2. page-self re-boot.3. countdown,
margaret lenins carter...
|
1 |
02.09.2006 02:07:02 |
|
|
Update query to a VBA invoked query
I created the following "query" via access, but it won't allow me to add any
more arguments...can someone please help me get started coding this in VBA?
I haven't a clue where to begin...here is the current SQL in access
UPDATE TrackInvoice SET TrackInvoice.FreightCharge =
IIf([ShipViaRate]="FREIGHT
ALLOWED",[FreightCharge]=0,IIf(InStr([ShipViaRate],"C"),[freightCharge]=0,IIf([customer...
|
2 |
01.09.2006 23:56:01 |
|
|
Dim objOutlook As Outlook.Application
Why is it whenever i an trying to declare variables such as...
Dim objOutlook As Outlook.Application
I get a "Compile Error" saying "User-defined type not defined. I specifically
got this from the following email code....
Private Sub Command0_Click()
'Arvin Meyer 03/12/1999
'Updated 7/21/2001
On Error GoTo Error_Handler
Dim objOutlook As Outlook.Application
Dim objEmail As Outlo...
|
7 |
01.09.2006 20:16:21 |
|
|
Automating zip code registry
Hi,
I have a form that allows data entry, linking zip codes to City/State
combinations. The purpose is to speed data input for form completion later.
Currently inividual zip codes are input. The problem is: New York has 125 zip
codes and I would like to be able to have my form say:
Input city name, state and the range of zip codes for that city, ie:
10001-10125.
Then the form would crea...
|
8 |
01.09.2006 20:03:01 |
|
|
Character Set Problem?
(This is a re-post of one from yesterday that wasn't answered. Still needing
help.)
I have an Access 2002 database that imports an XML file. It has been
working fine.
We just added a new client in south FL to the routine, and the import fails
when it first encounters a name containing the "nya" character (tilde n or
ñ).
CodeWrite shows the value of the character as a Hex F1, ...
|
4 |
01.09.2006 18:47:27 |
|
|
query with two tables
Dears,
I have 2 tables.
One table with details on events, containing minimum 3 important fields viz.
event name, start date, end date. Dates are in DATE format. There are few
dozen events in this table.
I have another table with details on transactions. Each transaction has a
date of execution assigned. For the same date there can be several thousand
transactions.
I wante...
|
4 |
01.09.2006 18:25:02 |