2003==>2007: Safest Path?
We have an immediate need to convert an MS Access 2003 app and it's 2003 back end DB to 2007. We do not want or need any of 2007's functionality at this moment. I'm thinking maybe the safest path would be to use each of those DBs as 2003 .MDB files and just execute with 2007 - converting/testing at some later... 25 Jun 2010 20:51
printing a report without blank pages after a record in Access 2007
The report is printing some 7 fields from a Table which has 14 fields. The report gets its data(to be displayed) from a single table only. In the layout view in Access 2007, it looks fine as I want it. But, in the Print Preview, I notice there are 2 blank pages after one record. Also, the first three pages of... 23 Jun 2010 17:17
Hi All, In AccessXP I have a need to select a random sampling from a large set of records giving the process some guidelines as in, from a 1000 records randomly select 50 each LOB = Auto, BOP, WC 10 each Tranaction Type = R, N, RW, C, H within each LOB This will be done daily and the # each LOB and # each ... 28 Jun 2010 11:41
Limited amount of characters displayed in report.
If I make a report one field displays limited amount of characters (252) while another field has no limitation. Both fields has format "Memo" and data of the respective fields is filled form the same form and is stored in the same table. Access 2003. Bart ... 30 Jun 2010 08:39
Customized login-password scheme
Dear Access Gurus, I woulld like to customize a login password protection scheme for my database. Based on the login name, a password will be automatically generated based on certain security algorithm. May I know if this can be done for Access using macros? Thank you very much. ... 25 Jun 2010 00:05
Scroll records with the mouse wheel in Access7
I noticed a problem with Allen Browne's Access7 tip using the mouse wheel event to scroll records in form view with Access 2010 beta. Access calls the event twice for each move of the mouse wheel, which causes skipping over records. I added code to check the count for each move of the wheel, then count down to 1 be... 22 Jun 2010 11:33
Update Statement - Replace, Wildcard, and partial update?
Hi, I am trying to create an update statement that will replace values based on a wild card and only replace the wild card data (not the entire field). Does anyone have any suggestions? Is this even possible? Here is my code: UPDATE UPDATE MyTable SET MyField = replace(MyField, '*[0-9][0-9][0-9][0-9][0... 24 Jun 2010 16:21
Setting IE Cookies - Windows 7
I have just gone from XP to Win7 and have run into a cookie issue. I wonder if anyone here has managed to successfully set a cookie in IE under Win7 or Vista...? Here's what works in XP: Private Declare Function InternetSetCookie Lib "wininet.dll" _ Alias "InternetSetCookieA" _ (ByVal lpszUrlName As String, ... 22 Jun 2010 19:20
Can't use recordset after splitting
After splitting the database, portions of code that use recordsets (now based on linked tables) don't work. Runtime error 3251 "Operation is not supported for this type of object." I've read past posts on the same issue, but I can't get any solutions to work. Self- taught amateur (so be gentle and use itty-bitty... 22 Jun 2010 19:20
Can't delete module
I have a module named 'Module1' which was created in error. If I try to delete it I get the usual 'Do you wish to permanently delete....' message but the module remains. If I try to open it in design view, I get a message 'The module name 'Module1' is misspelled or refers to a module that doesn't exist'. So I c... 22 Jun 2010 00:40