Recent content by brodkat

sure, it looks like that tab controls are a good way to organize some of my data entry... always learning new tricks, some day I might feel like I know something about access. thanks again!

thanks ... it worked! I like it. Easy. And per your last comment/first message - the 60 records in question are from only one datasheet and share a key (foreign key) but there is a stack of datasheets. The records are related via foreign key to a parent table but the form for entry into the...

Thanks for super fast reply! Your suggestion seemed perfect but I can't get it to work correctly. I think it is because I'm unclear about proper syntax. I've tried with and without quotes, square brackets, adding [Forms]!... out in front (and all combinations thereof) and usually #Error is...

I have a continuous form with properties set for data entry mode. The user opens the form and enters 60 records from a datasheet. The pattern of the values in one field [DropPt] start with 0.5 and sequentially increase by 0.5: (0.5, 1.0, 1.5,... 30.0). I would like any suggestions if anyone can...

I worked around this without having to write any code. I went back to the idea of updating all Is Null values for the FK. I added a text box to the header where the user types in the FK. Then I inserted a command button for the user to click when they are done that fills in all the IsNull values...

the foreign key is on the datasheet so the problem is just how to enter one FK for 60 records. So I was thinking a command button the user clicks after they are done that updates all IsNull for the FK - but your suggestion is (I think) more along the lines of having the user click a button...

I have a continuous form that is designed for data entry. There are 60 records to be entered from one datasheet and there are hundreds of datasheets. One of the fields is a foreign key that is the same for all 60 records. I would like the data entry person to be able to enter the foreign key...

hey thanks so much! both for the code from bob (I'm so pleased it finally works!) and for the reference from baldy (definitely helpful)

Thanks big booty for your helpful response. Some of what you offered worked well but the DCount line still doesn't work because (a) currPt is a string (PointID is text format - e.g., MC-1234-2) and (b) I can't figure out the proper syntax for the criteria. The code is mostly yours and currently...

I am certainly not the most qualified to answer your question but no one else is biting so I have an idea for you. In the crudest of explanations, I think your code needs 'a way' to run. You need to insert an 'event' in your form that runs the code. Running it directly from the VB editor isn't...

Hello, I'm struggling up the steep VB learning curve and trying to write code that will "read" the contents of a cell in a form so that I can search another table for the same string. Hoping someone can read what I have and point out what I'm doing wrong. The user uses the form to enter data...

I'm trying to write a macro that runs after data has been entered into a given field on a form. The first line is OpenTable and the second line is SearchForRecord. While stepping through the macro, the table opens in response to the OpenTable action but on the SearchForRecord action I get the...