Search results

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...

Hi Frothingslosh, Thanks for your reply. I'm afraid I dont know what you mean by code tags as I'm fairly new to this. I put the End if's in as I was doing an 'If x then Y else If' statement. Is this not correct? the error I'm getting is a compile error. Syntax error. Thanks

Hope someone can correct me here. I have a form with various text, date and combo controls. There is a button at the button that runs a macro (Close NB) at the bottom. What I'm trying to do is bring up a msgbox if certain fields are blank and not run the macro. I only want the macro to run if...

Thanks Paul. Used correct naming convention and it worked.

I have form 1 that brings up a record, I then open up form 2 with that record details. On the 2nd form I have a 'status' combo box with values 'OK', 'bad', 'unsubscribe'. I want to change the value of a checkbox, 'Active', on the 1st form, 'Maildelivery', from true to false if the combo value...

I have an on click event to mail a report which works. I want to change the text to include data from a table. I changed the code to include the field 'office' from the table 'Checks' but get an error saying 'Object required'. Code is : Private Sub cmd_mailreport_Click() Dim office As Object...