Search results

From https://learn.microsoft.com/en-us/office/vba/api/access.application.dmax (Criteria is optional) Place your arguments in the correct sequence Increment the variable after getting the max value

What is the expression you are using? What type of field is RecordNum? Integer? Autonumber?

willing to try this one? BIVACOR Heart

50,000+ forklifts operate in the US as FCEVs (Hydrogen Fuel Cells - the electricity to run the electric motor is produced by the fuel cell). ' Refueled in minutes and require less maintenance. Various sources for making the Hydrogen. Availability of vehicles, range and refueling stations - ...

You will still need to ensure that the text string you use as a filename from UnitCard only ever contains valid characters for a filename, or substitute characters that can cause problems. Just sayin. Happy that you were able to resolve your core issue.

You can run a routine to cleanse the Unit name of any illegal characters before assigning the file name. Adjust as needed. Public Function fStripIllegal(strCheck As String, Optional strReplaceWith As String = "") As String ' PURPOSE: Strips illegal characters from a string that is to be used...

Hey @Chuckieinoz welcome to the forum! 1. Set Option Explicit after option Compare Database - it will help with your debugging - in every module (can be set as a default). after setting it - try compiling and you will see: 2. You have not Dim'd the variable uFound or aProfile: Dim Ufound As...

Your form is similar to a questionaire and you may pick up some designs by searching for samples - plogs proposed arrangement is a valid starting model that follows a similar structure. For the responses to any question your form would probably use an option box control, where you might make the...

Refer back to the db schema provided - note the naming of the primary keys and the joins illustrated. MajP discusses this above. You use the relations/relationship (based upon the keys: Primary Key (PK) / Foreign Key (FK)) to tell you how data is logically associated, and use these to construct...

Most/all of your combos will be driven from the Type tables - using a query of the table to show the displayed value, hiding the stored ID of the particular type. Type table lists should not be arbitrarily edited - you need to avoid multiple terms being used for the same type. However they can...

A UNION query does not merge records, it combines the individual records from each source into one common form/presentation. Hence you have 2 records for those YearMonth. To now get the combined amounts, you write an aggregate query based upon the union query. What would be the rule for...

Access will not allow mixed datatypes, and to a database modeller/designer, those are two different data items (and so normalisation rules apply about atomic data items) - one that accepts/records a specific value such as applicable tax band and another perhaps boolean, which says, say...

That will be a judgement call: it is quite legitimate to have a separate Site table to hold the location details, however really this is only useful to you if you find that the Site information is re-used quite often for different jobs - you did mention that you (sometimes) quote for a number of...

Where there are more than one record satisfying the criteria in DLOOKUP, the first record is returned - not the immediate prior record Or a random value from the field: see DLOOKUP You might need to use some sort of sort, to then get the value from the previous record based upon the sort.

This is a form design problem needing to support your work flow, however I would suggest again that this is likely something like: A New Job (Quote) is to be raised: Prompt -->Existing or new client? if Existing then Prompt --> Present Client Sites to select or New Site btn Queries supporting...

I'll just address this question at this time (gotta get other things done) Site role is the site specific role a contact has for a job: eg the designated architect. However your contacts have a position/ expertise within the company in which they are employed - such a company director /...

The development of database using the relational paradigm requires the application of normalisation techniques to minimize data duplication - redundancy, ensure the data is logically consistent, and data integrity is maintained through the established relationship / rules between the tables in...

strwhere, I expect is going to be used in SQL, or at least as a legitimate SQL experession. You need to make sure you construct the criteria with the appropriate column names - perhaps like strWhere = "Yearcolumnname = " & tempvars("DateLimit") & " AND AccountcolumnIDname = " &...

As a start: Datediff Does not recognise "year" as an input setting: datediff-function As a side issue: you are assigning current members a membership rate for the current year, I think. What it implies, as you keep this info on the members table, is that you keep no history of payment of...

s/ I live in fear of your undoubted wisdom re the scientific method @The_Doc_Man: trembling in awe of your authority /s :oops: ... I was not leaving out the link you described. it was in relation to Pat's statements which were not about what you are discussing. The research conducted by...