473,943 Members | 11,143 Online
Bytes | Software Development & Data Engineering Community
+ Post

Home Posts Topics Members FAQ

Two Access Questions

9 New Member
Hi

This is my first thread here. I have a project in MS Access and i have 2 problems related to it.

1. In all the forms where i have the navigation buttons, the delete button is disabled. I am able to delete records by selecting one of the records and using the delete key on my keyboard. But the delete button on the navigation bar in the form is always disabled.
(In the form properties, i have enabled deletions)

2. Whenever i use the OutputTo command to export a report to a file, i get an error saying that a printer is not installed. But why should i have a printer when i'm just writing data to a file?

Please help me out soon.
May 23 '07 #1
3 1393
missinglinq
3,532 Recognized Expert Specialist
1. In all the forms where i have the navigation buttons, the delete button is disabled.
What "delete" button are you referring to? The native navigation buttons have an Add Record button, but no Delete Record button, to my knowledge. You're not referring to that, are you?

2. Whenever i use the OutputTo command to export a report to a file, i get an error saying that a printer is not installed. But why should i have a printer when i'm just writing data to a file?
Someone else here may know better, but I thik it's possible that Access considers this "printing to file" and like any "print" operation, does not allow it if no printer has been detected on the system. Hopefully someone here may have a more definitive answer to this!

Good Luck!
May 23 '07 #2
NeoPa
32,584 Recognized Expert Moderator MVP
Please remember to provide a meaningful Title for any threads started (Please Use Appropriate Titles for New Threads!). This helps to ensure that other members, and also the general public, will have a better chance of finding answers to any similar questions.

MODERATOR.

Also, in this case, please create one thread per question. For similar reasons to above.
May 24 '07 #3
NeoPa
32,584 Recognized Expert Moderator MVP
Hi

This is my first thread here. I have a project in MS Access and i have 2 problems related to it.

1. In all the forms where i have the navigation buttons, the delete button is disabled. I am able to delete records by selecting one of the records and using the delete key on my keyboard. But the delete button on the navigation bar in the form is always disabled.
(In the form properties, i have enabled deletions)

2. Whenever i use the OutputTo command to export a report to a file, i get an error saying that a printer is not installed. But why should i have a printer when i'm just writing data to a file?

Please help me out soon.
  1. Just as the other Expert here, I know of no intrinsic Delete button. Perhaps it's one you've added yourself. If so, then you need to code it to do the delete yourself.
  2. When a report runs in Access, it must have a printer associated as it matches the output to what the printer can handle. That's why, when you design a report, you must specify whether it is the default printer, or another specific printer, to be used.
May 24 '07 #4

Sign in to post your reply or Sign up for a free account.

Similar topics

4
7277
by: Dale Ring | last post by:
Access 2000 I am trying to print a report that only some of the records have pictures. When the report prints, I do not want a blank image control showing on the report. This project is a test bank of questions allowing the user to create an exam by choosing the questions. Some of the questions have pictures for reference and some don't. I have chosen to keep the images in another folder with a test field (QPic) that contains the...
1
5362
by: Stefan V. | last post by:
Hello! I am trying to convert a query written for SQL Server 2000 database tables, to a MS Access query. Here is what I have in SQL Server: SELECT t2.*, CASE WHEN t2.QType = '3' THEN t1.Note ELSE CASE WHEN t2.QType = '2' THEN CASE WHEN CONVERT(varchar(100), t1.ANumber) = '1' THEN 'Yes' ELSE 'No' END ELSE CASE WHEN CONVERT(varchar(5), t2.Qnumber)+'.' +
3
6101
by: krygsma | last post by:
So, I need to figure out how to do what I want to do with Access. I have many questions with mutually exclusive options, each option has a value, never=0, few times=1...ect.. (then when questions are "reversed", never will equal 4, which can be handled later but I'm open to any ideas) but need to be displayed as text. The easiest solution to this, I thought, would be option groups, perfect, they look beautiful, it seems quite logical that...
7
6125
by: Ariel | last post by:
I have a question that I'm hoping someone here can answer. Let's say I have two fields which have a beginning number and an ending number. What I'd like to do is have Access generate a list of numbers between the beginning number and the ending number (inclusive) for each row that exists in my start table. For example, my start table might look like: Begin End 513525 513528 513530 513538
42
5677
by: PC Datasheet | last post by:
I have zero experience with using a SQL database for a backend and Access for a frontend. I have some questions: 1. Does an SQL database have tables? 2. How does Access connect to the data in an SQL database? Linking, importing, or ??? 3. Earlier today there was a thread regarding DAO and ADO. In the thread it was said that ADO is very useful when the backend is a SQL database. Could someone explain that?
0
3039
by: totierne | last post by:
comp.databases.ms-access, I want to know how to use Oracle views with session variables in Access. The parameterised views in access, are migrated to views with per session variables. The open questions: How to display a resultset
4
1546
by: Grant Austin | last post by:
Hello, This might be a tad off topic. The c-programming groups I found appear to be unused... The problem is simple... I need to create a listing file from an assembler source file. The listing file is just a copy of the source file with line numbers along with a list of syntax errors (e.g. multiply or undefined symbols).
7
4788
by: Martin Strojek | last post by:
Hi, I have the following problem with developing some web site. I use Visual Studio 2003 to build a website. I tried Windows 2003 Server and switched now back to Windows XP with PWS but the error occurs in both installations. When I do a compile/build of my app and go to the browser and hit reload there comes an error:
62
11453
by: Ecohouse | last post by:
I was just wondering if there was any way to use a toolbar in Outlook 2002 in Access 2002? I want to create a custom toolbar in Access similar to the Calendar toolbar in Outlook. Any ideas?
21
2459
by: Bigpond News | last post by:
Work at a large site - 1000+ PC's. Mixture of Win98 & WinXP. Majority of applications using Access 97. If I compile the Acc97 application on a Win98 PC, the .mde will run perfectly on both Win98 and WinXP PC's. However, if I compile on a WinXP PC, the application doesn't run correctly on Win98 PC's. While I guess a Windows issue, does anyone know the offending files and even better, how to resolve it ? Otherwise I need to...
0
10143
marktang
by: marktang | last post by:
ONU (Optical Network Unit) is one of the key components for providing high-speed Internet services. Its primary function is to act as an endpoint device located at the user's premises. However, people are often confused as to whether an ONU can Work As a Router. In this blog post, we’ll explore What is ONU, What Is Router, ONU & Router’s main usage, and What is the difference between ONU and Router. Let’s take a closer look ! Part I. Meaning of...
0
11133
jinu1996
by: jinu1996 | last post by:
In today's digital age, having a compelling online presence is paramount for businesses aiming to thrive in a competitive landscape. At the heart of this digital strategy lies an intricately woven tapestry of website design and digital marketing. It's not merely about having a website; it's about crafting an immersive digital experience that captivates audiences and drives business growth. The Art of Business Website Design Your website is...
1
11304
by: Hystou | last post by:
Overview: Windows 11 and 10 have less user interface control over operating system update behaviour than previous versions of Windows. In Windows 11 and 10, there is no way to turn off the Windows Update option using the Control Panel or Settings app; it automatically checks for updates and installs any it finds, whether you like it or not. For most users, this new feature is actually very convenient. If you want to control the update process,...
0
9866
agi2029
by: agi2029 | last post by:
Let's talk about the concept of autonomous AI software engineers and no-code agents. These AIs are designed to manage the entire lifecycle of a software development project—planning, coding, testing, and deployment—without human intervention. Imagine an AI that can take a project description, break it down, write the code, debug it, and then launch it, all on its own.... Now, this would greatly impact the work of software developers. The idea...
0
7394
by: conductexam | last post by:
I have .net C# application in which I am extracting data from word file and save it in database particularly. To store word all data as it is I am converting the whole word file firstly in HTML and then checking html paragraph one by one. At the time of converting from word file to html my equations which are in the word document file was convert into image. Globals.ThisAddIn.Application.ActiveDocument.Select();...
0
6312
by: adsilva | last post by:
A Windows Forms form does not have the event Unload, like VB6. What one acts like?
1
4914
by: 6302768590 | last post by:
Hai team i want code for transfer the data from one system to another through IP address by using C# our system has to for every 5mins then we have to update the data what the data is updated we have to send another system
2
4515
muto222
by: muto222 | last post by:
How can i add a mobile payment intergratation into php mysql website.
3
3516
bsmnconsultancy
by: bsmnconsultancy | last post by:
In today's digital era, a well-designed website is crucial for businesses looking to succeed. Whether you're a small business owner or a large corporation in Toronto, having a strong online presence can significantly impact your brand's success. BSMN Consultancy, a leader in Website Development in Toronto offers valuable insights into creating effective websites that not only look great but also perform exceptionally well. In this comprehensive...

By using Bytes.com and it's services, you agree to our Privacy Policy and Terms of Use.

To disable or enable advertisements and analytics tracking please visit the manage ads & tracking page.