|
Outlook
If I use the docmd.sendobject to send am email it is giving an alert
when outlook is the default mail program. Is there a way to supress this
in outlook or with code?
The message is "A program is trying to automatically send email on your
behalf. Do you want to allow this?"
Dale Brown
...
|
15 |
04.09.2006 17:37:42 |
|
|
MailMerge from Access to Word
Hi all,
After i input all info into my DB using form, I need to output my record (1
at a time) from Access to Word template. Then i need to add some text, tables
etc. and save the file to a location.
i have created a mailmerge template already (called Letter.doc)
I found out that the below module code should automatically do the mailmerge
for me, same as if i would open a report for t...
|
1 |
05.09.2006 14:34:02 |
|
|
Yes/No Box Ticked Conditionally
Hi all,
I have a form that contains a Yes/No box labelled 'Completed'. Initially
this box is uncheck. However, a second box labbelled 'Date' will at some
point in the future will have a date entered, at start of database the 'Date'
box is empty (null). I would like to automate a tick to appear in the Yes/No
box only when a date has been entered into the date box. Hope I have
expla...
|
4 |
05.09.2006 14:21:30 |
|
|
"Go To" Reference Number
Hi
Is it possible, and if so, how would I go about doing it, to have a
text box on a form where I can type in the reference number of the
record that I want to display and it will display that record?
Thanks
Colin
...
|
4 |
05.09.2006 14:06:04 |
|
|
Text to number in conditional formatting
I have problem with conversion text to number and use this in conditional
formatting.
Example:
I have cell (text field) with value: <300
How to convert this value to number 300 and use in conditional formatting?
Thanks!...
|
3 |
05.09.2006 12:21:02 |
|
|
Converting Access XP to Access 2003 (Run-Time error 2004)
Our company are migrating an MS Office XP database to Access2003. The
database file format is already in 2002 format so I didn't expect much
trouble, however we use the database as a container for forms and
connect to our back end using ODBC Direct. I have a very strange
problem in that if I retrieve a SQL 'text' field which contains null
and try and put the result in an unbound text box...
|
7 |
05.09.2006 11:23:00 |
|
|
Distinguish a From and a subForm
Hello!
I use a form which is used twice: 1st as a SubForm and 2nd as a mainForm.
If the two forms are opened and I try to refer to the mainForm, it effects
the subForm ?!!?!
I know that if I want to refer to the subForm, I have to use :
MainForm.SubForm.Form.Property, but this time it respons even with
SubForm.Property..
How can I avoid this?
Thanks for any suggestion
...
|
11 |
05.09.2006 08:56:31 |
|
|
send a message to another screen
I would like to have a command button on a form with one user that when
clicked brings up a message on another selected user's screen or several
user's screens.
Is this possible please
Many thanks
...
|
4 |
05.09.2006 08:55:55 |
|
|
Access help!
Ok,
I have looked at this and customised it I think correctly, do I put the code
under the click event of a command button? Sorry new to this and getting to
know the ins and outs.
Thanks
"ruralguy via AccessMonster.com" <u12102@uwe> wrote in message
news:65cb79e35d4ab@uwe...
> MVP Allen Browne covers this pretty well.
> http://allenbrowne.com/AppInventory.html
>
&g...
|
3 |
05.09.2006 07:42:16 |
|
|
lock (secure) access tables-allow edit+read access only in form
i have an application for dataEntry in access application using access forms.
is there any way to disallow the user to go directly to the tables. only
access to data is through forms. if i hide tables then i think user can still
access the tables with importing those tables in some other access
application.
thanks...
|
1 |
05.09.2006 07:02:01 |
|
|
Refresh form and open record
I have a form, which has a query containing left joins for a data source.
After I update a combo box field on the form, I need the other
controls/fields on my form to update. I have tried the following different
codes in the combo box field's AfterUpdate event and nothing works. I can
get the form to refresh, but it jumps to the first record. I can get the
form to refresh and open, b...
|
5 |
05.09.2006 06:15:43 |
|
|
CNTL + (key) to launch form
Hello,
Is is possible to do do this?
User has Form1 open, user presses CNTL + L (or some other letter if needed)
and it will open Form2?
...
|
4 |
05.09.2006 04:19:02 |
|
|
Database can't find the field "|" referred to in your expression.
Hey,
I am working on a database for my campus television station. One of
the sections is related to Show Tapes and the Episodes that are
contained within them.
I am trying to perform a custom filter on a sub-form using VBA when the
error in the title pops up. There are three fields associated with
this custom filter: ShowTitle, LowerDate, and UpperDate.
The routine looks to make sur...
|
9 |
05.09.2006 04:05:09 |
|
|
Loop Returning One Value
I have this loop statement that is almost working, the problem is that
instead of starting at the first record, making it the next highest
LineID available, then going to the next and makeing that the next
LineID +1 its just finding the highest Line ID at the end of the
recordset and making all the LineID's in every record that one.
I should have this//
1
2
3
4
5
6
but I'm getting ...
|
7 |
05.09.2006 02:37:02 |
|
|
Database Help
I have created a database which hold customer details, stock control and
sales.
I am having difficulty with the following.
When I sell and Item I need this to be deducted from the total stock for the
item which has been sold, what is the best way to do this?
I have the following tables.
tblinvoice
Invoice ID(pk)
CustomerID(fk)
InvoiceDate
InvoiceNotes
Tblinvoicedetails
...
|
4 |
04.09.2006 22:50:13 |
|
|
I am unable to to recall an e-mail even though I have Outlook
I have outlokk but I am unable to recall sent e-mails. Can anyone explain why....
|
4 |
04.09.2006 21:54:55 |
|
|
Format Subform
I have a subform displaying a list of times and User Names.
When the form is opened I want some times to be enabled and others not based
on a value in the main form.
The following code checks the value on the main form and currently disables
all fields against each time.
I would like an If statement that would only disable the player fields where
TeeTime was between Certain Times e.g Bet...
|
1 |
04.09.2006 20:47:02 |
|
|
creating trial version of database
I have a database which a government agency is interested in. They require a
sample copy, so that users can get familiar with it. Obviously I want the
database to cease being operational after so many sessions. I could build in a
VB function that shuts it down after a certain date, but then someone could
reset a computer's date, use the program, and then reset the date back again. I
...
|
11 |
04.09.2006 20:29:51 |
|
|
If Statement is Wacky
This IIf statement is not working...it doesn't do anything.
I tried changing the first part of if to
If Me.TxtDisplay <> Me.TxtDupeID Then
then I did get the "DUPLICATE ID"
but the second part still wouldn't work.
Any help appreciated.
Thanks
DS
Select Case
Case 14
Me.TxtDupeID = Nz(DLookup("[EmployeeID]", "Employees", "EmployeeID = " &
Me.TxtDisplay & ""), 0)
If Me...
|
3 |
04.09.2006 20:05:50 |
|
|
Which One? WeekDay()
Which one is correct to use to get the WeekDay Number?
Thanks
DS
Weekday(Date())
or
Weekday(Now())...
|
5 |
04.09.2006 20:01:38 |
|
|
Help again with me.currentrecord
Hi
In myform i have 2 buttins on back and one forward
and i have to label with
cuurent record
and record count
so i can write you are on 1 record of 10 record
and if i'm on the first record my back buttons are enabled=false
and if i'm on the last record my forward button are enabled=false
all works fine.
Just not in one case the form i have is inside another form and in the main
...
|
2 |
04.09.2006 18:37:02 |
|
|
listbox requery on subform with no previous data
I need to requery an unbound listbox on a subform from a third form's close
event. The simple requery method works if the listbox already has data, but
it does not work if the listbox was blank before the third form was opened.
I tried the requery method:
Forms![frm_task_detail]![frm_view_notes].Form![lst_notes].Requery
And also setting the rowsource of the listbox:
Forms!frm_task_de...
|
2 |
04.09.2006 18:14:01 |
|
|
forms in forms
Hi
I have a form with another form inside, this second form is from start
visible=false when i make a choise in a combobox then the form get
visible=true and show what i want. this works fine.
But inside the second form (the hidden from start) i have this code:
Me.RecordsetClone.MoveLast
Me.lbl1.Caption = Me.RecordsetClone.RecordCount
And in this line i get an error bescause i dont ha...
|
3 |
04.09.2006 17:16:01 |
|
|
Msg box coding
Hello,
I am trying to include on the message box "The requested form is still under
construction". Can I get assistance on where that should be included on the
syntax below.
Private Sub cboSelForm_AfterUpdate()
If cboSelForm = "Training Travel Monitoring Form" Then
MsgBox Err.Description, vbExclamation, "Procuremnt Database"
Else
cmdSelForm.Enabled = True
cmdSelForm.SetFocus
End I...
|
3 |
04.09.2006 17:11:18 |
|
|
ACCESS FORMS.how to make demo version w.r.t. specific date
i have created an application for dataentry in access forms. what i want is i
want to make a demo version of this application. let say i want the
application to run before 10th of september. if i use smthing which gets the
system time and check the current date and compares with 10th sept, then this
thing fails if the user changes the system date to back.
so is there any way to make date ...
|
2 |
04.09.2006 16:37:33 |