Hi
Im using MFC (visual studio 2005), I want to create a table, so to speak, of two columns. the first column is a list of strings, and the second column is a respective combo box. This happens to look exactly like the "Properties Window" (when you press alt-enter) in visual studio.
I cant seem to implement this: i have tried using a CListBox, but implementing a column of CComboBox's seems not to be possible....
anansi
Last Activity: Dec 11 '07, 08:27 AM
Joined: Nov 12 '06
Location:
-
creating a table of CComboBox's (MFC)
-
hey. i tried, but am going to try another algorithm.. my problem is that i can accomplish the addressing between the form and subform, but when i try do a DoCmd.FindRecor d it does it for the subforms "record set" (not sure if i mean record set), where i actually want the action to be performed on the main form's "record set". switching the focus doesnt help, and i simply dont know why nothing wants to work...
thanks... -
Yes this is what i want to do, thank you
Since the information was posted i'v been trying to get it all to work. i am failing miserably.. The DoCmd needs to be for the parent of the subform and i cant seem to access the necessary form "shift viewer". The "shift viewer" form is what needs to FindRecord.
So my question isn't about FindRecord anymore, but about getting to the Form, "shift viewer",...Leave a comment:
-
SearchForRecord function problem
Hi all
I have a very simple problem but i am highly confused. firstly, a google web search of "DoCmd.Searchfo rrecord" returns nothing. i've been starting to get suspicious why no one else is interested in this function but me, but here goes:
...Code:sID = Me.ShiftID '--- this is the subforms field, ShiftID ParentsID = Me.Parent.ShiftID '---this is shift viewer's field, ShiftID
-
thanks, worked it out you ppl r, once again, legendsLeave a comment:
-
I believe i am selecting from tables only. Activities and personAndTime are both tables. correct me if i am in the wrong.
The rational behind this form is that the user selects the item they want to edit from a datasheet subform, listing all the records in a viewable table format. the editing i want to have done must be done through the controls in the main form. but thats neither here not there.
Could you please explain...Leave a comment:
-
NOOOO!!
I accomplished what i wanted, but now, in the main form, all the controls are UNEDITABLE!
This defies the object. The code i put into the subform's current function is below:
...Code:Me.Parent.Form.RecordSource = "Select [personAndTime].promoID,[personAndTime].date, [personAndTime].time, [personAndTime].VenueID, [personAndTime].ActivityID,[Activities].rate,[Activities].hours,
Leave a comment:
-
Thanks thats working pretty well, not got it fully working, but will post when i'v had time. How to SELECT from myquery, not mytbl?Leave a comment:
-
Controlling form's current record through selecting in a subform
Hi
I have a form called 'shiftviewer' and it contains a subform called 'all shifts for current month subform'. the subform is in datasheet view (access 2007) and the main form is a column orientated form.
Both forms contain records of 'shifts'
I want to be able to select a record (a shift) in the subform, and be able to set the parent form's current record to that record, through the identifying primary key that... -
You are a legend. thank you...Leave a comment:
-
Yes, I have a form called Shift Viewer containing a control called Text42. I created a separate query that returns the value (a single value and a single record).
When looking at this query in the query's datasheet view (access 2007) it works, the result is not #name?. So looking at this query in its "SQL view" showed the SQL statement for it. I copied and pasted this into Text42's control
but the control shows #name?...Leave a comment:
-
#name? error in form using sql expression...
Hi
I'm having what i would guess is a really trivial problem. i have searched the forum but nothing can solve my problem: here is my sql code that goes into a edit box control:
SELECT targetFromVenue Activity.target
FROM venues INNER JOIN (Activities INNER JOIN targetFromVenue Activity ON Activities.Acti vitiesID=target FromVenueActivi ty.activityID) ON venues.venue=ta rgetFromVenueAc tivity.venueID
WHERE (((targetFromVe nueActivity.ven ueID)=Forms![shift... -
Well the complete funtion now looks like this:
...Code:=IIf(Weekday(Now())=1,DateAdd("d",7,Now()), IIf(Weekday(Now())=2,DateAdd("d",6,Now()), IIf(Weekday(Now())=3,DateAdd("d",5,Now()), IIf(Weekday(Now())=4,DateAdd("d",4,Now()), IIf(Weekday(Now())=5,DateAdd("d",3,Now()), IIf(Weekday(Now())=6,DateAdd("d",2,Now()), IIf(Weekday(Now())=6,DateAdd("d",1,Now())Leave a comment:
-
Ok: I have got to this point:
an IFF statement embedded 6 times for every day of the week, determines how many days to add to now() to obtain the date of Sunday like such:
=IIf(Weekday(No w())=1,"set date accordingly here",IIf(Weekd ay(Now())=2,"se t date accordingly here","etc from here"))
What i need to know is how do you add X amount of days to a date [now()], obviously...Leave a comment:
-
return the date of this coming sunday
Hi
I would like to obtain the date of this coming sunday, without having to code in sql (im a bit of an access newbie)
im assuming using syntax such as now() weeknum() or format$() can somehow be put together to obtain what im looking for.
plz help, thanks in advance
No activity results to display
Leave a comment: