Search results for query: *

Hi everyone, I'm having the devil of a time remembering the proper code to create a search textbox on my form that can be used to make "inexact" matches. Here's the setup: I have a form based on a table called Books with a couple of fields I want to search on: Title and AuthorLN. Want to be...

I am having no end of trouble trying to work with the DTPicker control. I keep reading in the posts (and on the MS site) that the way to change the default date on this ActiveX control is to set the value property to the desired date on the Form Load event. Which I do, Private Sub...

Golom: Thanks for your input, I am always amazed at the extent to which MS will go to make a unusable any legacy Access programs.

The only success I've ever had is with a custom calendar created from an Access form. I will give you the link to the site where you can get it: www.glump.net/content/accessdatepicker It's not as slick and compact as the MS controls, but by God it's worked for my app through 4 version...

Golom: You know, I was afraid you'd tell me that. What a bummer. Thanks for the help, though!

Hi All, I have developed an app in 07 and I have a user who is trying to run it in version 10. He is getting the usual msg: "Your Microsoft database or project contains a missing or broken refernce to the file 'MSCAL.OCX version 7.0' " How can I get this app to run for him? Thank you for...

MajP --Thanks so much for your help, this does exactly what I'm looking for. I am in the process of re-designing this DB and needed to get this info out seperately to do that. have a great day! LM

Hi All, Am using ver 2007, I have a memo field with several lines, separated by returns, here is an example of this field data: 1 ) EXTENT OF VAPOR LEAKAGE OUT FRESH AIR DAMPER? 2 ) COLOR OF WATER IN SEAL? (LIGHT BROWN IS NORMAL) 3 ) SUPPLEMENTAL AIR FAN MECHANICALLY SOUND? 4 ) FD FAN...

Remou, Thanks to you also, now I can't decide --are there advantages to using one fo these versions over the other? LM

Skip & Randy, Thank you SO MUCH for setting me straight! What a dummy I are :-) Have a GREAT weekend! LM

Hi all, I am trying to write a little code to analyze the current time when a button on my form is clicked. I need to know if the current time is between 12:00 pm and 6:00 pm, or between 6:01 pm and 12:59 pm. I am using a variable called TimeOfDay to capture just the hourly info of Now(), and...

Hi All, I am using version 2007 and having a little trouble hiding duplicates in a grouped report. I have a series of issues being reported on and various responses to these are kept in a separate table. I used a single query combining the info in a basic report with no grouping, and hiding...

Duane & PHV, I've tried what I last mentioned and everything is working fine. It's beyond me why none of the other references worked. I've always thought Access subforms were the spawn of Satan, now I'm certain. Thanks to both of you for your help. LM

Duane & PHV, Though I hate to give up trying to find a solution to this, I am tempted to put all the graphs on the Menu form itself. Would refreshing be less of a problem then?

PHV, I tried your code, got this message: You entered an expression that has an invalid reference to the property Dirty. Run stopped at the first 'Dirty' line.

Duane, Here's the amended line of code: DoCmd.OpenForm "frmComplaints", acNormal, , , acFormAdd, acDialog Same message came up. BTW, thank you for taking so much time to help me with this.

Here is the click event to open the Complaint form. This button is on the Main Menu: Private Sub cmdNewComplaint_Click() Me.lstReview.Visible = False Me.lstRespond.Visible = False Me.lstUnfinished.Visible = False Me.lstReadyToclose.Visible = False Me.lblListLabel.Visible =...

Duane, I am trying to implement your code, but get the following messsage: Run time error "2118" You must save the current field before you run the requery action. The run breaks at this code: Me.YearlyTransportationStatsPieChart.Form.Graph1.Requery I never named the graph object on the...

Hi all, I am having trouble refreshing a series of graphs in my Access 2007 application. Here’s the story: I have five graphs on a Main Menu form, they are in five subforms. The user opens a Complaint form to enter information that these 5 graphs track. I would like the graphs to update when...

Duane, Thanks for the input --can I use what you've written for ADO? LM