Search results

Try it this way and see if works, I think HTML colours are a little tricky to handle in access. If Me.ServicePack = 3 Then Me.ServicePack.ForeColor = 255 ElseIf Me.ServicePack = 2 Then Me.ServicePack.ForeColor = 65280 Else: Me.ServicePack.ForeColor = 0 End If...

Using 2010 32 bit I've created a custom ribbon that only opens on report print previews. However, I can't seem to get rid of the File tab on the ribbon which allows access to the backstage and the Privacy Options button which then allows access to various setting that I'd don't want users to...

OK here's what I did in an attemot to secure my FE. 1. Created startup Properties 2. Ran this in the OnOpen event of my startup form Dim iRetVal As Boolean DoCmd.ShowToolbar "Ribbon", acToolbarNo iRetVal = AddStartupProperty("StartupShowDBWindow", dbBoolean, False) iRetVal =...

Using 2010 32 bit This is driving me nuts. I've been Googling all day yesterday and best part of today and just can't find any reason why the below isn't working for me. I've place the code in the onopen even of a form but still the darn Ribbon's visible, showing the File and Home tabs...

Using 2010 32bit. I'm running the following code from the on open event of a startup form but noticed the check box's under Options->Client Setting don't 'uncheck'. This code worked fine in 2000, just can't work out how to do it in 2010, any ideas? Application.SetOption "Confirm Action...

Thanks for quick reply GinaWhipp. Oh well. Regards SmallTime

Anyone know if there's been any progress on the SP1 fix? it's been a while. Can't leave comments on Access blog any more: http://blogs.office.com/b/microsoft-access/archive/2011/07/08/sp1-vbe7-update-impacts-64_2d00_bit-installations-of-access.aspx Maybe if people stop talking abut the...

Thanks for that pointer missinlinq. There go all the isNull's that I've been using. SmallTime

Yes but you then also have to take into account the available manpower and resources.

Had to come back and say thanks again, spent the whole of yesterday removing all formats and Cdates from vba and queries and testing. All is now good with the world. SmallTime

Thanks GinaWhipp I surfed some of these yesterday + some older posts. I was kind of hoping MS would have produced a fix by now, but couldn't find the definitive answer. If I'd caused such a problem for my customers I'd be working around the clock to get it fixed. I suppose that's the...

Anyone know if SP1 has been fixed yet? SmallTime

Hip, Hip, Hurray. Just tried out the SmallDateTime and it worked fine. Everything's back to normal. Phew. This was killing me. Thanks from me, my dentist and my dear old neighbour who thinks I've got turrets. SmallTime

Sorry, don't know where to look for this. I did notice this date issue before and thought it was just a MS quirk. I've been managing dates with the format() , and CDATE() functions but it's really getting on my nerves. Now you say SQL 2005 handles dates OK I'm starting to fear for my teeth...

using access 2010 with SQL server 2008 r2 Its DSNLess link

Thanks Glaxiom for quick answer. just double checked and DataType in sql Server is Date. However, viewing the linked table in design view from Access is indeed text. SQL format = Date, Access format = Text. It's a linked table so how do I resolve this?

Never seen the FIFO Stock database and maybe very few people have, which might explain why your question remains unanswered. If the sample database doesn't have the fields that do what you need then you'll have to created them and add code the handle calculations So in short the answer is YES...

I had similar problems when using embedded macros. Reverted back to good old VBA and all was fine. I suspect the embedded macros don't quite work as advertised and am hoping a proper SP1 will fix the issues (not the current broken version) Try as I did and drop the macro, open your form and run...

I keep hitting this problem time and time again and it’s driving me to distraction. Here’s What I have: A continuous form with the RecordSource as a linked SQL table (QLTblHolidays ) that contains a date field (MyDate). Here’s what I want 1. The date displayed in British format e.g. 01/01/2011...

Philben, I love the sample database you've kindly attached, in fact it's so nice that I want to use it in my own database (of course I'll leave credits and comments intact). However, this is a bit over my head as I know nothing about HTML coding. Would you be kind enough to place some comments...