Search results

You'll need to provide the code for someone to confidently give you a good answer. It might be that the drop-down is applying a filter to the data, and then the data is exported to Excel. If that were the case, you would either remove the filter, or change the drop-down so that when a...

Hi Dave, Not exactly - I was hoping to have an unbound report that I could create the records for on-the-fly through coding. As I was unable to find a suitable answer to accommodate that thought, I've instead decided to append records to a local table through code, then base the report off of...

Sometimes a simple example helps a lot - see attached database. 1 form, very simple. Make a selection for the first combobox and watch what happens in the second. Then take a look at the code.

Okay - the control has a "Name" property and a "Control Source" property. You change the "Name" property by adding the prefix to it. Don't change the "Control Source" property.

You rename the control on the form (i.e., change the combo box name from PreExisitingProgram to cboPreExisitingProgram.) Then look in the events of the control (After Update, for example.) If there is no value in the field, click the ellipsis button, choose Code Builder, then click OK. The...

To be clear, the variable and the controls are different things. To help keep these separate, use a prefix. For example, instead of Dim PreExistingProgram as Integer use Dim intPreExistingProgram as Integer. Instead of PreExistingProgram for the control name, prefix what this actually is...

Hi all, I'm trying to find how to programatically move to the next detail record on a report. Pseudocode: Open two recordsets (Old record, Current record) Compare old to new, if changes, mark up current report record. Move to next detail section Loop But I can't seem to force the report to...

Based on your explanation, it sounds like you want a Value list, not a Table/Query for your "Row Source Type." Then for "Row Source", you would simply type "Yes";"No". As far as filtering, the reports are based off of queries, which use criteria to refer to the values in the form. You would...

That did the trick - thank you. -Adam

Hi all, I have a report with some code on the Report_Load event. When I open the report, it works fine. I also have a subreport with some code on the Report_Load event. When I open the subreport directly, it works fine. When I add the subreport object to the report, and then open the...

If I'm understanding you correctly, then you simply need to make use of the "or" criteria in the query builder.

Unfortunately that is not enough information to provide you with a solution. If you can post the fields of the table that the form is based off of, as well as any code behind the button you're using to enter data into a field, we might be able to help.

Depending on your main form, you may find it easier to set the form's default view to continuous form. That will allow users to add multiple records

Yes, it is possible, but what do you mean when you say you have never done this previously? The code its self, or working with an Access form, or what? If you've never used VBA before, I would recommend starting with something a bit more simple before trying to tackle this.

Perfect. Thanks for the help.

Thanks for the reply. Still getting an error message. Here's my code: Me.txtRecordsforCurrentIndividualforCurrentMonth = DSum("NumberofPresentations", "tblCCMECPresentation", "ReviewDate = #'" & Me.txtReviewDate & "'#") The error message is: Run-time error '3075' Syntax error in date in...

Hi all, I'm sure this is just a syntax problem, but I cannot figure it out for the life of me. I'm working on a bound form and I'm trying to set the where condition of a DSum to Month(ReviewDate) = Month(me.txtReviewDate), but having trouble. I have tried several different ways. As an...

At some point today (2 hours ago maybe?) everything went back to normal speed for me.

How about something like this in the On_Current event of your form? if me.<name of check box> = true then Me.Form.AllowAdditions = False Me.Form.AllowDeletions = False Me.Form.AllowEdits = False Me!<subformName>.Form.AllowAdditions = False...

I think you're going to need a complete redesign for this to work. It looks to me like Client Demographics, Clients Current Address, ClientsAddresses, and ClientsNames should be 1 table instead of 4. I'm assuming the "Calls" table is where's you're storing the data of each individual call, and...