Search results
-
A
Append contents of textbox onto memo field
I've tried two sets of code at the moment... neither work ;( Can someone please help me enhance one of them? Set db = CurrentDb Set rs = db.OpenRecordset("Bemerkung") rs.Edit rs("Bemerkung").Value = Bemerkung.Value & vbCrLf & Me.notes.Value rs.Update rs.Close -... -
A
Append contents of textbox onto memo field
We have two databases... one is used by our CRM software which I have linked a table into my little database I'm using for my own little project, therefore comments need to go into the main database for the company but I also want them in mine.. I know this is redundant but it's required at the... -
A
Append contents of textbox onto memo field
I have a form which modifies the 'calls' table. The calls table has customer ID which is linked to customer ID in the customers table. Customer | Calls ------------------------------------------------- Customer ID | Call_ID... -
A
Display IDs as names on report
I just tried putting: =DLookUp("[Business]","[Customers]","[CustomerID]=") into the control source for the report field, but I just got '#error' How would I do what you say with the query? Forgive me it has been a while since I have done databases. :( Adam -
A
Display IDs as names on report
I have a query that returns Date StaffID CustomerID Subject 23/06/10 1001 2002 Blah My staff table obviously has the colums: ID, Fname, Sname. My customer table has: ID, businessName. When I print off a report, I want the report to...