|
User can't move on if a control hasn't changed
I have a subform that is formatted as Continuous Forms. The last control on
the subform is a tick box (txtpaidbymember) which must be ticked before the
user moves to the next record. I need some code to a bring up the message
that they must tick the box and not allow them to move on to the next record
until they have done so. Can anyone help?
Thanks
Tony...
|
11 |
10/15/2008 4:56:04 PM |
|
|
Format Multiple Colors on 1 form
Hi,
I have placed 3 different text boxes on my form, each with a different
color, then sent them to back, so the controls are visibile on top.
When I open the form in FORM VIEW, the text boxes only go to a certain width
of my screen, while my header and footer sections go the full width of the
screen.
Not knowing how each user's screen resolution will be configured, is there a
way...
|
3 |
10/15/2008 3:20:00 PM |
|
|
excel for MAC copying dates
I have noticed that anytime I copy a date from one excel spread sheet into
another it automatically changes the year to "12". When I tried to do a
custom set up and use mm/xx/08 instead of mm/xx/yy it wouldn't allow this
and showed the sample as 9/01/12. is it possible that in setting the example
as "12" for the year that all cells set up in this format are automatically
copied as "12...
|
2 |
10/15/2008 12:39:23 PM |
|
|
Easy way to trigger update of controls
Hello,
on my form I have a ListBox which represents a few columns of a certain
table. After selecting one row I might click on a button which open another
form and a new RecordSource is set. On this form all detailed entries of the
selected recordset of the ListBox are shown.
Now I modify some record entries and save the changes. And in fact, the
modifications are written in the data...
|
3 |
10/15/2008 11:46:01 AM |
|
|
Close sub-forms in design mode before attempting to open in form view?
Hi All
Does anyone have a solution to this common MS Access development
problem?
I have a system that uses sub-forms. When I am developing I jump into
the VB editor and make a code change behind one of my subforms. The
problem then comes when I attempt to view my main form in form view
back in Access as I get this error:
"You can't open a subform when it is also open in Dei...
|
2 |
10/15/2008 10:16:48 AM |
|
|
Command buttons on a datasheet form?
Hi,
is there a way how to add command buttons on datasheet form? I need to
enable users print a specific report from a datasheet form, but there is no
space to add command button to.
Thanks for any advice...
|
3 |
10/15/2008 10:08:10 AM |
|
|
ListBox and AfterUpdate Event
Hello,
I'm wondering why I've no success in reading out selected ListBox rows in
the function of AfterUpdate Event of the ListBox:
Private Sub lstTestListBox_AfterUpdate()
If lstTestListBox.ItemsSelected.Count > 0 Then
Debug.print "Something selected"
End If
End Sub
I assume that after selecting a row in the ListBox the AfterUpdate event
will get triggered. But no selec...
|
3 |
10/15/2008 3:35:01 AM |
|
|
Web Browser Progress Bar
Hello all-
I have two forms: MainForm PopUpForm
Main Form - Contains several subforms who's source object can change based
upon what the user wants to do. All are linked to a backend database
connected to a server.
When the user switchs the subform, there is a several second delay based upon
the number of records in the subform loading (2-5 seconds at the most). In
the delay, I wanted ...
|
2 |
10/15/2008 1:10:01 AM |
|
|
Trying to close a form when empty
Hello All
i am working on a form that pops up when a user logs in and has at least 1
of any number of 5 types of items. for instance the item types are issues,
service, warranty, order, returns. if a user has created any 1 of these items
and it is older than 14 days and has not been "finished" a form pops up with
5 list boxes, 1 list box for each type, showing the items that arent finis...
|
5 |
10/15/2008 12:52:09 AM |
|
|
Proper Code?
I have a form with a command button that opens another form. The forms are
frmProjectCost (parent form), and frmJobTotal (Child). When the command
button is clicked on the parent form, I want to hid it from view. In the "on
click" event I put the following code:
Me.Form.Visible = False
DoCmd.OpenForm "frmJobTotal", acNormal, , , acFormEdit, acWindowNormal
This hides the par...
|
3 |
10/14/2008 11:37:01 PM |
|
|
Hidding Tables to end users
Hi there,
Can one hide the underlying database from end users ?.
What I mean is the following. When one opens an Access database, one has the
'Objects' screen that allows one to view existing tables, queries, forms,
etc. Is there any way to hide that so users can only see the forms of the
application/database in Form View and they have no access to the tables
directly and the cannot ...
|
6 |
10/14/2008 10:07:01 PM |
|
|
Determining number of weeks in a month
How would i determine how many weeks in a current month? And how many days in
the current month. ...
|
2 |
10/14/2008 8:45:20 PM |
|
|
Can't get subform calculation to display in parent
I've written a function that figures number of days from a given date. It
works well, but I am trying to make if fly from within a subform and make it
plug the result into a field in the parent form and I'm not getting the
syntax right. Everything within the If statement works, but the last
statement generates a missing object error. The whole statement is
highlighted in the editor, so I...
|
2 |
10/14/2008 7:59:41 PM |
|
|
Custom control consists of CheckBox and ComboBox
Hello Everyone,
a customer wants to have the option to tick a CheckBox so that the according
ComboBox is grayed out. Well, this starts to get annoying in case of 100 of
such constructs. Behind the scene, an unticked CheckBox should set the value
of the ComboBox to NULL. Even though the same could be achieved with an
additional entry in the ComboBox list, the customer wants this feature....
|
1 |
10/14/2008 7:50:02 PM |
|
|
Filter
Hi:
I have a form based on query that filters on a user’s Sales ID, when opens.
for example the form for a specific user has 20 records; 10 of them are
locked (budget) and 10 can be edited (forecasted); Once the first forecast
record is found and a filter is applied to get just the ones for forecast (10
records), so far so good; BUT when I remove the filter I get the entire
table, f...
|
5 |
10/14/2008 5:43:01 PM |
|
|
Combo Box, select Station, opens new form to specified record
I have an access database that tracks all "stations" I created a main page so
when we have new information to add to an existing station we just select the
station from the combo box drop down list (there are thousands of stations!)
when you select the station you want (ie F12, J31 etc) it opens a new form
(this part i've got done) but the form opens up to record # 2 (F02) which
doesn't ...
|
6 |
10/14/2008 4:44:51 PM |
|
|
Passing a null value to a query
I am designing a form that allows a user to specify query conditions. I run
into trouble is the user does not want to limit on a particular item.
I have a form, fDrill that has three combo boxes, once of which is for the
customer name, cboCustName. The query that uses these conditions is qDrill.
The Customer Name field in qDrill has [Forms]![fDrill]![cboCustName] as the
condition. ...
|
4 |
10/14/2008 4:13:01 PM |
|
|
Combobox AfterUpdate to existing record
I have a combo box that's used to navigate records either by making a
selection or mouse button scrolling it. The problem is that read-only
users can't use it as the AfterUpdate code is disabled for them.
What's an "easy" AfterUpdate code for comboxes that will allow all
users the ability to make selections or mouse scroll? I've looked all
over the forums but can't find anything.
Thanks!...
|
10 |
10/14/2008 1:22:27 PM |
|
|
Multiple Search Criteria with AND/OR???
I have this search form, which I need to make it look for each criteria and
the next...instead of just one of them.
I'm not sure how to do this?
Private Sub Command12_Click()
Dim strWhere As String
Dim lngLen As Long
Const conJetDate = "\#mm\/dd\/yyyy\#"
If Not IsNull(Me.txtfirstname) Then
strWhere = strWhere & "([First Name] Like ""*" & Me.txtfirst...
|
5 |
10/14/2008 1:07:02 PM |
|
|
PDF Toolbar Button
Hello,
I was wondering if it is possible to create i button with in custom
toolbar I've made which which will enable me to PDF, Current open
reports.
ive manage to create i button which will do this from a list of
reports i have shown in a list box, and code is as follows,
Private Sub CmdPdf_Click()
Dim strDefaultPrinter As String
' get current default printer.
strDefaultPrinter...
|
5 |
10/14/2008 12:55:16 PM |
|
|
Going through all text/combo boxes on form, when user changes reco
Hi,
I have form with some nested sub-forms, and I need to go through all
textboxes and combo boxes, when user changes data (Dirty event). I'm using
Access 2003.
Is there a way, how to do it?
Thanks for any advice
Jarda
PS: I've tried to code something myself, but perhaps I'm a little bit
unclear on using .OldValue property. I've tried to compare .OldValue and
..Value of textbox or...
|
4 |
10/14/2008 9:00:01 AM |
|
|
Halt code execution when closing form
A form holds some code that performs database health check.
As it can take some time to perform, it is possible to halt execution,
closing the form......
....but..... the underlying code, keeps executing......
Is there a statement that can terminate all code execution?
...
|
3 |
10/14/2008 8:41:12 AM |
|
|
"Invalid use of Null" issue
Hi all,
How can I keep from getting the "Invalid use of Null" error if the
dateofReferral is indeed null?
vRefDate = DLookup("[dateofreferral]", "tbdetail", "RecordID =
Forms![frmain]!cbPatientList")
...
|
5 |
10/14/2008 3:04:02 AM |
|
|
"You canceled the previous operation"
Using Access 2003, SP3. I have this code when a button is clicked:
DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, , acMenuVer70
When this line tries to execute, I get the error "You canceled the
previous operation".
The lines of code after this try to open a report. I've tried
compacting/repairing to no avail. Also, this access database runs on
25 other computers and has n...
|
3 |
10/14/2008 3:01:09 AM |
|
|
Dynamic ToolTip?
Access 2003/Windows XP, continuous form. Looking for a way to modify the
content of a hover-generated Tooltip depending on the value of the textbox
over which the mouse is currently hovering. Specifically, the field in
question contains department names, and when the user hovers his mouse over
one of the departments, I want the ToolTip to display the name(s) of the
contact person(s) fo...
|
13 |
10/14/2008 2:30:23 AM |