(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...
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 ...
Thanks John, for answering my verrryyyyy siillllllyyyyy question :) I'm embarrased not to have seen that myself ! ... -- Eddie [Non-text portions of this...
Eddie- There are no silly questions, only silly answers! Glad to help... John Viescas, author Microsoft Office Access 2007 Inside Out Building Microsoft Access...
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- 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...
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...
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...
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- 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 ...
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:...
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. ...
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...
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...
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...
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...
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...
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...
Brett It's sent. Bill From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com] On Behalf Of Brett Collings Sent: Sunday,...
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...
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...
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...