Adding an IIF to a where condition?
Sun, 24 Aug 2008 10:46:02 -0700
I am using a where condition, [INCIDENT]![Report_Number]=([Enter Report
Number]) and it will bring back the correct report for the number entered.
However it will bring back a new record if the number entered is not correct.
How can I add an IIF or other change to either prompt the user to re-enter
their n ...
|
More Macro problems
Sat, 23 Aug 2008 10:34:01 -0700
Iâ??m still trying to figure out this Micro stuff.
Hereâ??s the deal I have a small form â?? Password Pageâ? it has 1 field
â??Passwordâ? I want the field to run Macro 2 on enter. It works so far. Then
in the Macro I want it to OpenForm [Admin] ONLY if [Password] =
[password]![pass]. The problem is ...
|
Macro problems
Sat, 23 Aug 2008 00:36:00 -0700
I have a check box, when it is clicked on I want it to open a form. I have
that part working I'm using a Macro. The problem I have is I only want the
form to open if [another] is <> to "X" and when the [checkbox] is Yes. I
have tried using the Where Condition but the form opens no matter what the
conditio ...
|
turismo uruguay
Sat, 16 Aug 2008 01:56:15 -0300
Venga al hotel y spa Kempinki Hotel Colony Park Plaza
Toda la comodidad para su familia y su bien estar.
Con tarifas adecuadas, promociones y la seguridad de tener un buen fin de semana.
Un lugar distinto, un lugar familiar.
Nuestros servicios son:
a.. Habitaciones dobles y triples para una mejor comodidad.
...
|
Problem with Active Directory
Fri, 22 Aug 2008 14:45:02 -0700
Has anyone else had issues with Access when you logoff local user and login
to Active Directory?
System info:
Front end: Windows XP, Service Pack 2
Back end: SQL Server 2003
Access 2007
Event: I have been running quite successfully an application built with VBA
and macros. I have had no problem runn ...
|
Soltion for You can't exit MS Access error message
Thu, 21 Aug 2008 12:56:00 -0700
I am running a looping macro, and receiving an error message: "You can't exit
Microsoft Access now. If you're running a Visual Basic Module that's using
OLE or DDE, you may need to interrupt the module.
Does anyone have a solution for this? ...
|
SetValue
Thu, 21 Aug 2008 07:26:01 -0700
I can't get SetValue to appear in my action list. How do I do this? ...
|
|
|
write text from email into table
Thu, 21 Aug 2008 06:55:01 -0700
I've written a macro to pull comma-separated text from emails, which I want
to put into a table
Dim folder As Outlook.MAPIFolder
Dim MailItem As Outlook.MailItem
Dim arr() As String
Dim aaa As String
Set folder = GetNamespace("MAPI").Folders.Item("AAA").Folders.Item("BBB")
For Each MailItem In folder.Item ...
|
Open form and go to record
Thu, 21 Aug 2008 03:57:01 -0700
I have a form (Void details) on which I have placed a command button. On
clicking the command button I want to open another form (SOR details) but at
the same time go to the same void details. Link is job number.
I did have this form as a tab on the void details form, but it slowed things
down too much, henc ...
|
Macro to transfertext giving error msg
Wed, 20 Aug 2008 21:32:01 -0700
Dear AllKnowingOnes,
I have created a spec and imported a text file into Access 2003 using the
Wiz, and would now like to have a macro perform the task.
Using the same filenames and locations as TransferText arguments in the
macro , I get the following error msg:
"You cannot import a text file unless it h ...
|
