Search results

I have a text box that provides a brief description of a product. If the field has no value (null or ZLS) it is set to display "No Description Available". This works fine except when the field has data beyond so many characters. That is, you only see part of the description. The data is...

Checkout this Microsoft document: http://support.microsoft.com/support/kb/articles/Q115/9/15.asp?LN=EN-US&SD=gn&FR=0&qry=parse&rnk=3&src=DHCS_MSPSS_gn_SRCH&SPR=ACC97

Rather than repeat everything, please see my post at http://www.access-programmers.co.uk/ubb/Forum4/HTML/004408.html I've been told I need to write code to parse my proposed combo box. What's parsing and how would I do that?

I have two text boxes in my subform FormReplacementList: Replacement For and Replaced By. The subform is linked to the mainform by my primary key consisting of two fields: Form_nm and Form_vdt. Currently, the user navigates to a record using the main form and enters Replacement For...

Thanks for the suggestions but, unfortunately, I get the same results (162 records when the result should be 120 as determinded by a crosstab query). My son suggests that I do an If loop on the Form ID field. Something like if Form ID equals previus Form ID, skip to next record. I haven't a...

Instead of repeating everything please see my request for help: http://www.access-programmers.co.uk/ubb/Forum3/HTML/002196.html Thank you.

Thanks for responding. By tagging, do you mean set up a ‘duplicates’ field in a table? If so, I would still have to look at each duplicate (or triplicate, etc.) record and determine which is the first instance of the record. Actually, first instance is incorrect. I’m looking for a way to...

I’ve developed a query on 3 different tables that generates all the records I need ... and then some (duplicates). The relationships are one-to-many (A to B) and many-to-one (B to C). There is no relationship between tables A and C. The output fields of my query which are later needed for a...

Thanks for the suggestion but I have trouble getting it to work some of the time. If I comment out the ElseIf code (including the EndIf) everthing works fine. But when I delete the ElseIf code (including the EndIf) I get an 'Argument Not Optional' error message. Any idea what may cause this?

In case anyone is interested, I solved it! Here's the new code I had to write before the Else statement. As you can see, it needed an ElseIf statement. If Me.ActiveControl = "MU" Then If Me.RecordSource <> "tblForms" Then Me.RecordSource = "tblForms" End If ElseIf Me.ActiveControl = Null...

I've written code that allows user to create a new record source for my form based on the combo box selection. It works and here’s the code: Private Sub cboState_AfterUpdate() On Error GoTo Err_cboState_AfterUpdate 'Purpose: Change the form's Recordsource to only records from the...

Sometimes we overlook some of the simplest solutions (I didn't recall the ShowAllRecords command). As an FYI, I still had problems ... I was still being prompted for state when I selected the ShowAllRecords button. I resolved this by adding the following line of code before the DoCmd...

I developed a command button that filters a form based on users input of 2-digit territory ID (in this case USA states). My problem is that when the user is done with the filter they want to remove it. I'm at a loss on how to show all records. Do I need to add another command button that just...

I'm fairly new with Access but my boss is asking me to track changes made to records in our database. I developed a History module based on MS Support Article Q183792. I am able to report changes in various controls of the main form to a memo field. My problem is that I can't get the changes...