General

Report Formatting
Hi all, I have two divisions of a company..and i have 1 sales report. This report is opened by both the divisions whatever the choice may be. Now my report has a logo(image) at its header which is different for both divisions. How do I code it so that according to the division chosen by the user, the report o... 4 Jul 2008 10:00

Access 2007 - Different Ribbons for Different Users?
This is driving me crazy. Unlike some people, I rather like the Access 2007 ribbon user interface, and I find creating custom ribbons quite straightforward. BUT what I want to do now is to have different custom ribbons displayed for different users. I have a start-up form which pops up a log-on dialog to req... 4 Jul 2008 12:04

Relationships & Primary Key in a Book Inventory Database
I am trying to create a database for a book program that I run. I am currently using an excel spreadsheet to track all books in inventory and who they are checked out to, but I know a database would be a lot easier so that more than one person can make transactions at the same time. The problem I have is I ... 6 Jul 2008 18:06

specify users in access
In an MSAccess 2003 database, how do I identify and refer to the current user? ... 4 Jul 2008 03:52

Case statement Problem
I am having trouble with this code can anyone help. I have the follwing case statement that checks the value of the combo box, and based on that it will select which report to print, but I can not get it to work Select Case ReportPrint Case "Me![Combo28].column(1) = Like'B*'" stDocName = "Pr... 5 Jul 2008 10:28

List box Full warning!
If my list box is full my vertical scroll bar appears! If I had a label [lblWarnimg] is it possible to become visible once my list box becomes full? -- Thanks in advance for any help with this......Bob WindowsXP..MS Access 2007 ... 4 Jul 2008 19:13

Input Mask query
Hi all, I have a textbox for telephone and fax nos. for which i added the input mask as telephone no. (999)-(999)-(9999) (the default no., that is...) The requirement is that if a no., say, +86-23-4455 has to be added, the format does not alllow it and writes the no. as +86-234-455. Also, it should not becom... 4 Jul 2008 00:49

Compact and Repair Problem
In Access 2007, I ran COMPACT and REPAIR on a BE database of 8 tables amounting to 8 megs (post operation the database was 4. 5 megs). When I opened forms in the FE, some (5 of them) showed fields that were clearly not hitting the right spots in the BE (“########” in many cases, for instance). I relinked tho... 3 Jul 2008 20:44

I want to automatically move to the next cell without tab, etc
Is there a way to automatically move to the next field once a set number of characters has been keyed. Ex. I set a field in access 2003 to a limit of 5 characters. Once I keyed the 5 characters I want to automatically advance to the next field. ... 3 Jul 2008 21:45

Web component issue
I had implemented Data Access Page with MS Access 2003. However, when I run the Data Access Page on some new computers, it require OWC10( MS office Web component 2002). All the new computers already had MS office 2003 and OWC11( MS office Web component 2003). Could any one tell me what/where i went wrong? ... 6 Jul 2008 21:10