Search results

And this is the module to find the current department... Option Compare Database Option Explicit Public Function fnLastLoc(ParamArray ref() As Variant) As Variant Dim v As Variant Dim i As Integer Dim pos As Long For i = UBound(ref) To 0 Step -1 v = v & (IIf(Trim(ref(i) & "") = "", Null...

Table attached. Fields Referral1 through to Referral6 are the department fields and AARef1 to AARef6 are the staff name fields. I'm aware it doesn't fit normaliztion standards but this is a quick interim fix whilst my company is awaiting its new CRM.

Hi I have a form that includes 6 fields in a column for department name. Next to each of those is a field that stores the name of a staff member in that department. In a related query I call a module function that looks at the 6 department fields and returns the value of the last non null...

I tried this but, by doing this it shows the record count at the bottom and window border. Is there any way of "cleaning" that up?

In my db I have a form with 5 tabs. What I am trying to achieve is to have each tab relate to separate tables. The main table is the one relationship and all "tab tables" the many side of the relationship, linked with the field "appID". How can I achieve this in the record source of the main...

I'm trying to create a query but when I select the relevant table in the query wizard at least one of the fields I need isn't listed but definitely is in the table. Why would this be and how can I select the field for my query?

I thought it wouldn't be a good solution tbh. I understand, whatever help you can give when you have time will be appreciated thank you. Sent from my iPhone using Tapatalk

Been thinking, should I have a table for each referral and have a sub form for each of these tables in frmApprentice or would this not be good normalisation practice? I suppose it would make frmApprentice look a bit of a mess with 6 subforms too?

Thanks jdraw. I've downloaded these and will take a look when I get time.

Thanks Minty. Those links were very useful. I've removed the lookup (didn't realise it was there) and renamed the forms and tables as suggested which makes a lot of sense. I've also removed the event coding to clean each form up a bit for now. I've also ungrouped the components for now and the...

Thanks Minty. I've populated some test data on the relevant tables (attached).

I pretty much have done what you've stated above but got stuck and asked here for advice on specific issues. I've been running an unnormalised db for 6 months and realised this wasn't effective. I planned a normalised db but got stuck and asked here for advice. I was advised to use a sub-form...

OK, I think I'm a bit confused so may not have explained correctly. I have a table of unique students and a table of unique documents. The purpose of the database is to track and record documents received for each student. For a single student we could receive Document A. Document A...

I've added LearnerID and set up the links but I'm still experiencing the same error messages. I've attached the updated version of the db. CJ_London - The purpose of the form is to search for the student/learner, show the basic learner details at the top section and in the subform I need to...

I keep getting errors stating "You cannot add or change a record because a related record is required in table ..." when using the Referral subform in Apprentices main form. In summary, the purpose of this db is to record receipt of documents relating to students, and record their "journey"...

So how would this be handled in a form? In my previous non-normalised db I had a form that had 6 separate fields for each referral. I need to have a historical record of each referral for traceability and reporting. Sent from my iPhone using Tapatalk

Okay, a little bit stuck already. Each document could, potentially, be referred to different departments up to 6 times before it's processed. Should I have a separate table for Referral1, Referral2...or add the fields to tblProcessed? I need to record the referral department, date and...

I didn't explain that one very well. I've created multiple tables one of which is for documents and another for students (not a separate one for each document and each student). Thanks for your suggestion of the extra table(s). I'll give that a go and may come back if I get stuck.

Hi I'm trying to create a new database to record documentation that is received and processed for students but I'm confused as to the relationships of my tables. I've already created many separate tables, including one for each type of document (DocumentT) and each student (LearnerT)...

Thanks for the advice from all above. I understand the normalisation issue but this db is very small and is unlikely to expand so a single table is sufficient for the purpose, though I do take on board your comments. CJ - Your solution worked as required. Thanks.