Search results

Thanks, but I still don't know how to fix it. If I change the return values to LongLong, it still fails. Private Declare PtrSafe Function ChooseColor Lib "comdlg32.dll" Alias "ChooseColorA" _ (lpChoosecolor As ChooseColorStruct) As LongLong Private Declare PtrSafe Function OleTranslateColor Lib...

Hi We've got a couple of dialogs that we are opening from the windows API, for example the File Dialog and the 'Select Color Dialog'. It works fine in Windows 32 bit and 64 bit, but if you install Office 64 bit it fails. It asks that you add the PtrSafe keyword to your declarations. If I do...

Can anyone give me any reason why I should go to Access 2013 instead of 2010. Or more simply, are there anything new in Access 2010 for desktop apps? As far as I can see all the new features are for the Access Web Apps, but you cannot use VBA in that (or can you?). I can't see a single new...

Yes, I went the C# way because it will increase any future job opportunities. Learning a new language syntax was quite easy as the web have lots of samples and translations available. But I'm still using Access for what I can, but it's getting less and less.

How are you trying to do the upgrade? Have you tried creating a new 2010 database, and then go to External Data and import everything from 2003?

Thanks. Problem is just that this needs to be done throughout the whole app in hundreds of locations. Bummer. I really hoped that there will a simpler solution.

Hi I've used Access extensively and also LightSwitch on a previous app. My feeling is that LightSwitch is not the answer. I had to redo the app on asp anyway at a later stage. If you are an experienced Access programmer, as you say, I think LightSwitch will only frustrate you with its limited...

Hi I upgraded my system to Windows 8 and Office 2013, and it's now 64 bit instead of 32 bit as before. Also note that I'm still using Access 2010 as before. So the following problem now arise in this new config that was not there before. When you do a calculation like '332.16 - 1', the answer...

Will there ever be a Service Pack that will fix these issues? Otherwise maintaining 2 apps will be the future very soon.

I think I agree with your issues that the 64 bit is not worth while. Sadly, in my case some of our clients are running the 64-bit version and I need to test, change and recompile. Can't force them to change just to use our app. Thanks for reply.

Hi I've installed Access 2010 64-bit (version 14.0.6112.5000). But when I now try to open a form, report or module that that were created in Access 2010 x86, I get the error: The database cannot be opened because the VBA project contained in it cannot be read. The database can be opened only...

Not really :). It's a tool from a different company and I do not have authority to distribute it.

How to add add-ins in Access 2010: Open registry Go to: HKEY_LOCAL_MACHINE\SOFTWARE\Microsoft\Office\14.0\Access\Menu Add-Ins Add the entry as a new Key that should appear in the menu Add 2 string values to the key: 1. Library: Value = Path to accdb or accde file where item is stored 2...

Add the form in the report's header or footer. If that is not suitable for you, add a new section "Sorting and Grouping", and add a new group based on the expression "=1" and give it a Header. Place your form in that Header.

Hi My reports in Access 2010 have a Min, Max and Close button when the window is not maximised. But when I maximise the report, the Min, Restore and Close buttons are not showing. My forms are working fine as in: http://dl.dropbox.com/u/18634911/Form.PNG But the report shows like this (only when...

Try this: currentdb.Properties("UseMDIMode") 1 =3D overlapping windows 0 =3D tabbed documents

Thanks, but I just opened the form with code. Can't close it again. Solution is to not open it using a form reference variable.

Hi Funny thing in Access 2010. I've got a form open: mystring = Forms(5).Caption 'This works, but mystring = Forms("MyFormName").Caption 'This tells me it can't find my form, and mystring = Forms!MyFormName.Caption 'also doesn't work And yes, Form(5)'s name is MyFormName. Why so?

Hi I read a number of posts on this forum and although other users have experienced the same issue, there were no clear answer yet. Perhaps with some new knowledge someone can assist. I'm trying to export a report to Excel. I'm using Access 2010, but the client only have Excel 2003. I run...

Can also use a dynamic filter that you do not have to change every year: Between DateSerial(Year(Date()), 1, 1) AND DateSerial(Year(Date()), 12, 31)