Variable Box Size

Dec 19, 2012

I am trying to create a box that represents a certain amount of time in graphical form. I was thinking of making some sort of box that will change the width of it according to a field that is in either a table or query. I am trying to do it in a report but I am fine with a form if I must, but I figure if I could do it in one I could do it in the other. I was hoping to just set the width to the variable but I am unable to make that work since it says that it must be in numerical form.

View Replies


ADVERTISEMENT

Reports :: Variable Report Depending On Data Size

Oct 3, 2013

I have now a report that span around 2 pages. It has subreports in the report that depening how many rows there are they can grow or shrink.I have the problem that the second page the top margin is to close to the top of the pager. The paper has a logo on the right top side. I can make the first page look nice under the logo, but the second page prints to close to the edge that prints over the logo. I did add a page break, but when the page 1 has more data, it flushes this to the next page. The page 2 is now page 3. How can I avoid that, or make it so that the margin of the second page/next page is on the correct lenght of the top. I tried it with the page setup, but it does not work.

View 3 Replies View Related

Reports :: Variable Size Boxes In Reports?

Dec 12, 2013

I'm trying to create a simple chart in Access but I can't seem to do it. I can create it very easily in Excel. It's just a simple posting of values that I want to give a report on with every record. I'm including an example of what I would like to do...(but with ACCESS, not Excel)

It's basically a set of scores for students. I remember reading somewhere how someone created a chart using VBA with boxes, and not the charting system in ACCESS but I can't seem to find that again.

Also, I want to be able to report on each student separately. That is, they are doing 6 tests and I want to show how they did on those tests with a simple bar graph.

View 5 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

Reports :: Subform Field Linker Error - Obj Variable Or With Block Variable Not Set

Apr 16, 2013

I am creating a 2 level report to confirm an order. Main report already created, runs successfully called as subform/subreport under "OrderDetails" form. Linked to master using Order.ID. There are two versions of the confirmation report that have different layouts for different program types.

The hangup comes when I try to add a "Class Dates" subreport. It lists dates of individual classes and Skip dates. I have created the subreport as "srClassDates". When I add it to the main report, it lists the records. However, when I try to link it to the Main report, an error message box appears with the "object variable or With block variable not set".

I have tried rebuilding both the main and subreports, rebuilt the query, have not found anything that changes the result.

Linker has been working successfully on other subforms. Report with groupings works fine, but I need data from 2 tables both linked to order.id.

View 2 Replies View Related

Modules & VBA :: Error 91 - Object Variable Or With Block Variable Not Set

Jul 8, 2013

Error 91 - Object variable or With block variable not set

I am getting this error telling me that an object variable is not set.

I know which variable it is but when I step through the debugger it sets the variable and all is fine? Issue is that public variable of a class is not getting set when the VBA Editor is not open?

View 14 Replies View Related

Modules & VBA :: Sorting / Object Variable Or With Block Variable Not Set

Oct 3, 2014

This code runs fine the FIRST time, however trows up a message the SECOND time it is run.

The error is on the line ".Range"

I am trying to sort records which have been exported to Excel.

Dim LR As Integer
LR = 5
Set xlApp = CreateObject("Excel.Application")
xlApp.Visible = True
Set wbRef = xlApp.Workbooks.Add
With wbRef

wbRef.Activate
.Worksheets("Sheet1").Activate
With ActiveSheet
.Range("A2", .Cells(LR, "O").End(xlUp)).Sort Key1:=.Range("C2"), Order1:=xlAscending, Header:=xlYes
End With
end With

View 3 Replies View Related

Modules & VBA :: Update Contents Of Variable But Not The Variable Itself?

Aug 20, 2014

I look at a lot of files to see when they were last updated. I wanted to write a generic procedure to manage that so ..

Code:
Public fDate As Variant
Public vField As String
Public vFile As String

'GTSdata
vField = "txt_gts_data"

[Code] ....

What I hoped Me.vField would do is update the date field [txt_gts_data] on my form with the date the file was last saved.

i.e. me. txt_gts_data = fDate

What actually happens is the variable vfield gets updated from "txt_gts_data" to 19/08/2014 then later code falls over because the fieldname is lost .

Me.[vField] corrects itself to me.vField (and does not work)
Me!vfield falls over (cannot find the field vField, not surprising J)

How do I say update the contents of the variable, not the variable itself?

View 7 Replies View Related

Reports :: Object Variable Or With Block Variable Not Set

Apr 15, 2015

Runtime error '91'

Running Access 2010.

I have two reports running off of the same crosstab query. I copied one report to make the second report, then modified the second report to change the background of column fields satisfying certain conditions. These lines of code were added to the Detail_Format section, in color below. The report with the extra code lines does not error--the original report errors.

Code:
Option Compare Database
' Constant for maximum number of columns EmployeeSales query would
' create plus 1 for a Totals column. Here, you have 9 employees.
Const conTotalColumns = 11

[Code] .....

If I say OK (rather than debug) after the error message, I can then click the button for the report again and it runs without complaint. And, as I said, the report with the added code never errors.

View 4 Replies View Related

Object Variable Or With Block Variable Not Set

Apr 23, 2006

I have a networked database. It is accessed with computers that have both Office 2002, and office 2003. I get the following error message on computers with Office 2003:

"Object variable or With block variable not set"

It happens occasionally and the problem generally fixes itself so I dont think there is anything wrong with my coding.

And when it happens on the computers with office 2003 the ones with office 2002 can open the database fine.

What can be causing this?

Thank you in advance

View 1 Replies View Related

Object Variable Or With Block Variable Not Set

Dec 14, 2006

Good afternoon all,

The following block of code was working great until I came into work this morning. This routine is called from the OnClick event of several combo boxes. When it does, I recieve the error listed above (Object variable or With block variable not set) on line:

If Me.cbxAss_Filter <> "All" Then

Any ideas? I'm running on no sleep in the last 24 hours so I'm sure I'm missing something simple

The code itself checks the contents of a form and builds a string of conditions which I apply to the Form's filter property to filter records.


Code:Public Sub CreateFilter() '************************************************* **** 'Name: CreateFilter 'Purpose: Generate a string to filter the form 'Inputs: None 'Outputs: None 'Instigates: Me.Filter ' 'Updated: 11/30/06 'By: Chris Lounsbury '************************************************* **** 'Vars Dim strFilter Dim lngLength As Long strFilter = Null strFilter = "" 'Each filter box has its own check for contents If Me.cbxAss_Filter <> "All" Then strFilter = "assigned = '" & Me.cbxAss_Filter & "' AND " End If If Me.cbxAction_filter <> "All" Then strFilter = strFilter & "action = '" & Me.cbxAction_filter & "' AND " End If If Me.cbxStatus_filter <> "All" Then strFilter = strFilter & "status_rsrch = '" & Me.cbxStatus_filter & "' AND " End If If Me.Combo34 <> "All" Then strFilter = strFilter & "rims_flags = '" & Me.Combo34 & "' AND " End If If Me.cbxAAMB_filter <> "All" Then strFilter = strFilter & "aamb = '" & Me.cbxAAMB_filter & "' AND " End If 'Check if filter string was built If strFilter = "" Then Me.FilterOn = False Else 'Determine length of Filter String 'minus the trailing ' AND' lngLength = Len(strFilter) - 5 'Chop off ending ' AND' and set the form filter If lngLength <= 0 Then Else Me.Filter = Left(strFilter, lngLength) Me.FilterOn = True End If End If 'debug 'MsgBox (strFilter) End Sub

View 1 Replies View Related

Please Help: "object Variable Or With Block Variable Not Set"

Mar 1, 2006

I get this error message, " object variable or with block variable not set", when I'm in the design view of a form wanting to use the command button wizard. Using a brand new database/blank I imported a table from my database in question. I then tried to make a new form and put a button on it. It worked for awhile but then when I close the database and reopen it to add another button to the same form, I get the error message again. It isn't a problem that is specific to my homeschool database. It affects all the database I use/maintain as well as any new "test" databases I've made trying to figure out this problem. I looked at references before and after the error occurs and there is not difference. I've also looked at code but don't see anything code that requires variables to be defined. In the case of the test database with one table and one form there is no code to look at until I make a button before exiting and even then, I don't see anything weird.

I would appreciate any help you can offer.

I've attached the original database I was working on when the problems began.

Is it possible for a database program to adjust security levels on certain reference libraries when installed on ones computer, thus making all other database act up that are using those libraries?

Thanks,
Kris

View 3 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

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 2 Replies View Related







Copyrights 2005-15 www.BigResource.com, All rights reserved