Search results

Not quite sure what to put for "YourFieldControlSource". The List Box is generated by a query on an existing table. The List Box name is List0. The query that generates the list is: SELECT BRC_RM.ID, BRC_RM.RM_FULL_NAME FROM BRC_RM;

Actually no errors now -- but it is only creating one big report. no matter which salesperson I select from the List Box.

Slight revision to the code: Private Sub Command2_Click() Dim intCounter As Integer Dim cboCode As ListBox Set cboCode = Me![List0] For intCounter = 0 To cboCode.ListCount - 1 'set the list to the next item cboCode = cboCode.ItemData(intCounter) 'make the report...

Here's the code I am attempting to use (tied to a button on the form with the list box): Private Sub Command2_Click() Dim intCounter As Integer Dim cboCode As ListBox Set cboCode = Me![List0] For intCounter = 0 To cboCode.ListCount - 1 'set the list to the next item cboCode =...

Looking to generate PDF

So I will admit -- have NOT been working with Access for long (as well as VB)....but have a need, so ready to do whatever necessary to learn! I have a sales report that I generate each week based on a query, which relies on the input from a combo box on a form. This works great - but I have...

Found it! One of the records had a blank field, and the parsing function was returning the value #error in the fields. Deleted that record, and the report ran properly. Just need to add some error correcting logic to my original parse formula. Whew.

/ are used as delimeters in one of the fields (we use the SPLiT function to then parse then into separate fields)

There are approximately 50 records returned; lots of / characters in one of he fields--but all of the other salespeople also have / in their records

Good thought - I too would typically blame the Irish - but alas....not this time. I actually have another salesperson named "O'Malia" and his is running fine!

This is the formula that is being used in the header of the report: =Count(*) & " opportunities totalling " & Format(Sum([Incr New Commitment]),"$#,000")

This is the query I'm using, if this is helpful: SELECT ParseText([pipeline]![Short Description],0) AS ARL, pipeline.Status, pipeline.[Estimated Close Date], pipeline.[Probability of Close], ParseText([pipeline]![Short Description],1) AS [BRANCH RM], ParseText([pipeline]![Short Description],2)...

Thank you all for the help! I was able to create a custom function using the SPLIT vb command that is working great!

I have a query that uses the input from a form as criteria, which is then used in a report. The form input is a drop down based on another table. This is a sales pipeline report, and the list is a list of sales people. The report works perfect for all sales people except one. When I run it...

I've tried to use the SPLIT function, but it seems to crash when there is inconsistent data in any of the fields. That's why I'm leaning towards using native functions. Is there a way to put some error correction into the code when using SPLIT?

Hi guys -- brand new to Access -- but making good progress. Trying to NOT use VB to accomplish this (for a variety of reasons). I have a field in our database with five distinct strings, separated by a delimited (a slash or "/"). I've been able to successfully write the formula to parse the...