Recent content by asanjose

Thank you! It worked. I had trouble at first because my main form was unbounded and the field/data that I wanted to link was between two subforms in different tabs. I was only able to change the master/child link after bounding the main form. Then I unbounded it afterwards. For the first...

Thanks for the quick reply! I think you are right on target. I'm just not sure how to do: Step 3. Use Master-Child links to link the InvoiceID to your subform control. I will look it up. Thanks again! asj

Good morning Jetblack, You have a good idea there. Here are some things to get you started: http://www.rogersaccesslibrary.com/forum/forum_posts.asp?TID=3 There are templates already designed for questionnaires and such. Good luck! asj

Good morning and thanks for viewing :) Is there a way to load a related record in a subform using a command button? I'm only able to load a related record by launching a new form/window, but it's going to get messy with so many forms/windows open. I have attached an image to better explain...

To create a text box with the current date, type =now() in the control source of the text box.

1. Create another form based on your table. That will be your subform. 2. Go back to your main form, and create a subform and point the source to the form you just created. 3. If you want it to make it look like a table, make the Default View "Datasheet"

I actually I want the all the records to show up. I just need to show them with count = 0. I found a work around where in the control of the [count of expenses], I just put: =IIf(IsNull([Sum Of Invoice_InvoiceAmt]),0,[Count Of Expenses]) I still wonder if there's a different way though. I...

I don't know how to retrieve certain lines or certain texts from a memo box but I will look into it. If you're still in the early stages of implementing your Access Database, you might want to look into Design #2. I think what you have is Design #1. (Image attached if the pic below is not...

I have a Query that counts the related records in a different table. I was able to make entries that contains 0 records show up by using Join Property 2. However, the record count that's suppose to show 0 records shows up as 1. Any idea why?

When you say cell, you mean a Memo Data Type? So all that data is typed in a Memo box?

Thanks Rich That's a neat trick hiding the textbox in the background using color and setting focus on it to highlight it when needed. :)

It's a bound control as of right now.

Hi GHudson, Thanks for the quick reply. I tried transferring the code over to the OnCurrent but it is still behaving the same way. I'm thinking maybe "me.price.visible" is the wrong way to go because it affects all the Price textboxes throughout the form. I need a way to target a textbox in...

I have a form that lists several Items (in "Continuous Forms" view). Next to the Item Name, I have a checkbox. The checkbox determines if the Item has a price. If the checkbox is clicked by the user, a hidden textbox named "Price" becomes Visible. Private Sub HasPrice_Click() If HasPrice =...