Search results

Glad to help you. You should evaluate it carefully and I would expect some questions to be raised as you work with it - as I do :) (case in point: the decision about how you choose to implement txApplied and the associated MedicationDetail, Procedure and VaxGiven tables as these have 1:1...

@FeelCore Having reviewed your database structure, language issues aside (some items I was not able to decipher), I think you need to consider the following for a better more robust structure on which to build your application: Happy to discuss details. Edit: I made a few small changes and...

Commenting upon the database-structure-png: You have made a decision to combine Client and Animal in the one table. That would appear a serious error in design. A client may have multiple animals, at any one time, and the animals a client has and brings to your clinic for a visit does change as...

No. @Claude Parisel It is the wrong command - see post #6. The DoCmd.FindRecord method in Microsoft Access VBA is used to find a specific record based on a search string. It mimics the functionality of the "Find" dialog box in Access. Me.[PN].SetFocus oCmd.FindRecord "Père", , , , , acCurrent...

DoCmd GoToRecord is used to move to a record by reference to the absolute or relative position of the record - it must specify a valid record number. Hence the proposed text matches will not work. it is the wrong command. Use a filter or DoCmd.findrecord...

Yes - it seems odd: acAdd is an enumeration for acOpenDataMode (https://learn.microsoft.com/en-us/office/vba/api/access.acopendatamode) but that is not acFormOpenDataMode. The first is used when opening a table, query, stored procedure, view - it does not mention a form or report. Perhaps an...

And in regards to points 1 and 2? Do you have the form properties for allow additions set? or for Data Entry to Yes?

1. Does the query used itself allow records to be added? 2. If frmsalary is open on the first record, can you simply go to the new record? 3. The docmd is used to open the form frmsalary and move to the new record. Is it executed from a different form, with the intent it is only used to add new...

see also this thread for same issue, from same OP https://www.access-programmers.co.uk/forums/threads/the-copy-text-and-add-new-record-button-events-are-not-working.334486/

No attached access db. Your pdf in post 5 showed 3 error messages ... you might indicate how these errors are generated in the access db you provide. which form , which action?

Then do you have a routine that allows relinking to a different BE - as an accde the users do not have the ability to change manually, unless it is programmed in to allow them to do it - see Jstreet relinker as an example utility you can incorporate as a module in yours to allow users to do...

The template referred to shows nothing that relates to the animals treated or the treatment they received - just a generic appointment schedule - so pretty useless. @FeelCore - The report to do with health inspections: is that a formal, regulated report that needs to be completed for certain...

No need to apologize - you are doing well. If I can just review some things you have said: For a veterinary clinic. - 1 only Your clients (in the client table) I presume are people, but as a vet clinic it is the animals that are treated - so perhaps you need a separate table for Clients and...

As a beginner you first need to tell us about the business context - what is the database for, how you expect to use it in your work. The start and fundamentals for your database are to understand the scope and business requirements to then define a database schema on which you can build the...

would be nice of you to provide 1. the error message(s) 2. and the code /macro - even a screen dump, particularly for the "K" button

Just as a side note - your reliance on Myers Briggs may be somewhat over confidence: to quote from wikipedia: And further: Whether that has an impact on your design that is another matter. Such personality / psychological tests are often subject to revision as further knowledge develops...

Anyway @Isaac , @Mike Krailo it been fun to kick a few cans down the road, but as you say there is no point taking this further with you two. It is clear where the lines lie, unless you want to continue making nonsense claims. I'll take a break - going skiing.

I wonder what that means - we can all feel awe-inspired, feel tiny in the majestic panorama of the universe and its wonder, or connected to one another. We are built that way, but to extend it to some fantastic being - with no discernible impact on the reality of living in the physical world -...

And there are those who will go to endless lengths to blindly believe the most extraordinary claims without evidence. Extraordinary claims require extraordinary evidence. Become a little sceptical and subject those beliefs to some rational assessment, or admit it is just faith - nothing more...

I was going to say OMG but that would be wrong - it would seem you are prepared to accept without question hearsay as evidence in establishing the effectiveness and efficacy of a drug in testing - WOW! You do not need RCTs then. Why not skip the whole testing program and just take it by the...