Recent content by Robster

thanks. How would i do that?

Hi, I want to know if you can update an Excel file from Access when it is a linked table? I try to do it an update query but get error Cannot update '(expression)'; field not updateable. Is it not possible or do I need to change some settings?

got the concat working. the actual table has 24516 records so when i run the query it comes up with not responding.

Finanlly got it working.... but it's killing the system so cant use. I'm trying to replicate the following excel. IF(A3=A2,S2&Q3,Q3))

Didnt work. Have attached the error i get. It says variable not defined.

Here is a test db that is trying to do what i need.

this is the sql query. SELECT SBCTask3.[AccountRef], SBCTask3.[Liable PArties], fnconcatDATA([AccountRef],"AccountRef","SBCTask3","Item","Value") AS SBCTask3 FROM SBCTask3 GROUP BY SBCTask3.[AccountRef], SBCTask3.[Liable PArties], fnconcatDATA([AccountRef],"AccountRef","SBCTask3","Item","Value");

this is the code. Dim recSet As DAO.Recordset Dim varItem As Variant Dim strSQL As String strSQL = "SELECT [" & strFieldName & "] " Rem* loop through each fields to concatenate Rem* and built Query string For Each varItem In FieldsToConcat strSQL = strSQL &...

Didnt work. :banghead: I create the VB Module and then created the query. I edited the SQL to match the correct table but when i try to run it, i get the error. Run-time error '3075' Syntax error (missing operator) in query expression '[AccountRef]='. when I debug the below line is highlighted...

Data in the office so will try in the morning.

Hi, Hope you can help with this. I have a table that has records with different values for the same person. What I need is to put those values into 1 field. This is an example of the data. Reference name item value 1234 Sam Smith ABT 12 1234 Sam Smith BTE 24 1234 Sam Smith CDE...

I need to create a query which will append the record selected in a form into a table (Print_Table) many times depending on the number in the field Quantity. The form has a dropdown list connected to a table called products. eg. Table products SKU, Description, Barcode 101, product1, 543543543...

I had a similar issue. I set the Login form to hide the Navbar and Tables on load. Then on the next form, once you had entered valid login details, you can show them I created security levels, SecLevel, with '4' being admin and the following works for me in Access2010. When loading the form...

Thanks. I've amended the code and it's now working. Thanks for your help.

Thanks. How's this? If (Me.cmb_cliname Is Null) Then MsgBox "Please fill in the relevant details" Else If (Me.cmb_Disease Is Null) Then MsgBox "Please fill in the relevant details" Else If (Me.cmb_ProjectType Is Null) Then MsgBox "Please fill in the relevant...