Recent content by Connorbop

The database is related to property and estates management and the cases are for any properties/estates that are flagged to us for a variety of reasons. Anyone can change the information within a case and each case is assigned to an officer as a sort of "officer in charge". When a case is...

See attached. I know they're probably laughable, I'm just guessing as I go along..

Hello, I am learning how to use VBA after playing with macros for a while. A brief description for what I'm attempting to do: I have a case management system which needs a comment box to show historic actions from various employees on different cases. Each comment needs to ONLY display on the...

No I'm using a standard access database. I wasn't sure what a data marco was, it's just something I found when trying to research a solution.

So I have had a go and have a working comments section as far as manually adding comments via the table. However I would like to have a txtbox with an "AddComment" button in order to add the data to the table. My table "tblComments" contains: CommID CaseID EmployeeID DateTime Comment So now...

Thanks for the point in the right direction, this has been helpful and I will give this a go, however I have a couple of questions: How do I pull the employeeID into a table when they add a comment? How do I link comment numbers to case numbers? e.g. How do I only display Case ID "1" within...

Hello, This is one that's been hard to search for as it only comes up with the use of a 'Memo' field - this is not what I want. I need a comments history which allows me to add comments to a specific case and when another comment is added, it is moved to the top. Each comment is marked with...

Thanks for this however I get a returned error saying "#Type!" within the report, why's this?

Hello, I am creating a report in which I want to concatenate multiple address cells: [AddressObject] [Address] [Street] [Town] [Postcode] to form a single line such as: [AddressObject], [Address], [Street], [Town], [Postcode] However, one or more of these fields may be null depending on the...

Afternoon, I have a database which does not require users to login however I have an administrator panel which I would like there to be a login system for. Below I have outlined the sort of thing I am looking for and wondered if anyone knows of a database I could edit for my purposes, knows of...

From what I gathered, this seems to hint toward using queries to form my case reference number, would this make it easier to work with?

Hello plog, I know the way I have formed my case reference number is clunky however it does contain a primary key already within the table called "CaseID" - Your question is going to be why don't I use this as the reference number. It's important that the reference number contains information...

Hello, (I'm pretty new to database design and everything I know is 100% self taught so I apologise if I'm talking rubbish, any tips are welcome) I have a table (tblCases) linked with a form (Case Manager) in my database and one of the text boxes (txtCaseNo) is populated with the below...