Hi MajP,
You were absolutely correct! I just needed an IIF statement before extracting the date. It's amazing what a good night's sleep will do when you go down the odd rabbit hole (I should have known better).
Thanks for all your help!
-Rod
Thanks The_Doc_Man,
As I just posted to MajP, the query seems to work in the stripped down database. So I will go back to the drawing board to see why it isn't working in the database it came from. There are a large number of records in the original database (+212,000) but that shouldn't make...
Hi MajP,
It is a huge database, so I created a smaller one (attached) with only a few records in the table with the query I was using. Odd, in this database, I am easily able to filter it. So I went back to the one I'm working on and still get the errors.
I'm tempted to export everything...
Greetings,
This one has me stumped! I have a database with a memo/long text field and in this field there are a bunch of time stamps and some text (for example, "2022-04-15 0945 In Production"). I have successfully extracted the time stamp in a query (using "Mid([Status],InStr([Status],"In...
This one always gets me in a bind & I can't seem to find the answer anywhere... I would like to open a report where the field in the record source is a variable. The following works fine where the field is boolean:
DoCmd.OpenReport "rptReport", acViewPreview, , "[StringFieldName] = -1"
I...
For anyone else trying to figure out the same issue, here is what works (my listview control is ListView1):
For i = 1 To ListView1.listItems.Count
If ListView1.listItems(i).Selected Then
'MsgBox ("Iteration: " & i) 'use this to see the iteration(s)
If FiltStr = ""...
Thanks vba_php. I have already been through most of those searches but haven't been able to source how to add to the Filtstr on each iteration or why it isn't working (keeping in mind this is Access & not one of the other applications).
I have a form that has both an Access Listview and Treeview & have successfully coded it so that I can drag & drop a single item from the listview onto a treeview node. However, I am struggling with dropping multiple items from the listview onto the treeview node. In dissecting the VBA in the...
I finally figured it out. I believe part of the problem was because I embedded the query into the form where I had the control. When I removed this and made the record source a normal query, it worked. Here is how the query found the control...
Hi MickJav,
Thanks for your quick response. Unfortunately, it didn't find it. I am wondering if it's because I'm placing it in a Query for the form's recordsource ("frmSubForm")? I have the "cboAsset" in the header of this form where the detail is a continuous form. Also, I'm only 2 levels...
I am struggling to refer to a control that is buried within 2 navigation forms. I have searched everywhere and tried different solutions but to no avail. This is the structure:
Top Form = "Main"
Navigation Subform = "NavSubForm"
2nd Navigation Subform = "TabSubForm"
Form holding the control =...
Thanks Everyone! I did manage to figure it out with by adding a line of code to format the list item when populating the records.
lstItem.SubItems(2) = Nz(Format(rs!Amount, "$#,##,0.00#"), "")
Which is actually the 3rd column of the ListView.
Sorry for the delay in responding! The data type of "Amount" in tblScansR is set to currency and I haven't been able to successfully place the "format([Amount],'$#,##0.00') " where it will work without an error. I think that it needs to somehow be placed in this part of the code:
With...
After hours of searching on my own for a solution, I have given up & hope that someone can help. I'm just an average VBA person and new to generating the ActiveX Listview and Treeview, but have so far managed to create a form with a Treeview list and an Listview where I can drag items from the...
Greetings,
I have followed instructions here and from Allen Brown's site for carrying forward values from specific controls to a new record. The instructions above also work very well for me except that after the form is closed and re-opened, these fields are blank.
I have the form set to open...