Access 2007-2019
Access 2000-2003
Access Seminars
TechHelp Support
Tips & Tricks
Access Forum
Course Index
Topic Glossary
Insider Circle
Home   Courses   Seminars   Templates   Help   TechHelp   Forums   Contact   Join   Order   Logon  
Home > Forums > Access
Access Forum

Welcome to the Microsoft Access Forum. Access is by far our most popular topic here at Computer Learning Zone. This forum is for everyone to read but only students can post here. If you'd like to become a student, all you have to do is enroll in one of my courses, which you can do for as little as $1. After you create a logon, you will have full access to the Forums.

Subscribe to this forum and receive an email update whenever new posts are added. You will also be notified by email if any conversations you are involved in receieve new comments. Yes, even non-students can subscribe to update notifications.

NEW: Access Developer Students, make sure you subscribe to the Developer Student Forum.

Click Here to Post a comment and start a new discussion

Please read the FORUM RULES before posting.


Continuous Report Upload Images   Link  
Beau Tanner 
3 months ago
I understand how to make a continuous form, but how do I make it print as a continuous report?

One of my forms is just a survey record: the date the building was surveyed and who surveyed it.  It is set up as a continuous form; however, when I go to print the report, it prints one name per page.  Frustrating!  How do I get all of the names to print continuously?
Beau Tanner
3 months ago

Beau Tanner
3 months ago

Add a Reply
Enter Key Behavior Upload Images   Link  
Tabitha Harris 
3 months ago
Can anyone tell me what I possibly did wrong?  I created my own form with a box for long text.  However, when I try to enter text, it will not let me go to the next line instead when I hit enter, the cursor goes to the next box.  I have not had this problem before.  Interestingly, the other boxes with long text in my form, there is no problem with hitting enter and going to the next line. Thank you for any assistance!
Adam Schwanz
3 months ago
First, double check that it's a long text field, if you didn't accidentally change anything that sounds like it's a short text.

If it's long text then go to design view and click the long text box. Go up to the top and click Property Sheet. Go to the Other Tab, there's a property there called Enter Key Behavior, make sure that's set to New Line in Field
Add a Reply
Nesting Upload Images   Link  
Marius Steenkamp 
3 months ago
Hi Guys. I an new at designing and am struggling with a nesting formula in vba or expression. Can anyone help. I need to cut material. So there are 3 options to work out best fit- 1. DesignWidth/ MaterialWidth /Qty 2. DesignHeight/MaterialWidth/Qty 3. DesignWidth is bigger than Material Width, you will have to work out the amount of material in length you will need to do the work. Read More...
Adam Schwanz
3 months ago
Could you explain what you are trying to do?  Not sure what the nesting formula is for, or what you want done with option 3.

But you could just add a textbox and put =DesignWidth/MateralWidth/Qty to get the number, then another textbox for the other if you're trying to compare them.

If you're looking for VBA to automatically give you the best number, you'd need to do something like this with a button on click event and a blank textbox

Dim X As Integer
Dim Y As Integer
X = DesignWidth/MaterialWidth/Qty
Y = DesignHeigh/MaterialHeight/Qty
If X > Y Then
TextBox = Y
ElseIf Y > X Then
TextBox = X
End If

You should probably also wrap the calculations with NZ to prevent errors. You'd also have to figure out how to handle option #3 to put it into the comparison.
Marius Steenkamp
3 months ago
I do printing of vinyl. Let me give you an example. Desigh size 80mm x50mm . Media Size 1350mm That means i can fit from left to right 1350/80 = 16 or 1350/50 = 27. If my qty is 200 . I will have 200/16 = 13 rows ( up/Down ) and 16 rows (Left Right )  on the 80mm side. I i rotate  i will have 27 rows ( Left to Right ) and 8 rows ( Up and down ) The bigger the design are the more complex the formula gets. If you get a size bigger than material width like 4000 x 3000 then the formula will have to work out the best way to print . It must always end up with the least amount of material needed to do the work.

Hope this helps
Add a Reply

Show Older Comments...
View in Table Format

Start a NEW Conversation
Only students may post right now. Click here for more information on how you can set up an account. If you are a student, please LOG ON first.

You may want to read these articles from the 599CD News:

12/8/2021Access Beginner 4
12/8/2021Access Beginner 3
12/8/2021Access Beginner 2
12/3/2021Access Beginner 2
12/3/2021Access Beginner 2 Lessons
12/3/2021Access Beginner 2
11/30/2021Import Multiline Cells
11/30/2021Adam's Access Games
11/29/2021Prevent Close

Access - index
Excel - index
Word - index
Windows - index
PowerPoint - index
Photoshop - index
Visual Basic - index
ASP - index
Account Login
Online Theater
Lost Password
Student Databases
Change Email
Latest News
New Releases
User Forums
Topic Glossary
Tips & Tricks
Search The Site
Code Vault
Collapse Menus
Customer Support
Web Site Tour
Consulting Services
Affiliate Program
Richard Rost
Free Lessons
Mailing List
Video Tutorials
Learning Connection
Idiot's Guide to Excel
Volume Discounts
Payment Info
Terms of Sale
Contact Info
Support Policy
Email Richard
Mailing Address
Phone Number
Fax Number
Course Survey
Blog RSS Feed    Twitter

YouTube Channel    LinkedIn
Keywords: microsoft access forum  PermaLink