|
Emailing multiple recipients using GroupWise
I have the following code to create an email to multiple recipients.
Dim rst As DAO.Recordset
Dim strAdrs As String
Set rst = CurrentDb.OpenRecordset("myquery")
rst.MoveFirst
Do Until rst.EOF
strAdrs = strAdrs & rst!adstrEmail & ","
rst.MoveNext
Loop
strAdrs = Left(strAdrs, Len(strAdrs) - 1)
Debug.Print strAdrs
DoCmd.SendObject...
|
1 |
11/24/2008 6:15:11 PM |
|
|
Checking Two Conditions in a Macro
Is there a way to check two conditions in a macro at the same time? I want to
check to see if both a date and name are in a table before appending the
data. These need to be checked at the same time as in the dbo table there
could be the same date from another 'name' or the 'name' could be for a
different date. My current code is shown below and the error message states
that the tblDots ...
|
4 |
11/24/2008 6:09:28 PM |
|
|
Why won't this DSUM work?
=DSum("[Amount]","Deposits","[DateDep] =#" & [Text21] & "#")
why am I getting "syntax error in date in query expression"?
thanks...
|
8 |
11/24/2008 5:48:51 PM |
|
|
Paasing an array in OpenArgs
Access 2000. I have a simple form with two unbound text boxes for the user
to enter a date range and a button to open a report resticted by the dates.
I would like the two dates passed on to the report to show in labels when it
opens. I thought a good way to do this would be to create an array with the
two date values and pass the array in the openargs argument. (This may not
be the best...
|
4 |
11/24/2008 5:29:31 PM |
|
|
How do I create a continuous form/ sub-form?
The templates use a built in function to enable clicking on a link in a form
that looks like a datasheet to open another form....I want to create a form
like the templates use...but a more simple one.
In my previous post I was told to create a continuous form/sub form that
looks like a datasheet to open another form.
How do I do this? What is the step by step process? I am brand new with
Acc...
|
2 |
11/24/2008 5:23:39 PM |
|
|
Set an Event Procedure to User Procedure
Using Access 2007 on Vista Home Premium.
I have a procedure called Build_Form, which creates a new form at runtime
and populates it with a tab control. The tab control has multiple pages and
each page has some labels and combo boxes. My goal is to get the value of the
combo box before and after it is updated by the user so that I can find and
update a record(s) in a table.
I have set...
|
4 |
11/24/2008 4:53:02 PM |
|
|
CurrentUser and breakpoints
Hello,
working with Vista Home Premium SP1 and Access 2003 SP3 and a level
secured database with workgroup information file, I got some problems
checking the CurrentUser property in "if/end if" blocks in the
Form_Open event to set some user-depending properties: the form opening
does not work! e.g. if I have the form open in design mode and try to
run the form, nothing happens - the f...
|
3 |
11/24/2008 4:48:30 PM |
|
|
User edit of label in List View Control
I have a List View Control on a form for which I want to 'goto' any of the
fields (under conditions determined by program control) and allow the user to
edit the text in that field and when finished typing (eg. <enter> key) I can
go back into program control with possibly an AfterUpdate event.
I know I can identify the required 'field' on the List View Control using
Me!cControlNam...
|
1 |
11/24/2008 4:07:03 PM |
|
|
Scroll to first item in list box in ACC2K3?
I've got a form with a list box that has ~ 100 items. When the user selects
a radio button, the list is enabled and they can select multiple items.
When the user clicks another radio button, I clear all of their selections,
but also want the list box to jump to the top of the list.
Any ideas?
Thanks
...
|
3 |
11/24/2008 3:59:33 PM |
|
|
How to populate these columns?
I have a form bound to my table and a subform for a related table. The main
form contains two calculated controls TotalPaid and BalanceDue. These
controls are unbound and are calculated based on the contents of the subform
and other controls on the main form. I'd like the contents of these two
controls to go into hidden bound controls to populate columns in the main
table. My question is...
|
2 |
11/24/2008 3:25:16 PM |
|
|
Param Form Drop Down ??
I have a table of events with a field for Region and a field for Agency.
Each event has region 1, 2, 3, 4 or 5 and an agency from an agency table with
hundreds of agencies. When they run a report, I want them to be able to run
it by a specific agency OR by region. If they run it by region, I want them
to be able to run a specific region OR ALL REGIONs.
I have a param form with contro...
|
1 |
11/24/2008 3:20:14 PM |
|
|
Creating good dynamic reports
I have a report that is made up from serveral subreports. My problem is
formating the report is really difficult as the contents can vary so much. I
have tried but cannot find a way of testing for report content and then in
some way adjusting the formating of the report base on it's contents.
Any suggestions would be appreciated.
Regards
alathwell...
|
4 |
11/24/2008 10:01:02 AM |
|
|
Prevent duplicates in sub form
I am using a sub form that has autoID(Primary KEY), EntDate , Catagoryrec
using radio buttons that range from 1 to 5 and HRTime. I can have the same
date for more than one catagoryrec but want to prevent duplicate
catagoryrec entries of that EntDate. As an example I could not enter two
record entries with EntDate 11/23 with radion button or catagoryrec2
selected. I would like an erro...
|
2 |
11/24/2008 8:23:23 AM |
|
|
sort a subform containing 2 combo boxes
My subform (say MySubform) contains 2 combo boxes which bound by their first
(hidden)column but showing the second column.
Is there a way that I can sort first by Combo1, then by Combo2 whenever the
main form is opened?
I can't do this in the subform's query: it contains only the foreign key
fields to which the combos are bound.
Evi
...
|
7 |
11/24/2008 12:12:56 AM |
|
|
delete the source table for a displayed listbox
I'm running Access 2003.
I have a listbox on my form that will contain data that is a result of a
query based on user input.
If I try to delete the table or run a make table query, I get an error
message saying it can't delete it because the table is in use.
Is there a way around this and still have the listbox on this form?
Jim...
|
3 |
11/23/2008 9:30:11 PM |
|
|
How to Create My Own Self Define Icon in BUTTON
Hi,
1.Just to make my application more user friendly, I like to create an icon
with my own define pics..
(Eg: Button with Handphone Symbol?)
2. Anyone knows how to do it ?
Edison
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200811/1
...
|
5 |
11/23/2008 2:43:53 PM |
|
|
Disable keystrokes in an unbound combobox ?
Hi -
Access 2003/WinXP: I have an unbound combobox (cboList) on a form and it
gets properly populated in VBA code.
Is there a design-time method to limit the user's interaction with the
combobox to 'mouse only' (no keystrokes) ? If not, how would you disable
keystrokes in a KeyDown event procedure?
Thanks,
Jay...
|
3 |
11/23/2008 5:12:00 AM |
|
|
Hide subform based on value in field on subform
I've seen the code in other posts to hide a subform based on a value of a
combo box on a main form or the value of a field on the main form, but I need
to hide/show a subform based on the value of a field in the subform, itself.
Is that possible?
I tried the following, but it did not work:
Me.frmParentCode.Visible = (Me.frmParentCode!LogName Is Not Null)
where "frmParentCode" is my...
|
4 |
11/23/2008 2:20:15 AM |
|
|
Run Different Reports with Same Button
I have a combo box named "ReportList" and a button named "GenerateReport" on
a form. I'm trying to make the report selected in the combo box run when the
one button is pressed as opposed to making several buttons for each report.
I'm using the code below for a button for each report:
Private Sub GenerateReport_Click()
On Error GoTo Err_GenerateReport_Click
Dim stDocName As String...
|
5 |
11/23/2008 12:11:01 AM |
|
|
default value for combo box in a sub subform
Hi,
I have a combo box (cbo2) in a sub subform of a continuous form. I put On
Form_Load() of the sub subform :
Me.cbo2.value = Me.cbo2.itemData(0)
When I open the sub subform on its own, I get the default value for new
record appearing. But when I open the same sub subform within the main form,
I do not see the default value for new record. What could be the problem ?
Many thanks....
|
2 |
11/22/2008 9:26:24 PM |
|
|
Getting the Right Window Size for A Form
I am trying to open a form in non Maximised state. So on open I execute:
DoCmd.Restore
But the Window opens in a maximised state and I do not want that.
The thing in the previous window, I execute DoCmd.Maximise ... the window
opens in maximised state.
How can I get round this problem?...
|
2 |
11/22/2008 8:15:01 PM |
|
|
error when saving
I have a form that I check for these 2 fields to be complete beforeupdate. I
also want to give the user the chance to verify they want to save the record.
If the user hits save and the counselorsignature is blank it tells them its
required and then I get a MS Access error box that pops up (You can't save
this record at this time!
Registrations may have encountered an error while trying ...
|
3 |
11/22/2008 6:34:30 PM |
|
|
Rich text memo field and formatting toolbars
Hi,
I could use some help on the following;
In Access 2007, I'm having a form (popup, not modal), the form has a subform
which displays a rich text memo field.
Problem; there are no formatting options available to apply the rich text
features. The command bar is disabled, and I noticed that the minitoolbar
(which displays when you hover over selected text in the field) doesn't show ...
|
2 |
11/22/2008 5:29:00 PM |
|
|
Combobox's list separator character, not separating correctly
HI,
I have a combobox on a form. I set the rowsource for it in code, to a string
of values delimited with ";" character.
The 'Row Source Type' is set to 'Value List' and 'Separator Characters' is
set to ";" on the form and also i set these properties in code to the same
values (acSeparatorCharactersSemiColon for the Separator Characters).
Anyway on the form, in the list of items for thi...
|
3 |
11/22/2008 3:57:48 PM |
|
|
Help with Currency Format
How do I format the Amount column to Currency in a List box using the
following...
List39.RowSource = "SELECT Deposits.DateDep, SUM(Deposits.Amount) FROM
Deposits GROUP BY Deposits.DateDep ORDER BY Deposits.DateDep DESC;"
thanks...
|
4 |
11/24/2008 5:58:04 PM |