Search results

That's great, but I'm afraid 32-bit will not work for me all machines are on 64 :/.

Thank a lot that. That's nice peace of code :). Unfortunately it acts exactly as with what i have achieved, if you press on application in toolbar it will maximize. I guess that's what The_Dog_Man talk about, windows and other applications interacts.

Thanks for the explaining it. I have originally hided the main app screen with form which maximized as a background for my DB and then loads on top login screen or other forms. All forms set as Pop Up and modal, so user cant do anything else just interact with forms. The reasons why i would...

Yep there is just the line not work :/ Private Declare Function apiShowWindow Lib "user32" _ Alias "ShowWindow" (ByVal hWnd As Long, _ ByVal nCmdShow As Long) As Long Full code... Global Const SW_HIDE = 0 Global Const SW_SHOWNORMAL = 1 Global Const SW_SHOWMINIMIZED = 2 Global Const...

Hi, Just for curiosity. Is it possible to keep Main Access app window minimized and run just forms?. Have found code with "Function GetSystemMenu Lib “user32″", but option don't work, not fully understand why though. Also found that you can choose "Tabbed Documents", deselect "Display...

Yes its is partial match. The matching part is from tmpFolder all name 123 in the mainFolder after "_" all rest string 123. tmpFolder\123 to mainFolder\ABC_123

Hello, I'm after little help again here :/ What I'm trying to do is to loop folder from temp location and check against main location folders, if it match copy over to main location. I managed to get working code, if there is no folder in main location or it's an exact match. What i would...

Hi, Thanks for responds. The bought suggestions made me thinking. What i will do is, ill set folder for normal users permissions just to write and files will be saved in temp folder. For users who needs to read the files will be moved from temp in to other folders as soon they will login...

Hello, Right i have set the form with save *.pdf in folder by IDs. All works as it expected. What I'm thinking right now and cant find any related data. Is it possible to save PDFs with same code in folder where folder has just to "Write" permission? Some users will be not allow to open the...

Hi. I have the database with front end, where some to time needs to be updated and passed to users. Instead asking them manually to copy i found macro which help to automate this process. The issue i having is that macro creates a loop, it tries to open multiple front ends unless the "Security...

Well for today was quicker to do Unpivot Columns in PowerQuery and sort that why :). In the future will try in Access.

Power Query in excel did the trick :) really good tool for sorting data.

Hello, Looking for solution or any suggestions, please. Having trouble to sort data in the why i need to. In attached file "Unsorted" tab data need to be added in to MS Access table. Second tab "Sorted" the why i need to be sorted. The actual file is with over 600 rows, so manual to do is...

Thanks all for help. Ill stay for now with black default color to much to understand at the moment :) Maybe in the future will try to have a look. Regards

OK i have tried on the my original version it is still the same in the second, 3rd tab drop down has black color. Can be because the back end tables are just linked to front end or still to do with PKs? Example version worked in first go if i change the key. Thanks a lot for tips :) Just to...

ok i think i cleaned as much i could and menu can be seen too.

Hi, Apologies for so late respond. I have attached a peace of the actual database I'm working right now. Maybe it will make more clearer. I can tell that I'm not an expert of MS Access (self learner) so please don't judge much :), I'm trying my best. Thanks

I could understand if they all be with black fore color, but in this case some black font some of it grey - what i exactly want :banghead: All controls has Enable = Yes and Locked = No. All setting are same for every control.

The textboxs are not disabled they can be used in any direction i mean the record can be selected from the list box or it can be used to edit add new record. i have attached the screen shots, txtbox and list box setings they are exactly the same.

That a dim color i do want and its keep black default one :(