Go Back   Access World Forums > Search Forums

 
Showing results 1 to 25 of 49
Search took 0.01 seconds.
Search: Posts Made By: Jordan76
Forum: Reports 05-11-2003, 07:40 AM
Replies: 7
Views: 1,730
Posted By Jordan76
Is there a code snippet I can throw in to release...

Is there a code snippet I can throw in to release the resources if I am just setting the printer using default settings, and using the specific printer settings for 2 different reports?
Forum: Reports 05-10-2003, 08:06 AM
Replies: 7
Views: 1,730
Posted By Jordan76
Here is a screenshot of the error

Here is a screenshot of the error I recieved.

This error pops up everytime i open a new instance of the DB on another PC on the network. Even if you reset it on one by using Setup, and then move...
Forum: Reports 05-10-2003, 07:26 AM
Replies: 7
Views: 1,730
Posted By Jordan76
Access recognizes the printer, even says in the...

Access recognizes the printer, even says in the error message that the default printer IS 'check printer' but it constantly says it is not available. I believe its holding the resources on a user...
Forum: Reports 05-09-2003, 07:29 AM
Replies: 7
Views: 1,730
Posted By Jordan76
I think I've discovered it. I have not created a...

I think I've discovered it. I have not created a workgroup for my database. Could this be affecting the printer resources if its used by multiple users?
Forum: Reports 05-03-2003, 08:49 AM
Replies: 7
Views: 1,730
Posted By Jordan76
It should be noted that the problem is, that the...

It should be noted that the problem is, that the printers are constantly being seen as not available on new machines,

Any ideas?

Thanks,
Jordan
Forum: Reports 05-03-2003, 08:13 AM
Replies: 7
Views: 1,730
Posted By Jordan76
Network Computer's holding printer resources?

I've been designing a database in access for monthes now.
Being close to finished, I began rolling out to multiple workstations when I encountered a new problem I have never seen before.

I will...
Forum: Reports 04-14-2003, 06:10 AM
Replies: 1
Views: 934
Posted By Jordan76
(User-Defined Paper Size)

Recently I developed a check printing DB for a travel agency. This worked wonderfully, providing I was able to set the paper size to (user defined Paper Size).

This weekend I was setting the DB...
Forum: Modules & VBA 03-26-2003, 12:46 PM
Replies: 4
Views: 796
Posted By Jordan76
Thanks Mile, Your the bestest!

Thanks Mile,

Your the bestest!
Forum: Modules & VBA 03-26-2003, 08:52 AM
Replies: 4
Views: 796
Posted By Jordan76
Thats Fantastic thank you, I just needed to know...

Thats Fantastic thank you, I just needed to know where to put it.
Do I need to specifiy any error? like its generating a 2471, do i need to say 2471 anywhere?
Forum: Modules & VBA 03-26-2003, 08:42 AM
Replies: 4
Views: 796
Posted By Jordan76
Error Trapping Novice

Hi there,

Im using dlookup to search for values entered into 3 texts boxes.

When one of the values isnt found, I get a 2471 Error and have to push end to move along with the data entry.

What...
Forum: General 03-07-2003, 05:31 AM
Replies: 3
Views: 6,454
Posted By Jordan76
Hmm, this could cause a problem. Is there a way...

Hmm, this could cause a problem. Is there a way to set a custom page up maybe? When choosing the page size, it only lets me use the ones in the drop down.

Thanks In Advance
Jordan
Forum: General 03-06-2003, 05:26 PM
Replies: 3
Views: 6,454
Posted By Jordan76
Setting print area like in Excel

Do access reports, allow you to set a specific print area like in excel?

I print cheques all time in Excel, and they stop right after the print area (that i manually set). However in access, the...
Forum: Reports 03-06-2003, 03:54 PM
Replies: 1
Views: 495
Posted By Jordan76
Is there a way to set the print area

Is there a way to set the print area like in excel?
Forum: Reports 03-06-2003, 03:47 PM
Replies: 1
Views: 495
Posted By Jordan76
Having a report not Scroll when printing is finished

Hey all,

I am printing cheques, and I cant figure out how to have the printer not scroll into the check below. Its a tractor feed printer, and I need to only print the detail portion then stop,...
Forum: General 02-12-2003, 04:49 PM
Replies: 1
Views: 513
Posted By Jordan76
Hmm Ive been reading on the differences between...

Hmm Ive been reading on the differences between the two and cant figure it out.

any ideas please?
Forum: General 02-12-2003, 06:37 AM
Replies: 1
Views: 837
Posted By Jordan76
Ok what I did was use the wizard and litterally...

Ok what I did was use the wizard and litterally go column by column in the excel spreadsheet selecting the appropriate format for each column.

Also try formatting the columns in excel so they are...
Forum: General 02-12-2003, 06:28 AM
Replies: 1
Views: 513
Posted By Jordan76
Why would this work in 2002 and not 2000?

At Home I am using Access 2002 with Windows XP. I am designing a DB for a Travel Agency. They informed me that I was going to design the application for the same platform.

However when i got there...
Forum: Reports 02-10-2003, 02:23 PM
Replies: 9
Views: 1,291
Posted By Jordan76
It works great as well when I do it for two as...

It works great as well when I do it for two as long as both fields are not empty.


I had a similiar problem and solved it by putting default values into each box using the properties <default...
Forum: Reports 02-10-2003, 11:58 AM
Replies: 2
Views: 696
Posted By Jordan76
Thanks Wayne I got it:) What I did, was edit...

Thanks Wayne I got it:)

What I did, was edit the Query adding a second field concatanating the two fields like so.

LastName & " / " & Firstname

So simple and it worked:)

Thanks for...
Forum: Reports 02-10-2003, 10:50 AM
Replies: 2
Views: 696
Posted By Jordan76
Formatting a List Box With Two Columns in a report

I got a Listbox in my report that displays LAstname and First name like so:


Lastname | Firstname

Basically is shows the two columns (fields) next to each other.

Is it possible to change...
Forum: Reports 02-10-2003, 10:47 AM
Replies: 9
Views: 1,291
Posted By Jordan76
What do you do when you want to total more than...

What do you do when you want to total more than one? I tried a text box with =SUM([product1]+[product2]) or =[product1]+[product2] but nothing seems to work.


=SUM([product1]+[product2]) should...
Forum: General 02-03-2003, 07:52 AM
Replies: 2
Views: 537
Posted By Jordan76
SQL

SQL - Structured Query Language.

It is the name for the language used to compose Query's for retrieving, updating appending ect data.

There are many sites in which have crash courses on SQL....
Forum: Reports 02-02-2003, 08:21 AM
Replies: 3
Views: 871
Posted By Jordan76
Thank you so much WayneRyan. Looking into it...

Thank you so much WayneRyan.

Looking into it now.

Sincerely,
Jordan
Forum: Reports 01-31-2003, 11:29 AM
Replies: 3
Views: 871
Posted By Jordan76
I cant figure out why whenever I run the report,...

I cant figure out why whenever I run the report, when including a subreport it prompts me for a value. The Value its asking for is the tblInvoice which is the name of my invoice table.

I think the...
Forum: Reports 01-31-2003, 11:12 AM
Replies: 3
Views: 871
Posted By Jordan76
Wierd Parameter Keeps Popping up

I have a report that prints cheques, it works great. It is based on a 3 table query.

It displays the Cheque, and payment details after.

I then added a subreport, to show how many passengers...
Showing results 1 to 25 of 49

 
Forum Jump



All times are GMT -8. The time now is 05:36 AM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World