Auto number records when a form opens
Sat, 20 Mar 2010 13:43:02 -0700
Hi,
I have a table that contains fields: Title, Location, etc. and a number
field. Is it possible than when I open a continious form that displays the
data from the table that the number field would be changed to reflect the
order of the records in the form? In other words for the first record the
number ...
|
Repeating data in table
Sat, 20 Mar 2010 19:06:48 GMT
I am trying to start simple and understand some of creating a dbase. However,
I want to develop a dbase to handle bank statements. Each client (using ssn)
can have several bank accounts. I have set up the form to gather the client
info, bank info, and of course the account numbers. How do I create a form
to ...
|
Concatenate form fields and include linefeed
Sat, 20 Mar 2010 00:25:01 -0700
Access 2003 Question.
I want to concatenate some table fields into a single text field in a report.
Basic concatenation works OK but I cannot get linefeeds to work. Every way I
try I just get square boxes and no line feeds.
Will very much appreciate it if I can get either confirmation that it can't
be ...
|
Remove dropdown arrow from read-only combo box
Fri, 19 Mar 2010 15:25:01 -0700
Is it possible to get rid of the dropdown arrow in a combo box and make it
look like a text field?
Wierd question, I know.
Thanks!
...
|
Listbox selected count
Fri, 19 Mar 2010 10:51:02 -0700
I have a form with a multiselect listbox.
I also have a textbox that gives me a count of the items on the list using:
Controlsource.....=lstbox.listcount
I would like a textbox next to that one that gives me a count of the items
selected updated as i select items. Is this possible? If so please help. I
...
|
Modifying Data for export
Fri, 19 Mar 2010 16:18:12 GMT
Hello ,
I have made two make table queries, one with a A record and one with a B
record. I need to export my data to look like:
A Record Information
B Record Information
The B record information is specific to the A record and there are 300+ A
records. I need help figuring some way to do this. Help p ...
|
Show a subform based on data in subform
Fri, 19 Mar 2010 08:54:01 -0700
I have a database for members of an organisation some of whom belong to
sub-committees (of which there are many). On the main 'Members' form there
is a 'Committees Subform shown. How can I hide the subform if the member
does not belong to any of the committees?
Your suggestions would be appreciated.
- ...
|
|
|
RE: Update a record
Fri, 19 Mar 2010 08:51:01 -0700
>>tells me that there are "No valid fields can be found in 'FindZipcode'.
What is 'FindZipcode'?
From the name I assume it is a query but the only query you mention is an
update query. You can not use an update query as source for a combo.
--
Build a little, test a little.
"Rick Wright" wrote:
> ...
|
Hide System Fileds in table
Fri, 19 Mar 2010 10:43:55 -0400
Hello All,
How can I hide/show the system fields in a table i.e. s_Generation and
s_GUID?
Thanks
Abe
...
|
Problem with color in subform
Fri, 19 Mar 2010 14:00:43 GMT
I have form with a subform. On the mainform I have a history of all kind of
machine parts. In the subform I have information of a supplier. Some Machine
IDâ??s have more then one supplier attached.
The subform look like this if I have more then one supplier attached to a
machine (only showing few fields and I ...
|
