|
Processing Key strokes
I am to capture the Enter or the Tab key to execute a special set of
instructions. What I want to do is process all other key strokes normally;
so that if the a is pressed then an "a" appears on the screen. Is there a
function or process that allows me to get the keystrokes that are not Enter
or Tab to behave the way they always do?
...
|
6 |
21.09.2006 21:04:10 |
|
|
User Defined Type Not Defined
When I'm compiling my application I keep getting an message...
User Defined Type not Defined.
This is the Line...
Dim objOutlook As Outlook.Application
How do I correct this?
Thanks
DS...
|
10 |
21.09.2006 19:47:43 |
|
|
Overly Persistent Filter
Hi, all!
Have several forms that I open using DoCmd.OpenForm and provide a filter to
limit the records viewed. Problem is, when the form is closed and then
re-opened, that filter remains and all records are not seen. I followed the
advice in a previous post and placed
Me.Filter = ""
Me.OrderBy = ""
DoCmd.RunCommand acCmdSave
into Form_Unload. Even added Me.FilterOn = False an...
|
1 |
21.09.2006 19:33:03 |
|
|
Return to Inventory and Delete Transactions
I have a table order, with information, then as transactions of the
order, there are records in a transaction table. In using a macro, and
some SQL coding, how do I delete the order, but I have to have the
following: 1) the inventory returned to table inventory from the
transaction table for the multiple transaction records. Confusing
maybe, but I have already coded and have gotten the first ...
|
1 |
21.09.2006 19:20:14 |
|
|
LostFocus not triggered when leaving subform
There are several posts about this problem, but no solutions.
I would like to trigger some code when a subform loses focus. The
LostFocus event doesn't trigger when this happens.
For example, if the user is in the subform, but he then tries to click
on a button on the main form that simply pops up a message, I would
like an event to trigger if a certain field in the subform is Null
(e.g....
|
6 |
21.09.2006 19:05:04 |
|
|
Equivalent for clipboard.gettext needed
Am using the following code to do a paste append from one form to another.
It is attached to a button. The clipboard.gettext is from VB, but doesn't
appear to work in VBA.
Any ideas?
Thanks!
Function frmmcrPasteNotesAppendToCSRText()
On Error GoTo frmmcrPasteNotesAppendToCSRText_Err
csrtext.setfocus
csrtext.text = csrtext & vbcrlf & clipboard.gettext
frmmcrPasteNotesAppe...
|
2 |
21.09.2006 18:43:47 |
|
|
Code for button to execute a filter on a form
I would like a command button on a form that will ask
what word(s) to search for in a memo field. This is a memo fields with info
on books. The name of the field is "notes". I have scanned posts
in this group and discovered the following string that
seems to accomplish part of this task:
Like "*" & [What word?] & "*"
I would like to make this very simple for users; they click the button,...
|
8 |
21.09.2006 18:30:02 |
|
|
Listbox sometimes finds record and sometime pulls different record
I have a listbox that shows the Time a note was written, the EntryType
whether the source of the note is an Email saint/recieved, letter
setn/recieved, phone call S/R etc and then the First 8 characters from the
Note. Users can then select a note based on when they wrote to Whom it was
concerning, and the Content of the note.
However recently it spazzed out and now on one record (yes i...
|
3 |
21.09.2006 18:23:01 |
|
|
move object with vba
I wrote some code to move a line object "on timer" it dissappears, and doesnt
produce an error. the code is below (some lines commented because they were
just to see) and the timer is set to 1000.
Is it even possible to move or resize a control?
Select Case CDbl(Right(Time$, 2)) * 5
Case Is < 90
Me!second.Left = 8.5
Debug.Print Abs(Cos(CDbl(Righ...
|
4 |
21.09.2006 18:05:02 |
|
|
Testing for Null value in Txtbox
Hi,
Quick query!
I have a form with txtbox "txtCoName". The code behind a command button
on this form has an if..then as follows:
If me.txtcoName.Value = Null then
Do stuff
Else
Do Some other stuff
End if
The problem is when this txtbox is blank the first part of the if
statement incorrectly proves false. I can see this by placing a
breakpoint at this statement and using intelli...
|
2 |
21.09.2006 16:42:04 |
|
|
ODBC Connectivity
My MS Access 2003 mdb file is accessing a MS SQL Server back-end. I
have a couple of users utilizing laptop computers with the NexTel
aircard to access the internet. The pc card is cutting the connection
due to in-activity and when this happens they have to restart the
application. I have been unable to locate a solution to this problem.
I don't think refreshing the table links will solve ...
|
3 |
21.09.2006 16:00:03 |
|
|
Delete Duplicate Records
Hello All!
I have record "A" and record "B" in table "Zoo". Record "A" and record "B"
are exactly the same. I would like to delete record "A" and keep record "B".
Happy to provide additional info.
As always thanks very much!
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200609/1
...
|
3 |
21.09.2006 15:34:34 |
|
|
Subtracting date from system date MS Access
Hello everyone;
I hope some will have a hint or a full solution to my this problem;
I want to retrieve data from MS Access table based on date.
What format should I use with the Access Date() or Now() function to
give me yesterday date.
For example i have a column with date and time. let say i want today to
retrive all data which was inserted since yesterday. i want to use
Now() or Date()...
|
2 |
21.09.2006 15:09:12 |
|
|
Filtering a table from a combo box menu
I have a table that stores all my product types, priceing info specific to my
customers. I am designing a sales order page and would like to have a combo
box that would only display the products that relate to the customer, is
there some way l can have the combo box lookup the customer name column and
display the product and priceing info for this customer only?
I already have a combo b...
|
1 |
21.09.2006 14:28:03 |
|
|
List box
Hello, I have a list box that is populated with records created that day. If
I select one record or all records it makes no difference each record
outputs to its own report. I want the reverse of this, I want to select 1,2,
or 3 records and have them out put to the same report not individual
reports. Any help would be greatly appreciated thanks.
...
|
12 |
21.09.2006 12:34:07 |
|
|
Combo box to populate Unbound field
I have a continuous form. In the form header I have an unbound combo box that
allows the user to select an item. This updates the record source for the
form and filters the continuous section of the form to display on items
related to the selected one.
In the continuous section of the form, there is another combo box. I have
two columns, one is a number identifier (which is the bound da...
|
5 |
21.09.2006 06:11:43 |
|
|
Tab control page reference to form
Hi,
I have a tab control with several pages. On each page is a form, and I want
to reference the visible property of these forms (Rather than individual
controls within the form).
tabMainTree.Pages.Item(tabMainTree.Value).Controls gets me to the controls
on the page, but can I specifically reference the form object, or do I still
have to iterate through each control looking for an ac...
|
3 |
21.09.2006 03:33:01 |
|
|
Special considerations when app rendered in Korean, Japanese, Chinese?
I have already built in support for multiple languages in some of my
applications, but so far they have only used Western languages (English,
Spanish, etc). I need to add some Far East languages: Korean, Japanese,
and Chinese. Can anyone with experience in this area tell me of any
special considerations? Access 2003.
I've read here that the database sort order should be set to the
app...
|
3 |
21.09.2006 02:38:45 |
|
|
Combo box problem with form filter
Hi All,
I'm applying the form filter based on a selection from a combo box.
My problem is that when the filtered query has no result, the item selected
in the combo box does not show. Why is this happening? Is this normal
behaviour for a combo box and filtered form? What can I do to fix the
problem?
Any help is very much appreciated. Thanks.
...
|
2 |
21.09.2006 01:00:04 |
|
|
How do I move focus to a control in a nested subform ?
I need to move to a control(txtDIA) located in a nested subform. The nested
subform (subPatient) is located inside subform subPatientInfo, which is
located inside frmPatientInfo. I open frmPatientInfo by closing another
form, frmNotes.
frmPatientInfo, has the following properties:
Name Source
Object
Main form: ...
|
3 |
21.09.2006 00:48:04 |
|
|
Passing oneself off as an MVP ?
is it an offence to pass oneself as an MVP?
...
|
8 |
20.09.2006 22:59:59 |
|
|
*** Urgent *** unable to update data in a view ...
I have linked a sql server view in access db.
I am able to update data in query analyzer, but I can't
update data in Access either directly or using a form.
How can I resolve this?
Thank you,
-Me
...
|
3 |
20.09.2006 22:33:02 |
|
|
Compacting and Repairing Database, Opening Primavera
I have a couple questions.
First of all, because I'm going to be releasing my Access database
application as an mde that cannot be altered, I'm wondering if there is any
way to allow Access to automatically compact and repair the database
periodically, such as whenever the user exits the application. I've tried
running DoCmd.RunCommand (acCmdCompactDatabase) and
DoCmd.RunCommand(acCm...
|
3 |
20.09.2006 22:09:01 |
|
|
Code in Forms/Querry
I am creating a form in which the user will enter some data in some fields
(not all the fields will be fill out with data).
Let's say that in the form I have 2 fiels for now: Member_ID and Tier. If I
enter both a Member-ID in the form (for example 1100000031) and the tier
number (for example 9) and then I hit the 'OK' button it works fine (it
retrieves all the records from the querry w...
|
2 |
20.09.2006 21:01:16 |
|
|
DateAdd
For some reason I cannot get this piece of code to work. I'm trying to
figure if the ReportingDate (current month end) is not = to the clients
YearEnd or the YearEnd plus three month, or minus three months or plus 6
months the LBRRecd field should display "n/a"
The problem I am having it it figures invalid monthend dates (1/30, 7/30, etc.
) This is the code:
Date1 = CDate(Date...
|
2 |
20.09.2006 20:21:35 |