Search results for query: *

@PHV Oh, well, that shows what I know :-) I'll check it out. @MajP: That is indeed a clever way to go about it! I'll play around with it tomorrow when I'm in the office and toss my code up here if I can't get it working the way I want it. Thanks guys!

Hmm, conditional formating will likely not work in this case. I have a continuous form where users enter upcoming years and the total proposed budget for that year (ex: 2010 and $1000). They can then click a "Details" button for that entry and enter a more detailed budget breakdown for that...

The subject pretty much says it all. I'm trying to set values for a single instance of a control on a continous form. I'm not entirely sure if there's an easy way to do this, but it's pretty essential to my setup. As it stands now I'm only able to reference *every* instance of a certain...

Thanks for the response, lameid! My problem is actually more based on the Query. I'm not sure how to create something that will check whether or not certain fields have values in them, and if they do, sum those values.

Ahoy! Firstly, I'm sorry if this is in the wrong section. I *think* it's going to be solved by a query, but I'm not entirely certain. What I have is this: Form A is used to enter upcoming Assignments and the proposed/estimated total budgets for upcoming years. Each entry has a button which...

Got it! The switchboard was opening it in Add mode, and it needed to be in Edit mode. This thread is becoming somewhat of a chronical of my bumblings, sorry about that.

Hmm, I should add that this only started happening after I set the Switchboard to be my main form, so that they Capital Program form is opened from a Switchboard button. Everything seems to work fine if I set the Capital Program form to be the one that opens automatically upon opening the...

Discovered another little issue. When I open the database fresh and the main Capital Program form comes up, it doesn't have any entries and clicking on anything in the pick list triggers an error message in the code because it could not find those records. If I then change to Design view and...

Triumphant update! I realized that the problem was probably because the foreign key wasn't inheriting the value of the primary key properly. It turns out that the reason for that was the values in the frmAssignmentSubform weren't actually being written to the record before the button was...

Correction, I only get the error when attempting to add records to the AssignmentDetails form: "You cannot add or change a record because a related record is required in table 'tblESPAssignmentsBrief'" Someone please let me know if it's considered annoying to continuously update a thread like...

Hrm, it turns out I'm still getting the original error, even though the values seem to be getting assigned just fine. I'll tinker with it some more and upload it again if I can't bend it into shape in the next few hours.

Got it! I just needed to call the subform in the proper order, thusly: =[Forms]![frmAssignments]![frmAssignmentSubform]![AssignmentID] Please let me know if that is, for some reason, stupid. I really appreciate all the help, it greatly reduces angry monitor glaring :-)

That worked splendidly, thanks! My follow up question is, how do I specify the default value when it's coming form a continuous form? The frmAssignmentSubform is a continous form with command buttons for each record that open a new form (frmAssignmentDetails). In order to sync it all up I'm...

Ah, that makes sense. So I can set the default value of the foreign key field to inherit the primary key value of the frmProgramInfo?

I have a bit of a problem that's driving me absolutely nuts...so I'm hoping someone can set me straight :-) In my database (www.offtopicproductions.com/Lawrence/public/LawrenceDB.zip), I have a one to many relationship between tblProgramInfo and tblESPAssignmentBrief, and then a one to one...

Hmm, correction. It seems that when I attempt to include fields from *more than* 2 tables, it truncates the Record Source and that of course screws up the whole thing. If I only include records from 2 tables it works just fine. This is all using the wizard to build it, of course.

You're bang on with the truncation! It looks like I've reached the limit of the record source length, and actually can't include that many entries :o I'm not entirely sure how to normalize this data and fix that problem. Any suggestions? Normalization has been the hardest thing for me to...

Hmm, seems the forum attachment thing tacked on a bit to the beginning of the URL. This should work (just put it up on my own webspace): www.offtopicproductions.com/Lawrence/public/LawrenceDB.zip

Apologies for the rather tremendous delay! I took some holidays and then was starting up my classes for my last year of Uni (only working part time, now). I've attached the database, which should illustrate the problem outlined in my original post. Mainly: "The picklist [on the ProgramInfo...

Thanks AceMan. I'll strip some stuff out and post it early this week. Trying to avoid work on the weekend :p