|
Setting Focus to Word
I have a form that contains paths and names of word documents that when
clicked it starts word using automation and loads the document. This all
works fine but I would like the focus to stay with word after the document
is opened but focus returns to the access form when the exit sub is
encountered. Can someone please tell me how to force the focus to stay with
word? Here's the code fo...
|
5 |
12/15/2008 11:25:20 PM |
|
|
Birthdate calculation
I have a database with a field called Birthdate. I want to insert a unbound
field in a Form with a macro(module) with the coding for years, months, and
days. How is it writtern and how do you implement it. I have been trying for
days. This is all new to me....
|
6 |
12/15/2008 10:14:01 PM |
|
|
Remove filter before comboBox finds record
I have a unbound combo box used to find a record on a My form F_Parts
it uses the rs.FindFirst "[PartNumberID] code that the Wizard Supplies on
the after Update,
I also have code on my forms "On Current" that keeps the combo displaying
the correct info if navigation buttons are used Me.SelectByPNID_Combo =
Me.PartNumberID
the issue i am now having is Code from my F_search that ope...
|
9 |
12/15/2008 9:07:01 PM |
|
|
Forcing data to be a negative number
I am putting client payments in the same field as their bills.
Thus, I need to force payments, entered on a form, to be saved as a negative
number, no matter what.
I assume that some of the people entering the data will enter it as a
negative number and I need to insure that it is always negative.
How is that done?
...
|
3 |
12/15/2008 6:18:13 PM |
|
|
List Box After_Update problem (HELP***)
Hi,
I have a List Box problem that is driving me insane :-((
I have a List Box that drives a second List Box - classic Customers /
Contacts scenario.
Works a treat (nearly) - when I select a Customer (using the mouse) it
displays the relevant contacts in the second List Box.
However, when I use the keyboard up/down arrow key it doesn't work properly
- the SQL statement I use brin...
|
5 |
12/15/2008 6:01:01 PM |
|
|
Calendar Active Control
How can I have a calendar control become invisible when, if before a date is
selected/clicked, another part of the form is clicked or the user moves to
another record?
The problem is that if the user does not select a date but clicks another
part of the form or moves to another reocrd, the calendar control remains
visible....
|
3 |
12/15/2008 5:21:01 PM |
|
|
Why my records are read only?
I have an access front end with sql server 2005 back end. when I run the
following code:
Set db = CurrentDb()
Set rst = db.OpenRecordset("tblUserLog",
dbOpenDynaset, dbSeeChanges, dbOptimistic)
With rst
.AddNew
![UserID]...
|
3 |
12/15/2008 4:55:01 PM |
|
|
Form.Requery error
I've used a DoCmd.RunSQL before Form.Requery to delete all rows within the
form, then i want to requery the database but i always get "record is
deleted".......
|
1 |
12/15/2008 4:03:02 PM |
|
|
conditional format tab control pages
I have a form with a tab control which contains several subforms. I would
like to highlight the pages which contain data. I think I'll have to hide
any pages on which the subforms are blank. I know I need to test the
subforms, ie.
For each subform on mainform
If IsNull subform1 then
page0.visible = False
End If
Next subform
How do I reference these from the main form?
--
Than...
|
3 |
12/15/2008 2:44:15 PM |
|
|
Command Button
Two quick questions:
1. When I am building a form and I select a command button, a wizard use to
pop up and walk me through it but it no longer does. How do I turn the
wizard back on?
2. With #1 above... I do not know how to set up this button to open the
report so the user can view it, it currently just prints; my report is
"IO_KO_Time_Crosstab". Can someone tell me the command...
|
2 |
12/15/2008 2:25:00 PM |
|
|
Variable that is automatically 0
I have code that I borrowed from Allen Browne to loop through folder and
subfolder contents recursively. Actually, I adapted it to search for a
particular file that includes a specific text string in the file name. If
the file is not found I want to tell the user. Without getting into the
details of the code, the subfolders to be searched are added to a collection
for which I can dete...
|
8 |
12/15/2008 12:10:50 PM |
|
|
Function Call ?
Hello all,
I want a public function that I can call from any procudure. All it does is
display a message. The trouble I'm having is in the call itself. I just
want to be able to execute it when needed wherever required.
How does one call a function that passes no values?
-S...
|
9 |
12/15/2008 8:51:01 AM |
|
|
Old and new values of combo box columns.
I use the before update event to find the old and new values of the bound
column of my combo box with:
cbo_mycombo.OldValue and cbo_mycombo.Value
But, is it posible to find the old and new values of an unbound column in
the combo box with something like cbo_mycombo.Column(2).Value.
Any help would be greatly appreciated....
|
4 |
12/15/2008 6:23:29 AM |
|
|
Update textbox via subroutine call
I need to update a field (textbox) on several very similar forms. To reduce
the amount of code and to preclude having duplicate code to do the
calculations in each form I want to use a subroutine to perform the
calculations.
I want to call the subroutine with several parameters and have it return the
result directly to the form. A very stripped down (simplified) sample is
shown belo...
|
4 |
12/15/2008 6:22:02 AM |
|
|
Open database from child form
Hi,
I have a subform and a button that I want to click to enter a new record on
the subform. I've tried the following but it doesn't do anything. When I
click the 'Add New Record' on the bar at the bottom of the subform, it opens
to a new record; this is the action that I want to replicate on my button.
How do I d this?
This is the code that doesn't work:
Private Sub btnAddNewAdmiss...
|
3 |
12/15/2008 1:12:01 AM |
|
|
Capturing the first keystroke
What form event do I use to trap a users first keystroke on an unbound form?
I have placed breaks on KeyUp, KeyDown and KeyPress but none of the events
seem to trigger with a keystroke. If I could work this out I would then moove
on to the following problemwhich someone may be able to help me with also.
I have declared as public fFirstKeyStroke as Boolean, I'm not sure how to
set its init...
|
4 |
12/14/2008 9:40:10 PM |
|
|
Changing form properties from VBA code
Hi Guys and Gals
I know this is probably a really simple thing to do, but I want to change
the properties of an Access form from code. The property I want to change
expressly is DataEntry. Because I would like to use the same form for "data
entry only" as I do for viewing and editing records. Alternatively, if
anyone knows a better way to deal with something like this. Ultimately, I...
|
5 |
12/14/2008 8:29:26 PM |
|
|
Subform
I have a form that contains 1 Subform and a button that of the information
is SQL The problem is when delete all records of the sub him disappear.
Just show returns with allowadditions = true
Why this happens?
...
|
3 |
12/14/2008 7:29:15 PM |
|
|
Imbedded Macros
Does any one know if you can attache an event (insert date in date field) to
an imbedded macro that triggers from a command button?
The command button: "Save Record"
Action wanted: Insert current date into date field in addtion to save
record.
Thanks for the help....
|
5 |
12/14/2008 3:29:00 PM |
|
|
Apply initial filter from within form without requerying
Hi,
I have a form whose data source is a very slow query.
I want to bring up the form with an initial filter without executing
my slow query twice. It appears that if I invoke the form with:
DoCmd.OpenForm "Form", WhereCondition:="Filter", it comes up with
Filter on and the data is queried only once.
I would prefer though to be able to apply the filter within the form
itself and then it ...
|
3 |
12/14/2008 1:57:32 PM |
|
|
Add New only takes first record
I am trying to add from one subtable to another subtable where a checkbox is
True. This is part of a larger process where a record is added to the table
and then to the subtable. It works except that it only takes the first
record that is checked, not the other records.
I tried this with the rsTOD.MoveNext inside the Do While and Outside the Do
While and either way it only takes the...
|
12 |
12/14/2008 1:08:00 PM |
|
|
Programmer - an organism that turns coffee into software.
http://www.quotegarden.com/programming.html
--
Are your loved one's OK?
http://www.onecalladay.com/
...
|
1 |
12/14/2008 5:20:56 AM |
|
|
Visability
I have my form with a multitude of tabbed sub forms at the bottom. I would
like to only have one tab visible, based on the data from one field on the
"Main" part of the form...
How can I do this??
Thanx
Tom...
|
7 |
12/13/2008 8:29:06 PM |
|
|
Differenc between Lost Focus and On Exit
Can someone explain the difference between these two events for me please? I
want to creat an event to move the cursor to the first input box on the form
when the user clicks the New Record button.
Thank you,
--
Jacqueline...
|
5 |
12/13/2008 8:23:59 PM |
|
|
Frustrated - Creating Auto Number
I've tried so many times to get this without asking for help.
I have a number field containing the current date in yyyymmdd format (this
is being used as a reference number). Then, there is a customer number of
that day (we are taking orders) formatted 000 (first order of that day is
001, second is 002, etc.). So the order number will officially become
"yyyymmdd-001" (20081101-001) or...
|
4 |
12/14/2008 2:41:01 AM |