mjvm
Last Activity: Oct 27 '16, 11:37 PM
Joined: Oct 31 '08
Location:
-
thanks Jim - this is a really useful page, and I'm sure others will find it helpful. -
thank you for this.
ticked this as best reply because it answered my question in the most straightforward way - which is what I need :)Leave a comment:
-
Message box to alert if changes are being made on a form/subform
Hi,
I have successfully added code that alerts the user if they are making a change to a record when a check box is 'true'. However, the form includes a subform. I can't work out how to trigger the message box when changes are made on the subform.
I don't know how to include the subform in my code below.
OR whether to write code for the subform and reference the check box (I tried frm.DischargedS P and Me.frm.Discharg edSP... -
Thanks NeoPa - that is perfect.
Thanks so much for your help and support. I apologise for the delay in getting back to let you know it worked- I got caught up in so many other things!!!!
All the best,
marcellaLeave a comment:
-
Hi NeoPa,
Thank you so much for your help. I'm glad my question was clear - I was a bit nervous, it's been a while since I have tried to do any code in my db. Thanks for the tip on starting a new question too.
Thank you for the code - it is picking up if a student name is already entered, so the field names are accurate; and does nothing if a new name is entered.
I would like to change the yes/no buttons...Leave a comment:
-
Detect Matching Record
Hi,
I have been trying to adapt this code for my database. I'm using MS Access 2007, and most front end users are in 2010.
The name of the underlying table is tblStudents, and the record source is qryMainDataEntr y (which links two tables).
The Form is called frmMainDataEntr y. The name of the field holding the data is called StudentName and it has the same name in the table and the form (I know it probably shouldn't)....Last edited by NeoPa; Nov 9 '13, 03:17 PM. Reason: Added more info. {NeoPa mod} Split to its own question and added link into here for info. -
Thank you Adezii, that has fixed my problem. I also had made a mistake in setting up the Update query, which I have also fixed and the whole process is now working perfectly.
Thank you so much for your time!
regards.Leave a comment:
-
HI - back again!
this is a response to the message from Adezii that is listed as best answer. Now that the database is up and running and I am testing this process, I have hit a hurdle.
Adezii - I have used your code without changing anything. There is only one record per student in qryChase, but if a student already has a note in tblNotes, then it doesn't create a new note (I can see how this happens in line 9), and...Leave a comment:
-
Hello,
In answer to the first part - I am using the Wizard available under External data to take me through the process and it it isn't working. I am getting an error message - which I hoped someone might understand and be able to help me with and therefore, fix my problem. After having a look at some of the other responses on this forum, I now realise that the forum focus is VBA and so this may not be the right place to post my question...Leave a comment:
-
Mail merge to word problems
HI again,
I am trying to use the mail merge to word wizard under External Data from a query and this is what happens:
On opening Word, I get an error message called: ODBC Microsoft Access Driver Login Failed, and the message says: Could not find file (and file name).
If I click OK, I go through a series of steps to link to the database and choose the query BUT the Access tab at the bottom of the screen... -
NeoPa - just saw your post and I will keep those points in mind the next time I post. However, I will now turn the computer off and go to bed (I'm in Melbourne).
Thanks again!Leave a comment:
-
Oh my goodness! It worked.
Thank you so much for the code ADezii, and thank you to NeoPa, MSquared and ADezii for your patience and persistence in "unpicking the thread".
Regards,
marcellaLeave a comment:
-
Of absolutely - I was completely aware that it was me not getting my message across and that I wasn't being clear or detailed enough for you guys.
What is difficult is not having the right words - the terminology - to ask the question. You don't get the answer you need if you don't - or can't - write the right questionLeave a comment:
-
I am about to have a go at using the code - wish me luck!
I really thought that I was being as clear as I possibly could - written communication shouldn't be this hard!
:)Leave a comment:
-
That sounds like a good idea, but I don't know how to do that. Is it difficult or complicated to code?
Cheers,
MarcellaLeave a comment:
-
yep - I get that.
Thank you and till my next challenge...... .. I hope you all keep well!Leave a comment:
-
An alternative solution - would be to export the qryChase to excel including StudentID (from tblStudents), then add the notes information that I want, and import back to Access into tblNotes, renaming StudentID to NotesStudentID so that it provides the reference.
? MaybeLeave a comment:
-
Thank you.
As I struggled to explain what I needed, I was starting to think it might not be possible.
Thank you MSquared, NeoPa and Adezii for your time and patience - and your skills!Leave a comment:
-
Clearly I am missing something! :)
A school rings in and refers a student. The date is recorded, and the forms are sent. When forms are not returned, we email the schools to prompt them to return the forms.
If this was happening on paper, we'd have a running sheet with each student's name at the top, and record the date that we sent the form. The running sheets would sit in an in-tray waiting for forms to be returned. When...Leave a comment:
-
Hi NeoPa,
I can only recognise the group of students which all need the same note. As a human, I run qryChase and that's the group we need to allocate the Notes to.
I have been trying to think of a different way of solving the problem. I thought maybe having a table that records each time we send the email, but haven't worked out how that links to the student records.
Maybe I need to stay with using a...Leave a comment:
No activity results to display
Leave a comment: