Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations SkipVought on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. greg85374

    Self Join on distinct field

    Thats IT...Thanks much Guys..Id this post on another forum for a week now...50 views and no replies...much appreciated
  2. greg85374

    Self Join on distinct field

    Getting Very Close..lol..Im looking for the following But when I added the additional field(contributionAmt) I got incorrect results again... Either Way thanks much!!! SELECT memno, LastContributionDate,ContributionAmt, TimesContributed from TblProspectMember tb2 left join ( SELECT...
  3. greg85374

    Sub routine - Help

    Well it depeneds on the type of file it is and on your os version... can u be more specific...is it in a folder that requires access rights is sometimes an issue too...
  4. greg85374

    Dynamically update the contents of a listbox based on similarity

    Ive done this many times...Use the onupdate evenet of the combobox In the onupdate peform the following 'clear evrything out of the listbox list2.value = "" List2.rowsourcetype = "Value List" List2.Rowsource = "" List2.Rowsource = "your Sql Query" List2.Requery 'not really needed but sometimes...
  5. greg85374

    Add a control to open form

    I dont know how old this is but you must put controls on form @ design time but theres a cheat.. Docmd.Echo false Call another form and make it invisible Docmd.close acform,acsaveyes(whatever the exact syntax is) Call a public sub in this other form that with put your combo box on...
  6. greg85374

    Self Join on distinct field

    Ok..basically I have a table with a duplicated field i need to work with. I need to select all the distinct memno's from this table with the related ContributionAmt AND ContributionDate My table has 4 fields: PacEntryId ('Pk'),MemNo ('Fk'),ContibutionAmt, and ContributionDate Now..I knwo...
  7. greg85374

    Newbie needs help

    I need to know how to do the following: I need to know hot to setup table(s) so that I can query an EMPLOYEEID so that Whatever month in my calendar the user is on I can loop through the days in that current month and get a value for that day eg..I setup a table called "EmpAttendance" With...
  8. greg85374

    Calendar Control 10.0 in vb 6.0

    Thanks YoshiCD.... I do believe there are at least two ways to more appropriately doing this...one to do it in access and have databinding keys(whatever you call it) and two to use CalendarUI add in component...I have it but its telling me i dont have a license for it..im using vb 6.0 working...
  9. greg85374

    Advanced Calendar Controls

    barry there is a free calendar control that alredy falg using four differnt colors a selected day of the month maybe you can edit the code to suit your needs....i am trying to do something similar except using text....but here is how youll find some help go to aol keyword search...adding text to...
  10. greg85374

    Calendar Control 10.0 in vb 6.0

    I recently have been trying to use built in calendar controls to takie input from the user and store it on the calendar during run time. Unfortunately I can't or dont know how to reference any of the properties for the calendar control 10.0 I tried to place textboxes in all the date boxes but...

Part and Inventory Search

Back
Top