|
Multiple Reports for Listbox
Dear All,
I am reposting this as I have not got any response to my earlier posting. Can
someone please help
I have a form with a listbox lboemployee which has a record source
tblEmployee. I have a report Employee Sales for the Month.
I want to print individual reports for each of the employee as a separate
report when cmdprintreports is clicked.
I want to avoid printing one report at a ...
|
12 |
11/10/2008 2:16:46 PM |
|
|
A couple lingering multiple form instances questions
Hi All,
I've created a collection for storing instances of the form I want to
open multiple copies of. I've placed the collection in the module for my
LeftNav form. This form is the first opened by the program when it boots,
never closes, and is always visible until the program is shut down. All
the code that manages my visible forms is already in there. Is there a
reason to ...
|
2 |
11/10/2008 6:39:31 AM |
|
|
form problem
I created a form from a query. The query woks correctly, but when I open up
the form, I can't add records....any suggestions??...
|
4 |
11/10/2008 3:30:32 AM |
|
|
Print Current Record From A Form
Hello,
Using Access 2002
I am trying to print the current record from a form. I do get the report
using the below listed code. However, I don't just get the current
information on the subform, I get all the information on the subform and I
just want the data from the displayed record. Any help will be appreciated.
Private Sub cmdPrintCurrentRecord_Click()
Dim strWhere As St...
|
3 |
11/10/2008 12:45:01 AM |
|
|
read only form - command buttons
I have a form that I use for adding new records. I then later open the form
in read only. Is there a way to not display a command button when I open the
form in read only....
|
6 |
11/9/2008 10:49:01 PM |
|
|
Form Wizard Not Working in 2003 after Loading 2007
I have both versions of Office (2003 and 2007) loaded on my machines. I have
not experienced any problems until now. When I try to use the Form Wizard
and run any macros in Access 2003, it will not work.
When I go to run the macros I created in 2003 in 2007, they work.
Does anyone know of a patch for this?
Thank you!!! ...
|
4 |
11/9/2008 10:36:44 PM |
|
|
Macros in 2003 and 2007
I have both versions of Office (2003 and 2007) loaded on my machines. I have
not experienced any problems until now. I can create macros in Access 2003,
but when I try to run them they will not work. However, if I try to run them
in 2007, they work.
Does anyone know of a patch for this?
Thank you!!! ...
|
2 |
11/9/2008 6:00:54 PM |
|
|
previous record+1 as default
I have frmPO (main form) with frmPODetail (subform) as one to many
relationship tracking purchase orders. When entering record in subform, how
to have previous record plus 1 as default of current record?
For example: if user enter 1000300001 in LACCDTag as first record, on enter
of 2nd record, how to give 1000300002 (numerical) by default?
LACCDTag Description OtherFields
100030...
|
5 |
11/9/2008 2:24:41 PM |
|
|
default number from 2nd record
I have a frmPO with subform frmPODetail to track Purchase Order. It's one to
many relationship (one PO can have one or more items in PODetail).
When user enter record in subform, in Tag field (number type), if user type
1001 in the first record, how can I give 1002 on the second record as
default if that PO has more than one items?
...
|
2 |
11/9/2008 2:21:46 AM |
|
|
Keeping OpenArgs around: Hidden textbox or Private global variable?
Hi All,
The title says it all. Somewhere, way back in time, I got in the habit
of setting a Private local variable in a form's module if I needed to keep a
value around from the OpenArgs. A couple of folks have recently suggested a
hidden textbox for this.
Is there an advantage to one over the other? Going even farther back
in time, I know global variables are generally ...
|
7 |
11/9/2008 12:40:03 AM |
|
|
Acess2007 Field name change prompts Enter Parameter Value in Form
I have changed some field names in a table; just closed the gaps, and
although they reflect in the query as well as in the the control sources
of the form, when I open the form I am asked to Enter a Parameter value
for the first field I changed.
Is there a way round this to stop that happening, and just open the form
as before?
Thanks...
|
8 |
11/8/2008 7:32:45 PM |
|
|
Escalation on form
Hi there
I have a form for advertising clients, and on that form is a
"DateOfPlacement" field
this is the date that the ads for that client goes out.
then i have a field for "Duration", which is the length of the contract
:6,12,24,36 months - this field is set to "number"
now i have a field called "ExpirationDate", and i want this field to
calculate the date that the contract expir...
|
4 |
11/8/2008 6:28:33 PM |
|
|
Multi-Field Primary Key w/Listbox
In Access 2002/2003. I would like to launch a pop-up continous form showing
SEGMENT (below) by double clicking on an item in a list box based on
ASSIGNMENT (below). My tables have multiple fields which make up the primary
key but the listbox "value" is limited to one field. Is there any way to do
this? The structure is something like this:
CLIENT ENGAGEMENT ASSIGNMENT SEGM...
|
4 |
11/8/2008 5:41:00 PM |
|
|
Syntax error
I'm trying to adapt the following code to filter a user form, but I
keep getting the following error:
Any help would be greatly appreciated.
Runtime error 3075
Syntax error (missing operator) in query expression 'Media Type LIKE
'*P*"
Code:
Private Sub cmdSearch_Click()
If Len(cboSearchField) = 0 Or IsNull(cboSearchField) = True Then
MsgBox "You must select a...
|
6 |
11/8/2008 4:35:19 PM |
|
|
Forms - Getting specific info from duplicate information
What I want to see is when I do a search for example for ABC Company
I would like to see all of the directors, shareholders and officers
associated with that company. I think that the table I am using may be
interferring. I imported an excel sheet for my table. This is the data that
our old database exported to excel.
Company Name Incorporation # Date of Incorporation
ABC Company 12...
|
5 |
11/8/2008 3:30:54 PM |
|
|
Access 2003 - Keyboard Shortcuts for International Characters
I am creating a database to hold the names of famous artists. Some names
are French and include characters with diacritical marks such as the acute,
grave, or circumflex. Microsoft Word allows the use of keyboard shortcuts
to type international characters, but I can't find a way for the user to do
this in Access. The only solution I can find at present is to provide a
text display of ...
|
2 |
11/8/2008 12:49:26 PM |
|
|
Passing a value from One control to another control with 2 columns, one hidden
Hi,
I'm trying to set the value of a combo box to a value in a control on
the form it is loading from using the following code. All of the
controls below are textboxes other than 'Manager'. I cannot figure
out how to set the value of a combo box with multiple columns. It
gives me an error saying 'Object Required'
By the way, all of the following work fine with passing the value
excep...
|
2 |
11/8/2008 3:52:18 AM |
|
|
Filter in subform
Hello!
I need a help to crate a form with subform based on filter criteria.
I have tables:
Category
Post
Person
Order Detail
Order
In Category I have three fields yes/no (checkbox)
In Post I have ZIP and Post Name
In Person Name, Surname
….
Now I would like to create a form with subform where I can select person name
with dropdown menu. But records (names) in this Dropdown m...
|
2 |
11/8/2008 1:40:03 AM |
|
|
Switchboard disappears
Hi, can you help?
I created a Switchboard (SB) with Switchboard Manager (SM), made it my
default and told Access to open it when the database was opened. I went into
its Design mode and adjusted the size of one box (trying to change the font
size). The box disappeared. Then, the whole SB disappeared from the database
window. But, it's still listed in SM (I can edit it and everything)....
|
5 |
11/7/2008 11:51:01 PM |
|
|
Auto maximizing?
Hi
I would like my forms to automatically open "maximized".
Also, i have noticed that the form sizing can be ok on my laptop and fit
into the screen, but when i open the
database on my desktop pc, the forms are too large, and you need to scroll
down to see the rest of the form?
how can i ensure that all the forms will open - maximized (i dont want to
see the "file, edit, view" opti...
|
4 |
11/7/2008 11:22:59 PM |
|
|
Selecting a record from a combobox
Hi there
I have a form for "Advertisers" which is a form that includes contact info
for my advertisers.
i have created a seperate form, and on this form, i want to insert a combo
box where i can select
an advertiser from, and then when i select the advertiser in the combo box,
i want my "advertisers" form to open, showing that specific advertiser i
selected
please help
thank u
Me...
|
3 |
11/7/2008 10:38:26 PM |
|
|
How to Limit Memo to 1500 Characters
I am a new user looking for a simple solution (I don't write code) to limt a
memo field to 1500 characters. Is there a way to do this using the Validation
Rule?...
|
9 |
11/7/2008 10:23:02 PM |
|
|
Form based query/Filter
I am trying to create customized reports based on a 24 field access table.
The reports need dynamically selected columns and need to be filtered and
sorted on the fly. The users of this form (or whatever) are computer novices
so I need to design this to be simple to use. I have been planning to use
access to do this but at this point I am open to suggestions.
I am in way over my head an...
|
8 |
11/7/2008 9:20:05 PM |
|
|
Selecting a record from a combobox
Hi there
I have a form for "Advertisers" which is a form that includes contact info
for my advertisers.
i have created a seperate form, and on this form, i want to insert a combo
box where i can select
an advertiser from, and then when i select the advertiser in the combo box,
i want my "advertisers" form to open, showing that specific advertiser i
selected
please help
thank u...
|
2 |
11/7/2008 8:27:49 PM |
|
|
Locking A Boolean Field In A Table To Only Allow One True Answer
Hi,
I have a form with a subform (datasheet view) that displays records in
a table. There is a checkbox there where the user can select the item
and then hit a button that says 'View'. I want to lock the table so
that only one record can be checked true at a time. How would I do
that? I was thinking about writing a loop that cycles through the
records in a table and evaluates every oth...
|
4 |
11/7/2008 8:02:00 PM |