General

Documenter doesn't provide object types or names
The object documenter is not providing object types or names. It displays only the file path of the database, and the word "Test" where the object type and name should be. Solutions? ... 7 Jul 2008 14:33

is this one table or two tables?
I have to track purchase orders. I also have to track modifications to the purchase orders. Each purchase order has a unique number and includes the date, vendor, description and amount. Each modification has a number which is the p.o. number plus 1 digit (ex: po# 12-34-1234, mod# 12-34-1234-1). For each modifi... 7 Jul 2008 20:44

Entry Screen
How do I create a screen that will allow anyone to input information, but will not allow access to the tables, queries, forms, and reports. I would like it to have buttons that when clicked will open the corresponding form, etc. Thanks. -- SS ... 8 Jul 2008 10:01

Show/Hide expand indicator
I'm used to seeing the expand indicator (+) for tables which have a one to many relationship. One of my tables does not show this indicator in the datasheet view and I can't find how to turn it back on. ... 7 Jul 2008 14:33

'Data type mismatch in criteria expression' Error
When placing a function into a field of query builder, I expect to be able to apply a criteria. For example, for the following simple function: Function TestA(VarA) As String If VarA > 100 Then TestA = VarA End Function I can insert a field in to the builder: Expr1: TestA([RVID]) and apply the cri... 7 Jul 2008 14:33

Autonumber Question
I have a table in Access 2007 with a field called "Entry #" set up as an AutoNumber field to give a new entry in increments. The last entry # was 1345. When I try to enter a new record the next autonumber it gives me is 55582 and so on. Nothing has been changed in design. How can I fix this ? ... 7 Jul 2008 18:41

Getting error: ‘Object or class does not support the set of events
Good morning all..., Getting error: 'Object or class does not support the set of events' Reproduced: Open form (split form) and set 'Status' (combo box) to 'Resolved' or 'Closed'. More info: I'm running the following macro on the control's ('Status' field) After Update event. Condition Action Argume... 7 Jul 2008 14:33

Format month in crosstab
I have a crosstab query which groups by year and by month using Year and Month functions respectively. The Month([Date_Of_Procedure]) returns the correct month number but I cannot format it to show the month name; when I use the format property everything ends up as January as (I guess) it is using the julienn... 7 Jul 2008 12:29

User permissions
Can anyone point me to a 'simple' tutorial or article about setting user permissions in Access 2003? Thanks Sandy ... 8 Jul 2008 08:59

Cannot link address book to contacts folder after memory upgrade
My memory was upgraded while I was out and now my address book is gone. I still have all my contacts but when I follow Instructions on http://support.microsoft.com/default.aspx?scid=kb;en-us;287563&Product=ol2003 for linking my contacts to address book (Step 2 of instructions) it does not work. When I go to ad... 7 Jul 2008 11:28