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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.