-
WSDrew
AskWoody LoungerOk, I’m a little busy at the moment, trying to get a project for work done, so I don’t have the time to modify the code for you. But here’s what you should do. Where it is opening the recordset, change that line to open a SQL statement that queries for that email address…then check for EOF/BOF. (Stay away from filters in a recordset….). If there is a record, close the recordset, and create the HTML you want to display, otherwise, close the recordset, reopen it (like the original line) add the record and display whatever you want for that.
To display different data to the user, use conditional formatting:
This text is displayed to the user if x=something, it’s HTML, so
would display to the end user as a line breakThis is displayed if x doesn’t equal something
Within conditional formatting, you can ‘place’ variables into the html with like this:
Hello
hope this helps.
-
WSDrew
AskWoody LoungerThis shows some promise. Unfortunately, I’m swamped today, I’ve added that site to my favorites. If I figure out a way to ‘hook’ into AD, I’ll post my solution here.
-
WSDrew
AskWoody LoungerThat’s possible. Honestly, I have code that can get the data I am looking for. Wouldn’t be hard to modify the code so that I can set it as a service to ‘check’ for changes by doing comparisons. I just don’t want to have a service constantly checking AD. I actually have a service I wrote that does check AD for locked user accounts. Runs once a minute….very quick code. There are hooks for all sorts of things, was just hoping there was one for AD.
-
WSDrew
AskWoody LoungerJanuary 10, 2008 at 4:22 pm in reply to: Including Folder Name when Printing tasks (Outlook 2003) #1091912Thanks Joe, that did the trick. (Actually, I added the ‘In Folder’ field)
-
WSDrew
AskWoody LoungerCool, well if you have any specific questions, give me a holler.
Have you ever made an asp page?
-
WSDrew
AskWoody LoungerWhat about the folder that the database is in?
-
WSDrew
AskWoody LoungerOk, so the account has nothing to do with Access itself, both the admin and the limited user are NT based accounts, and both are logging into the database with Admin (the default account). If that’s the case, then it’s not an Access issue, it’s a file permission issue. Create a .txt file in the same folder as the .mdb, then log in with the limited account, and see if they can change the contents of that .txt file.
-
WSDrew
AskWoody Loungergoogle for request.cookie and response.cookie. The first ‘reads’ cookies from the web user, the other writes.
I started with Access 97, taught myself how to write VBA code, and about 2 years later decided to give asp a whack…haven’t turned back since. I love web interfaces, they have some distinct advantages over anything else (with only a few drawbacks).
If you have the MSDN installed, take a look at the ASP Built in Objects reference card. Pretty handy.
-
WSDrew
AskWoody LoungerSorry for the delay in replying, but you really shouldn’t use the IP address to identify something with a web user.
Instead, create a user id and set it as a cookie. Have each page check to see if a session object ‘exists’. If it does, that object is the user’s ‘id’. If not, check for a cookie (you can set and read web users local cookies for your sight) value.
Now, this is a stripped down version of actually having user accounts, where a user has a username and password. (using the cookies will work, but if someone wipes out their cookies, they’d get a ‘new’ account the next time.
-
WSDrew
AskWoody LoungerWhat is the limited account? Are we talking an Access User Level Security account, or an NT account?
-
WSDrew
AskWoody LoungerThanks Hans. I hope I get a reply too. I haven’t found what I am looking for through google yet. I just need to know if it’s possible.
-
WSDrew
AskWoody LoungerDecember 22, 2007 at 5:49 am in reply to: Quick Question- How do you list all tables in … (Access) #1089545Thanks! I’ll try to be more active, just got too busy with work.
-
WSDrew
AskWoody LoungerDecember 22, 2007 at 12:23 am in reply to: Is it bad to use Memo Data Type? (Access 2000 – 2007) #1089516A lot of information has been posted already. Text fields are limited to 255 characters, because the first byte of storage represents how many characters will follow, so if there are 10 characters stored for the text in a field, in the actual .mdb file, where that field ‘starts’ will be one byte with the binary value of 10, followed by the 10 bytes representing the characters of the field. So Access never takes up more space then necessary for text fields, due to this prefix byte.
Memo fields, as already explained, are stored outside of the table structure (from the standpoint of the actual file structure of an .mdb). Size wise, however, Memo fields are in theory allowed to take up the entire space of the database. The 65k character limit is only applicable when the data is entered through the Access interface, such as a form, or table view. If you put data into a memo field programatically, you’re limited to the physical disk space limit of the .mdb (1 gig in 97, 2 gig in 2000 and later).
However, the main reason I am posting to this, is that there are other differences which should be taken into consideration when designing a database structure. First, Text fields can be indexed, Memo fields cannot (at least Access won’t index them…). So when data is entered into an indexed text field, doing a search in that field will have jet hit the index. Doing a search in a memo field will have Jet running through the entirety of every applicable memo field. If you have hundreds of megs of text, that’s a lot to run through.
Also Memo fields have some issues with queries. Off the top of my head, I know you can’t group by a memo field, you can with a text field.
Don’t misunderstand me, I use memo fields all the time. I use them when I have no idea how much text is going to be entered. If I know there’s a limit, I use a text field. and if the limit is over 255, but can be dealt with by multiple text fields, sometimes I’ll design the table to have multiple text fields, to include the indexing/querying capabilities of a text field.
-
WSDrew
AskWoody LoungerDecember 21, 2007 at 11:55 pm in reply to: Quick Question- How do you list all tables in … (Access) #1089513A lot of methods posted. Personally, I prefer the ADO method (which will work for tables and queries):
Function GetDBTables()
On Error GoTo ErrorHandler
Dim cnn As ADODB.Connection
Dim rs As ADODB.Recordset
If DBConnect(cnn) Then
Set rs = cnn.OpenSchema(adSchemaTables)
Me.lstTables.Clear
rs.MoveFirst
Do Until rs.EOF = True
If Me.optTables Then
If rs.Fields(“TABLE_TYPE”) = “TABLE” Then Me.lstTables.AddItem rs.Fields(“TABLE_NAME”)
Else
If rs.Fields(“TABLE_TYPE”) = “VIEW” Then Me.lstTables.AddItem rs.Fields(“TABLE_NAME”)
End If
rs.MoveNext
Loop
rs.Close
Set rs = Nothing
cnn.Close
Set cnn = Nothing
End If
Exit FunctionErrorHandler:
Err.Clear
End FunctionThis is right out of an application I wrote that builds classes in ASP from tables/queries. It’s displaying them in a listbox. And there are option buttons to display tables, or to display queries. The function DBConnect is essentially:
Function DBConnect(ByRef cnn as ADODB.Connection)
set cnn=new ADODB.connection
cnn.Provider=”Microsoft.Jet.OLEDB.4.0″
cnn.Open “C:SomePathSomeDatabase.mdb”
Exit functionHowever, you can connect that ‘cnn’, the connection object, to any database you want (Access, SQL Server, Oracle, etc), and it will list the tables for you.
-
WSDrew
AskWoody LoungerI know, my website has been down for a few months, long story.
As for docs on regions, look up Region Function in the MSDN library.
![]() |
Patch reliability is unclear. Unless you have an immediate, pressing need to install a specific patch, don't do it. |
SIGN IN | Not a member? | REGISTER | PLUS MEMBERSHIP |

Plus Membership
Donations from Plus members keep this site going. You can identify the people who support AskWoody by the Plus badge on their avatars.
AskWoody Plus members not only get access to all of the contents of this site -- including Susan Bradley's frequently updated Patch Watch listing -- they also receive weekly AskWoody Plus Newsletters (formerly Windows Secrets Newsletter) and AskWoody Plus Alerts, emails when there are important breaking developments.
Get Plus!
Welcome to our unique respite from the madness.
It's easy to post questions about Windows 11, Windows 10, Win8.1, Win7, Surface, Office, or browse through our Forums. Post anonymously or register for greater privileges. Keep it civil, please: Decorous Lounge rules strictly enforced. Questions? Contact Customer Support.
Search Newsletters
Search Forums
View the Forum
Search for Topics
Recent Topics
-
Outlook new and edge do not load
by
cHJARLES a pECKHAM
4 hours, 48 minutes ago -
Problem using exfat drives for backup
by
Danmc
1 hour, 8 minutes ago -
I hate that AI is on every computer we have!
by
1bumthumb
1 minute ago -
Change Info in the Settings window
by
CWBillow
5 hours, 24 minutes ago -
Attestation readiness verifier for TPM reliability
by
Alex5723
11 hours, 47 minutes ago -
Windows Update says that “some settings are managed b your organization”
by
Ed Willers
59 minutes ago -
Use of Gmail rejected.
by
CBFPD-Chief115
7 hours, 35 minutes ago -
WuMgr operational questions
by
Tex265
35 minutes ago -
Beijing’s unprecedented half-marathon: Humans vs. humanoids!
by
Alex5723
1 day, 3 hours ago -
New Phishing Campaign Targeted at Mac Users
by
Alex5723
3 hours, 34 minutes ago -
Backing up Google Calendar
by
CWBillow
1 day, 9 hours ago -
Windows 11 Insider Preview build 27818 released to Canary
by
joep517
1 day, 22 hours ago -
File Naming Conventions (including Folders)
by
Magic66
21 hours ago -
Windows 11 Insider Preview Build 26100.3613 (24H2) released to Release Preview
by
joep517
2 days, 5 hours ago -
Microsoft sends emails to Windows 10 users about EOS
by
Alex5723
1 day, 16 hours ago -
Outlook 2024 importing Calendar and Contacts – FAILURE
by
Kathy Stevens
22 hours, 30 minutes ago -
Adding Microsoft Account.
by
DaveBRenn
2 days, 6 hours ago -
Windows 11 Insider Preview build 26120.3576 released to DEV and BETA
by
joep517
3 days, 6 hours ago -
Windows 11 Insider Preview Build 22635.5090 (23H2) released to BETA
by
joep517
3 days, 6 hours ago -
Windows 11 won’t boot
by
goducks25
23 hours, 18 minutes ago -
Choosing virtual machine product for Windows on Mac
by
peterb
2 days, 20 hours ago -
Rest in Peace
by
Roy Lasris
4 days, 1 hour ago -
CISA : Install Windows March 2025 Updates until April 1 or shut down PC.
by
Alex5723
22 hours, 53 minutes ago -
Google proposes users with incompatible Win 11 PCs to migrate to ChromeOS Flex
by
Alex5723
4 days, 1 hour ago -
Drivers for Epson Perfection V600 Photo – scanner
by
Bookman
17 hours, 11 minutes ago -
Long Time Member
by
jackpet
4 days, 4 hours ago -
Woody Leonhard (1951–2025)
by
Will Fastie
1 day ago -
What I learned from Woody Leonhard
by
B. Livingston
3 days, 21 hours ago -
Windows Settings today
by
Simon Bisson
2 minutes ago -
Mail Merge magic in Microsoft Word
by
Peter Deegan
1 day, 10 hours ago
Recent blog posts
Key Links
Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.
Mastodon profile for DefConPatch
Mastodon profile for AskWoody
Home • About • FAQ • Posts & Privacy • Forums • My Account
Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts
Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.