Hi There, Lets take the first social # 001-01-0001 This guy is common in 429 and 465. But he is not current Year common in 429 since no hours and compensation....
Hello all, I'm working on an application to help the Boy Scouts in my area. Every year, they offer an event called Commissioner's College, where adults are ...
Did you try adding a number field to your excel spreadsheets? You can just number the first 2-3 rows and then highlight the coloum and edit->fill down to...
Hi guy's, In chapter 9 of the Access Developer's Handbook Vol 1 there is some code on a demo that allows you to print multiple copies of a mailing label. I...
Bhupinder Kim's solution is probably the best. Because you need to keep track of the order the rows are in the spreadsheet, you need a primary key. If you have...
Neil John Vieascas posted this many moons ago. All you need is a table with one field numbered from 1 to whatever your highest number of labels might be. ...
been trying for a good day to get my filter code to work on this form where after update the form will filter down to a value that's in this other field. so...
Neil, Here is an another method than can be used. Not as slick as Bill's, but it works: Private Sub Detail_Print(Cancel As Integer, PrintCount As Integer) ' #...
I am having a problem implementing this. myobject.name shows the form name "frmContact". This code is supposed to find out if frmGroups or frmGroups_ImpOnly...
Ryan If ID is numeric: DoCmd.ApplyFilter , "id=" & idfilter If ID is text: DoCmd.ApplyFilter , "id='" & idfilter & "'" Regards, Bill Mosca, Microsoft Access...
Good Day to All, I have a report that is a reminder to members of the status of a donation pledge that has been made if it has not been satisfied yet. Of...
Neil, Suggested solution posted by me recently in response to a similar thread initiated by Jerry, is placed below. Let the number of labels required be...
Myra: Your response doesn't really address what I am in need of. I would like to be able to have a process that does a count on the analyte name within a...
I took out Case End and added docmd.close and now it's working.... Private Sub cmdClose_Click() On Error GoTo Err_cmdClose_Click DoCmd.DoMenuItem acFormBar,...
Its difficult to diagnose the problem with out seeing the big picture. If your trying to compare a summed contribution amount to a non-aggregated amount, you...
I just read what I wrote. The reason I bring up the design comment is by the joins in your query. Having a complex query is not a bad thing, but for what...
Hey Clive, I've taken a good look at the coding and methods you've used and I'm pretty sure I can now apply it to the real database. I goofed up the sample I...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the MS_Access_Professionals group. File :...
MS_Access_Professiona...
Mar 1, 2007 6:29 pm
47044
Lee, This will require dynamic criteria clause: (a) If EndMonth >= StartMonth, you have to verify that the current month falls within the period spanning start...
Bt Creating separate tables for each Analyte would denormalize the database. What you should be doing is creating an Analyte table with a primary key and...
Hi, I just downloaded the sample, I will take a look at it when i get a chance - unfortunately I was just told to add a new parameter so I have to go modify...
Thanks Bee Kea, I have uploaded a new file named PledgesSatisifed, and once you click on the report, the first record should print out 3 unsatisfied pledges as...
Hello, This email message is a notification to let you know that a file has been uploaded to the Files area of the MS_Access_Professionals group. File :...
MS_Access_Professiona...
Mar 1, 2007 9:37 pm
47050
Hi Amber, Glad you've fixed. For future reference, the way to test for hidden forms is to check the Visible property. If (myObject.IsLoaded) And...
I got this on another group. Was wondering what was up. Hadn't seen any thing since last night until about 2:45 EST. ... Bob Peterson [Non-text portions of...
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.
