Search results

I have a function that builds a filter and it get a syntex error. It has three components and I must be missing something in combining them into the filter. SpecID and ReviewID are numbers. Selected is a checkbox and 'Yes' is a string. Can anyone see the source of the Syntax Error? Private...

Error #2046: The command or action 'OutputTo' isn't available now. Reply to Thread Thanks for your reply. I finally resolved the problem by first focusing on getting all the code to develop a report correct. Once that code was correct I then directed the report to the 'Output To' code. I had...

I've tried to debug and track down the source of this error, but I can't figure it our. I've researched access forums for something similar, but had no luck. Can someone help me with this code error?Public Function OpenSnapReport(ReportName As String, Optional View As Integer, Optional _...

I'm trying a different approach. Instead of using a filter, I'm trying to change the recordsource. I'm still having problems with this. Private Sub btnSetFilter_Click() On Error GoTo Whoops Dim strSelect As String, strFrom As String Dim strSQL As String, strWhere As String Dim...

Maybe it would be simpler, if I could find an example of a filter that includes a sorting code? Does anyone know of such a sample db? Thanks, PC

Thanks for your reply. The variables that begin with a "g" are global variables. The filter without the sort code works; so that's not the problem. There's no error message, but there is no sorting. The sort code that I added to the filter is:'ComboBox Sort strOrderBy = " ORDER BY " &...

I'm trying to include sorting code in a filter code. Is this possible? Can someone help me? This is what I've made so far.Private Sub btnSetFilter_Click() On Error Resume Next Dim strSelect As String, strFrom As String Dim strSQL As String, strWhere As String Dim strOrderBy As String...

Thanks for your reply. The problem seems to be capturing the date criteria. I made some changes to try to simplify the changing of the combobox recordsource and the changing of the date field. The reports are displayed in two listboxes. The work order listbox code is: Private Sub...

Emailing loop A few months ago I had the same problem. This email loop includes a lot of things. I hope this is helpful. Public Function EmailLoop() On Error GoTo Message_Err 'On Error Resume Next Dim strErrMsg As String 'For Error Handling Dim olApp As New Outlook.Application Dim...

I have a filter on a form for my reports and it consists of: 6 comboboxes and 2 date fields. The user may use one or all the filters for reports of the same recordsource. The reports are of two catagories indicated by their name's prefix "rwo" or "rpg". One of the filter comboboxes (Filter5)...

I've resolved the problem with displaying the Discription when the user doubleclicks on one of the branchs. Private Sub tvHelpTree_NodeClick(ByVal nodTreeView As Object) Dim RecordtoSelect As Long Dim strTopic As String Dim strDiscription As String Dim db As DAO.Database...

The readme file explains that all objects are hidden and how to access them. This db is a prototype to import into my project after I get it working. When the prototype is utilized in my project the objects will remain hidden. I've done more work on the db and its now too large to upload...

I've seen the module Enabling Full Row Select in a Treeview on The Access Web, but there is now clarification on how to use it. Has anyone used this function? Basically, I'm looking for a way to identify the branch of a treeview on a form that the user selects and have it return a field in the...

This is the first time I've tried to work with a treeview control and it's very challenging. I've developed the branch building code in the form's module to a point where I'm confused on how to proceed. I've attached the database and a "readme" file to this posting. I hope someone can help...

Thanks for your help. For others interested in this solution, I'm posting the working sample that I've developed.

I'm beginning to think that its easier to use just one recordsouce and use update queries to determine how the checkboxes should be checked. Two of my update queries are update parameter queries for the date range and I get an error when I use these two queries. The error is Run-time error...

I have a follow-up question Roy-Vidar. In order to printout all the records that have their checkbox selected, I've used your code in a function for looping through the form's checkbox controls. I can't seem to get it to work in generating a report. Could you take a look at my sample file...

Thank you for your reply Roy-Vidar. I'll test your code. Thanks, PC

I realized that in my next step in identifying the exact records that are selected are also going to be grabbed to put into an email module. This will send each selected record that contains project information to each individual staff member. Counts won't be enough, so I had to try something...

I've created a code that I think more closely takes information directly off of the form, but I still need someone's help. The Public Function CheckboxOnForm() give me an error. See attachment. Thanks, PC