BeforeUpdate fires the OnClose event 6 51 (9/4/2012 4:22:46 PM)
Hi, In the BeforeUpdate event, I am requiring a field to be completed and issuing a message "Activity is Required" if activity is null. I get the message but immediately the OnClose event is fired and the...
KW

Move items from a Form into a different Table 1 9 (9/5/2012 4:53:44 PM)
Hi, I want to place a button on my form to take the information in specific cel= ls and add them to another table in the data base, but I=92m not sure of th= e coding. From the form, I want to take the in...
Dromas (1)

Extract rich text from Word doc 8 27 (8/27/2012 10:26:27 PM)
I use the code below to extract (scrape) the text from a Word doc and put it into a memo field that is set to display rich text. However, the "richness" of the text gets lost with this method. Anyone kno...
danny1454 (19)

Unbound OLEGraph Updating Automatically 4 29 (8/21/2012 5:16:25 PM)
I am going mad with 3 graphs on a form! I can't stop them updating. When = I change it to Manual Access resets it back to Automatic (Update Options). = It does not seem to work in VB either. I know the gr...
james1483 (13)

Display record count based on parameters in current form 2 38 (8/28/2012 5:14:08 PM)
Hi All, I am working on a database that stores servicing information for industrial= equipment - it enables users to log the actions and work undertaken to ser= vice or repair equipment. This data is then...
oli.paris (2)

Access 2010 - Form - Box "Search" in Navigation bar 7 77 (8/30/2012 9:43:44 AM)
I'm tryng to replicate the box in object that can filter the visualized data while I digitize searching in every field of the table. I have realized something similar with this simple code that filter olny...
ancucchi (4)

Set default datasheet font in Access 2010 3 60 (8/30/2012 5:24:34 PM)
I'm stumped. Where do I set the default font for new tables when viewed as datasheets. Every new table I create uses 'Tw Cen MT (Detail)'. I can change it once the table is created but where do I set the def...
comcraft1966 (52)

Composite indexes are incompatible with the Web - Access 2010 1 68 (8/31/2012 3:13:21 PM)
I have three tables in a database that will be eventually migrated to SharePoint: tblProjects: ProjectID, ProjectName, etc... tblOrgs: OrgID, OrgName, etc... tblProjectOrgs: ProjectOrgID(PK), ProjectID, Or...
comcraft1966 (52)

Form Suddenly Became Non-Editable? 1 14 (8/28/2012 2:55:35 PM)
Got a data entry form with many fields on it. Suddenly all fields have become non-editable. The form's .RecordSource is editable. All I can think of is that I have fat-fingered some property that is c...
PeteCresswell

SQLServer database setup 2 34 (8/29/2012 3:19:37 PM)
Hi All, I'm wanting to put some Access tables on SQLServer, I was given a Server to use which has SQL Enterprise Manager v8 installed. Since I know nothing about SQLServer db's I've been playing with the s...
vulcaned (261)