Search results

Workaround: design a smaller (say half-sized) report, and scale it to 200% at the printer driver before you output or preselect your paper size, and select 'scaled to fit' on your printer settings.

ditto what Doc_Man said. Assuming (rather than FORCING) a sequence or order to be in a table can lead to DISASTER. In excel, add another column with a simple formula like (assuming your range starts at A1): D3: +iif(A3<>"",A3,A2) (and copy down as needed in D) and use column D rather...

First of all, you shouldn't add text into your posts once another has posted to the thread, as your revisions are usually overlooked. It's better to post again with followup questions such as this. To answer your concern, you would simply add a new record in your link table for each instance...

It sounds to me that you have an access db with no proper structure at all. If it were me, I would redesign the thing, complete with normalization. It might sound like a lot of work, but I can almost guarantee that the effort will pay for itself many times over in future effort savings.

You ARE aware that, eventually, you are going to want to APPLY your accumulated knowledge on something that 'isn't on a test' ! Learning about a topic is NEVER a waste of time.

Your db is likely split into a front end / back end (FE/BE) structure. Each user has their own FE containing the forms, queries, reports, etc (probably on their individual PC hard drives) while the single copy of the BE containing all of the tables (and therefore the actual data) is on a...

Let's break your problem down a bit. You are hinting that you need to keep track of inventory, or at least a pseudo-inventory, in order to properly track and connect orders, demands, fills, etc. So the first thing that I would do is search these forums for inventory control threads, as there...

As long as you only need four or fewer different colors, you can use 'conditional formatting' (CF) on all Access versions after 2000. Just write expressions for each of your cases, with the default color being one of your choices. So, you format the text in the control to be green in the usual...

Rule of thumb: If a piece of information about a store is unique, like an address, it belongs in the 'store definition table' (your [strgenrl]). If a piece of information may occur more than once, it needs to be in a separate table, with a unique identifier, and use a foreign key to link it...

Charlie picks up a woman in a bar. They get in his car, and they're going down a dirt road to Lover's Lane, when he gets a flat tire. He looks in the trunk, and his spare is flat, too. He figures, what the hell, he's gonna get a little bit. So they get in the back seat, and he's just getting off...

There's nothing wrong with what you are doing, but... It looks like you are using the '+' (subdata) available in table view. Yes, this happens to show you one direction of your many-to-many relationship between child and parent when viewing table A, but Access merely picks the 'most likely'...

I have been wanting to do that precise thing for more than a year now, but i have yet to discover a way to do it! I too have assorted existing pdf files that I want to include in reports. I don't want to store the contents of the pdf file in Access, and I don't want to have to convert the pdf...

Is there more than one client from whom they receive such a list? Assuming no... Optional: Assuming there COULD be more than two types of transactions, beyond 'cash' and 'credit', make a lookup table called [TransactionTypes] that contains an ID field and a value field. Initially, it will...

If it were me, I would build a new table (say [tblQuestionResponses]) and establish a one-to-many relationship with your table presently containing the survey Question reponses. This new table will contain the responses (if any), beyond the yes/no choice, so you are not carrying a lot of empty...

Have you looked at the 'Find Unmatched Records' Query Wizard?

Whenever I am trying to INCLUDE complex groupings of records with diverse criteria, I often flip the problem around to look at it from an EXCLUDE standpoint. If you can create a query with all of the records you DO NOT want, then you can have a second query use this and the "NOT IN" statement...

To increase visibility, I have reposted this question to the general forum: http://www.access-programmers.co.uk/forums/showthread.php?t=75848 Please respond there. I apologize to those who detest multiple-posting, but I decided my question belonged over there.

I would like to show a pre-existing .pdf graphical file on a report (and a corresponding form, if that is possible). Ideally, I would like to associate such files to an appropriate field of each record in a table, and have the CONTENTS of the pdf file show up as part of a printed report, as an...

I would like to show a pre-existing .pdf graphical file on a report (and a corresponding form, if that is possible). Ideally, I would like to associate such files to an appropriate field of each record in a table, and have the CONTENTS of the pdf file show up as part of a printed report, as an...

I am usually guilty of thinking that ANYTHING can be done using Access, but... Weren't speadsheets like 1-2-3 and Excel actually invented to help accounting-types with their chart-of-accounts, ledgers, etc. I thought the use of spreadsheets by the 'beancounters' was the first 'killer-app' that...