Search results

Andy, thank you for your reply--I appreciate your help. That is a good idea to use on the startup form, but doesn't that require the dll file too? I can use that, but it seems a little harder to secure since it is not part of the database. What do you think?

I have read a great deal about mouse scrolling and not scrolling and found some fancy solutions. I am not good at reading code and what I want may be simpler than what these solutions do. I would like to disable the mousewheel entirely while my database is in use. I don't want to offer the...

Well, I got it working by splitting it into two separate update queries. I don't know if that's the best idea, but at least it's working. Thank you so much for your time and help!

It's a little more complex than my explanation, so maybe it's not just my expression that is the problem. I tried a couple more things and still nothing. What do you think? Here it is: UPDATE DatasheetTemplateTable INNER JOIN ObjectiveSummarizedTable ON (DatasheetTemplateTable.Ax1Defined =...

Still nothing... Thanks for the reply, but that didn't seem to matter. Any other ideas?

I have the following expression: IIf(IsNull(DefinitionField),Null,LabelField) The goal is to clear a label out of the LabelField if a definition is cleared from DefinitionField. Nothing is happening, however. What am I doing wrong? Thanks in advance, Carly

Hi Everyone, There may be a quite simple answer to this, but I am a novice. I have a data entry form with multiple subforms and subsubforms. People sometimes enter their data and then realize they are on the wrong form or some other such problem and they want to undo all the data entry they...

This is probably too good to be true... Hi Pat, Ok, this is what actually got it working, without the other steps. It is simply this code in the afterUpdate event. It is significantly simpler than what you had suggested, which worries me. I am hoping that I didn't properly explain myself in...

Nothing happens Hi Pat. When I tried this code slightly altered to my forms, nothing happens at all. Any ideas why? Here is my code: Private Sub Form_AfterUpdate() If MyNewRecord = True Then Me.FLASHDataEntrySubform1.Form!DataEntrySubform.Form!EntryDate = Now()...

I am wondering if anyone could tell me how to accomplish the following. It is a problem I have been wrestling with for days now. I have a form with several subforms. Each subform has a different default value for time of day and then fields for data collected at that time, with default values...

I tried that... still, no data saved. Is there something special about the textbox you are hitting enter on?

I have a form used for data entry with several subforms which store data for specific times of day. The date is entered on the mainform and stored in each "TimeOfDay" subform. This setup allows for data to be analyzed by day or by a specific time of day. I have default values for data in the...

I have a form which is printed out for data collection and then used for data entry. In screen view it looks great, but when it is printed out the subform names appear in the upper left corner of the subform areas. I checked that there are no labels behind the subform or anything like that...

Thank you Pat. I basically have a form that functions as both a schedule and data collection sheet. The design is set up so that data collection for each time of day is a new record, so that, if I would like to analyze data according to some of the schedule information, I can do so even if...

Great! I'll try it. Thank you so much!

I should also mention this is a date field. I tried using the SetValue function in a macro, and I get the date 12/30/1899 no matter what date I enter on the mainform. Doesn't this mean that my macro is not setting the value? Or am I running the macro at the wrong time? I have tried it in...

Thank you for the reply--I just need a little more help... Where does this code go? Would it be an OnCurrent Event for the subform? I know about as much about using code as I do about performing brain surgery. (And I am not a brain surgeon). Thank you so much for your time! Carly

Does anyone know a way to automatically fill in a subform field with an unbound mainform field? Apparently you cannot link unbound fields?

Wayne, Thank you so much for the heads up. I am actually planning for this form to be add only, but it sounds like the most used method is DMax. I for some reason was having trouble with it yesterday, but I got it working now. Thank you so much for your help. You are so kind! Carly

I got it working with DCount. Thank you guys so much for your help. That is so nice of you to take your time to help other people who don't have a clue like me. Best, Carly