|
Click link
to request
|
Question
|
Date
(dd/mm/yy)
|
Length
|
|
|
|
|
|
|
1944
|
When I open my Microsoft Access 2007 application on my new Windows 7 computer I get a Security Warning. How do I get rid of the Security Warning as I trust the software?
|
20/11/09
|
642
|
|
1876
|
I am trying to hide the ribbon in Microsoft Access 2007. I followed the example in the help and at first nothing seemed to happen. Once I turn on the error message I ended up getting the message "Custom UI Runtime Error in ". "Error found in Custom UI XML of "". "Unknown Namespace: http//schemas.microsoft.com/office/2006/01/customui". Element: CustomUI.
|
18/06/08
|
1298
|
|
1875
|
How to have a Microsoft Access 2007 database not display the Ribbon when Access starts.
|
18/06/08
|
1419
|
|
1874
|
How do I show system tables in Microsoft Access 2007?
|
18/06/08
|
451
|
|
1849
|
In Microsoft Access 2003 and earlier I could easily see the tables and queries by showing the database container. The database container is gone. What should I now use in Microsoft Access 2007?
|
10/04/08
|
332
|
|
1792
|
When I open an older application in MS Access 2007 and use the filters the filters stick. They didn't previously. What can I do about this
|
16/11/07
|
93
|
|
1784
|
In MS Access 2007 some of my drop down boxes in a form showing multiple records is now the background colour and not white as set.
|
10/11/07
|
1682
|
|
1783
|
In Access 2003 I have a form with a sub form. The sub form contains a total which is also updated in the database. The main form displays the total from the sub form. This worked with Access 2003/XP. Running this application with Office 2007 under Vista this no longer displays a value for new records entered in the sub form.
|
10/11/07
|
1035
|
|
1768
|
When I open an older Microsoft Access application in Access 2007 the records are shown as a list. When the form is closed the layout changes and only a single record is shown if the form is opened again.
|
25/10/07
|
641
|
|
1623
|
After installing Internet Explorer 7 the Microsoft Access application (using MS Access runtime) gives me an error "Cannot open this file. This file is located outside your intranet or on an untrusted site. Will not open the file due to the potential security problems." The application is located on their Linux server.
|
11/11/06
|
325
|
|
1535
|
In this article I share how I add spell check to MS Access runtime applications. This requires MS Word to be installed on the users machine.
|
21/02/06
|
2647
|
|
1534
|
I have a system written in MS Access. Each of the users have Office Professional which is used to run the MS Access system. When the users enter data there are spelling errors everywhere and the quotes we produce are unprofessional. How can I spell check what I have typed in an MS Access application.
|
21/02/06
|
675
|
|
1494
|
When I try to display the linked tables using the Linked Table Manager in Microsoft Access 2003, none of the linked tables display. How do I get around this problem?
|
10/12/05
|
2473
|
|
1488
|
When I start my Microsoft Access application I receive the message, "The expression On Open you entered as the event property setting produced the following error: Bad file name or number."
|
02/12/05
|
1271
|
|
1476
|
I've been told that Microsoft Access is like a Word document. That is it can't be secured to stop users from changing or getting access to the code. Is this correct?
|
16/11/05
|
425
|
|
1474
|
In Microsoft Access how do I change the headings in a multi-column combo box?
|
08/11/05
|
916
|
|
1441
|
One office for a client wanted a list of email addresses for all their staff across all offices. They do keep such a list themselves. We maintain a list of email addresses in our own Microsoft Access base system. The following is how we provided them with a list of names and email addresses.
|
11/10/05
|
4537
|
|
1417
|
In an MS Access query when I use the function Instr(0,Field,Form value) to determine if a field contains a string the user enters into a form the query displays #Error in the column. Can I get around this?
|
05/09/05
|
1580
|
|
1416
|
In MS Access XP (2002) I have two databases. A database containing the data, and a database containing forms, reports etc, and links to the data in the other database. When I check my linked tables a couple show errors. When I look at the tables directly where the data is stored there are no errors.
|
04/09/05
|
2000
|
|
1411
|
I use SendObject with Microsoft Access XP (2002). When I cancel the email I get an error message "Run-time error '2501': The SendObject action was canceled." How do I stop getting this error message.
|
31/08/05
|
1401
|
|
1401
|
In MS Access 2002 (XP) I get an error "Run-time Error '3061': Too few parameters. Expected 1." The error occurs in the VBA code when I use a query in an Openrecordset statement. The problem is when I compare today's date with a date on a form.
|
26/08/05
|
3374
|
|
1398
|
When designing and testing an MS Access XP (2002) application I often get stuck debugging because the window which has the focus is behind other windows and is not visible. How can I make the window visible.
|
23/08/05
|
480
|
|
1397
|
How do I start a MS Access application so the start up procedure does not run and I can see the database container?
|
23/08/05
|
116
|
|
1396
|
In Microsoft Access XP (2002) I have a single page report which produces a second blank page. How do I get rid of the second page?
|
23/08/05
|
719
|
|
1395
|
In MS Access XP (2002) I have a placed a line across the page using the toolbox. When I preview the report it is not quite horizontal and it appears slightly jagged. How do I force the line to be horizontal.
|
23/08/05
|
331
|
|
1394
|
In MS Access XP (2002) when I print a single page report I receive the message "The section width is greater than the page width, and there are no items in the additional space, so some pages may be blank." I've used accurately enter all measurements but I still get a blank second page.
|
23/08/05
|
505
|
|
1393
|
Using MS Access XP (2002) when I print a report a get every second page blank.
|
23/08/05
|
298
|
|
1392
|
With MS Access XP (2002) I have labels which are two across and four down. I keep getting the message "Some data may not be displayed. There is not enough horizontal space on the page for the number of columns and the column spacing you specified." I make the columns narrower but I still get the message.
|
23/08/05
|
814
|
|
1368
|
This article shows how to set up an empty Microsoft Access database without having Microsoft Access. One use of such a database is as an empty database for use with OpenOffice.org.
|
15/08/05
|
1959
|
|
1301
|
I have an MS Access 2000 application running under Windows XP and Access XP (2002). When I type with caps lock on the automatic completion in a drop down list fails and I end up with the second letter entered being lower case.
|
01/06/05
|
1177
|
|
1299
|
When I run the Access XP (2002) runtime on a new Windows XP SP2 computer I receive a "Visual Basic 6.0 Setup Toolkit" message and the setup fails with the following message. "The Office System Pack cannot be installed on this system because it requires Windows NT 4.0 Service Pack 6 or later". This issue shows how we get around the problem for the developer.
|
30/05/05
|
1977
|
|
1297
|
Have you encountered problems with removing defined relationships between tables (in Microsoft Access)? I accidentally put one in and now even though I have deleted it, the system integrity won't let me make table design changes that affect the relationship!
|
24/05/05
|
742
|
|
1276
|
Microsoft Access runtime (XP/2002) will not install on a new computer.
|
10/05/05
|
733
|
|
1274
|
I am moving to Microsoft Access 2003. Now when I open my application I get a Security Warning window and I have to click on an Open button. This is very annoying. How do I disable it?
|
07/05/05
|
1441
|
|
1262
|
In MS Access XP I kept getting errors whilst working with the application. I repaired the data and now I have #Error in particular fields.
|
26/04/05
|
926
|
|
1237
|
The following are my concrete reasons for not using OpenOffice.org as a replacement for MS Access. These reasons will still apply once OOo 2.0 is released, so we suspect they will still apply for up to two more years.
|
31/03/05
|
2326
|
|
1229
|
Some feedback on using mswinsock (winsock) with Microsoft Access XP and why we do not use it.
|
07/03/05
|
4080
|
|
1180
|
When sending emails using the SendObject in MS Access, the line breaks do not work as expected in Outlook.
|
20/01/05
|
744
|
|
1179
|
When I run the MS Application MDB using MS Access runtime I get the error: "Your xxxx database or project contains a missing or broken reference to the file 'OWC10.DLL' version 1.1.". This works fine on the development machine with the full version of MS Access XP.
|
20/01/05
|
865
|
|
1164
|
When I compile the MS Access XP application I get the error "Compile error: Method or data member not found" which relates to the line "MyRecords.Edit" which has previously worked. What has happened?
|
10/01/05
|
455
|
|
1163
|
After converting an application from Access 97 to Access XP the date fields contain #Name? and using Control+; does not insert the current date as expected.
|
09/01/05
|
1743
|
|
1161
|
I have some date fields on a Form in an MS Access application which is an MDE file and default to today's date. When the application is run using the full version of MS Access XP there is no problem. On two machines using MS Access XP Runtime it works on one machine, but on a second machine the date fields contain #Name? and using Control+; does not insert today's date.
|
09/01/05
|
2409
|
|
1159
|
When I try to create a runtime package from the Start button under Windows XP it always abends. What can I do?
|
09/01/05
|
6708
|
|
1158
|
When I try to create an MDE using MS Access XP it fails. I have checked and added Option Explicit to all the code but it still fails to create an MDE. What next?
|
09/01/05
|
111
|
|
1149
|
When using MS Access XP I keep getting a "Run-time error '13': Type mismatch" error when using a dynamic array. I have two dynamic arrays defined on the one Dim statement and the second one does not give a problem.
|
28/12/04
|
853
|
|
1146
|
I keep getting a "Run-time error '5': Invalid procedure call or argument" when I try the instruction "Set zTextStream = zLogFile.OpenAsTextStream(ForAppending, TristateUseDefault)" to append to a log file in MS Access XP.
|
26/12/04
|
785
|
|
1144
|
When I print a Microsoft Access XP report from my Windows 98 machine across the network there are lines and other parts missing. The printer is a HP laserjet 5P connected to a Windows XP Pro machine.
|
22/12/04
|
646
|
|
1134
|
When creating a Microsoft Access 2002 (XP) runtime file (mde), I get the message "microsoft access was unable to create mde". What should I do?
|
18/12/04
|
1528
|
|
1121
|
I'm using MS Access runtime on one computer and I get the message "Your database or project contains a missing or broken reference to the file 'msoutl.olb' version 9.1". It works fine on another computer.
|
09/12/04
|
545
|
|
1104
|
When I go to compact an MS Access file or create another mde which is located on my Linux server I get the message "Cannot save the file (file path and name given) is not a valid file name." What can I do?
|
22/08/05
|
852
|
|
1057
|
Reasons we are looking for a different development platform to MS Access
|
12/10/04
|
2170
|
|
1036
|
I would like to have spell checking in my MS Access runtime based system. Runtime does not have spell checking available via F7 like the full version.
|
06/09/04
|
903
|
|
1035
|
The contact data I have is in a MS Access database. How do I get this into my Pocket PC?
|
06/09/04
|
3635
|
|
1016
|
I have a list transactions in an Excel spreadsheet that I have collected on my Pocket Computer. I now want to add these to my MS Access data on my desktop computer. How do I do this?
|
10/08/04
|
583
|
|
977
|
As an MS Access developer a number of things have stopped me from moving to OpenOffice.org. This article lists those reasons.
|
23/05/05
|
6998
|
|
785
|
We moved our MS Access XP runtime system from a Win98 machine to a WinXP machine acting as a shared server. Access runs fine for a while then becomes slow.
|
18/12/03
|
698
|
|
783
|
In a Microsoft Access application when I tab through the main form and the cursor goes to the subform, it does not start in the first column. This only happens sometimes. Why?
|
17/12/03
|
646
|
|
538
|
We moved a shared MS Access sytem from a Win98 to a WinXP machine and now the very first we open a form it takes around 72 seconds. From then on everything is fine and it does not occur again.
|
26/06/03
|
262
|
|
267
|
My Access 2.0 based system cannot update the underlying table when the function adds a value.
|
27/02/03
|
197
|
|
221
|
Does record locking work when Accessing a Microsoft Access database from OpenOffice.org?
|
23/05/05
|
1188
|
|
141
|
Information on using dates within Visual basic code and in particular within an SQL string.
|
28/01/03
|
856
|
|
135
|
I use Microsoft Access and my lines on reports print on one printer and not on another. What is going on?
|
28/01/03
|
464
|
|
113
|
Compaction of Access database was enormous.
|
14/01/03
|
495
|
|
75
|
Our access database appears to be corrupt. What should we do?
|
02/01/03
|
696
|
|
69
|
When I used SendObject in MS Access with a text message the email addresses were converted to actual links.
|
22/12/02
|
759
|