|
Determining DPI of user's monitor
greetings
from within Access code, how can I determine the DPI setting of the user's
computer? (the value found in Control Panel/Display/Settings/Advanced/DPI
setting)
--
Thank you in advance
cinnie...
|
3 |
12/29/2008 10:16:15 AM |
|
|
test msg
test msg...
|
2 |
12/29/2008 3:17:26 AM |
|
|
SUPRISE...!
http://navayuga.blogspot.com/...
|
1 |
12/28/2008 3:42:54 PM |
|
|
Count by Month
I have a query that gives me totals by date. I would like to ge the totals
by month but the field is a date field (12/12/2008). How would I remove the
day and get a count of how many for Dec 2008?
Thanks
--
NotGood@All...
|
6 |
12/28/2008 10:20:20 AM |
|
|
Calendar 2 part question.
I have created a calendar with the days,month and year control,but the
calendar does not allow for multiple date selections. I think I may need to
place a start date and end date on the calendar form,but I am not sure how to
configure them.
Second part of question I have a query behind the form where the status is
set to a closed criteria. would it be possible to use a global on the dat...
|
2 |
12/28/2008 1:25:34 AM |
|
|
Simple password
Hello,,
After I modified, I used the sample of Access sample switchboard as my menu
in opening my database. Anyone can help me in making a password by just
clicking 1 menu of this. I can make it thru Swithcboard Administrator, by
running a code on it, but I do not know how to make a code so that by
clicking 1 switchboard item, it will shows Message box asking for password.
So the cod...
|
3 |
12/27/2008 10:39:00 PM |
|
|
Modifying Command Button
I'd like to add a command buttons so that each one is dedicated to Find in a
specific data field, eg a button to search for last name, another to search
for company name. And so there'd be a macros for each button. How do I
modify the script so that it goes to a specific field? Below is the default
script. If someone could tell me what and where I need to add to the script,
that woul...
|
4 |
12/27/2008 2:03:14 PM |
|
|
test
test msg...
|
1 |
12/27/2008 12:23:01 AM |
|
|
Printing forms with date range
Happy Hollidays ...
Is there any way to print the date range of forms...ie...
date range would be the 1st to the 15th. There could possiblely be 40 or more
forms in this date range.
Thanks for the help
...
|
2 |
12/27/2008 12:03:28 AM |
|
|
Unbound controls to create records
I have a form with unbound controls that i need to use to create records in a
single table. I have figured out a way to do this (see code below), but dont
think that it is the best way. Can anyone help me clean up the code below?
I will have about 6 more controls to add to it once i am done. Thanks.
Dim strSQL As String
Dim strUnitID As String
strUnitID = Me.UnitID
If Me.txtMillwor...
|
2 |
12/26/2008 9:59:46 PM |
|
|
How is 869343 less than 869330?????
This is the code that for some reason isn't following standard mathematical
logic. In my current record, Me.Odometer = 869343. The last Odometer
entered was 869330. My Invalid Odometer message pops up. I put a code break
to see what's happening. varPrevOdometer is showing 869330 and Me.Odometer
is showing 869343. However, it's still going thru the steps as if 869343 is
less than 86...
|
10 |
12/26/2008 9:16:40 PM |
|
|
capacitor
A capacitor is an electrical/electronic device that can store energy
in the electric field between a pair of conductors (called "plates").
The process of storing energy in the capacitor is known as "charging",
and involves electric charges of equal magnitude, but opposite
polarity, building up on each plate.
http://electronicstopics.blogspot.com/2008/10/capacitor.html...
|
9 |
12/26/2008 8:44:58 PM |
|
|
User Idle Time Form (2nd post)
Sorry, my computer cannot find my original post on this. So, here goes again.
I have a form to detect user idle time - adopted from 'from
http://support.microsoft.com/?id=210297. It works just fine. My only problem
is that I have users that are in one form and often using the same control
for more than 20 minutes. The record should be changing. I tried to adapt the
code (below) to set a...
|
2 |
12/26/2008 6:15:37 PM |
|
|
Dynamic field
there are 4 fields in a table/form (3 of them are checkbox and one text) so
the question is:
How i can store a value for each time user puts a checkmark on individual
fields.
Example:
option1 (yes/no checkbox)
option2 (yes/no checkbox)
option3 (yes/no checkbox)
result (text)
when user puts a checkmark on option1 so "New York" should be stored in the
text field and when user puts c...
|
2 |
12/25/2008 3:47:05 PM |
|
|
Allen Browne Calendar Code
I am using the Popup Calendar from Allen Browne.
Does anyone know why the line :-
'On Error GoTo Err_Handler
is remmed out on the cmdToday_Click, Form_KeyDown and Form_Open events
on the frmCalendar form. It probably doesn't matter but just wondering
if there is a reason for this.
Peter Hibbs.
...
|
3 |
12/25/2008 12:28:54 PM |
|
|
Modifying Delete Button code
In my form I have Delete Button coded by the wizard with some modification as
follows:
Private Sub btnDeleteAsset_Click()
On Error GoTo Err_btnDeleteAsset_Click
If MsgBox("Are You sure You want to delete this asset?", _
vbYesNo + vbExclamation, "Attention!") = vbNo Then
Me.Undo
Cancel = True
Else
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd...
|
3 |
12/25/2008 10:56:54 AM |
|
|
Point of Sale
Hello,
I know this is not the correct forum for this question, but I am not sure
where to go to find the answer. I am hoping someone can give me some
direction.
I am basically looking for any information on how to use Access in a Point
of Sale application, primarily the request for payment portion of a
transaction. I have developed small applications using bar code readers for
in...
|
3 |
12/25/2008 4:11:54 AM |
|
|
Major Advise Needed
Hi All,
Need some help, cant seem to get what i want to work?
So I have a fully working Database that is populated with Enquirys?
and one of the fields i have added is a "Exporttocontracts"
Ive then created a separate table in a contacts back end, and the
theory behind what i want to do is all the projects that have a tick
in the field "Exporttocontracts" when i run an append query the...
|
2 |
12/25/2008 4:07:25 AM |
|
|
Control Source Dependent on Combo Box
Hello,
I have a drop-down list on a form with several years (2005, 2006, 2007). I
also have a Table which has 3 columns of data (i.e. for 2005, 2006 and 2007).
I would like the control source of a single text box on the form to be
dependent on which year is selected. Any idea how to do this?
Thanks!...
|
3 |
12/25/2008 3:05:33 AM |
|
|
Combo Box Add Item Error
Hi everyone, (Merry X'mas in advance)
1. I had a combo Box.RecordSource = Table/Query
2. No problem with retrieving value from query to Combo Box
3. Now Problem, Append value from one of my controls unto Combo Box
4. I tried AddItem But can't achieve (Please see below code)
counter = StaffName_ComboBox.ListCount
counter = counter + 1
StaffName_ComboBox.AddItem User...
|
5 |
12/25/2008 12:27:12 AM |
|
|
Using a Query in a Form
MERRY CHRISTMAS EVERYONE!
I just had to do that. Well, on to the problem. I've got a form for data
entry with the control source as the main table...I've also created a
duplicate of the same form with the control source as a query in order to
find data by the primary key and edit the record. I don't like this though.
Besides, after listening to all of you MVP's I'm really getting the pi...
|
5 |
12/25/2008 12:26:22 AM |
|
|
Customize Autonumber
Hello,
I am trying to make an autonumber have IN(yy)-nnn, I have used the forms
BeforeInsert function to write the code, but nothing I have tried is working.
Any help out there would be appreciated. ...
|
3 |
12/24/2008 10:50:53 PM |
|
|
'Tag' property of combo box
Can I store the date/time the combo box entry was selected in the tag
property and read this value later. E.g.
Me!cmbBox.tag = Now()
Is there any reason why this would not work?
In the form before update event, I need to know the exact time when the
combo box was last changed.
-- Dorian
"Give someone a fish and they eat for a day; teach someone to fish and they
eat for a lifetime"....
|
8 |
12/24/2008 6:27:59 PM |
|
|
Coding help run-time error '3464'
I have a form with 3 combo boxes in which I want to use to pull information
from a report. Orginially I had only one combo box in which I was able to
get to work using the following code.
Dim StrWhere As String
StrWhere = "[Contractor] = """ & Me.Combo0 & """""
DoCmd.OpenReport "coding", acViewPreview, , StrWhere
then I added to other combo boxes and tried using the following code ...
|
10 |
12/24/2008 5:19:14 PM |
|
|
property is too long
I have a situation in running a report. I go thru a listbox and select all
the locations (100+). I go thru a second listbox and select all the accts
(30+). This is actually building a where clause. This all worked last year
at year end but this year there are more locations and accts.
As the report begins to run, I get the following message;
"The setting for this property is too ...
|
3 |
12/24/2008 5:06:54 PM |