|
Help - I need an Undo
Somehow I managed to get the database so that when it opens only "File",
"Edit" and "View" show up on the toolbar. I am minus "Insert", "Tools",
"Window" and "Help".
Someone told me to press the "Shift" key when I open that database and the
other categories do show when I do that, but other people use the database
and I would really like to restore it so that all of the tools show up ...
|
3 |
29.09.2006 12:03:01 |
|
|
Creat a report from multile backends
I am trying to create a report which is generated from records in identical
tables from multiple backends.
For example, a report of employee names which is the complete list of every
employee name in numerous backends.
I can do it the long winded way by connecting to each backend via
Set db = DBEngine.Workspaces(0).OpenDatabase(strdbName) etc ...
then looping through each applicabl...
|
1 |
29.09.2006 11:28:01 |
|
|
Running Unix commands in access
Can I run Unix command in access, if yes how?...
|
2 |
29.09.2006 11:11:09 |
|
|
Expansion of Database Size by Linked Images
Hello,
Would anyone suggest to me why when I inserted jpgs in a OLE Object Data
type column, linked, it still disproportionately expanded the size of the mdb?
Even one inserted linked jpg increased the size from roughly 500 kb to 19
mb. I expect the answer is probably a simple one.
I even did a compact and repair afterwards to see if that would address it
but the size remained the ...
|
2 |
29.09.2006 11:09:56 |
|
|
Printing form
I have a form that is 2 pages long, however I want to use command print
button and shrink that form to 1 page. Thank for help...
|
2 |
29.09.2006 11:07:36 |
|
|
QA Testing
Testing
...
|
2 |
29.09.2006 11:02:28 |
|
|
Help with MDE file
I have an '.mde' file that I can not access ( no pun ).
I don't know what version it was created in. Is there any way to tell?
When I run it under access 2003 I select Open Database on the Convert/Open
page but then I get this message;You can't convert of enable an MDE file.
When I run it under access 2002 I get the same message.
Thank you,
Fred Jacobowitz
...
|
15 |
29.09.2006 10:59:31 |
|
|
Linked Server Problems
I have a query regarding linked servers on SQL Server 2000. The SQL
server service runs with a particular network account, and the linked
server in question is setup to connect to an excel spreadsheet located
on a network drive. I've set the security on the linked server to be
'Be made without using a security context'.
I've made sure that both the sql server service account and the user
...
|
2 |
29.09.2006 10:49:02 |
|
|
Where is the back space arrow in outlook ?
...
|
2 |
29.09.2006 10:37:45 |
|
|
Help with query please
My tblActions table has the following fields (amongst others)
TaskID (Primary Key)
CompanyID (Foreign Key)
OwnerID (ForeignKey)
DateDue
DateDone
I would like a SAVED query to return for each CompanyID, the Earliest
DateDue for uncompleted (DateDate Is Null) tasks together with the OwnerID
for the task.
Many thanks
...
|
5 |
29.09.2006 09:28:43 |
|
|
Adding values on the fly to a combo box on a form with a subform
The code shown below is the compliation of alot of people's help on this
discussion board, and is very much appreciated. While I am close, things
still are not working right. While it first appeared to me that I was able
to add values on the fly to the combo box on my main form (Patterns), but not
to its related subform (Fabrics), upon further exploration, I realized that I
am not addi...
|
3 |
29.09.2006 08:21:04 |
|
|
Default Value
Hi all
I have a combo box which is populated from the results of a different combo
box on a form using the strsql to set rowsource. If the results returned are
only one record can the default value of the 2nd combo box be set to this?
I have tried setting default value to first row in combo box but could not
get this working, also I only want this to be true if there is only the one
...
|
5 |
29.09.2006 08:18:01 |
|
|
sdcfasx
...
|
1 |
29.09.2006 07:36:58 |
|
|
fdvadfd
...
|
1 |
29.09.2006 07:36:09 |
|
|
Significant Issues: Access
I run XP x64 and Office 2003 on an x64 box with multiple monitors. My
configuration has two hardwired monitors attached to an ATI X1900 XTX and a
third monitor is accessible using the Maxivista x64 beta to take control of
the monitor attached to my testing machine.
I am seeing a number of serious issues when running Access across multiple
monitors. For instance, in a two monitor configu...
|
3 |
29.09.2006 06:53:01 |
|
|
Imported Data usiing ODBC
I import data from an external database using ODBC. Into tables. Access is
used as a report writer. I have no control over the way the data is imported
into the tables. The problem is some of the tables have been set up to import
multiple lines of text as individual records. i.e. Table A has the main data
about the record. Primary being the record numer entry. Table B has the same
primar...
|
5 |
29.09.2006 06:29:02 |
|
|
MDB Search Tools
Are there tools that would allow me to search MDB queries & tables for a
variable\value?
Ex: I have used the condition " equals Typical" in queries. Now I have
close to a hundred queries. Finding the one with this condition is hard.
A find and replace for this condition would be helpful.
Ex: "equals Typical" would become In ("Typical","Other")
I have searched the Internet and hav...
|
9 |
29.09.2006 06:18:06 |
|
|
I can't open .mdb file.
I created a simple .mdb file on my office computer using Access 2003. When I
attempted to continue working on it on my home computer, also on Access 2003,
I received the following error msg: "The database XYZ.mdb needs to be
repaired or isn't a database file" Thinking it was corrupted, I tried to
repair it, but MS Office won't repair it saying "Unrecognized database
format...It can't ...
|
4 |
29.09.2006 05:20:41 |
|
|
VBA : Relationship between two linked table
Hi,
I'm tryin to dynamically rebuild relationship between two Sql Server
2005 linked tables using the code bellow.
The point is that I get a warning message telling me I can't do
relation between two linked table.
Anyway, using the RelationShip Model, I can !
Is there a solution to do that in VBA ?
*****
Set rlts = CurrentDb.Relations
With rlts
Set rlt = CurrentDb.CreateRelatio...
|
1 |
29.09.2006 05:15:13 |
|
|
Null to Zero in Crosstab Query
Can anyone explain how to convert Null values to Zero in the Value field in a
Crosstab Query? I know how to use the Nz function but I don't know where to
use it to get it to work!
The Crosstab Query is based on an underlying Select query with aggregate
functions on fields. CountofFieldA is dragged from the Select query into the
design grid of my Crosstab query and I want the Sumof(Count...
|
2 |
29.09.2006 04:44:21 |
|
|
Lunar Holiday
I was wondering if there was any way to have Lunar Holidays automatically
synced to my calendar like Yahoo's Calendar?
----------------
This post is a suggestion for Microsoft, and Microsoft responds to the
suggestions with the most votes. To vote for this suggestion, click the "I
Agree" button in the message pane. If you do not see the button, follow this
link to open the suggestion i...
|
2 |
29.09.2006 03:00:51 |
|
|
How to use a statusbar control in a userform
Hi everybody
Im using AccessXP and trying to use a statusbar in the userform footer.
However, I don´t know how to show messages on it because I don't find its
Panels and Text properties.
Thanks
Luis
...
|
3 |
29.09.2006 02:47:38 |
|
|
Password protection on Access VB Project
Hi all
Rephrasing a previous question, given an Access database's full path,
how do I programmatically ascertain whether it has any password
protection on the VB Project? (Sorry about the multiple posts - not
sure which is the appropriate group to submit to).
Thanks in advance
Paul Martin
Melbourne, Australia
...
|
1 |
29.09.2006 02:47:01 |
|
|
Access Front-End to SQL Server
I am a forum newbie - I'll try to be brief...
We are embarking a new adventure to scale an internal system up to SQL
Server from Access 2003. We are not going to use the upsizing wizardry. We
are going to go ahead and rebuild / optimize our tables.
The question is which route to go with the Front-End?
- Access 2003: SQL tables linked via ODBC
- Access Data Project(ADP)
- Access 2007: S...
|
3 |
29.09.2006 02:08:13 |
|
|
Date triggering an input
Is there a way to get Access to prompt the user to input the month end stock
price after the month ends? For example, if someone opens the database on
10/1/06 or later, I'd like the db to prompt them to input the stock price on
9/30/06. If the stock price has already been entered then I'd like no prompt
to occur....
|
2 |
29.09.2006 00:47:06 |