Recent content by GPSPOW

I am new to this. In a simple way, how do you loop through the string? Thanks Glen

Can someone tell me how I can build a field to parse a text string like: ABS.PAT.string.2 where the result would be a field value of just "string.2"? I have field values where there are variable occurrences of the "." before the last capital letter. So I want to parse the field 2...

I am getting a Run_Time error 3075: Syntax error (missing operator) in query expression 'dbo_DMisProvider.Name WHERE qryPhysician_Registration_Data.Prim_Care_ID = Left(StrIn, Len(StrIn)-1)' Here is the new code: Thanks GPSPOW

I am still getting a pucnuation error on the following: Thanks Glen

The following is a VBA code I am trying to create to set the SQL statement for a query based on on a parameter set from a listbox. If lstSelect.Value = 4 Then SQL = "SELECT qryPhysician_Registration_Data.Prim_Care_ID, dbo_DMisProvider.Name AS PrimCare_Name" SQL = SQL & "FROM...

I have a SQL statement to create a query with a where condition coming from a recordset value. When I process the following code, the variable name comes out as the actual value. I am attempting to qualify the query to the value from the recordset record the do while loop is currently at...

Thanks I think I have it now

What would the syntax be in your 2nd example, DoCmd.OpenForm "SecondFormName", , , "FieldName = '" & Me.ControlName & "'" when I want to process a pdf report? DoCmd.OutputTo acreport, "rptIPAPhysStats_V5","PDFFormat(*.pdf)", "Path", What goes here?? Where do I place the parameter for the...

I hope someone can tell me how to fix the following code. I am creating a query to designate the subset of physicians from a master list. From this subset I want to loop through the results, print a report to a pdf for that physician, loop to the next physician and repeat the process until I...

Hi, I have a main report that lists data grouped by physician:banghead: for totals of the procedures they have performed within a given time frame. At the end of the group I have placed a subreport that gives summary data related to the physician with its own headers. I am having a...

Below is a query I can run without a problem. But when I try to convert it to VBA, I get a data type mistmatch. If you could, can you tell me why the SQL does not work. Thanks Query built via Create: SELECT dbo_BarPeStatusVectors.VisitID, dbo_BarPeStatusVectors.PeriodDateTime...

Thank you.

How do I write the build expression to do the following: IIF( isnull(Field1) and isnull(field2), 1, datediff('d',now(), dateserial(2012,4,30)) I am having a problem with the "and" clause. Thank you GPSPOW

OK. I did. Thanks GPSPOW

Will this also work in Excel VBA?