IT SOLUTIONS
Your full service technology partner! 
TheJoe [Unspecified] -Collapse +Expand
-Collapse +Expand
TheJoe
-Collapse +Expand Profile◄╣
Member Info
Member Narration

POSTS:
MB Posts (6)

Search TheJoe:

Advanced
Personal Account . . .
TheJoe
-- USA



Real Name:  TheJoe [Unspecified]
Primary Role:  Coder
Joined: Mar 2001 (19 years ago)
Visits: 9
Email Not Verified!
Once email is verified, we will review and approve the account.
Web Presence Hidden.
Once above is taken care of, full Profile content will display including back links, about me, my message, custom Profile html, social networking links, message board signature, company profile, etc.

Message Boards Activity

6 posts.
More...

Thread 6 of 6
Thread Starter or a Reply (but not last)  Group

TheJoe
Down with the read-only notification
I have a MS Access project file that I share on a read-only network drive for users. I modify it all the time, and don't want to dispatch a copy for each user. It works ok, but each time they open up the .adp, there's this pop-up telling them that the file is read only. This little innocent box annoys me and the users like hell. How to prevent it from showing?
Posted to MB Topic: Access News / Other « Access Board
19 years ago
Nothing New Since Your Last Visit
1458
Hits

Microsoft Access

Thread 5 of 6
Thread Starter or a Reply (but not last)  Group

TheJoe
How to parse a text file with VBA?
Are there any code examples available somewhere where I could see some guidelines how to parse a delimited text file and change my database accordingly?
Posted to MB Topic: Access VBA Programming « Access Board
19 years ago

bprestwo
First reference the Microsoft Scripting Library in your code. Open the file using the TextStream functionality of the Scripting library. Then use the Split function to break the delimited records up into their elements.
19 years ago
Nothing New Since Your Last Visit
8167
Hits

Microsoft Access

Thread 4 of 6
Thread Starter or a Reply (but not last)  Group

TheJoe
Custom Apply form filter button grays out
I have a form that has a Filter by Form button and an Apply Filter button, so that users wouldn't have to use them from toolbar. When I enter the Filter by Form -state, all buttons in the form gray out, including the Apply filter. How can I prevent this?
Posted to MB Topic: MS Access Interactive « Access Board
19 years ago
Nothing New Since Your Last Visit
1387
Hits

Microsoft Access

Thread 3 of 6
Thread Starter or a Reply (but not last)  Group

TheJoe
Limit records to those with records on another tab
I have two tables here, let's call them "Customers" and "Orders". By using the form wizard, it's easy to create a form with which I can browse the customers, and which has a subform for their orders. Very nice, but how can I filter this main form to include only customers that actually have entries in the orders table?, , I know this is basics, but I'm a total beginner. =(
Posted to MB Topic: MS Access Interactive « Access Board
19 years ago

Scott
{Too Long!}
19 years ago
Nothing New Since Your Last Visit
2175
Hits

Microsoft Access

Thread 2 of 6
Thread Starter or a Reply (but not last)  Group

TheJoe
Re: Limit records to those with records on another
Doh, forgot the magic word DISTINCT..
Posted to MB Topic: MS Access Interactive « Access Board
19 years ago
Nothing New Since Your Last Visit
2
Hits

Microsoft Access
More...
Go ahead!   Use Us! Call: 916-726-5675  Or visit our new sales site: 
www.prestwood.com


©1995-2020 Prestwood IT Solutions.   [Security & Privacy]