|
BOLD A FIELD
i have a continuous subform which lists all the phone #'s and ctc
names for each customer and i would like to know if it's possible to
have the field the user selects to become BOLD once it is double
clicked.
ie. if there are 10 customer ctc's listed the user would pick the one
he wants and double click it - then only that contact would be bolded
(thereby making it easier to read)
is this...
|
2 |
11/26/2008 9:49:00 PM |
|
|
Combobox Question
I posted this before, but apparently the original post may have confused
some people. My apologies for that.
I have a form called Vendors that is bound to tbl_Vendors. tbl_Vendors is
normalized in that Cities, States, and
Postal Codes all have their own separate tables with a one to many
relationship--each has cascade update to prevent having to requery when
changes are made to an exi...
|
7 |
11/26/2008 9:46:20 PM |
|
|
Type Mismatch in dLookup
On strContact I keep getting a type mismatch error and I'm not sure why.
Below I pasted the code performing the DLookup and also the SQL for the query
the DLookup is searching. Me.ContactChurch is a combo box in the form and
Me.ContactLastName is a text box in the form.
What the code is doing on frmContactAdd is searching to see if someone from
the same church exists with the same last...
|
11 |
11/26/2008 9:42:01 PM |
|
|
What wrong is it?
Hi - Please help with this:
I have a form open, when the user click button search for a Lastname in in
the link table dbo_A. the problem is: it's alway FOUND the record, but
actually it doesn't.
Set RsA = CurrentDb.OpenRecordset("dbo_A", dbOpenDynaset, dbSeeChanges)
With RsA
If Not IsNull(Me.lname) Then
strWhere = strWhere & "([lname] = """ & Trim(Me.lname) & """) "
...
|
10 |
11/26/2008 9:24:10 PM |
|
|
How to bypass the first time user ID dialog with Access 2003
I'm setting up users on a terminal services box (windows 2003) with an
Access 2003 application. For each of these users, the first time they
run the db, it's also the first time they've run Access on that box, and
they're asked to provide user name and initials. That's an Office thing.
How can I make that dialog go away? Because they are launching the app
via shortcuts, the dialog intefe...
|
1 |
11/26/2008 9:12:50 PM |
|
|
List Box Column Data
I have a list box that is being used to display search results. The list
box's Row Source Type is Value List and it has 5 columns. I have a search
button that calls a function that generates a SQL statement based on the
completed fields. The results are returned in a RecordSet. I want to add
each record (which is made up of five fields) to the list box, but making
sure that each fiel...
|
2 |
11/26/2008 8:48:01 PM |
|
|
Access pages- add and delete record
Hello,
I have created a access page to be able to add or delete records,
i set up the Dataentry = true and
readonly to false
but i still get the error message when i click add
"you can't add a new record or delete an existing record becuase the
recordset fot this page is read-only"
i even dont see an empty line to enter data into.
any help?
Regards
--
Message posted via ...
|
1 |
11/26/2008 8:03:09 PM |
|
|
Not in List Event Error
Hi, All...
I have an Access 2000 database that has a bound form with bound combo boxes.
I want the user to have the ability to update a city after a prompt asking
to do so.
The code below was copied from another form that is unbound, and the
combobox is unbound. It updates just fine and moves to the next field on
the unbound form. However, when I use the same code on the bound form...
|
17 |
11/26/2008 8:01:31 PM |
|
|
remove clipboard prompt???
i created a macro which allows me to copy a record and paste it into
the same table then open the form and show me the new 'pasted' record.
the problem is now i keep getting the "you copied a large amount of
data into the clipboard...' prompt and wish to stop this from
happening. (btw i don't need the data in the clipboard anylonger after
it has been pasted)
can someone please tell me how...
|
1 |
11/26/2008 7:51:29 PM |
|
|
Find current username and store in temp table
Access 2003 on WinXP Pro or Win2003 Server.
How can I get the current username logged on to the computer, and store that
value in a temp table to use later?
On db close, the temp table record will be deleted.
I have a form that pops up after you do certain db maintainence and I want
to log information about the work completed, including the username. I do
not want the current user to ...
|
3 |
11/26/2008 7:22:13 PM |
|
|
DCount problem
Hi all,
Can anyone tell me why this codes doesn't work?
=DCount("[Status] = 'InStock'","Inventory Table","[Name] = 'hammer'")
I have this code on a textbox and it return all value that associate with
hammers regardless of the status ( Sold/InStock), any suggestion?
Thank
Mark
--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding...
|
7 |
11/26/2008 6:52:58 PM |
|
|
Dcount Type Mismatch
Hi there, I’m not great as a developer, but I have a small timesheet
application developed in Access (2000). I am trying to use Dcount in the
Before Update to warn a user if they have input a duplicate timesheet. The
tbl_Main is quite simple, it has three columns. A primary key, Text input
field and Date/Time input field.
The code works if I use either the text field (Chris) or the Week E...
|
8 |
11/26/2008 6:31:27 PM |
|
|
trying to get Filter on Subform to work with Multiselect in Listbo
Most of the code here is just FYI....my question really gets to the
TabCtl0_Change() event. The Filter works well with the Multiselect set as
None. How would I adjust the code to make the Filter work with Multiselect
set at Simple?
thanks
Private Sub Frame17_Click()
If Frame17.Value = 1 Then
List15.RowSource = "SELECT Format((DateDep),'yyyymm'),
Format(SUM(Amount),'currency'), Ac...
|
3 |
11/26/2008 5:59:01 PM |
|
|
can't get SELECT to work
Nothing is showing in List 13 on the click event...any ideas?
Private Sub List11_Click()
List13.RowSource = "SELECT DateDep, Account, AccountName,
Format(SUM(Amount),'currency')" & _
"FROM Deposits WHERE (((Fund)='" & List11 & "'))" & _
"GROUP BY Month(DateDep)" & _
"ORDER BY DateDep DESC;"
End Sub
...
|
13 |
11/26/2008 5:43:22 PM |
|
|
updating control
I have a textbox on a form that is a calculating control that sums the
amounts from about ten different textboxes. How can I get the calculating
control to automatically update each time there is a change in one of the
other textboxes??
thanks...
|
7 |
11/26/2008 5:40:00 PM |
|
|
Browse folder
Hello,
I would like to create a button in the form that allow user to select the
directory and specify the file name. I want to use this path and file name
to save the table in text format.
How should I do this?
Thanks,
...
|
2 |
11/26/2008 5:38:03 PM |
|
|
Trying to figure this out
I have created a button on my form. I have created a Query. I would like to
learn how to get the button control to execute the Query. Any advice would
be appreciated. Thanks....
|
3 |
11/26/2008 5:07:23 PM |
|
|
Use of Subform?
I have a one to many relationship between 2 tables, call them table A and
table B respectively. I would like to create a form that shows data from
each row in Table A and data from all of the corresponding rows in table B,
all on one form.
Table A.Order 1 Table A.Date of Order 1 Table A.Company
Table B.Item
Table B.Item
Table B.Item
I can't f...
|
2 |
11/26/2008 4:48:01 PM |
|
|
With error
Hi Groupies
I am trying to use Open Arguments to open a form and
find a matching inventory item. If the item does not exist
I want to go to a new record. I borrowed the code from an
old thread but I can not quite get it to work for me.
I keep getting "Else without If" when I compile the code.
Private Sub Form_Load()
If Len(Me.OpenArgs) > 0 Then
With Me.RecordsetClone
...
|
8 |
11/26/2008 4:43:44 PM |
|
|
why won't date sort by date and not by number or text
the date referenced below in code is sorting like....
September08
September07
October08
October07
instead of.....
October08
September08
October07
September07
Private Sub List13_Click()
List15.RowSource = "SELECT Format((DateDep),'mmmmyy'),
Format(SUM(Amount),'currency'), Account
FROM Deposits
WHERE (Account='" & List13 & "')
GROUP BY Format((DateDep),'mmmmyy'), Account
O...
|
5 |
11/26/2008 4:32:23 PM |
|
|
Subform Blank?
I have a form with a subform that is initially invisible. The user enters a
value on the main form, and the AfterUpdate event makes the subform visible
(the entered value is also used in a calculation within the query that feeds
the subform).
Problem is, the subform opens to a blank screen, nothing displayed. If I go
to design view, then back to form view, then change the entered va...
|
4 |
11/26/2008 3:19:02 PM |
|
|
Form filter gives incorrect results at first
I have a table with about 8000 parts (Access 2003). On my "search" form, I
allow users to enter search criteria, then I open another form (based on a
query of the parts table) to display their search results. This part works
fine. However, if they specify a certain kind of search criteria, I have to
change the query I use to get their results, so when I open the results form,
they'll get t...
|
8 |
11/26/2008 3:04:33 PM |
|
|
Alpha search to load a list box
I have a work order form with a list box. I would like to use the alpha
search that Steven Lebans uses on his site to load the list box with clients
starting with the letter that is selected. I have a label at the top of my
form A to Z. Does anyone know if I can load my list box using that code on a
new work order only. The already created work orders work perfect, when
choosing next...
|
6 |
11/26/2008 2:41:01 PM |
|
|
Relink question
I'm not sure this is where to post this question, but here it is anyhow.
Somebody who was working with me a while ago came up with the following code
to relink back end files. I don't know if it is adapted from the code at
the mvps web site, or what exactly. Tables may be in more than one BE
database. In particular, the Employee table is used by a number of
applications. I don't want...
|
29 |
11/26/2008 2:20:35 PM |
|
|
Ugh! I should know this...
Hi everyone! Happy Thanksgiving! I'm using A02 on XP and I should know this
by now but it's always just one little thing I miss. Darn it.
I have a record on my subform with a field [PlanNum] and a report with a
query that contains the field [PlanNum]. On my subform, I have a button with
the following OnClick:
DoCmd.RunCommand acCmdSaveRecord
DoCmd.OpenReport "rJanusLtr", acViewPrev...
|
7 |
11/26/2008 2:37:02 PM |