Recent content by Allan

Re: [SOLVED] Between Dates inconsistency Time to eat humble pie again and apologise for wasting everyone’s time. I set up a new database from scratch, importing the tables etc as I did the first time and the code worked first try. After comparing the new with my previous attempt, I noticed...

Apologies. That is embarrassing, it does not pay to rush an example before having to go out. However my original problem remains. Dave I have used various dates and the result will only produce records prior to 31 Dec 14. When the ‘firstdate’ is I Jan 2015 or later, no records are returned...

I have checked all the fields for consistency with no apparent problems so I have tried to duplicate the problem in a new database. I imported some data from Northwind and set up a similar form and query. The problem may not be a 'Date' issue. I note in the query that if I removed the...

The field data source is a table in a split database (linked) and the DateReceived is manually inserted into a 'MediumDate' field on a form. I tried your second suggestion, albeit I have used >< without the = sign. Both work, both produce the 2014 records but 2015 stays in the ether. I have...

Thanks ArnelGP Your formula gives a format error. However one of the "combinations" I had previously tried was: Between Format([Forms]![frmMain]![FirstDate],"dd/mm/yyyy") And Format([Forms]![frmMain]![SecondDate],"dd/mm/yyyy") If I have the first date as 1 Jan 2015, the result is blank. If I...

I have an Access 2013 database containing a number of unique ‘Clients’ and each client has multiple events attached including the date of the event (actually it is the date the information was received). Currently there are 4000+ events for 100+ clients. I am having difficulty with a query in...

This is the only forum I have posted on and being a novice I don't know enough to "not like an answer". I just wanted to know if what I am trying to do is possible. I know why I am getting the error and am looking for advice on whether there is another way.

Hi, If the question is what the table looks like, I have provided a screen grab of the table itself. I found it easier than the steps you suggested and provided the same information. Is there other data using your methods you need to see? Otherwise I am not too sure what you are looking for.

Thank you for your response but I am not too sure if I explained the problem correctly or how looking at the table fields will help. The attached are screen snips of the database and the sequence I am following. The tblAnchor is the main table from which I am extracting the information by...

I have a database which among other things records how jobs are received – i.e.: Telephone, Email, Mail, Facsimile or Web. For each client I want to identify the percentages of each method of receipt against the total of jobs received and during different time periods. I have created a make...

Problem solved. I imported the US date formatted text to a Date/Time field with the Format (Field Properties) set to: mm\/dd\/yy h:n:s AM/PM. All dates faithfully converted in double digits and I could use a query to change the to dd mm yyyy h:n:s.

A2007. Default date format is day month year. I have a text [Time Stamp] field with the data imported from an Excel spreadsheet in the form of "3/21/2012 8:14:52 PM" or "3/12/2012 8:52:11 AM" - the US format. (Attemps to change to a date format in Excel failed too - it seems Excel does not...

Thanks Gina, I had already checked the references and they were the same. I did not have the time to spend on working it out so had to take that particular function out of the database. I also checked the obsolete References on your link and did not have any of those checked. I have a little...

Hi From examples in this forum, I have used the following code several times under a command button: Email.HyperlinkAddress = "mailto:" + EmailWork to successfully open an email in Outlook ready to complete the other fields (Subject and Body etc). I used the same code in a new database...

Hi, I have an intermittent problem with a memo field that I cannot duplicate or identify a cause. I am posting it here just in case someone has experienced the same situation. The database is in Access 2007 and is split Back End on the server and Front End on four desktops. This problem has...