Search results

I am creating a function to produce and email a report as a PDF file. The filter in the DoCmd.OpenReport does not work. The function works in that the files are saved correctly but each one contains all the records in qrySubs1 not those just relating to a branch. I would like some help please...

Thanks for your help. I solved it by using a select query to find all the incorect dates the updated them using DateAdd("yyyy",-100,[DateOfBirth])

DateValue([TextDateField])

I do have a backup and yes its only date before about 1930 that are affected.

I inherited a db where dates were stored in a text field. I added a temporary field to the table of Date data type. I ran an update query to update the temporary date field to the date value of the text date field. I then deleted the text date field and remamed the temporary date field to that...

I worked it out in the end. i was a bit hasty in posting. DoCmd.TransferSpreadsheet acExport, , "qrySelUpdatesLapsed", _ "C:\Users\Submariners\Documents\" & MakeFileName & ".xls", True, "Lapsed"

I have a function to transfer query results to a spreadsheet. DoCmd.TransferSpreadsheet acExport, , "qrySelUpdatesCurrent", _ "C:\Users\Submariners\Documents\WeeklyFullUpdates.xls", True, "Current" DoCmd.TransferSpreadsheet acExport, , "qrySelUpdatesLapsed", _...

Thanks Ari, that did the trick.

I have the following code in a calculated field in a query which is the record source for a form. Test: IIf(IsNull([NatSubsBranch]),"",IIf([NatSubsBranch]=1,"Standing Order",IIf([NatSubsBranch]=_ [BranchID],"",DLookUp("Branch_Name","tblBranch","BranchID=NatSubsBranch")))) When I run the query...

I'm a newbe to Dreamweaver with dmxAjaxDatagrid. I have spent a long time looking for an answer but no joy. I want to make the name column a mailto: hyperlink to the email column in the grid which is hidden. I can get the email address to display under the name but on clicking, the email address...

Thanks Sarah, During the several hours that I was pulling my hair out trying to find a solution I did use single quotes at one time but all that did was comment out the rest of the sql string. I can see the logic behind it now. Nearly three score and ten and still at school. :)

Thanks Paul, This is the solution I found: sql = "UPDATE tblMemberBranch SET tblMemberBranch.Test = " & Chr(39) & res & Chr(39) & _ " WHERE (([tblMemberBranch].[MemberBranchID]= " & OpenArgs & " ));"

Trying to update a table using vba. I have a problem on how to get quotes around a string variable in the sql statement. when the sql executes I get a popup asking for parameter for whatever word the variable is. If I enter the word the table is updated. The sql string is: sql = "UPDATE...

Thats cracked thanks. used Res = Mid(Res,3) which got rid of the leading space as well.

I changed this line Res = Res & ", " & ctl.ItemData(varItm) To Res = Res & ctl.ItemData(varItm) & ", " and the result is Secretary, Treasurer, I dont want the comma at the end if that makes sense.

Debug.print Res lists the items selected but with a comma at the begining of the line. The result I need is the items selected seperated by a comma

I have a form with a multi select list box. I need the output to be a list of rows selected seperated by a comma. The code that I have puts a comma at the start of the line i.e , Secretary, Treasurer Private Sub Command2_Click() Dim frm As Form, ctl As Control Dim varItm As Variant...

Re: How do I filter a Filter (Solved) As usual posted in haste. Sat looking at my post and the light came on ;) Private Function MakeFilter() On Error GoTo MakeFilter_error Dim s As String If Nz(Me![ctlLike], "") = "" Then Select Case Nz(Me![OpGroupIndex], 1)...

I have a form with a make filter function to enable users to pick to display records. I have an option group allowing users to select records begining with a letter or number or begining with a group of letters. I have a check box control 'StatusActive' which when clicked should, when clicked...

Thanks very much Steve. I was resigned to the fact that I would have to reinstall all the software but I thought a last chance post might mind someone with a solution. Busy now trying to find all the discs. :-)