Search results

Hiding the form would make the procedure more aesthetically pleasing to the user but this would not alleviate the slow processing time, or would it?

To clarify I did achieve my goal of the dynamic form, but it was taking too long to execute on certain computers which is when I began to question it. Unfortunately i did put in the time to write tons of code to "save" the data (maybe 200 hours as I had to teach myself everything). Part of...

Scenario: Need a dynamic data entry form. The user generates this form by specifying which parameters (field names) will be on it. In one case it may be only 1 field, in another case it could be 25 fields. The parent form is static, these fields are only found on the subforms. I have been...

Thanks a bunch!

Ok, here is the scoop. This is a database for a water quality lab. The data is stored as 1 result per record, while the lab data entry sheet has many results in the same record. There is a button "SAVE" that activates a bunch of subs that translate the data from the entry form into the tables...

You make a good point. The subform names are known and will never change, the field names might though. I could use your method if I populated an array with all the field names that are currently on the form (arrayofcurrentfields). For c = 0 to Ubound(arrayofsubforms) For i = 0 to...

Here it is. The sub will be called from a different routine, at this time TESTFORM1 is closed so I have to open it to manipulate the hidden property. You can see how directly referencing a textbox works to hide a column by the buttons I have on TESTFORM1. I was hoping to accomplish the same...

it is a textbox

Sorry, I was skipping past the part of the code that I know work. This should make it more clear and simple. Public Sub test1() Dim i As Long Dim c As Long Dim subformlist(0) As String Dim cntrl As Control Dim testarray(1) As String subformlist(0) = "testtable1_sub" testarray(0) = "3"...

1) it is a public variable already defined out of this sub 2) I got lazy with this - it is the parent form = Forms!F_labnew 3) module

Thanks! I guess my question has been narrowed down to this: How can I use the ColumnHidden property of the "current control"? Dim cntrl as control Dim i as publicarray() For i = 0 to ubound(publicarray) For each cntrl in FORM If cntrl.name = publicarray(i) Then cntrl.ColumnHidden = False...

Thank you for the response. I haven't had any luck using the .visible property of a control, text box, etc with datasheet view (works with other views like single form). This code works (sorry no fancy colors). Me.TESTTABLE1_sub.Controls("ControlName").ColumnHidden = True But I want to be...

Greetings, Well this sure is a simple question and I'm embarrassed I haven't gotten it right yet, but a few minutes of your time will certainly solve my issue. All i need is the following pseudo code translated into actual working VBA code. For each value in a public array(1), I am attempting...

Thanks a million. I like the site 3 non-overlapping also. I will prepare all that stuff and post later today.

Thanks for the response. The start/end date time for each site query is no problem for me to make. There could be any number of sites but likely range would be about 1-10. The resolution of the timescale can be very course.

I will be adding a significant amount of code so this is very helpful.

Thanks for the prompt responses, which are very helpful. I can see how I would use the method SOS suggests - in my case i would not need to loop but rather refer to a particular subform and use the afterupdate event rather than mouse click. I think I would prefer to insert an actual sub or...

bump ^ anyone have any suggestions?

Greetings, I need to know how to add an event procedure to a form programmatically. I have a routine where a user generates a custom form & subforms for data input. I need to add event procedures to some of the subforms on the form that have been created with the code. This all must be done...

This form is a utility to help the user import time series data to the database. The only thing I'm stuck on is how to make a nice graphic for the user that will help them quickly know if they have time series overlaps. Table1 Preexisting time series data from several different sites. Already...