Search results

Thank you for help, I changed the dlookup to DLookup("ID", "Files", "Member Number ='" & Answer & "'") and it now works. Thank you :D

[SOLVED] dlookup data type mismatch error HI, I am trying to get my VBA module to find the ID of a Member Number from a table using a dlookup but I keep getting a data type mismatch error, Dim Answer As String Dim varX As Variant Dim rst As Recordset Dim strSQL As Integer Dim stWhereStr As...

Hi, Thank you for your help. pr2-eugin function works great thank you!!

Calculate exact age - solved Hi, I am trying to find a way of calculating the exact of someone from their Date of Birth. On my access form I have a text box with the date of birth and what I want to be able to do is have another box flag up whether from the dob the person is under 18 but as...

Hi, I have a VBA module in an access database which sends XML to an outside location. The code is below, however when I run the script I keep getting the error "Run-time error '-2147024809 (80070057)': WSDLReader: XML Parser failed at linenumber 61, lineposition 19, reason is The name in the...

I have tried opening a file that is not read only and it opens fine no problem

Good Morning, Hi, I have an access database which in one form opens a word mail merge file which is linked to the database tables. In 2007 and 2010 Access it was fine no problems however since we moved over to 2013 access I have a got the error message "The OpenDataSource method or property is...

HI I have a database in Access 2010 which has 3 tables (OEM, Products & Support) and a form (SupportForm). I now want to create a report which has two drop down boxes (linked to 2 columns in the Support Table, Field2 and Field3) on it, which when choices are selected from them they will run...

Hi Hi I know this is not a question but i really need some help with my dissertation on comparing different database software including Microsoft Access 2007. I am looking for anyone who has used Microsoft Access 2007 before. If you have could you please please please fill out this...