|
Saving multiselect selections
Hi, I have a multiselect list box on a form, and I need to execute an
insert query for each item selected in the list to save each selection
on a separate row in the table, along with the candidate ID for that
particular record. How do I do that?
Thanks!!!
(more info here if necessary:
http://groups.google.com/group/microsoft.public.access.queries/browse_thread/thread/41445cfc30daac3e#
...
|
2 |
11/11/2008 7:11:23 PM |
|
|
Access03 form does not display records on open
I have a simple form based on a simple query. No records display when
the form is opened, but Records | Remove Filter/Sort on the menu bar
causes the records to display correctly.
I can find no combination of Me.Requery or Forms![frmName].Requery on
any of the form events (Open, Load, Activate) that will cause the
records to display.
I added a simple SendKeys statement to the On_Open of ...
|
6 |
11/11/2008 6:02:18 PM |
|
|
Acess 2003
Could you please see what is wrong with this formula, because it doesnt give
the right result. I think the criteria isnt well written.
DLookup("[Descrição_Artigo]";"Tipo_artigos_stock";"[Tipo_Familia_Stock]=[Familia]"
and "[Tipo_SubFamilia_Stock]=[SubFamilia]" and "[Refª_Artigo]=[refª_produto]")
thank you
...
|
7 |
11/11/2008 6:00:12 PM |
|
|
Yes/No Field
I've searched for an answer to this.
I have four fields on a form that require Yes/No answers. Originally I used
check boxes but the user wanted to force a response, or at the very least to
show a default "No" so that the responses wouldn't be overlooked.
I'm using the response to the four questions in a series of tests to prove
or disprove whether a property lease can be treated as...
|
5 |
11/11/2008 4:52:15 PM |
|
|
Bookmark Error
I use this code below to open a form in dialog mode, make changes, and on
close requery the calling form and go to the record that I was on. I use this
book mark code all the time. But this time I am getting an error. My code and
the error are below.
The calling form is based on a query.
Thanks in advance.
Dim stDocName As String
Dim stLinkCriteria As String
Dim vB...
|
3 |
11/11/2008 4:43:02 PM |
|
|
#name?
Hi,
I have a form based upon 2 tables linked through an ID number
When I assign one of the linked table to an entryfield of the form I get
a #name? in this entryfield.
I picked the name of the linked field out of the list of available
fields so I think there can not be a mistyped name..
What can cause this?
Thanks
JP...
|
2 |
11/11/2008 4:29:12 PM |
|
|
timing problem
Hi,
I have a bound form with 2 pushbuttons to open a report based upon this
form.
There are a lot of checkboxes on the form..
When I change one and click the pushbutton the report don't show the
modified checkbox.
When I close the form and click the pushbutton again, the modification
is shown correctly...
There must be a way to avoid this...
Any help is welcome
JP...
|
3 |
11/11/2008 2:31:26 PM |
|
|
Handling odbc errors on a sql server backend with a bound form
Is there any systematic way of intercepting the error messages from sql
server on a bound form?...
|
4 |
11/11/2008 2:12:14 PM |
|
|
HOW CAN I MAKE A PARAMETER QUERY RUN AGAIN ON A FORM?
I have a form which starts with a parameter query on a combo box and finishes
with an ‘Add New Record’ button.
The parameter query asks for a text phrase and returns options that match
text inputted. These results appear in the combo box list.
An item can then be chosen from the list after which, other criteria on the
form can be completed. The last stop on the form is the ‘Add N...
|
3 |
11/11/2008 11:00:03 AM |
|
|
Show or Hide Controls on Form
I am setting up a very simple database in Access 2003 which will keep track
of various bits of equipment. I have a drop-down combo called "InFrom" that
will show where the equipment has come from and beside it I have a text box
"Other" which will contain the further details. The combo has the following
options: Local, Import, Other. If I select Local or Imported, I would like
the "Other" f...
|
2 |
11/11/2008 6:48:09 AM |
|
|
locked table
This is hard to explain... please be patient!
I created a form, clickin a pushbutton runs some code which finaly
should generate a report.
The report is based upon a table linked to another one (let's name it
XYS) by an ID.
When I run the code from a form I get an errormessage sayin (and I have
to translate the syntax):
The database engine can not lock the table XYS because it is u...
|
12 |
11/11/2008 2:28:39 AM |
|
|
HOW TO SHRINK OR GROW COMBO BOX
Hi Guys,
I have a form with several comboboxes and textboxes. I find the Can Shrink
and Can Grow properties of the textboxes very handy, especially when thier
data is nil or exceed the space I have provided when I print the form. Is
there a way I can make the combo boxes behave the same way?
--
Glint...
|
9 |
11/11/2008 1:54:21 AM |
|
|
Hiding fields on a form based on lack of data in another field
I am attempting my first database that will need VB/VBA coding. I am very
new to VB/VBA and need a little jump start.
The database is to track unit rework that has to be performed due to product
mishandling. It is a very small database at this time (only 3 tables):
tblUsers, tblSecuritySettings, tblUnitData
The security table is set up to identify Operators, Supervisors and QA
A...
|
10 |
11/10/2008 9:49:43 PM |
|
|
Sub Form Code
I need to clearify whether or not my form naming convention is preventing my
code from running. The main form is named "frm MainMenu" and the subform is
"frm Options", and yes there is a space after the m, it makes it easier for
me to read it.
Now on my main form in the afterupdate event of the "WorkOptions" option box
I am grabbing the value and trying to change the recordsource of the...
|
4 |
11/10/2008 9:47:29 PM |
|
|
Filtering form from another and make visible/hide
Hello,
I've tried these groups before and been helped tremendously, thanks!
I have a database that I am working on right now that has me really
confused. I am being asked to develop a database that tracks projects
for our agency. This is what they want:
Form with drop down menu with each department (done)
From the form above, have another form "appear" that shows the
employees related...
|
9 |
11/10/2008 9:38:14 PM |
|
|
SP 3 udpate
Our Access 2003 just get SP 3 udpate during the weekend.
some of dropdown does show the records.
It was working last Friday, before udpate.
Any dropdown issues reported for SP 3?
Your help is great appreciated,
...
|
2 |
11/10/2008 7:17:40 PM |
|
|
Can't view table records in datasheet view
I have a form that I use to add contact and event particpation records to
their respective tables in an Access 2007 database. If I open the tables in
datasheet view Access does not display all of the records. I have a function
in a module that I use to return a record count for a given table. In the
case of tblContacts where 17 records are displayed, there are actually 377
records. In...
|
4 |
11/10/2008 6:36:43 PM |
|
|
Pop up message when selecting a specific option in combo box
Hi
I need help with the following. I have a combo box in a form with 3 options
to choose from: Open, Closed, Parts on order. I want to display a pop up
message only when "Closed" option is selected. How do I do that?
Thanks a lot for any help you can provide.
...
|
3 |
11/10/2008 5:49:01 PM |
|
|
DoCmd.RunSQL - Help
The value I need inserted into FIELD is: TRS*T3*105*081031
The value that is inserted into FIELD after running the code:
TFS*T3*"105"*"081031 (notice the extra quote marks)
Also receiving the message: Invalid use of Null
What am I doing wrong? Thanks for your help.
THE CODE:
Private Sub Command17_Click()
On Error GoTo Err_Command17_Click
Dim LineCount As Variant
...
|
7 |
11/10/2008 5:27:41 PM |
|
|
Search Form Adds a New Record
I just created a search form (very basic) that I linked to Query Criteria,
when i put the number into the text box and hit enter, it auotmatically
updates the subform in the same form. I really like just hitting enter, and
getting results, but the problem is that it adds a record of whatever I have
typed into the text box. What can I do to fix this.
--
Message posted via AccessMonster.com...
|
2 |
11/10/2008 4:56:58 PM |
|
|
Work tables
I may have already tried to get an answer to this, but not worded the
question correctly.
Is there a preferred way of allowing multiple users to update an Access Bill
of Materials database.
I have tried adding a "UserName" field to the work table.
I have thought of copying the layout of the work table to a table whose name
includes the UserName.
I wondered whether to use a copy of the ...
|
6 |
11/10/2008 4:33:18 PM |
|
|
Input Box entry to a table ?
I must place some code behind a command button (on a Form) that would prompt
the user for a batchID num , then add that input to a table field (BacthID)
Please advise the most feasible way / method
--
Thanks for your valuable time...
|
5 |
11/10/2008 4:31:03 PM |
|
|
filter on and off
I have a form that certain fields will be filtered against by the users.
What they are looking for is a simple way to filter. I can do double click
on the field (which they prefer) to filter using the "DoCmd.RunCommand
acCmdFilterBySelection" but would like to be able to double click again and
return all the records. How would that be done?
Thanks...John...
|
2 |
11/10/2008 4:26:03 PM |
|
|
How to filter List Box based on multiple Combo Boxes
Good day Everyone,
I have a List Box (lstData) and three Combo Boxes (cmb1, cmb2 & cmb3).
I want the List Box to auto-populate based on the selection made from
the three combo boxes (or one, or what ever many combo boxes were selected).
In the beginning, display all the data and then narrow then down as you
select from the Combo Boxes.
Thank you,
Adnan
...
|
8 |
11/10/2008 3:19:25 PM |
|
|
Error 2042 in Excel ActiveX Control
Hi everyone,
Has anyone ever used the Excel ActiveX control in their forms or know of a
good reference?
I have the OWC11.Spreadsheet.11 control on a form and I am able to set cell
values but have been struggling with trying to use Excel functions. For
example, I am trying to find the row number of a cell with a certain text
value using the MATCH function and I get an error (2042).
...
|
3 |
11/10/2008 3:10:12 PM |