|
Spell check still causing problems
I'm still having spell check problems.
I posted a note message to this board back in September, and never did
resolve the problem. I've worked on several other applications since then,
and have never resolved the problem I'm having with a spellcheck function
that I allow users to call via a shortcut menu. If they are in a textbox on
the main form, the function appears to run successfu...
|
11 |
12/17/2008 2:48:35 AM |
|
|
Validation rule using calculated value from another subform
I have form with 2 subforms.
1st subform shows assets' names (securities etc) and its overall
possessions(calculated sums of all transactions money-wise and units-wise)
and is based on query using tblTransactions
2nd subform is TransactionForm - with controls for AssetName,
TransactionKind (Buy-Sell), Price and Quantity and is based on
tblTransactions.
I need to set the Quantity control...
|
4 |
12/17/2008 2:44:05 AM |
|
|
loop eof problem
Hi All,
I am trying to code the following procedure: Get the jobfunc assign to
empemail from empjob table. Compare the jobfunc to the new jobfunc being
assigned in the form. If the jobfunc being assigned to the empemail at the
form stage is the same with any of the jobfunc already assigned (stored in
empjob table), then exit a particular sub.
The following code is a outline of what...
|
11 |
12/17/2008 12:09:59 AM |
|
|
Catch duplicate error when inserting into table and display msg
If two users are insert the same, exact data into the same table and the
warnings are off, is there a way to capture and display the duplicate error?
Thanks...
|
2 |
12/16/2008 11:47:28 PM |
|
|
Error 2105
This error is returning on occasion. I believe it's due to my code being
faulty:
Private Sub Form_Load()
If Me.OpenArgs = "New" Then
DoCmd.GoToRecord acDataForm, Me.Name, acNewRec
End If
End Sub
Does anybody see what's wrong?
Thanks!
--
www.Marzetti.com...
|
6 |
12/16/2008 10:41:57 PM |
|
|
OpenForm action was canceled
Hi ALL,
I am getting this error message: The expression On Click you entered as the
event property setting produced the following error: The OpenForm action was
canceled.
I only get it when i open my .mde using runtime 2007. But if i open the same
..mde using the full access 2003, then i don't get that error. I am not sure
what is going on.
Can anyone help?
thanks.
--
L...
|
5 |
12/16/2008 9:53:17 PM |
|
|
problem opening form
I have a main form that has a command button to open a form in data entry
mode. The form I am opening has entry fields at the top of the form and 4
subforms - set up as pages in the middle.
My tables are tblclient, with clientid as primary key and autonumbered. and
tbltxplanmh with txplanMHID as primary key and autonumbered. clientid is a
foreign key in tbltxplanmh.
The probl...
|
3 |
12/16/2008 9:29:09 PM |
|
|
highlight the cursor position
is there a way to highlight the position of the cursor....for example if the
cursor is in a textbox, the textbox background would change to a certain
color. Now, if there are, say, 30 controls on the form, is there a way in
program to highlight where the cursor is. If the button has the focus it is
blue, if the textbox has focus it is blue or if the subform has focus it is
blue... I d...
|
5 |
12/16/2008 9:04:02 PM |
|
|
before update event
I have a form and subform. In the subform, I want to allow entry only if one
of the fields in the main form has one of two values. This is the code I put
in the BeforeUpdate event of the subform but nothing happens. Any
suggestions would be great - especially if there was a way I could disable
the location field in the subform. The subform is in tabular form for
multiple records (not...
|
11 |
12/16/2008 8:57:34 PM |
|
|
Finding Current mdb or mde name & folder
Hi, Thanks in advance.
Need to know the current database name and file extension. Together with
folder name. I need the following stings completing as an example.
do action here to find:-
mydbfile = "test"
mydbext = "mdb"
mydbfolder = "c:\Database\Current\"
Thanks once again
trev...
|
3 |
12/16/2008 8:43:21 PM |
|
|
1 Main for 2 Subforms
I truly Apologize for this, but I can't find an answer for this at all.
Ok, I posted a similar question, but I am not sure I explained myself enough
in order to get the correct answer.
I have three forms I am working with. I have a main form with two subforms
in it. I have a combo box on the main form that will search through
employees and it pulls up all their records on the subform...
|
16 |
12/16/2008 7:35:45 PM |
|
|
UI freezes on DoCmd.Close
I have a bound Form which does not close properly with a DoCmd.Close (fired
from the OnClose event of a "Close" button on the form). When this executes,
the Form does close (because pressing Enter will open it again from the
selected control on the form beneath which launched it in the first place)
but the Access UI completely freezes, with the form remaining displayed.
I've tried all t...
|
3 |
12/16/2008 6:33:01 PM |
|
|
resizing msoFileDialogFilePicker
I have an app where I use the msoFileDialogFilePicker. I must have clicked a
maximize button in the corner, because suddenly it is full-screen, and there
is no resize button. When I close the app and reopen it, then try to use the
file dialog picker it opens full-screen.
Is there any way to get it back to the smaller screen size?
Thanks.
Fred...
|
2 |
12/16/2008 6:29:02 PM |
|
|
Access, Outlook, and Word - Email Form Fill-In and db Update
REQUIREMENTS FOR EMAIL FORM FILL-IN AND UPDATE OF ACCESS DATABASE
1. Need individual recipients to review/update their “contact†information.
Some, without email will respond to a mailed form. For those with email, an
on-line form fill-in with a reply that updates an Access database is
preferred.
2. The Access pre-built tool for use as an email update mechanism works,
however, a te...
|
1 |
12/16/2008 6:27:01 PM |
|
|
Command Button to execute a Function
I have the following function that I want to execute onclidk using a command
button.
What code will run this (or any function) on click within a command button
Public Function AutoCompact()
CommandBars("Menu Bar"). _
Controls("Tools"). _
Controls("Database utilities"). _
Controls("Compact and repair database..."). _
accDoDefaultAction
End Function
Thanks
...
|
2 |
12/16/2008 4:51:01 PM |
|
|
Validating first input character
Win XP and MA2003
Currently have a TextBox control where user is required to input a
percent value as .25 as an example. How can I capture the fact that
the first character input is a "." and not a "2" or vice versa for
instance. If the input is not as required then MsgBox etc .....
I think I have to turn the number into a string to test it but can't
seem to find how to do that. I have s...
|
3 |
12/16/2008 4:29:40 PM |
|
|
use append in a form
INSERT INTO tabl1 ( [TAG], [Date Received], DPS, [P/N], DESCRIPTION,
CITY )
SELECT parts.[TAG], parts.DATE, parts.DPS, parts.[PART NUMBER],
parts.DESCRIPTION, parts.CITY
FROM parts
WHERE (((parts.[TAG])=[enter the tag number]));
this is the sql for an append query that i have. i created a form that
would use the query in the tag field and then display the addes
records to the tbl1 in my ...
|
1 |
12/16/2008 4:06:20 PM |
|
|
Conditional Formating or Continuous Form Record Formatting
Hi
I have another question.
I have a continuous form that I need to highlight certain records based on 2
or 3 criteria. If the criteria is met then all fields within the record (or
even the back colour of that record) must be changed to red.
I have the following fields on the form
fldStartBy
fldDeadlineDate
fldDeadlineTime
fldCurrentTime
fldTypist
fldStatus
Condition 1:
I...
|
2 |
12/16/2008 3:16:39 PM |
|
|
From 2003 to2007
Hi,
I converted my code from my previous 2003 version to the new access2007
version.
I get following error:
(I have to translate so could be a bit different)
error 13 during executing:
Types are not matching
The code:
Dim db As Database
Dim tb As Recordset
Dim kl As String, afd As String, jr As String
Set db = CurrentDb()
Dim sql As String
sql ...
|
2 |
12/16/2008 1:01:02 PM |
|
|
Bidirectional Dlookup
Is there a way to get a connection from database to a textbox
independent of the present form query?
Dlookup would be ok but it just retrieves data from database. I need
it both ways.
I use Access 2003.
Thanks
H. Martins...
|
11 |
12/16/2008 12:05:48 PM |
|
|
Who is logged in the duration of current connection
Hi All
I have an Access FE installed on users pc's (about 100). The BE is a SQL
Express db.
I need to find out who is connected to the SQL Server - what date/time they
connected and what date/time their session ended.
I have read a number of posts on getting a list of current users but is it
possible to keep a historical record of this information?
Ulitimately I need to use ...
|
2 |
12/16/2008 11:47:10 AM |
|
|
Brizar Exporting to Excel
Hello,
I'm rather confused to why when i use the in built "Analyze it with
Microsoft Office Excel" Feature from MS Access and use a filtered
table results or unfiltered table.
when the records have been exported to excel and excel opens straight
away, all information is their apart from one field "Notes" Access is
not Exporting the full notes that SOME records have,
i thought it could...
|
1 |
12/16/2008 10:50:54 AM |
|
|
HELP! My Subform cant trigger any Event.
help! someone.. this is driving me nuts & I don't get it..
I am doing leave application, currently reaching Cancellation of Leave.
A. Situation:
- Form 1> User Choose Type of Leave to Display (Eg: Child Care Leave, Annual
Leave) From Combo Box
- Form 2> Only consist of 1 Subform (With Empty Record Source) Allowdeletions
= true
B. Problem:
- When user Delete (using keyboard)...
|
8 |
12/16/2008 9:26:02 AM |
|
|
Handling Bugs
I develop software for schools. The system is quite an extensive database.
It contains over 100 forms with an average of about 8 printed pages of coding
per form. I distribute the software with a runtime version of Microsoft
Access 2000.
With all these forms and coding, I'm being haunted my minor bugs that keep
popping up now and then that close down the database, so the users have t...
|
34 |
12/16/2008 4:58:58 AM |
|
|
Controlling Input
Win XP and Access 2003
Currently asking user to input a % into a textBox as .25 for example.
How can I code a check that it is input as .25 and not 25?
I think I have to convert the input to a string in order to test it
but can't figure out how to do that. I have searched this "group" for
solution but cannot come up with one. Any guidance would be
appreciated.
Thanks as usual....
|
2 |
12/16/2008 12:30:04 AM |