Search results

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...

1. There are some combos that have no defined record source. Are you having trouble defining these? What is the problem - you have defined the record source for other combos? 2. There are references to qryProfileDimensionDetails. That query does not exist in the db supplied

The reason I do not use the hyperlink is because I am dealing with files - not links to web pages/ sites. Are you proposing that users may save links to their local files, which are not available to others, and links to files which are shared on the network under L:\local? If that is the case...

A bit confused by your description so: 1. Your users can select a file (using file explorer). 2. Selecting a file moves it to a network folder (nominally L:\Local?) 3. Having moved the file a record is automatically created in your table in which the hyperlink is stored (in field linkname)? -...

Within the health system there is a need to retain legal name and also allow multiple alias's / AKA names to be captured, and used in searches to retrieve records, which were held in a dedicated table.

A gotcha that could occur with deployment of your app on PCs with just the runtime MS Access installed on the client's PC: - it may not apply in your client's case where a trial version of office was used (as the trusted location may have been set while using it). The access app needs to be...

larry - it is on the screen dump you just posted - About Access - Current Channel - Case of TL:DR ? :)

For me the template is a starting point - look at the table design and think (deeply) about whether they can hold the sorts of data you need. look for gaps you need - set your scope - eg will you need to track depreciation? service schedules? service companies/contractors/employees. When you...

If you are really new to access - are you really new to databases? Do you know how to design tables to minimize redundancy in your data? That step is independent of the database tool. While you might think about the tables to store and manage the data you also need to have a good roadmap of how...

Just two tables? Table one: Customer .. CustomerID autonumber and customer detail attributes ("Main table" in plog's post) Table two: CustomerQuote .. as per plog suggested structure however do you need a QuoteDate? and QuoteID (InsuranceCompanyQuotes - icv - in plogs post), quote accepted flag...

also requires the customerquoteid - as the icv_value is presumably the quoted policy premium value from the icv. There may be other common attributes of the quotes which might be used judge the best deal, but that was not indicated.

Good to hear - good luck. Also consider how to get quantity entered for each Job-Part. Set to 1 as default.