Search results for query: *

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 =...

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 =...

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 "/wrkgrp" 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...

I am trying to open custom made Help file for my Access 2000 application (using a VBA procedure). I do not wish to open a context related topic, but the Help Topics dialog box. I think I can use the WinHelp API function, but cannot find the numeric value of the "HELP_FINDER" command...

I have spent all day trying to open custom made Help file for my Access 2000 application (using VBA procedure). I do not wish to open a context related topic, but the Help Topics dialog box. I think I can use the WinHelp API function, but cannot find the numeric value of the...

I am using Microsoft Help Workshop to create a help system: when I compile my topics file (.rtf) and the help project file (.hpj) without specifying a contents file (.cnt), the help file (.hlp) opens with Index and Find tabs. When I compile the topics and project files together with the contents...

I am using Microsoft Help Workshop to create a help system: when I compile my topics file (.rtf) and the help project file (.hpj) without specifying a contents file (.cnt), the help file (.hlp) opens with Index and Find tabs. When I compile the topics and project files together with the contents...

I seem to have encountered peculiarities when using the new Access 2000 conditional formatting on a continuous form: 1) I use flat, white-background controls with transparent border style; I leave small gaps in their horizontal spacing and set the Detail section slightly taller than the height...

I have a record in my database which reports error: 3197 - two users are attempting to change the same data at the same time. The problem is that the error persists even though all other users quit from the database: and it is triggered by the only remaining user tabbing into one particular...

Using Access 97.<br><br>I had a form in modal state and I tried to set it to reset itself to normal mode via VBA while opening another form. Following this the database is unusable.<br><br>On trying to compile or trying to run anything I get an automation error, highlighting an object (database)...