Recent content by pavla

Thank you for your detailed reply. – I think I am fairly tidy in closing objects and the database compacts on close. The database is native to Access 2007, too. Everything else behaves orderly. I do like your suggestion of monitoring the memory usage properly from the Events Log, though there...

Yes, thank you for the suggestion, I did think of that one, too, and had checked the Task Manager precisely because I wanted to be sure nothing else was running. So that is not it, but a reply from another forum (I am afraid, I posted the query elsewhere, too, because I spent so much time...

I have an Access 2007 database with strange behaviour: the same database, opened with the same version of Access 2007 halts on my new computer with run-time error 2004 There isn't enough memory to perform this operation. Close unneeded programs and try the operation again when I try to open a...

I have a bitmap picture stored in an Attachment field (one picture in one Attachment field). - I would like to display this picture on a form bound to another table. I have put an unbound Attachment control on this form. I have tried to display the picture by running VBA code: 1. creating a DAO...

I have a bitmap picture stored in an Attachment field (one picture in one Attachment field). - I would like to display this picture on a form bound to another table. I have put an unbound Attachment control on this form. I have tried to display the picture by running VBA code: creating a DAO...

I have been developing Access databases for individuals/small groups for many years starting with Access97 up to Access 2003. My three versions (Access97, Access 2000 and Access 2002) of the SYBEX Developer’s Handbook (Litwin-Getz-Gilbert-Gunderloy) well dog-eared are always opened by my side. I...

I would like a good book on publishing Access database on the web. I have been developing with Access (using VBA, too) for many years, so I am OK with database concepts and making user friendly local databases, but know nothing about the web: Do I need to know about designing a web page onto...

On a form in the new PivotTable view (Access 2002), I can sort pivot table fields in, say, column area in order other than alphabetical one by setting the field’s OrderedMembers property: PivotTableObject.ActiveView.FieldSets(“FieldName”).Fields(“FieldName”).OrderedMembers =...

Does not the SELECT statement: SELECT tblState.idnStateID, tblState.StateLong FROM tblState UNION SELECT "*", "<All>" FROM tblState ORDER BY tblState.StateLong; generate a list of all your states from the tblState and then as many lines of “<All>” as there are records in the tblState? To add...

I am using new in Access 2002 pivot table view on a form: I can sort pivot table fields in, say, row area in order other than alphabetical one by setting the field’s OrderedMembers property: PivotTableObject.ActiveView.FieldSets(“FieldName”).Fields(“FieldName”).OrderedMembers =...

After many hours of careful scrutinizing of much sample code I think I have figured it out: while setting up the data structure before the function (API common dialog function “GetOpenFileNameA”) is called, do not set any values for the CustomFilter (not even empty strings and zeroes) - just do...

I have been using Window’s API common dialog function “GetOpenFileNameA” both from Access97 and Access2000 in Windows98. This function, as it was originally constructed, does not seem to work any more now I have changed to WindowsXP: the dialog box does not open at all. What do I need to...

Why, if I open my Access 2000 database with the Display Database Window unchecked (I am opening it with a custom built menu bar to give users access to the database forms, etc), some built-in commands on the menu bars (both the custom built menu bar and the default menu bar: toggle between the...

I have an Access 2000 database. I have created a new Workgroup file and attached it to my current database by using the &quot;/wrkgrp&quot; startup command-line option specified for a shortcut which opens the database. However, the default SYSTEM.MDW workgroup file still exists in the folder...

I have both Access 97 and Access 2000 installed on my machine. I am able to run both versions of Access simultaneously. I need to, on a regular basis, transfer data from the Access 97 database into the Access 2000 database. When this transfer is going on I would have just the Access 97 database...