Search results

Yep, I placed that on OnResize and it works now :)

I just noticed that if I remove DoCmd.Maximize from my Form_Load, then scrollbar is not shown even when I open the application, so probably this gives my form the scrollbar. So I should probably use "DoCmd.Maximize" again somewhere right?

Yes. I can only see that many records as my screen height lets me, i can't scroll down since I don't have scroller anymore (unless if I close app and start it up again).

I have a list of my records and I need scrollbar to see them all. Here are 2 images: 1) When I open application I see scrollbar and all is fine: http://img339.imageshack.us/img339/9282/34285712.jpg 2) When I minimize app and then open it up again, there's no scrollbar anymore...

I have full screen app and I use button to minimize the application with this code: DoCmd.RunCommand acCmdAppMinimize All works great, until I maximize the app, then the scroolbar on right side disappears. Does anyone know what could be causing this problem?

I made my access application for full screen (I use "Fit to screen" settings). It's all fine but some of users use "Auto-hide the taskbar" and the application is full screen so they have to press Win button to get taskbar instead of just moving mouse down like with other applications. Is there...

Yep, I do use attachments. Well I decided to use Access Runtime on my users and they can run application. Thanks for the help.

If I use Save as > Access 2007 database then I get save windows to save as access 2007, but if I click Save as > Access 2002 - 2003 then nothing happens, no Save as window pops out.

I found a post from Avelino who wrote that this setting is stored in register, so I now added registry change in installation and this works :)

Whoever uses my application gets security warning and can't run macros. The solution is to go to "Trust center" and then select "Enable all macros" but is there any way to do this in VBA script, so that users doesn't have to open access first and search for those settings and after that they can...

Probably not since at least he could offer me to save entire project as different name but still under 2007 but can't get to that.

I am using access 2007 but some of my users still use access 2003. I made application in access 2007 and it is saved as .accdb. Now I am trying to save it as mdb but can't find a way to do it. If I go to Save as it's gray and can't click it - I can click it if I for example click only one form...

I can't use network application, because some users use it offline on their drive only. So there's no way to intercept the SHIFT, what about locking forms/tables/reports (back end only - design) with password just like VBA code?

So is there any way around that or all access applications can be accessed "back-end" like this? To check if CTRL is pressed, just like I have in code when application is already running.

This will probably do it. I will try, but how can i call some code from macro? For test I now just added MsgBox and tested it and still it's to late. If I hold SHIFT button when application starts this autoexec doesn't run.

Where can i enter some code which is used when application starts? I tried On form load and form open but that's to late...

I just noticed that even if I have linked to specific locations and if that file doesn't exist I get "Can not find file ..." and access stays opened and anyone can mess around in forms. Is there any way to create in code to check on start if file exists if not applications closes?

I tried that but even attached file FR Leads.zip doesn't work like it should. I tried the code anyway on my application but I get this "error": The record source "Contacts" specified ion this form or report does not exist. Even though path is OK... I thought that there's any easier way with...

Each user has his own database on his drive, when I'll make network database, then it will be OK to use without VBA code, but for now it's better to use VBA link to the same folder as project file is in as that I force user to place it in the folder which I want.

If I use External data > Access and then "Link to data source by creating a linked table" I have to write strict full path where database is and this very limits my users from using application - they have to place it in the correct folder. Is there any way that this wouldn't be strict, but...