Search results

Fixed it I was able to come up with a solution... it may not be THE solution, but it is A solution. I wrote a query on my main table and set the criteria for each of my three fields to be the entries in the fields from the main form. Then, I based a subform in form view on that query and set...

Pat: Thank you... and thanks again to Michael for his help. I think, though, I have badly explained what I believe to be my poor understanding issue. Since the fields in the main form are "unbounded," how do I link the subform with the entries on the main form? After making those three...

Thanks Michael. I'm not sure how to relate your database to this issue, though. I appreciate the llok, though. All I really want to do is add notes to each of these records. Since there will be more than one note, they need to be in a subtable, of course. I just don't know how to make it so...

I set up a database allows me to use Candace Tripp's 3-level cascading combo boxes within a form, and display the datasheet within the subform (Do I need that displayed?) But, now I want to be able to add notes to each of the selected activities. What I have is First selection: Conversion...

I don't think that procedure is exactly correct. Let's say you have a sales data table, with these fields: Autonum Name Date Amount If you want to find the last entered sale of any particular person, and are going to use the autonum field MAX to do that, you must omit the Date and Amount...

Ok. That seems to work well. Thanks. Now, I have to allow for iterations of activities, so I need to include a subform for notes and data, which is not a problem. However... let's say a programmer is doing conversion number "123" for the geography "Germany." I'd like to make it so the...

Hello all, and thanks for your help. I am having difficulty getting through the logic of structuring my database for the following situation: My company works in many different geographies and is going through a data conversion process that can involve as many as 21 sets of tasks. Not all...

Train your users I've had this exact problem. Either use the dummy record procedure or sort the spreadsheet so that an alpha entry appears first. Now, to complicate matters, a long numeric value (12 digits, for example) will be changed to Exponential format and end up looking like "1.2E10" or...

Creates another problem Ok... if you use two ampersands "&&" in a label, and then export the report to Word, you get BOTH ampersands showing in the exported .rtf file !! Now what!! HAHA I got you now!! (Actually, I need to resolve this. All help will be appreciated!) Tom

resolved I was able to fix this problem by NOT using an entered pagebreak at the end of the section. Instead, I changed the section property to include a pagebreak "After Section."

I have a record report that is printed when a form command button is selected. For most records, this report only requires one page. However, when the report text is long enough that it requires a second page, the text just runs off the bottom of page 1 and I get no page 2. Help? Thank you! Tom

FANTASTIC! Works exactly as hoped. I looked at the syntax of the Do statement to make sure I understood it. Thanks again! Tom

Hello. I am trying to write the code for a form button that will print the current record's report. I can get it to work if I use a query that asks for the issue number, but I would like to get it to do it directly from the button. The code below tries to open the report, but I really want to...

Easy enough. Works perfect. I was looking for "integer" in the help but couldn't find it. THANKS! Tom

I am trying to write a sum equation of three other fields. However, each of those fields is a decimal, and I need to sum only the whole number of each. In other words, if the field reads "3.8" I want only the "3" and not the ".8" to be added. This is true for all three fields to be added...

Dwight: Yes, unfortunately all the addresses have to be kept so that the client activity ("where they've been living") can be tracked. State funding requirement. UGH! Thanks for the idea on checkbox. Neil: I'll try that. I've never used the MAX value before, but I certainly can study on it...

I have a database that has a table of address updates, so that each new address is added to the table as the client moves. Now I am being asked to provide a report that includes the clients CURRENT address. So, I need to query the table for the last-entered address for a client. The goal is...

Hello. I apologize for the simplicity of this question. I used to be able to do a lot more complicated things in Access than this, but I had a stroke in December, 2002 and just can't remember VB code hardly at all any more and have to keep things a lot simpler. I'm back to using wizards for...

Jack: THANKS so much. That seems simple enough, and I will certainly try that out. Tom

I have a dropdown with two choices. Each choice requires, then, a different set of inputs. Can I put two subforms on my main form and have it so that only one of them will allow entry/editing, based on the result of a drop down (or radio button) choice? Thanks for any help! Tom