Recent content by jeffshex

I'm wondering what the best way to do this would be: I am trying some stuff out and have a server with 2 databases on it, Live and Test. Basically I want to pick a connection on the first form that gets used throughout the program until it is closed. Everytime you run the program, you have to...

I completely agree! I just feel sorry for the poor users who see theme colors, but when they pick that theme, it doesn't use the exact colors that it shows it uses. Oh well.

Maybe I am thinking the themes should work in a particular way, when it is in fact designed to pick colors differently. When I create a new form with my theme applied, the colors come up with the ones I said previously. That being said, if I go into the property sheet of the form, textbox, or...

For example, in a brand new database, I picked my theme which for testing purposes, everything is set to black, except Light 1 and Light 2, which is white. In the form: Header backcolor: Gray 80% Detail backcolor: White (this is what is set in the theme.) Text forecolor: Lighter 50% (seems to...

Yep! If you use a split front-end/back-end solution, you can create a separate front end that contains the macro. Just set the macro to run on the form load event and have that form be the one that the front end loads up on startup. After the macro runs, just add another line to quit the...

I have searched high and low on the Google and have not found a suitable answer. It seems that no matter what theme I choose, even my customized ones, the color that it actually uses on my form is not the one I picked - they all seem to be a lighter variation. For example - if I tell it I want...

It may or may not be the next weeks date. He doens't have a set time when he will enter in the dates, so automating that part is not a huge concern for me. The base query (unupdateable), that is bound to my data sheet view form is: SELECT tblClientInfo.ClientID, tblClientInfo.LName...

OK - But in my OP in the first few lines, you will see i'm trying to present the form in datasheet view which is tied to the problematic non-updateable query. Nowhere did I even mention they enter it directly into tables. :( I'm just curious on any approaches/techniques to solve the issue of...

The program record would be determined by their ParticipationDate from the tblProgramInfo which would be asked for on the initial form that brings up the hours form. I usually normalize out, but this is how the user wanted to input it as, he doesn't want to have to punch in a date for every...

Yep, The PK ClientID from tblClientInfo is the FK in both tblProgramInfo and tblHours. Otherwise the primary keys for tblProgramInfo is ProgramID and tblHours is HoursID. All of the PK fields are autonumber.

Ok, here it goes from the beginning: Table fields tblClientInfo tblProgramInfo tblHours ============= ============== ======== ClientID ProgramID HoursID LName ClientID ClientID FName ParticipationDate MonthDate ...

Hey all, I'm trying to present my form to my users that look like an excel form (data sheet view). My problem is that it is a non-updateable query due to a Left Join on one of the 3 tables. The table layout is like -------- ------------- -------------- tblHours <--- tblClientInfo...

I think this does most of what I need. Just need to figure out how to work in the insert of the related records only those that are backordered. http://allenbrowne.com/ser-57.html

I have the forms and everything built out, but am looking for a way to do copy a row from an Orders(tblOrders) table along with it's Order Details(tblOrderDetails) and insert them back in. The only catch is that I only need to do this to any order detail record that meets certain criteria. For...

I think I may have figured it out. I added table that contains the people's scores on again and aliased it. I added duplicate fields for the area and score and put a parameter in for area 1 and area 2 in ther other box. It looks like it is what I need, but not sure what the downsides to doing...