Recent content by sjr1917

Of Course!! Thanks. I knew I should just walk away and come back later... too many hours behind a keyboard. :banghead:

Running this code the application throws an Error 91: "Object Variable or With block Variable not set" when it hits the "Set rst to..." line. Viewing strSQL in the Immediate Window, "Me.cboDonor2Report.Column(0)" is resolving to a valid ID value. If I create a new query and copy the strSQL...

Thanks. Yes, I'm aware of how to change the size of buttons. The problem was opening an existing Access 2013 application with a new laptop all the buttons visually were 10-15% larger than their actual size and overlapped each other,etc. This happened as well when I created a whole new form...

I've changed computers and all the buttons in existing applications, AND newly created ones overflow their bounds with style. Why? and how to fix? See the attached image.

Thanks. I have just check that out.

I have an Access 2013 application created on a PC. Can it be run on a Mac? If so, what steps are needed to transfer it?

MarkK, Good point. The solution I came to was for the sake of expedience. One table with all the data needed to drive a TreeView control displaying the reserved status of every room throughout an event, rather than a complicated query that would have to be run each time I needed the view. Will...

OK, finally found enough on the internet to solve it: First create a Cross Join query (I named qryRoomsXDt): SELECT * FROM (SELECT id FROM tblRooms) AS B, (SELECT eventdt FROM tblEventDts) AS C; Then INSERT that query into the emptied tblRoomsByDt: INSERT INTO tblRoomsByDt (RoomID, EventDt)...

I have the table structure set, just need a specific SQL statement to initially fill a reservations table (tblRoomsByDt). Let me try to simplify the example. Assume 2 populated tables: tblRooms --> field RoomID (the only field that matters in this example) tblEventDts --> field EventDt (will...

Can't figure the SQL to UPDATE a table (tblAccomResv) with columns: AccomID and DtBooked. It will be an empty table. I need to populate it with one record for each record in tblAccomodations (ID) by each record in tblEventDts (EventDts). Like: Room1 Dt 1 Room1 Dt 2 Room2 Dt 1 Room2 Dt 2 etc.

Let me try this again... On a form I will have a dozen or more checkboxes that determine if specific documents are required for this client. Each checkbox will have "associated" with it one or more other controls that hold data about when that document was sent, received, the score, etc. The...

namliam... That's a point I hadn't considered (running a merge off a query). Haven't had much experience at Word merges other than with existing tables. Here is the SQL statement that does what I wanted: UPDATE People SET People.Selected = TRUE WHERE People.ID IN (SELECT People.ID FROM...

What I need as a final result is a table that will work without Access running. I can take the People table with the proper "selected" fields marked true and call it from within Word to do a mail merge (or forward it to someone else for them to use likewise). Don't see how I could do that with...

Yes. Thanks. The combobox isn't the problem... I'm stuck on: once I've got a subquery which contains the people.id's who are members of the chosen group how do I use that to do the update query that actually marks the Selected field in table 1 = true for each person in the subquery.

***SOLVED*** see end of thread Three tables: 1) People with all the usual demographic fields plus a "Selected" field 2) Groups: ID, GroupName 3) PeopleXGroups: PeopleID, GroupID I have first set all "Selected" field in table 1 to False I need to create an update query that sets the "Selected"...