Search results

Well all depends on how you use to work. Lets suppose yr record table has a column “TimeStamp_” and you want to check the 24 hr period [Period_start … Period_end] So the Where section of Query has to check TimeStamp_ against the upper and lower limits Period_end and Period_start) eg TimeStamp...

You are right CraigDolphin, when I looked at your code I remembered that I saw some of this astonishing stuff before, in “the Access Web” site I think, (eg http://www.mvps.org/access/modules/mdl0006.htm) but I completely forgot about it (I hope its because it looked rather weird to me and not...

I see your problem this way: As far as I know Access does only transfer Data from its dB to Excels dB, not Command strings. What you want to do is execute Excel instructions within Excel domain. So only if Access could transfer Excel instructions into the Excel Macro Set you would have a...

I am somewhat suspicious about you changing the forms underlying data while you are in the subform as probably your subform is synchronized with the form. So it looks to me it could be that you are sawing off the branch where you are sitting on. At least I would expect some confusion.

Thanks a lot for being interested in my problem. To answer yr questions regarding SQL Server, I passed them to the SQL Server Admin., as I have no access to the Server (just the Query Analyzer) which is corporate IT business of the compagny. I got following answers: Index Name...

remember that a date is stored as a number, so to take 1 day off (24h) it is just date_-1. Look at this: dummy_=#02/01/2008 10:00:00# ? Format((dummy_),"dd/mm/yyyy hh:mm:ss") 02/01/2008 10:00:00 dummy_=dummy_-1 ? Format((dummy_),"dd/mm/yyyy hh:mm:ss") 01/01/2008 10:00:00

raskew is right - in sql you always use the US representation for the date, sql will not recognize the dd/mm/yyyy format (the same way you use 5.6 and not 5,6 in sql)

What happened to the stored queries defined in the FE of our Access FE-BE application, after upsizing the Access BE (just tables) to SQL Server? As an example: [ProjectChances].[PropNum] ç related è [Sales].[PropNum] Below the excerpt of a SQL Server printout showing the relationship...

I had this same problem a few days ago, and suspect that this field probably was copied from a text field changed to a memo field (as George mentions). For some reason the change went not complete, so the field limitation remained. I created a fresh memo field in the form substituting the old...