Recent content by tkpstock

There are multiple COM addins that can cause this problem. I think one of the search engine (Google / Yahoo / etc) toolbars also caused this problem. Disable all your COM addins and see if you still have the problem. Load a COM add-in On the View menu, point to Toolbars, and then click...

Thanks Doc. It's actually a database which stores geographic features for every country on earth. The database itself is expendable - the data is publicly available and merely being cleaned up for an Oracle implementation which I'm currently building. It was just easier to clean up in Access...

There is no front end. I've written a couple of small subs and functions, but there are no forms, macros, etc. and only a few queries (not enough to bulk up the db.) The size of the DB is totally dependent on the one table that has over 5.6 million records - all the other pieces are relatively...

It was checked - but I exceeded the limit during some updates. The compacted version was over 1.5 gigs (one table has over 5.6 million records). When I tried extracting a subset of those records using a "select into" create table query, that bushwacked the whole thing. When it tried to...

That's what I ended up doing - I had to trash the 2-gig one. What a pain! I can almost see Bill's thought process on this one: Hmmmm.... Access is pretty robust. How can I get people to buy SQL Server if they can get Access so cheap? Oh! I know! I'll put an arbitrary limit of 2 gigabytes...

I've apparently hit the two gig limit in access. The database won't let me compact/repair. it wont let me save changes to tables. I can't open access by itself and repair the external table. I'm sure that the database could be shrunk down if I could get it to do the repair! I get an...

Are you using Livelink or some other COM add-in? See the solution (work-around) above - changing the registry key LoadBehavior with the add-in. HTH

One way to do it is to grab parts of the string and force it to a date. Example: st = "20060316" yr = left(st,4) mo = mid(st,5,2) dy = right(st,2) thedate = cdate(mo & "/" & dy & "/" & yr) HTH

Thanks Peter - I couldn't find the CanGrow property in the help - i was looking in Access help instead of vba help. Is there no other way to do it? Like code in an event in the details section to resize the field based on the size of its content?

That is a property in VB textboxes, but not in Access textboxes, apparently.

I have a main form with a subform (subform display is continuous forms and key field is linked to key field of main form). I have a text field (enabled, not locked) on the subform that I've set the Can Grow property to Yes, but it doesn't get bigger even though the text! I've set the detail...

I just had this problem... I think I resolved it by going into the immediate window of the vbe and using the DoCmd.SetWarnings True command and then saving the database. My conjecture is that it saves the last state - maybe by setting it in code or in the immediate window...? The database now...

Might've anything changed within your registry? Your classid info is stored there - if it got screwed up somehow, that may be a source of the problem. If you have access to a good registry tool like Norton Utilities, sometimes those problems can be fixed.

What it appears is that you have a continuous form - are the checkboxes a field in your table that the form is linked to, or just an unbound checkbox? If they are bound to a field in the table, you could then pass the recordset to the report: DoCmd.OpenReport "YourReportName", acViewPreview, ...

You use # to delimit dates in the same way you use ' quotes to delimit text strings and nothing to delimit numbers. I don't suppose you can post a copy of your database or just the form / code?