|
Listview resize scale with screen resolution
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 using MS access 2003.
Thanks
...
|
3 |
12/30/2008 10:02:44 PM |
|
|
CheckBox in PopUp form grayed out
I have a PopUp form (popup = yes, modal = no) that consists of a form and
subform. The subform is continuous and lists a group of people and certain
attributes. One of those attributes is displayed as a Check Box. When the
PopUp form is opened, the check box for everone's record is grayed out. If I
scroll down the list of people, the check boxes take on their correct
true/false appea...
|
6 |
12/30/2008 9:33:34 PM |
|
|
Custom Autonumber Help
Hi All,
Some one once created a very simple put useful auto number generator
the following code was used, and did what i needed.
Private Sub Form_Current()
If Me.NewRecord Then
Me!ProjectQNo = "Q" & _
Format(CLng(Nz(DMax("Mid(ProjectQNo,2,4)", "tbl_Projects", _
"Right(ProjectQNo,2)='" & Format(Date, "yy") & "'"), "0")) +
1, _
"0000") & Format(Date, "yy")
E...
|
7 |
12/30/2008 7:27:04 PM |
|
|
Updating a table using forms and combo boxes
I would like to do the following:
1. Pick item in combo box from a table that is used as a lookup. This
table also contains the description of the code. (Ex. Column 1 = shoe type
column 2 = colour)
2. Once picked, it would write the shoe type value into my data table
3. Also once picked, it needs to update the text box on the same form with
the colour of the shoe and also update the...
|
1 |
12/30/2008 6:58:34 PM |
|
|
Cascading ComboBox
I have read all the posts and links on this. I've seen 2 ways to make Combo2
contingent on Combo1:
1. Add this sql code to Combo2 property's Row Source:
SELECT DISTINCTROW [Table7].[zip] FROM Table7 WHERE ((([Table7].[city]) Like
[forms]![frmSimple]![combo0]));
and add the code:
Private Sub Combo1_AfterUpdate()
Me!Combo2 = Null
Me!Combo2.Requery
End Sub
2. Add code in the Af...
|
2 |
12/30/2008 5:51:31 PM |
|
|
Open form and filter form & subform using combo-boxes
Hi, (Using Office 2003, but in Access 2000 format)
I have a form that has 14 or so combo-boxes that allow a user to open
another form and filter the records based on their combo-box selections and
clicking the command button. I've had this working perfectly, but have
decided to add in a subform which now contains 5 of the 14 selection fields.
How do I alter the stlinkcriteria to filter...
|
3 |
12/30/2008 5:39:39 PM |
|
|
DoCmd.OpenForm opens empty subform
I use the following code in the OnClick event to open subform (variables
declared) with specific record(s).
---- CODE START ----
stDocName = "sub_Form_Name"
stLinkCriteria = "[ID]=" & Me![ID]
DoCmd.OpenForm stDocName, , , stLinkCriteria
---- CODE END -----
1) If records in the sub form exist - it opens OK, corresponding records are
shown.
2) If there are NO records, ...
|
4 |
12/30/2008 5:26:46 PM |
|
|
Changing subform properties by code Error
I have a database which has been running without a problem for a year. This
problem, which just started, occurs on about half the computers at a
non-profit. On the computers when it occurs, it occurs about 80% of the
time. All computers use Windows XP and Office 2003. All software has been
updated and all programs have been compacted and repaired.
This line of code occurs when the ...
|
6 |
12/30/2008 3:02:15 PM |
|
|
Open with one Access application another Access application
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 application visible
acc.Visible = True
I have another computer (Office 2007, Win...
|
12 |
12/30/2008 2:30:07 PM |
|
|
Sort data in combo box - unbounded
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
query. For example, if the first column in the query is called ColumnA, then
fol...
|
6 |
12/30/2008 1:42:01 PM |
|
|
delay in updating
I have what seems to be simple issue - but can find no documentation on this.
The refreshing of forms doesn't seem to follow the order of VBA code. Or
maybe the issue is that the speed at which things refresh cause it to appear
that the order is different. Here is the code:
Private Sub Returned_AfterUpdate()
Dim curCredit As Integer
Me.Refresh
curCredit = Forms![General]![frmContact...
|
11 |
12/30/2008 4:05:12 AM |
|
|
unload event "you canceled the previous operation" error
Hi Everyone;
I posted this question yesterday, but cannot find it. So, here it is again.
I have a form with a subform. If the subform is empty, I want to advise the
user. I have a message box, which asks them if they want to fill in the
subform. If they choose "yes", then the error "you canceled the previous
operation" pops up. How can I remove this error or fix what is wrong? ...
|
5 |
12/30/2008 3:35:00 AM |
|
|
Concatenate names
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 "membername". Please help and keep it simple for me, like I said, I
haven't used Ac...
|
6 |
12/30/2008 2:31:55 AM |
|
|
Return a default value in a textbox
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?...
|
5 |
12/30/2008 2:27:05 AM |
|
|
Adding to a Table list using a Form
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 in Table 2) or to type in a new City.
On Table 1, everything works fine: the n...
|
2 |
12/30/2008 1:30:20 AM |
|
|
Retrieving data from a table
hello to all
I have an application with about 40 forms and I want to control the size and
position of each of these forms when it opens. I currently do this with code
in each form's Open event like...
DoCmd.MoveSize 150, 250, 1100, 1850
But, I've noticed that there are only 5 different MoveSize settings spread
among all 40 forms. I'd like a way to put these moveSize values in a ta...
|
3 |
12/29/2008 11:24:00 PM |
|
|
Unload event "you canceled the previous operation" error
Hi: I am trying to advise the user that a subform is empty before they close
the main form. When "yes" is chosen, to not close the form, the form does
not close, but, I am getting a message " you canceled the previous
operation". On the Unload event, I have the following:
Dim intResponse As Variant
If SubfrmAssessment_Details_Admission.Form.RecordsetClone.RecordCount = 0 Then
intRe...
|
3 |
12/29/2008 11:11:01 PM |
|
|
Which event should I use for recordset changed
Maybe I didn't state clearly in my previous thread.
Let's make it simple.
In a continues form, when user press [F5] or the button [refresh] on the
ribbon, and the records count changed, Is there a way to know that?
Any clues would be appreciated.
Tony....
|
7 |
12/29/2008 10:04:05 PM |
|
|
data base connection runtime error 3211
i am building an application for our help desk to improve response time for
answering questions regarding insurance information. have an option group
that allows the help desk person to choose a specific region. based on that
option, a combo box generates a list of system names from our legacy systems.
based on that selection, another combo box generates a list of provider
specialties t...
|
3 |
12/29/2008 8:56:25 PM |
|
|
display an option group
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...
|
5 |
12/29/2008 8:26:01 PM |
|
|
User Idle Time Form
I've added the User Idle Time code and form from:
http://support.microsoft.com/?id=210297. It works great, with one little
problem. It is common for my users to have the same form and same control for
a fair amount of time, but not the same record. Any ideas about how to do
this? I tried adapting the code (shown below) to use the bookmark property to
see if the user has changed records, ...
|
5 |
12/29/2008 2:48:00 PM |
|
|
Combo box not displaying data
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 has 3 lines of information from the name to
another number and DOB. I have the dat...
|
2 |
12/29/2008 2:14:35 PM |
|
|
Access Date linked to SQL ODBC not working on Vista
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 filter the dates without any problems. The filter works for
all other data types o...
|
1 |
12/29/2008 1:37:14 PM |
|
|
Select Case questions
Good Morning!
Thought this would be an easy one to figure out, but apparently not today :)
I have a country table (tblcountry), and then three tables with cities
(tblUS, tblUK, tblFrance) - my plan was to use cascading combo boxes...the
two I am working with are cboCountry and cboCity...I want cboCity to update
with only the table from the selected Country (a US city if US is chosen)
...
|
10 |
12/30/2008 6:27:01 PM |
|
|
VBA code broke in migration from 2003 to 2007
I have some very extensive VBA code using Access forms for the UI. While
migrating from Access 2003 to Access 2007 I have encountered a problem with
the "visibility" of subform controls and their properties in my VBA code.
One of two things happens when the problem occurs:
1. The code behaves as if I have put in a "On Error Resume Next" statement
and ignores any problems.
2. I get the ...
|
8 |
12/29/2008 5:12:52 PM |