Search results

Hello, I have paired down an existing db to be able to attach it here. My issue is that I don't know what the proper syntax is when using DoCmd.BrowseTo acReport that is pulling data from a query containing an Expression. The code that is producing an error is tied to the first DropDown called...

Hello, Attached is a db which shows the results of a simple Unmatched Query. I am confused by the results. I would expect the query to return no records at all as the two tables are identical with regards to their record data. It seems the query is picking up empty or null fields and treating...

I am trying to generate an event each time the user changes a field on a single record. In other words, the user changes one field, then the event gets triggered, when the user moves to another field on that same record and changes that field another event would be generated. I can get the...

I am attempting to pass logic operators via TempVars to query to filter a list box. What is the proper syntax as "<>5" does not seem to pass to the query properly? Sample DB attached. Private Sub Frame0_AfterUpdate() Select Case Frame0.Value Case 1 TempVars.Add "tmpSelected", "<>5"...

Does anyone know how to fix what seems to me to be a bug in the query view? Using Access Office 365. The tables and links are partially hidden and can't be adjusted. Scroll bar is all the way up yet I don't see the top of the view box to be able to adjust the tables in the view.

In the attached sample DB I would like to figure out how to replicate the data of any record that has more than one item selected as part of the FirstName multivalue field. So if the record has three names chosen, I would like to create three new records with each of those names but keeping the...

Hi, At the risk of getting yelled at for asking a multivalue combobox question, I would still like to know, how does one cycle through a multivalue combobox to obtain only the records which were selected? Combobox is called NamesList I am using the following without success. For Each oItem In...

I have a Pie Chart in a report that works just fine. As soon as I place that report with the chart into another report as a subreport, it no longer displays the chart. I tried look at master/child links, which to me seem correct. Record source for the Pie Chart is a query. I have also tried...

Hi everyone, Background: I am trying to simplify invoice entry. The user enters the activity to be invoiced using form: "ServiceCharges" The invoice activity for each record could potentially be charged across multiple client projects. To do this, the user selects one or various client...

Within the "Report Center" tab, the user should choose a filter to filter the report that is in place. I would then like to be able to print out the resulting report. I can't seem to accomplish this as the SubReport is part of a form on a tab control. Would love some help with the VBA to...

I would like the user to be able to select a town and then be able to print out the result using the command button. Currently all the items from the listboxes print out (checked and unchecked). I would like to only print out checked items. Thank you.

Hi, I have received some good help in the past from various people on a project I am working on. Unfortunately I am stuck again with the following: I have several combo boxes embedded in subforms within a navigation form. I know the syntax changes between a standalone form and one embedded as...

Hi, I am looking to use the "DoCmd BrowseTo" along with a "Where Condition" to filter a report in place. I can not for the life of me get the Path to Subform Control argument right. I did try and look at other threads and still can't seem to get it right. Here is my current setup: Form: Main...

Hi, I have a navigation control with various tabs on it. On my tab called "Task Center" I have a blank form called "Task Center". On this form I have two subforms which are both unbound. The first subform is called "Task Center subform". This form contains various fields. [ID],[Project...