Search results

You cannot. If it is stored as 1203015555 for 12th March 2001 it will be the same for 1901. Why not do this the other way around, store the date of birth and then extract a random identifier when required.

It is probably easier to add them all together and subtract the lowest value;)

The simple answer is that you cannot easily do it. The right click on textbox logic is pure microsoft. In order to do it nicely you have a lot of coding to do.

Continuous improvement is a nightmare for those of us who are perfect :D

Personally I hate the concept of things dedicated specifically to ISO, ignoring Access completely, I hate the concept of ISO systems. In my business we function correctly and because of this we are ISO compliant. In a perfect world there would be no ISO guides and the like, an auditor would...

Interesting question this, we do almost entirely use Access for our ISO system but there is a huge but. ISO cannot do anything, databases cannot do anything. We built a system around what we do and the addition of an ISO system allowed us to define our practices more accurately, this lead to...

Have you considered using Message Boxes instead of forms?

Presumably when modifying the form you can click on 'add existing fields' and it is present in the list of fields that can be added. This is because it is set as a field of the form, this is why I suggest you look at the data source of the form as I assume it will be a query which has a field...

It is only referenced in the list of fields because it is an existing field. Presumably the data source of the form is a table or query and you need to edit the data source and remove the column that no longer exists.

Perfect and many thanks, I obviously had too much Christmas :o

I am defining a document name using the following: CoCName = "COC" & Right(Year(Date), 2) & Month(Date) & Day(Date) Last month this returned, for example, COC161225 on Christmas Day but today it returns COC1715 and I am trying to return COC170105. Is there a way to get it to return the month...

Edit the data source of the form to a query and just select records that are not listed as empty.

Jon, apparently you could have saved a lot of those years of time, see attached. Only joking:D Perhaps any serious objectors could be offered an advert free version for a small consideration;)

In the query delete the "group by" from dates and just set criteria for your date range.

Obviously Access would not be able to handle gutschmecken as it is a matter of taste:D

You cannot use Access as a brain :mad: What you could do is import the details of the datasheet into a table such as 'tempdata'. You could then load this into a sub-form for viewing with the main form for data entry. The main form would contain your real fields and could consist of drop-down...

DateSerial should give you the end of a specific month.

Apparently he was the son of God and for all we know God may be Chinese. On this logic all argument about his race or colour can only be guesswork:D

Having used this a lot, my work around is a little different. Just change the form fields so that they have default values of: DateAdd("m",-6,Date()) and Date() This will automatically load the last six months and you can then change it to whatever you like.

Many thanks again, Minty but this is very useful for Excel. I guess the real issue here is that I am trying to save time. There are hundreds of ways to do this using a set of forms, control tips or VBA loaded information. What I would like is to take a user manual saved as a chm file and each...