Search results for query: *

I have 2 fields Year and Month. They are both numeric and in YYYY and MM formats. I’m trying to write a query that will select records that are less than the current date. For Year I’m using <=Year(Date()). For Month I’m using <Month(Date()). Because we are in Feb, I’m only selecting records...

MajP, Thank you. And yes I did have those variations to deal with. Works like a charm! Thank you so very much, Kopy

I need to convert phone numbers with format like (617) 868-8332 or 617/731-3413 to 617-868-8832 and 617-731-3413. Any thoughts on the best way to do this will be greatly appreciated. Thanks, Kopy

Declaring as an Object resolved the issue.

Thanks. It did the trick.

I'm trying to copy the Start Date from one form to the Start Date of each record on another form. In other words I want to change all of the Start Dates at once. Likewise for the /End Date. I'm currently getting Error 13 Type Mismatch. Here's code: Dim rs As Recordset Set rs =...

Thank you very much. I followed the approach delineated in the thread and it seems to do the trick. Thanks again, Kopy

...The expression FldListCheckItem you entered as the event property setting produced the following error: Error loading DLL. * The expression may not result in the name of a macro, the name of a user-defined function, or [Event Procedure]. * There may have been an error evaluating the...

I have a form with a button to print another form. When I execute the following code, the database window unhides. Dim stDocName As String Dim MyForm As Form stDocName = "frmPrintPictureLandscaspe" Set MyForm = Screen.ActiveForm DoCmd.SelectObject acForm, stDocName, True...

Thanks for the help. I placed it at the end of on current event, but still get the error. Any suggestion of a better place? Here's my code: Private Sub Form_Current() 'Display New QuoteID for a New Record '-------------------------------------- Dim intnewrec As Integer Set...

I have a form, used to create and document quotes for parts, that has the AllowEdits property set to No so that once a quote is written it can not be changed. If the user moves to a new record, I want to change the AllowEdits property to Yes. There is a combo box that the user can use to...

I recently got a new PC with Windows 7. Now my Access 2003 graphs show no data in the form view. The row source is fine and the graph prints fine. Any ideas would be great. Thanks, Kopy

I'm trying to create a button on a chart that will exports the chart and appends it to a Word doc named "Export Graphs". My problem is that right now the code opens "Export Graphs" and then copies and pastes the chart into a new Word doc. Also, I'm not sure how to have the copied chart append...

I have an Access chart that I want to add a button that will allow the user to export it to Word. Any advice on how to go about this will be great appreciated. Thanks, Kopy

I have a couple of pie charts with each chart having around 10 - 15 different data elements. The data labels are set to show alongside the relevant pie sections - showing category name, value, land leader lines. The labels overlap and cram on top of each other. The label position is set to Best...

...stLinkCriteria As String stDocName = "frmDataEntry" DoCmd.OpenForm stDocName, , , stLinkCriteria strSQL = "SELECT tblPatients.*, tblTissueSamples.*" strSQL = strSQL & "FROM tblPatients RIGHT JOIN tblTissueSamples ON tblPatients.[Pt MRN] = tblTissueSamples.[Pt MRN]"...

My previous post wasn't clear enough. I creatyed the graph using 2003's wizard on a PC that has 2007 installed.

I created a graph for an Access 2003 application on my current PC that has Access 2007 installed. When the user tries to enter the graph on a PC that has only Access 2003 installed, they get an OLE error. The graph was created using the graph wizard. My understandg is that when I created the...

...oApp.Visible = True 'Export Report: Local DoCmd.OutputTo acOutputQuery, "qryMDPHReport(MGHCampus)", "MicrosoftExcel(*.xls)", "c:\Impact Consulting\Partners\Occ Health\AnnualMDPH(MGH).xls", False, "" Set sh = CreateObject("Excel.Application") sh.Visible = True...

Here's the documentation on tblQBF: Columns Name Type Size StartDate Date/Time 8 EndDate Date/Time 8 StartInitialAge Long Integer 4 EndInitialAge Long Integer 4 StartCurrentAge Long Integer 4 EndCurrentAge Long Integer 4 PDDNOS Yes/No 1 Autism Yes/No 1 Aspergers Yes/No 1 HFA Yes/No 1...