Search the web
Sign In
New User? Sign Up
MS_Access_Professionals · MS Access Professionals
? Already a member? Sign in to Yahoo!

Yahoo! Groups Tips

Did you know...
Show off your group to the world. Share a photo of your group with us.

Best of Y! Groups

   Check them out and nominate your group.
Having problems with message search? Fill out this form to ensure your group is one of the first to be migrated to the new message search system.

Messages

  Messages Help
Advanced
Messages 50652 - 50683 of 76980   Oldest  |  < Older  |  Newer >  |  Newest
Messages: Simplify | Expand   (Group by Topic) Author Sort by Date ^
50652
(Bill, To lend a different perspective ...) Hello Ahmed, Why do you want to know? Anyway, I do not think it is possible to (easily) tell the difference... The...
Strive For Peace
strive4peace...
Offline Send Email
Jul 1, 2007
10:09 am
50653
Hi Ahmed, All barcodes have a checksum. If you are handling the keystrokes yourself then you must check that the checksum is valid. See...
Clive Williams
horastacatto
Offline Send Email
Jul 1, 2007
11:42 am
50654
Hi all, Is there a way to make a printout of the complete VBA code of a project? Eddie...
strep21
Offline Send Email
Jul 1, 2007
1:55 pm
50655
Eddie- Open the VB Editor. Choose Print from the File menu, select Entire Project, and then OK. John Viescas, author Microsoft Office Access 2007 Inside Out ...
John Viescas
jlviescas
Offline Send Email
Jul 1, 2007
2:32 pm
50656
Thanks John, for answering my verrryyyyy siillllllyyyyy question :) I'm embarrased not to have seen that myself ! ... -- Eddie [Non-text portions of this...
Eddie Van
strep21
Offline Send Email
Jul 1, 2007
2:41 pm
50657
Eddie- There are no silly questions, only silly answers! Glad to help... John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access...
John Viescas
jlviescas
Offline Send Email
Jul 1, 2007
2:52 pm
50658
DEar All, I'm working on one form, whose rowsource is made up by a query linking two tables: TblDocs and TblOrder. Those tbls are linked on the primary keys...
Davide Franceschini
bigcat_21
Offline Send Email
Jul 1, 2007
3:40 pm
50659
Davide- It sounds like the relationship from tblDocs to tblOrder is one-to-one, correct? Do you have a special reason for doing this? What are the data types...
John Viescas
jlviescas
Offline Send Email
Jul 1, 2007
4:00 pm
50660
Davide I don't understand the relationship between tblDocs and tblOrder. How are they related in the real world? It appears that tbkOrder does not have a...
Bill Mosca
wrmosca
Offline Send Email
Jul 1, 2007
4:05 pm
50661
Hi John, I know it is not the best thing to have a one to one relation ship, but I need to keep track of all the docs in one year with a unique progressive...
Davide Franceschini
bigcat_21
Offline Send Email
Jul 1, 2007
4:20 pm
50662
Hi Bill, I agreed with you that's why the status in the docs, but if I have to perform clean up I will go to the parent and get rid of the data at once ...
Davide Franceschini
bigcat_21
Offline Send Email
Jul 1, 2007
4:29 pm
50663
Davide- One to one relationships are difficult to work with. For starters, I would think you should do a LEFT JOIN so that you get all rows from Tbldocs and ...
John Viescas
jlviescas
Offline Send Email
Jul 1, 2007
4:36 pm
50664
Hi Crystal I was thinking of using the KeyPress event to determine if the keyboard was used. I don't know if that will work, but it might. Bill From:...
Bill Mosca
wrmosca
Offline Send Email
Jul 1, 2007
5:16 pm
50665
Eddie You might like this COM add-in for converting VBA to HTML for printing purposes. It retains the font colors. You can find the download at: ...
Bill Mosca
wrmosca
Offline Send Email
Jul 1, 2007
5:21 pm
50666
Ahmad, Bill, Crystal, We need more info from Ahmad. Ahmad may be using a barcode reader with keypad which I would expect to do the error-checking internally. ...
Clive Williams
horastacatto
Offline Send Email
Jul 1, 2007
6:18 pm
50667
Thanks Bill, Not sure i'll use that, since I'll probably need to print a code just this once. Will keep it in my (small) library though. ... -- Eddie [Non-text...
Eddie Van
strep21
Offline Send Email
Jul 1, 2007
9:06 pm
50669
Jim, It looks like John and AD have got you sorted, but this is what the function below will give you. I guess I should have explained more. Paste the function...
Donkers Steve
stevedonk
Offline Send Email
Jul 1, 2007
9:43 pm
50671
Eddie The nice thing about COM add-ins is that you install them and then use them in the VBA editor whenever you need them. After you install the add-in you...
Bill Mosca
wrmosca
Offline Send Email
Jul 1, 2007
11:09 pm
50672
Hi, I found your group today (hallelujah!) and joined. I'm delighted to find such a wealth of information in one location as well as having the opportunity to...
redflag85268
Offline Send Email
Jul 1, 2007
11:12 pm
50673
I tend to print my VBA code from Programmers Notepad after copying and pasting into it. Its a freeware code editor described here...
Donkers Steve
stevedonk
Offline Send Email
Jul 1, 2007
11:27 pm
50674
Welcome, Nancy. And thanks for finding the broken link. I'll get right on correcting our link. Regards, Bill Mosca, MS Access MVP Founder,...
Bill Mosca
wrmosca
Offline Send Email
Jul 1, 2007
11:31 pm
50675
Hmmm interesting ... I liked the look of this Steve but darned if I can get anything meaningful out of it. All I seem to get from a whole Access file of with...
Brett Collings
sumbrett
Offline Send Email
Jul 2, 2007
12:33 am
50676
A.D., I looked at your two samples. The ReportBottomAligned looks like it would do the trick. I did have problems in following the what-and-why of your code...
Gary Chandler
glcshadow
Offline Send Email
Jul 2, 2007
12:34 am
50677
Would you mind dropping me a personal email please. I just tried what I thought was the correct one but it bounced Brett Collings ...
Brett Collings
sumbrett
Offline Send Email
Jul 2, 2007
1:42 am
50678
Brett It's sent. Bill From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Brett Collings Sent: Sunday,...
Bill Mosca
wrmosca
Offline Send Email
Jul 2, 2007
2:32 am
50679
Thanks, Steve Jim Coon...
Jim C
liteguy.rm
Offline Send Email
Jul 2, 2007
3:01 am
50680
I tell my people that Silly questions are a lot better than silly mistakes....
Jim C
liteguy.rm
Offline Send Email
Jul 2, 2007
3:04 am
50681
some of my forms are getting rather cluttered with buttons to do this or that. Is it posible to make tabs and group like buttons on each tab to reduce...
Jim C
liteguy.rm
Offline Send Email
Jul 2, 2007
3:10 am
50682
Paul (aka pbaldy) has been awarded the Microsoft Office Access MVP award for his generous work helping others learn Access! From my perspective, I can say he...
Bill Mosca
wrmosca
Offline Send Email
Jul 2, 2007
3:16 am
50683
Sure Jim, using a Tab control to group like options would be a good way to organize things. Depending on what the buttons are doing, an alternative might be a...
Paul
pbaldy72
Offline Send Email
Jul 2, 2007
3:56 am
Messages 50652 - 50683 of 76980   Oldest  |  < Older  |  Newer >  |  Newest
Advanced
Add to My Yahoo!      XML What's This?

Copyright © 2009 Yahoo! Inc. All rights reserved.
Privacy Policy - Terms of Service - Guidelines - Help