Search results

Hello there, I have seen this many times across the Forum, when some of us ask users to upload the DB.. The responses we get are "The information is sensitive", "The file is too big", "There are over 100,000 records".. Well when I started using this Forum, I did not know how to UPLOAD a...

Glad that you have it sorted. Please refrain from Double Posting : http://stackoverflow.com/questions/29488275/access-criteria-currently-month-and-next-month For more information on Why should you not post the same question in several Forums, read HERE.

Okay, how about May 30? The Saturday that follows the Bank Holiday Monday. Would anyone be interested to go for that date? Location still being Bristol? As no one seemed to disagree on that.

Could you please show some code you are using?

Please post the Full SQL, with some sample data. If everything fails, please post a stripped DB. How to Upload a Stripped DB. To create a Sample DB (to be uploaded for other users to examine); please follow the steps.. 1. Create a backup of the file, before you proceed.. 2. Delete all...

Wow Rain, think you should make a trip there too. Maybe we could catch up. ;) Or I could come to Aussie next time around :D

Vanakam/Namaste? ;) Welcome to the Forum Navi (n?) ! Hope you find the forum useful in your learning curve ! :D Will be in Germany (Kaiserslautern and Frankfurt) end of April.

Could you please post the SQL?

So my guess is the field you are trying to use the criteria is not Date type is it? It is of type Text? If so, you understand why the error !

@ Minty, what weekend would you prefer. @Uncle Gizmo, I understand what you mean. Okay what would be a good date? Any suggestions?

I have not found an alternate solution unfortunately. I still do two compilations. One for a 64 bit machine and another for a 32 bit. The older version the better. Decompiling and Recompiling will not solve your problem unfortunately !

How about, BETWEEN DateSerial(Year(Date()), Month(Date()), 1) AND DateSerial(Year(Date()), Month(Date()) + 2, 0) ? DateSerial(Year(Date()), Month(Date()), 1) 01/04/2015 ? DateSerial(Year(Date()), Month(Date()) + 2, 0) 31/05/2015

Unfortunately, the compiled project should be done on specific bits. As you have already found 32 bit should be compiled in a 32 bit environment 64 bit should be compiled in a 64 bit environment. Now VBA code is not compatible with different bit files so you have to make sure all code is made...

See if there is any method associated with the control that cancels the update.

Yes and also in the control_AfterUpdate()

@Isskint > That is bad. :( @Uncle Gizmo > Thought that might be a suitable time, given the fact many of us would have it off?

Try RecordSetClone and in the AfterUpdate event of the ComboBox, use the same code.

Hello peeps (in the UK) ! It has been a while, since we met up. The last time we did was in London - September 2014. Wow, it has been 6 months already and I feel it is time we made the effort to meet up. I am sure some of us would agree. Last time, we did try to make the effort of asking people...

Could you please show us the query?

You mean remove it from an option. Or just remove the selection?