Search results

Unfortunately my laptop that has Access 2010 on it died today so I'm fixing it at the moment and won't be able to test what I'm about to give you. But you can try: [Forms]![masNavigazione]![NavigationSubform]![SubformControlName]![txtDataInizio] ... amend the bit in blue. But make sure it's the...

Before I even look at any code, can you first tell us what the error message is? Not just the error code.

I only said that in jest, hence the wink ;). Strange occurence. I would hope that DoEvents would cure the problem but it's not an ideal piece of code for this scenario.

I'm not questioning your code or your use of implicit type conversions. The variable declaration was DateTime which isn't a datatype in VBA, the equivalent is Date. And the type conversion functions used were Date(), but then again the VBA equivalent is CDate() or DateValue(). Also, for a...

The answer is here...

Since you know how to do it for a combo box, you could start with that code. There's no difference between the search functionality between when a combo box is used and when a textbox is used.

Or Max in a Totals Query grouped by the relevant fields.

The code that Ranman256 does exactly what you're after. Private Sub cboSalesquote_AfterUpdate() With Me .Filter = "[Salesquote] = " & .cboSalesquote .FilterOn = True .cboSalesquote = Null End With End Sub ... I don't know why you decided to turn off the filter...

Perhaps your PC is too powerful in that the cut wants to happen quicker than the VBA validation ;) Try breaking it down: If Shift = Access.acCtrlMask Then If KeyCode = vbKeyX Then KeyCode = 0 ElseIf KeyCode = vbKeyC Then KeyCode = 0 ElseIf...

You can do it in the Control Source of whichever textbox you choose to be the only date textbox, or do it in the record source (i.e. query) of the form: Nz([Date1Field], [Date2Field])

Amending Dennis' code to be more VBA friendly ;) AfterUpdate or Change event ?? If Me!acxCal.Value = Date Then Me.btnToday.Enabled = False Else Me.btnToday.Enabled = True End If

I would expect the newly created item to be a copy of the template and any changes made to it shouldn't affect the template. Can you show the full code you used to change the Body of the template?

Sorry, just going through some old posts and came across this one. I agree with GohDiamond! The other way to get the properties, methods and events of a control is to hit F2, type "Textbox", under the Class column select the row that has "Textbox", look at the frame just below the Search...

I was going through some old posts and was surprised to find your questions unanswered. =Sum([Invoice Amount]) / Sum([Quantity]) =[Text114] * [Other box] ... I have no idea what other box you're referring to hence [Other box]

ted.martin, I only use that method for text file types not for pdfs. What's your objective?

Maybe you can explain the objective and we can give you some ideas?

Why don't you ask, "any other ideas" rather than "anyone else". And if something doesn't work, explain exactly what you tried and what the outcome was.

It was only a matter of using "*" instead of "x". The square brackets weren't needed in this case.

Looks like mlai08 wasn't thinking out of the box when s/he read my post so I'll expand a little. * User1 on FE1 wishes to send an e-mail with a hyperlink to User2 * FE1 sends a "hyperlink" creation request to delegate db (DbDelegate). The request contains the form name and the unique ID *...

Not sure why you're quoting yourself in your first post burrina, but it's not completely clear (to me) what you're trying to do. If you want to add quarters to a date you can use the DateAdd() function.