|
Form Missing Bottom Scrollbar?
One of my forms is missing the bottom scroll bar that shows how many records
there are?....Thanks Bob
--
..........Jenny Vance
...
|
3 |
20.09.2006 05:29:01 |
|
|
Filter problem in report
Hi all
I am trying to filter the report based on the combo boxes in form,
using the following code
Me.Filter = "LocationName = " & LocationName & " AND " & "ParameterName
= " & _ ParameterName
DoCmd.OpenReport "rptResults", acViewPreview, , Me.Filter
but when I press the button and report opens it asks for the 'Enter
Parameter' both both fields.
Interesting thing is that it asks for '...
|
2 |
20.09.2006 05:11:19 |
|
|
active x error problem
Since I cannot get any of the suggested ways to link photos into my database
reports, I thought I would try a simple wizard approach.
See: http://support.microsoft.com/default.aspx?scid=kb;en-us;285820 for an
example that doesn't work.
Using Access 2002, I cllicked on Table Design wizrard, personal, Plants.
(I'm doing a rhododendron database design) I selected ID, species, and
photog...
|
2 |
20.09.2006 04:33:12 |
|
|
will 2003 upgrade allow Access 97 and 2003 to both run together
Can I buy the upgrade and still run Access 97 and
2003 on the same computer, or do I need to buy
the full version?
...
|
3 |
20.09.2006 04:26:33 |
|
|
Access for attorney document review
Can anyone help me design a simple straight forward Access database so I can
load TIFFS for use as an attorney docment review tool that can be accessed on
the firm intranet? The simpler the better. Like a push-button banking
screen. Open the file, and allow them to put the file into folders:
responsive, non-responsive, privileged. Fields need to include the name of
the reviewer and ...
|
4 |
20.09.2006 03:11:54 |
|
|
Access should allow "save as" to any drive or folder
I teach the Microsoft Office Suite of programs at the high school level using
Shelly, Cashman series. I am always amazed how weak Access is compared to
other database programs; it is the weakess within the suite. I am especially
frustrated by the fact that Access does not follow the other programs within
the suite when it comes to "Save As". It is very difficult to save an Access
file...
|
4 |
20.09.2006 03:07:50 |
|
|
Database Corruption
I am writing a database for work. I have been good on getting very few
corruption error, however when I do get a corruption I cannot fix it with the
Compact and Repair Feature. It appears that the corruption is on the front
end.
The database is located on a server and multiple people are able to access
it at one time. I would like to install the front end on every PC, but I
have a ...
|
1 |
20.09.2006 02:08:02 |
|
|
sendobject using groupwise only recognizes last address
When using 'sendobject' in a macro with Groupwise 7.0 only the last address
in the 'To', 'CC' and 'BCC' fields is populated....
|
3 |
20.09.2006 01:54:02 |
|
|
Clearing column in an access table
Is there a simple way to clear all the data out of a column in an access
table without deleting the column itself. When I right click the column in
an open access table it appears I can only delete the column, not clear the
contents. Thanks in advance for help....
|
5 |
20.09.2006 00:24:49 |
|
|
compare memo fields
I have 2 memo fields in table1.field1 and table2.field2. I need to
compare them, and get the rows where the fields arent equal. How can
one accomplish this?
Thanks advance
of
Francis
...
|
4 |
20.09.2006 00:10:43 |
|
|
how do i delete data from a coluum in access 2003
how do i delete a large amount of data from a table coluum in access 2003...
|
3 |
19.09.2006 23:57:30 |
|
|
Best and least expensive way to purchase Access 2003
Can someone please advise the least expensive way to
get Access 2003. I found a whole range of prices on
the internet. We are currently using Office 97.
TIA
...
|
3 |
19.09.2006 23:12:33 |
|
|
Authenticate to MS SQL using alternate NT credentials
We are trying to authenticate to MS SQL through an MS Access application
coding in VBA and want to pass NT credentials of a service account instead of
the user that opens the MS Access app. I am aware of how to code this using
a SQL authentication, but was wondering how to do this using NT
authentication of a user other than the the person that has opened the app?
Any help or sample co...
|
3 |
19.09.2006 22:22:19 |
|
|
Dlookup function
Hello!
In my Computer an Access application works very good, but in my parnter's
computer doesn't; It show a message "Function is not found". It's about
"Dlookup function" in a calculated field into a Query.
I uninstalled and installed Office 2003 and the Service Pack, but it doesn't
work.
Any help will be appreciated!
Excuse me for my english.
--
Oscar Picos
Office Autom...
|
2 |
19.09.2006 22:20:57 |
|
|
Automatic Year Completion
Is it possible to have Access automatically complete the year in a date
entry. We want to be able to type "7/8/6" and make Access complete "7/8/2006"
Any ideas?
...
|
3 |
19.09.2006 22:09:01 |
|
|
"Issues" database
I want to create a new field named "Completion Date" in the Issues Table and
have it be set by default to the current date when an issue is closed. How
do I do that?...
|
8 |
19.09.2006 22:06:01 |
|
|
Linking
I have a recordset that has to be split up into several tables because it
contains too many characters. I plan on linking all the table through their
primary key in a 1-to-1 relationship.
My question is if this needs to be done in any particular way, ie. should
the tables be linked serially - table 2 is linked to table 1, table 3 to
table 2, etc, or radially, meaning all tables are linke...
|
11 |
19.09.2006 22:05:02 |
|
|
Outstanding Balance Query on Time-Billing Template- Access 2003
Hello. I am trying to create a report or a query to spit out a report
of what clients still have outstanding balances (and the balance) . I
have tried to past the client subform into a report, and all I get is
'#NAME?' in the 'Amount Due' column.
Anyone get something like that going in this template?
Thanks in advance,
-J
...
|
6 |
19.09.2006 21:54:02 |
|
|
Form tab Order
How can I change the order of the feilds that are highlighted when I am
pushing tab in a form?...
|
4 |
19.09.2006 21:50:02 |
|
|
Sales Prospect Template for Access 2003
Can anyone recommend a good sales prospect template for Access 2003?
--
GPBurdell...
|
1 |
19.09.2006 21:41:01 |
|
|
Dlookup function
Hello!
In my Computer an Access application works very good, but in my parnter's
computer doesn't; It show a message "Function is not found". It's about
"Dlookup function" in a calculated field into a Query.
I uninstalled and installed Office 2003 and the Service Pack, but it doesn't
work.
Any help will be appreciated!
Excuse me for my english.
--
Oscar Picos
Office Autom...
|
1 |
19.09.2006 21:30:01 |
|
|
Add a line break/paragraph
I Have table that has imported data from a spreadsheet. the field data has a
marker <p> to indicate that this should be a new paragraph.
Can anyone tell me what I would need to create an update query to insert the
paragraphs as required?
Thanks in advance
Les
...
|
5 |
19.09.2006 21:17:00 |
|
|
antivirus and access files
should I be configuring my antivirus software to exclude access (mdb) files?
...
|
1 |
19.09.2006 20:40:51 |
|
|
How do I link a .pdf file to a table or form in access?
I am trying to link a document that I have scanned in and saved as a .pdf
file to our access database which keeps all of our clients information. I
have imported the document but it takes up to much space so I am trying to
link it with the hopes that it will not take up as much space on the server. ...
|
2 |
19.09.2006 20:21:01 |
|
|
powerpoint snapshot
how do you import a access snapshot into powerpoint?...
|
2 |
19.09.2006 20:18:02 |