Recent content by Grounded

hey, this was great. wound up doing almost exacltly this. thanks for the help!

Ok, so the guys in the field are collecting a TON of related data not just these three things. This is just one small piece of the puzzle. We’re using Trimble Recon GPS enabled pocket pcs. When there is a spill there are many beach segments that each get surveyed many times. There are also many...

Ok, I am working up the example. First - there are NO sites. A blank version of this db will be brought to each new incident/site. This is an oil spill response tool so a new spill gets a new copy of the database to track all the info for that spill. Assuming the db arrives with the standard...

This looks interesting - I look forward to your example so i can really dig into it. Thanks, IZ

Hey, I'm no expert but it's probably because you need to make the active form invisible - which would include the subform. Screen.ActiveForm.Visible = False this might help.

Another in the continuous stream of problems. I have a table with three fields: Oil_distribution, oil_width, Oil_character. There are 5 predefined values for distribution and 4 for width. This means that there are 20 possible combinations of the two and each combination is assigned a character...

I guess you go with the solution that shows the most promise soonest. In the end though it worked out. Turns out that this works great – until the converter is called from a subform. Then screen.activeform returns the active parent form and the form passed in contains the subform. This proved...

Exactly! Thanks.... iz

Thanks for the advice but i still get the same error. "Database can't find the form 'strFormName' referred to in macro expression or Visual Basic Code." Code used: (Where strFormName and strControlName have successfully been populated) strtest =...

This worked well in the end: Private Sub cmbOrg_ID_NotInList(NewData As String, Response As Integer) On Error GoTo Error_Check 'ask if they want to enter a new value If MsgBox("Organization not in list - would you like to add it?", vbOKCancel, "Not on list") = vbOK Then 'clear out the...

This should be simple: I double click in a text box on a form. The event triggers a public function in a separate module and passes the current form with ME. I want to take the value in the box convert it from feet to meters and return it to the box. Here's the function: Public Function...

Ken, that was helpful for a code cleanup but it didn't solve my problem - infact it is worse now. New Code: If MsgBox("Organization not in list - would you like to add it?", vbOKCancel, "Not on list") = vbOK Then Response = acDataErrAdded DoCmd.OpenForm "frmOrganization", acDesign, , ...

I have two forms - one enters info about people. One enters info about organizations. when entering a person you choose an organization for them. If you type in on that isn't on the list then i fire this code: MsgBox "Organization not in list - would you like to add it?", vbOKCancel, "Not on...

[dater] = 38825.9785763889 int[dater] = 38825 datevalue([dater]) = #Error datevalue(format([dater], "mm/dd/yyyy") = 4/18/2006 Expression: datevalue(format([dater], "mm/dd/yyyy") Criteria: #4/18/2006# Returns two rows!!! Finally - this looks like it. Just one more permutation. Thanks for alll...

Nope - this still returns zero records. I thought this is something that should be common and easy. iz