Search results

So in no way am I an authority, but in practice: I Compact && Repair (during development) generally just to reduce database bloat (caused by multiple append / make tables then delete queries). I make use of temporary "side" databases to handle any temp tables that are usually subject to bloat...

Danny, what is the relationship between AnalystID and the email address? If you are not storing the address anywhere, how are you expecting the address to be auto-populated?

qdf needs to be set first. Try something like: <Code>set qdf = currentdb.createquerydef ("tempquery") <\CODE> Sent from my SM-G900P using Tapatalk

I must say, extremely interesting discussion. Does that mean BigHappyDaddy.IsDrunk = False? :)

So I found this to be an interesting problem and come up with an independent (but very similar) solution. Posted for your review. Public Sub GetHouseNumbers() Dim db As DAO.Database Dim rs As DAO.Recordset Dim strHouses As String Dim arrLine As Variant Dim arrHouses As Variant...

What happens if you remove the docmd.applyfilter line? Sent from my SM-T530NU using Tapatalk

Ok, for your error. You have 2 where statements in you variable task. Change the second where to and. As for the recordsource, just as you have it except do not include the and statement. Replace docmd.applyfilter with me.recordsource=task Then readd docmd.applyfilter, but instead of task...

This my understanding : You want a textbox on the main form to reflect the number of records in the subform (excluding duplicates) when the user clicks on the button 'calc' The Dcount should be done one of two ways 1- base dcount on a query that replicates the subform recordsource AND...

First, I am guessing you current problem resides in the string task. You have a '&' trailing the where statement. Then you are using task as a filter. Try removing that character. Second, i personally belive your original method was a closer solution. But instead of applying task as a filter...

Trying to follow the desired results and I am lost. If I understand correctly you a table with (at least) the fields testid, Na2CO3,HCL, HO3 and Plain. I am assuming testid is the primary key of the table. Based on my assumptions above and your image above (1 record form with over 50 controls)...

Please confirm that the procedure SetButtonState is in the form's module and not in its own module. Sent from my SM-T530NU using Tapatalk

The location of the code would go und r the command button click event. As for making the form unbound, simply remove the record source of the form. Now it is not bounded to any dataset. But i expect that would cause other issues . Instead try creating a new unbound form for the user to...

Personally I would create a query to append the data to the BE table. Have the query created when the user submits the record. Just use the various text boxes / combo boxes values, etc to populate the table. strSQL = "INSERT INTO [BackEndTable] ( [Field1], [Field2], [Field3]) "SELECT...

I am not sure if this is the issue, but it popped into my head as I was reading this forum string. First, is the form an bound or unbound form? If bound, at anytime during the entering of data, if the network connection is lost, the record on the BE may be <deleted>. Well not deleted, but...

My pleasure Sent from my SM-G900P using Tapatalk

See attached. You were right and your reference was incorrect. I did two things, converted the macro to code and simplified the reference. See code below: Private Sub Search_Click() Dim strFilter As String strFilter = "FirstName Like '*" & Me!Text17 & "*' " & _ "OR...

Sorry, I just saw your line about doing this in code. It is my preference to do all this in code instead of macros. There are many advantages of doing this in code over macros. If you are able to post a copy of your database, I would be willing to take a look at it. Please remove any...

The error is being generated because you are trying to apply a filter to a form that doesn't have any data attached to it (it other words, the form is unbound). So either the error is being generated because you are trying to apply the filter to the parent form (navigation form) or the...

Ok, sounds like a subform. So I am assuming that this subform still includes the text box control (named Text17) and the command button. I am also assuming the results are based on applying your criteria as a filter. Ok next, please explain what you mean by "can not get this to work"...

So a question to clarify your intent: When you say "...place this in a navigation form", are you trying to insert the original form (SearchForm) as a subform into the navigation form, or are you trying to replicate the search functionality on the navigation form?