Subforms Misbehaving, Size Discrepancy

Mar 28, 2005

Please refer to the screen snapshots.

I've got two subforms on an input form, and space is critical. In design view the forms are very close together (how I want them), as depicted in one snapshot. But then when I go to form view, each subform has a big gap below it, which spreads the two subforms apart on the form as shown in the other snapshot.

Why does this happen with subforms? I've poured through the formatting properties and can't figure out what causes this. Am I missing something?

View Replies

Forms :: Set The Size And Print Current Record With Subforms

May 30, 2014

I have a form that has 2 subforms. When I try to print the current file there are a few problems,

1) When you use the print option in File menu, and select "Selected Records" , it will always print the second record, no the one selected.

2) No matter how often I change the printer properties , it will not keep the paper size I request.

Is there a script I could use to set the size and print the current record ?

View 1 Replies View Related

SUM Discrepancy

Oct 26, 2006

Hi to all once again. I thought I had resolved this issue but the addition of more data has found a floor in my design.

I have a small DB I intend to use for auditing my companies hardware / software.

frmComputerSoftwareAllocation: Allows me to allocate software / software licenses to computers.

Process: I select the computer I wish to allocate software to:
'computerID'. I then select the software 'cboSoftwareID' and then allocate
a license 'cboLicenseNum'.

As you know there can be multiple license keys for any one instance of software. So this leads me to my problem.

qryLicenseAllocated

Software ID of 32 = Microsoft Office Professional Edition 2003
1 * Volume License = 10
1 * OEM License = 1

Problem: As a test I alocated 1 volume license and the 1 OEM. When I �sum� the number of licences from tblComputerSoftware instead of the query returning the desired result:

Microsoft Office Professional Edition : Licences Purchased 10 � Allocated 1
Microsoft Office Professional Edition : Licences Purchased 1 � Allocated 1

I get:
Microsoft Office Professional Edition : Licences Purchased 10 � Allocated 2
Microsoft Office Professional Edition : Licences Purchased 1 � Allocated 2

I can see what it is doing but after a long day getting this far can not see how to resolve it!!
Help very much appreciated.
Phil.

View 8 Replies View Related

Checkboxes Misbehaving

Jan 16, 2007

Hi everyone!

The backstory: I've recently started a new job and as such now have responsibility (with no handover of any kind) for someone else's very very messy Access database that has bandaids upon bandaids. And I don't know that much about Access LOL. I thought I knew enough to get it to do what I wanted, but apparently not.

So, I'm trying to add a checkbox to a continuous form. I've added a Yes/No field to the database and made sure all the records are populated in this field. The checkbox I've added to the detail section of the continuous form is bound to this field.

Now the problem - when all the records are displayed in the continuous form, all the checkboxes show grey-ness. And you can't click on them - it says "Control can't be edited: its bound to an unknown field". But the field is definately there, and there are no typos. It doesn't even have to be editable in this form (although that would be handy), it just needs to show one way or the other!!

I know that the field works because I have a checkbox on a different (non-continuous) form bound to this field and it works fine there.

Anyone who can help me fix this problem wiill have my eternal gratitude :P

View 1 Replies View Related

Large Field Size = Larger Overall Database Size?

Aug 29, 2005

Will keeping your field size shorter result in a smaller MDB file?

Or does Access only use as much space as there is real data in its fields.

Way back in the dBASE III days, dBASE would pad all your "real" information with as many spaces as necessary to fill up your field. I suspect that the MDB structure is probably smarter than that.

Another question on the same topic - I believe there is a maximum number of characters in a record (4000?). Can your field sizes add up to more than 4000, as long as the actual data, all combined, never totals 4000...?
Thanks............
..dc

View 3 Replies View Related

How To Link Subforms To Other Subforms On An Unbound Form

Feb 4, 2006

I forum could someone tell me:

I have an unbound form on that form I want to put three sub forms one on a products table the other on a course start dates table and the link table that joins the other two together. all three are related to each other with Pk/FK links.

When I try to link them it says you cannot link items on an unbound form.

regards in advance
Peter:eek:

View 1 Replies View Related

DB Size

Sep 18, 2006

Hi,

What should be done when the size of a database keeps getting bigger and bigger?

Regards,
B

View 14 Replies View Related

MDB Size

May 10, 2007

I'm trying to create an mdb that is well over 2 gig and everytime it gets to 2 gig, I get an Invalid argument statement. Is there any way to bypass this process and create an mdb in excess of 2 gig? I've tried linking tables, queries, etc and I have also compacted and this mdb is simply that big.

View 14 Replies View Related

Access Size

May 20, 2005

I'm still in design phase but I'm going to have more than 30 tables. I know I'm going to have a pretty good number of forms, queries and reports. Should I start preparing for the worst in case this db gets too big? What kind of techiques can I use to make sure that it still runs quickly enough?

Thanks

scratch

View 4 Replies View Related

Field Size

Jun 9, 2005

I have a query that consists of three fields. This query is then placed in a form. I would like to set the physical length of my fields because one field consists of 4 digit numbers (I want the size of this to be relatively small) and the other two field consist of categories (field that need more space so that the user may see each letter of the category) Please help.

View 1 Replies View Related

Size Matters!

Jun 14, 2005

In the time-honoured fashion of reducing the size of the front end of a db I imported everything into a new db. The size reduced from 32mb to 17mb. Success.

When I change anything, no matter how small, in the new db, it immediately increases in size back to 32mb. I always compact on exit.

This is annoying, rather than a major problem.
Am I doing something wrong or is this a �feature� of Access?
Access 2000 on XP professional.

View 2 Replies View Related

Display Size

Jan 24, 2006

Is it possible when loading a control form to set the users default display size to say 1024x768. I'm creating quite a complex form and it will be too large on an 800x600 display.

Ta

View 1 Replies View Related

Size Of Access DB

Mar 26, 2007

Hi there..

we have one access database with size about 600mb and 1 million rows in one table.My concern is is it bad to have so much data in access database. If so what is the possible solution for that.

Thanks
Danny

View 3 Replies View Related

DB Ballooning In Size!

Apr 4, 2007

Hey guys,

I'm not sure what happened, but my database size has gone from about 60MB to 290MB. I have added about 10 new records and had an AuditTrail function keeping track of history. I had problems with too many entries in this field, so I deleted the field and started fresh. I have also tried to compact and repair the database. Can anyone give me some light on this situation?

View 3 Replies View Related

Access Size

Dec 20, 2007

I will like to know if access can store a lot of data. I am using a database that was written in access and the database has been in use since like 2004. How long can we still use this database. It is becoming slow and having one or two error messages.

View 2 Replies View Related

Zero Size Mdb Files

Mar 11, 2008

Hi, I am new ( as of today) to this forum. I have been using Access for a few years following on from using Q&A. I manage a database for membership for a club and more recently designed my own database for another personal application. Last weekend I did a full backup on a new laptop I have that has both Access 2003 and 2007 on it ( I don't use the 2007 version at the moment) and following that most of the databases, including backups have gone to zero kb in file size. I tried a system restore to no avail. I can see the files but they are 0kb in size and won't open. Does anyone have any idea why this should happen and more importantly how (if) I can resolve it ?. The laptop has Vista as the O/S.

Kind Regards & greetings from a wet and windy Dublin,

Ian

View 4 Replies View Related

Size Of Datasheet

Mar 16, 2008

Is there any way you can specify the size of a datasheet?

Say the datasheet opens up with 600x800 size?
or 10cm x 15cm?

View 5 Replies View Related

Size Of Table

Feb 2, 2005

unfortunately I am making a form using more than 255 fields which is the max for access 97. I tried using more than 1 table but still no help.
what can I do? will upgrading help?

thanks

andrewm

View 14 Replies View Related

Table Size

Mar 6, 2006

There is probably a real simple way to do this but a couple of us are here racking our brains. :o Is there a way to tell how big a table is size wise? example 1.2mb

Thanks,
-Sandy :)

View 1 Replies View Related

Field Size

Jun 9, 2005

View 2 Replies View Related

Database Size Got Too Big

Jun 15, 2005

Hello friends,
I had converted a Access 97 database to Access XP. The original size of database was about 38 MB.Last week I worked with some queries of different types.Now the size is about 135 MB.How should I reduce the size of database again.I really also dont know whether it happened because of queries... :(

View 5 Replies View Related

Message Box Size

Oct 4, 2005

Hello out there
I have a query to be conditioned by an input to a messsage box. An example could go like this:

SELECT [Quote politician].rubbish, [Quote politician].garbage, [Quote politician].bullshit
FROM [Quote politician]
WHERE [Quote politician].rubbish Like [Type the words or quotes of rubbish which your favourite politician has babbled];

The message box is not big enough to accomodate this long instruction. Is it possible to enlarge it?

nsv

View 3 Replies View Related

File Size

Mar 16, 2005

hi all,

on a form i have 2 fields
one for import a file with the filedialog
2e for the size of that file
how can i have te size from the file in that field
can someone help me with that code

thanks

View 1 Replies View Related

Form Size

May 4, 2005

hi all

i am new to access.I have a continous form with lots of coloumns.Is there a maximum size defined by access .

I checked this on the forms properties ..its showing the width for the form as 22".i tried to increase this but everytime it sets to this value.

Is there any way i can do this.

Thanks,

View 1 Replies View Related

Re-size AcDialog Box

Aug 25, 2005

I use the Docmd.open form with acDialog parameter as I need to interrupt the code for the user to select some information before proceeding. Is there anyway to control the size of the dialog box as currently in a continuous form format, it only shows 3-4 records. The screen is large enough to hold probably 10+ comfortably. There are vertical scroll bars but I would like the dialog box to open with more than 4 records showing.

Thanks

View 2 Replies View Related

Size Of Forms

Mar 23, 2006

I have a button on Form1 that when clicked opens Form2. I want Form2 to be a certain size everytime it opens. I can't seem to get this to happen, it always resizes depending on Form1 being maximised or not.

Dusp

View 1 Replies View Related