Listview resize scale with screen resolution
Tue, 30 Dec 2008 03:07:20 GMT
Hi,
I have search on the web and have found limited help on this scaling of
listview when a form is scaled or resize. I have a listview that populate
some data. however, I want the listview to scale down to different screen
resolution. Could someone provide a sample VBA code or guidline on doing this.
I am usi ...
|
Adding to a Table list using a Form
Mon, 29 Dec 2008 16:21:00 -0800
Bear with me while I try to explain my problem:
Table 1 has two columns: CustomerColumn and CityColumn. I have created a
form which allows users to add customers to Table 1. A combo box (cmbCity)
on the form allows the user to either select a city from a drop down list
(which references a list of cities i ...
|
Sort data in combo box - unbounded
Mon, 29 Dec 2008 15:45:01 -0800
I have a code (se below) that will populate a combo box (unbounded) using the
â??columns headingsâ? name from a query (qryUsers). The question I have is: how
can I sort (Ascending) the data in the combo box? Right now, it appears that
the sorting order is the same as the columns order (left to right) in the
...
|
Return a default value in a textbox
Mon, 29 Dec 2008 14:17:02 -0800
I have created a form with a dropdown list of Names referenced from Column A
in Table 1. I would like a textbox on the form to automatically display the
appropriate phone number in Column B of Table 1. How is this done? ...
|
display an option group
Mon, 29 Dec 2008 08:48:01 -0800
developing an application for our call center.
i want an option group to display only when a field in the table is greater
than zero.
how do i code that? can build option groups with no problem, but can not
determine how to display based on other conditions.
thanks for your help ...
|
Concatenate names
Mon, 29 Dec 2008 14:13:10 GMT
I'm using Access 2002 but I haven't used Access for awhile and I forget how
to perform a simple concatenation. I have a table that lists member's name
and spouse's name and on a report I want to concatenate them so that it looks
like "membername & spousename", but if there is no spouse it will just look
like "m ...
|
Combo box not displaying data
Mon, 29 Dec 2008 06:10:01 -0800
Over the years forms have been working great from a 97 Access db. Zoom to
today and for some reason it's not, and no matter what I have tried, I can't
get the employee names to appear in the combo box.
The user is to select a name from the list and the employee id is then
stored in the field. The field ha ...
|
|
|
Access Date linked to SQL ODBC not working on Vista
Mon, 29 Dec 2008 05:37:14 -0800
Only on machines with Vista OS, when I go into any ODBC linked (SQL 2005)
table and try to filter any date (just by clicking on the the Filter By
Selection button) I get the error message, "Microsoft Access has stopped
working" and it closes the db down. The same database works fine using
Windows XP, I can f ...
|
SUPRISE...!
Sun, 28 Dec 2008 07:42:54 -0800 (PST)
http://navayuga.blogspot.com/ ...
|
Open with one Access application another Access application
Sun, 28 Dec 2008 13:17:13 GMT
Hello,
I'm using the following VBA code to open with one Access application another
Access application (Office 2003, Windows 2000) and it works great:
Dim acc As New Access.Application
'Open the database
acc.OpenCurrentDatabase "Path.mdb", False, "Password"
'Make the appli ...
|
