Search results

John, Correction:The mainform/subform recordsources are not the same, they are similar. Sorry. Thanks for your advice. You're right. A listbox would be ideal, however, my client requested a display where records w/ a (-) quantity to be red and (+) quantities be shown in blue. I couldn't devise...

You can join (or concatenate) the two fields by creating a textbox and setting its controlsource: =[title]&" "&[surname] this will give you the two fields w/ a space between them...

Check your link child/parent fields on your subform. Are they set up properly? Too easy to be of any kind of real help, but atleast it's a start. HTH

I've encountered the same frustrating issues. It took re-installing Access and running the SR-1 patch from MS for it to clear up.("knock on wood!").

shiner, Not to confuse your situation, but did you create and save a Query and then set your Form's recordsource to that Query (say Query1 or something like that)? If so, you can accomplish the same thing by copying the Query's SQL statement (Select....From...Where...etc) and pasting it...

Thanks for your reply. Good point. A parent/child relationship could be set up between the forms. That would make things much easier. For that to take place, I would need to set up the relationship in reverse of what "normally" would be done. (i.e. where the parent would be the Subform and the...

Try a subform What functionality do you want for the control? If you want only to view the data, you could use a listbox to display the table data on a form. If you want the functionality to edit, delete, add records you could display a form as a datasheet or continuous form. Or if you want...

Hello all, Is there an easy way to keep a Subform record stationary while using the RecordSet.FindFirst method on the MainForm? Using FindFirst on the MainForm causes my subform to "jump" to the top record. The user selects a SubForm record which Finds that record on the MainForm (both having...

Jon, Thanks so much for the reply! When I didn't get any respones to this post, I had figured that I was doing something wrong (which I haven't ruled out yet either???). I do believe I had re-installed Office. None-the-less, I will try it again though. I'm willing to do anything at this point...

Same thing happened on another machine I'm very displeased to say that the same problem has happened on another machine. It seems that it's different everytime it occurs. This time after I got the Save as... dialog, it seemed that everything was OK. I deleted the form that Access "forced" me to...

Got it! Full reference names are wonderful (when they work, that is)!!!

Is it possible to set the tabcontrol.value on a form upon opening the form? I would like to have the tabcontrol on the form display the second tab instead of the first tab when it's opened. Can this be done? I tried something like... Me.tabEstimates.Value = 1 When I try this, I get an error...

The more time you spend there, the more fluent you'll become... If you create a query and use as the Where condition... ...where [Surname] = [Enter Customer Surname]; Because Access won't recognize "[Enter Customer Surname]" as a vaild field name, it should bring up a MsgBox automatically...

The problem is the reference. I have not used a reference to a subreport and I'm guessing here, but try... Reports![MainReport]![SubReport].Report.Filter I couldn't locate any example in Access help. See what happens. It can't hurt.

Conditional Formatting? Have you looked in Access Help or Search on this site under "conditional formatting"? As to using them in reports, I'm not exactly sure about it. I will leave that up to you. But I would guess that you can use them. If you have any problems, give us a shout! HTH

I don't know if I'm understanding you correctly, but what you are describing is exactly what should happen, whence you change the caption property. What you put in the Caption property will show up in the Headings for your columns. What is it meant for.... Say I name my table field...

A caption is merely a "title" that is given to a field in case you want to name it differently on your form from what you have called the actual field in the table. As far as, "use the Caption to store some information for the persons that will use my database.", I'm not really sure what that...

Could it possibly be a virus that's infected my machine? I'm going to work on a different PC and see if the same thing occurs.

What exactly is it that's giving you the #Name error? If it's a calculated textbox, then check the actual names of the textboxes that you're trying to calculate the value from. Make sure that the Names you're referencing in the formula match the actual Names of the textboxes. Look at the...

Try this... Dim stDocName As String Dim stLinkCriteria As String stDocName = "FrmComment" stLinkCriteria = "[Student_ID]= " & Me![Stud_ID] & "AND [Period]= " & Me![PD] DoCmd.OpenForm stDocName, , , stLinkCriteria HTH