| Thread | Last Post | Replies |
|
| prevent deletion of record | 23 Aug 2005 21:10 GMT | 9 |
I have a form that displays previous year's info at top w/ space to enter new
info current year info at bottom. I would like to prevent the deletion of
the record if there is a value greater than '0' in the previous yr value.
There is a deletion button on the form.
|
| Email Cmd | 23 Aug 2005 21:07 GMT | 2 |
I have a Command that generates an email message as follows:
Private Sub cmdSendOverdue_Click()
Dim strMessage As String 'Body of message
Dim strSubject As String 'Email Subject
|
| opening a form from another form in datasheet view | 23 Aug 2005 20:39 GMT | 3 |
I have a form that launchs another form with a button.
The onclick event looks like:
Private Sub get_common_attributes_Click()
On Error GoTo Err_get_common_attributes_Click
|
| combo box selection | 23 Aug 2005 20:31 GMT | 2 |
I have a form with few combo box, I want to make the user choose one of the
options in all the boxes. How can I make sure the user filled all the combo
boxes before continue?
Thanks
|
| Postion in a List Box | 23 Aug 2005 20:10 GMT | 3 |
I have a form with a TextBox and a ListBox. The ListBox is based on a query.
As the user types in the TextBox the ListBox will sequentially postion to
the correct record. Here is the code for the Change Event of the TextBox
that makes the sequential search work.
|
| Loop through records | 23 Aug 2005 18:27 GMT | 9 |
Would like help on opening a query in vba and reading every record
changing if necessary. Need to know how to :-
1) Updating file
2) Stop when end of records reached
|
| Passing a query parameter via code | 23 Aug 2005 17:59 GMT | 4 |
I have in my access application a form to build report criterion. Among other
criterion is the reporting period which is set thru a txtStartDate and
txtEndDate text boxes. I want my report to return all the records if no date
is entered and to filter records only for the period ...
|
| Need to generate a report based on the value of a combo box | 23 Aug 2005 17:35 GMT | 4 |
Hello everyone....
I am trying to generate a report based on a combox box. I need the report to
show only those records that have an entry in the combo box titled "Override
Code"
|
| Combobox - Retrieving only the required records | 23 Aug 2005 17:25 GMT | 15 |
I have 2 forms - 'Existing Instructor' and 'Existing Course' which are
linked. The first form has the following fields - InstructorID,
Instructor First Name, Instructor Lase Name and Department, all of
which get populated when the form loads - the information for all the
|
| Next number during Edit | 23 Aug 2005 16:00 GMT | 1 |
I have a PO db, and for the OrderNo, I put the following in BeforeUpdate of
the Form:
Me.OrderNo = Dmax("OrderNo", "PO_Table") + 1
For the workgrp access, I plan to have a Data Entry user (insert data only)
|
| Recordsets | 23 Aug 2005 15:44 GMT | 3 |
i have a register form which displays mon-fri etc i wish to change the yes/no
boxes so that the user cant tick that box unless the student is registered to
that day, i.e set the box to enabled = false
if something = false then
|
| lookup field value in a sub form | 23 Aug 2005 15:36 GMT | 4 |
I am going to try and make this as simple as I can (I hope). What I need is
to get value of subform form2 field month where its monthnumber is equal to a
value in textbox2 in form1
my sub form form2 has 2 fields month and monthnumber
|
| Recordset .Find | 23 Aug 2005 15:24 GMT | 5 |
I need some help getting this to work.
Basically, I want to search a table for certain items,and then display them
in an unbound text box. (unbound, because i need this info from another table)
heres what i got that works:
|
| Access 2000 code won't compile w/ 2003 | 23 Aug 2005 15:21 GMT | 2 |
Microsoft has a tutorial "How to Load OLE Objects from a Folder into a Table"
at http://support.microsoft.com/?kbid=198466
In this, the following code won't compile:
Private Sub cmdLoadOLE_Click()
|
| Microsoft Web Browser | 23 Aug 2005 14:11 GMT | 7 |
Bit stumped by this control. I am using it to display HTML stored in a table
on a form. The OnCurrent event procedure on the form is:
Me.ocxWebBrwsr.Object.Document.body.innerHTML = "<HTML><HEAD></HEAD><BODY>"
& _
|
Sign In
Join
My Latest Posts
My Monitored Threads
My Blog
My Photo Gallery
My Profile
My Homepage
Start New Thread