|
Combo Box default value
...
|
1 |
21.09.2006 10:42:02 |
|
|
AddNew function in Access VBA
Hi,
I am using the AddNew function in VBA to populate my access table from
data in excel. The following is the piece of code:
With WriteRS
.AddNew
!column_Names(0) = "acctNo"
!B = "CoName"
!C = "acctMan"
.Update
.Bookmark = LastModified
End With
The column names in the access tables are A, B and C. If I hard code
these values it wor...
|
3 |
21.09.2006 08:58:11 |
|
|
Unable to edit
Within Access 2003 I have created a form based on a query which has 3 tables
and I am unable to edit this form.
What I need to do is allocate an Agent to a certain job but it will not let
me do this yet the field is not locked.
Any ideas as to how i could get around this problem?
Thanks...
|
9 |
21.09.2006 07:25:16 |
|
|
SubForm Control
Hi Folks - I have a subform control that displays related records.
Typically, there are 1-4 related records per master record. When the subform
has only one record, the subform control displays a lot of "gray space". If
it has two records, it displays a little "gray space". If 3 records, it
looks great. If 4 records, I get a vertical scroll bar.
Is there a way to get the subform control...
|
2 |
21.09.2006 04:29:25 |
|
|
format fields with a button
I've found some code here that allows me to lock & unlock forms with a button
- that part works great, but I'd like to change the format of the fields so
it's obvious which state it's in. i.e., greyed-out for locked. Can I add
something to this code (from Allen Browne originally, thanks allen!) to do
that?
Private Sub cmdLock_Click()
Me.Refresh
Dim bAllow As Boolean
bAll...
|
3 |
21.09.2006 02:16:02 |
|
|
Filter main form by subform
Is it possible to filter the records displayed on the main form through
records on a subform? That is if records on the main form will be displayed
only if they have the appropriate record on the subform. Thank you for any
help that you can provide....
|
2 |
21.09.2006 01:47:56 |
|
|
Help with combo boxes.
I am trying to use a combo box based on an existing table. I have set
up the combo box such that it filters the entries as follows.
Row Source = SELECT DISTINCTROW Members.* FROM Members WHERE
(((Members.Current)=Yes)) ORDER BY
Members.ID;
Where "Members" is a table and "Current" is a "Yes/No" field in the
table.
The problem that I have is that i...
|
3 |
21.09.2006 00:48:58 |
|
|
Close Form generates an "Enter Parameter" dialog with form maximized
I have a very strange problem with one of my forms.
I have a close button on the form which basically just closes the form.
And it works fine. But when I set the form's On Open event to
DoCmd.Maximize, the close button now produces an "Enter Parameter Value"
dialog - looking for Forms!frmName!IDName.
When I get rid of the On Open event, the problem goes away.
Any ideas?...
|
6 |
21.09.2006 00:12:14 |
|
|
Random Number list without duplicates in a range.
I could use some help with the following issue. I have a form that needs to
generate a random sample. The criteria is that a sample of at least 10 but
no more than 50 needs to be selected (based on pulling 10% of the items to be
audited). 0 cannot be a returned since the recordset starts at 1. This is
selecting items to audit, so there should be no duplicates. Also, when the
result s...
|
2 |
20.09.2006 23:10:38 |
|
|
Opening a form with empty fields
I have an input form that has three fields that will not show as "blank or
empty" when the rest of the form is blank. If I open the form to input a new
prospect, there is data in a field that belongs to a different prospect.
Thank you....
|
6 |
20.09.2006 22:32:02 |
|
|
Blank subform
I just converted a Access 97 database to Access 2003 and I have a subform
that is just blank (none of the underlying fields display at all). I ran the
recordsource (query) and it has records and is correct but the subform
doesn't work (just the background color displays)? I have never run into
this before?...
|
3 |
20.09.2006 22:21:02 |
|
|
How do I Expand a field with a mouse click instead of using SHIFT+
Does anyone know how to Expand a field with a mouse click instead of using
SHIFT+F2. The field in question is a note field and is one of many that very
often run over a few lines which become obscured du to the (necessary) size
limitation. Ideall, i would like to link the 'expand command' do a mouse
double click. I can't find any reference to Keyboard Calls for SHIFT+F2.
...
|
4 |
20.09.2006 22:05:20 |
|
|
Open Form
I have a database where specific user enters through a secured database.
When they click on "Open my assignment" they get an Open form cancelled
message and can't open their assignment. I have about 40 users and this is
only user who has this problem. I don't think its a permissions issue. I
also deleted her security account and started over but that didn't help.
(She was able to op...
|
1 |
20.09.2006 21:45:02 |
|
|
How to create an option group with multi-selectable check boxes
Hello,
Can someone please help me with creating an option group of check boxes in
which I can select multiple check boxes at the same time? It seems that the
option group that Access Wizard just allows me to select only one check box
a time.
Thanks,
Rocky
...
|
4 |
20.09.2006 21:44:04 |
|
|
Strange characters in textbox
I was looking at the data in a system I developed and came across some
strange characters in a textbox. They look like thick vertical bars but they
aren't the vertical bar character. When I click the zoom box the characters
appear as double quotes but not the double quotes on the keyboard, the double
quotes where the right one and the left one are different like // or \\. My
question is ...
|
1 |
20.09.2006 21:43:02 |
|
|
limiting values in lookup list
On a form I have a combo box that uses a lookup list to display values. The
row source type for the combo box is a query. I need to "Limit to List".
I would like to have the query return only values that are "active"
(there's an active indicator column in the underlying table).
I would like to display only active values in the drop-down list. But, I
want to display values in the co...
|
2 |
20.09.2006 20:20:02 |
|
|
Delete an Employee
I am new to Access and putting together a form for other users in the office
to use. When an employee retires/quits this form would allow you to delete
an employee. I chose the Delete Record from the command button, when I
choose an employee from a drop down list, it shows that employee but when I
click on the "Delete Record" command button it reflects the employee at the
top of tab...
|
8 |
20.09.2006 18:11:02 |
|
|
New Record On Open
I have read just about every entry on this site and have figured out how to
get to the OnOpen function in my database.
When I look at the properties of the form, I dont see any "OnOpen" event
listed. And I also can't seem to find anything on the "Data Entry" (where you
would put yes for the data entry property)
What am I missing? I can't find out where to put this code at all!
I wou...
|
7 |
20.09.2006 17:54:22 |
|
|
same insert into problem
Hi I am having a problem trying to get the data entered into a form
copied over into a second table. I would like to do that exact same
thing that I did in another from within the report only from a
different form into a different table and Access doesn't seem to be
liking my formula.
This is the old formula in my report that is working: This works,
taking fields [LN1] and [AMOUNT1] from t...
|
10 |
20.09.2006 17:53:41 |
|
|
Form_~TMPCLP...
I have several forms of this type, that I cannot see and I cannot delete them
as well. How can I erease them?
Thanks a lot, Lina ...
|
9 |
20.09.2006 17:22:47 |
|
|
Question about Cascading Combo Boxes
Hi all. I am a rookie, and trying to get my head around the cascading combo
boxes. I have searched and read a lot of the other posts on this topic, and
none seem to either make sense or make it work for me. My situation is this:
Tables: Markets, Collectors, Clients
Fields: Markets.Market, Collectors.Collector, Clients.Company Name
Combos: Market, Collector, Client
Form: 4-Call Log E...
|
4 |
20.09.2006 17:08:02 |
|
|
Returns to calling Sub before executing all of the code?
I have a Sub that renumbers records to allow for record insertion
anywhere in the table. For some reason the code returns to the
returning procedure after executing the LOC DoCmd.RunSQL(strSQL). I
have tried moving the last LOC above the DoCmd stmts and it returns to
the caller without executing any of the DoCmd stmts.
Any ideas why this may be happening?
Public Sub reNumber()
Dim new...
|
5 |
20.09.2006 16:57:40 |
|
|
How do I make a registration page to be able to e-mail them
...
|
2 |
20.09.2006 16:56:26 |
|
|
Broken Reference
This has happened a couple of times and I'm not to sure why and how to fix
it. I send out a new install of my program. I use the developer package to
package up the program for the install. I have one client that install the
program on her desktop and everything works just fine. When she installed
the program on her new laptop everything looks like it installed fine and
runs like it s...
|
2 |
20.09.2006 16:39:01 |
|
|
Combobox Display Problem
This appears to be my final frontier on the current project. All other
threads relating to it are now closed.
My data which displays in the Items Combobox of the Group Subform is,
finally, the right data. The problem is that when I click on an item in the
expanded combobox the pointer immediately jumps back tot he first displayed
record.
The Combobox has the controlling table of the ...
|
13 |
20.09.2006 15:51:51 |