Hello Experts,
I've a main form with sub form in it. Main form is a single form while sub form is a continues form as Access default setting applies. the sub form contains related transaction of Main form and sub form has record selector enabled.
Question:
Is there a way to open a particular...
No John, it's a modification of data and addition as well, but delete system is blocked and a new system just like delete I introduced that is hiding of data with help of query criteria, user thinks that data has been deleted but its not actually. it just hide from data form on which he or she...
Actually the database has to remain open all day about 12 to 14 hours and there is no need to close it but data entries are made about 200 to 300 per day, that's why, I need to insert this option to stabilize my project and to secure less space as well. :)
Man that's really working............
SendKeys "%(TDC)", False
I was talking about 2 links that I found inside threads and they are not working.......... your link are working fine................
Thanks a lot man............... you helped me again.............
John I found 2 links on that post which you linked but both are unavailable. 1 is show page unavailable and 2nd is show 404 error msg of unavailability, plz send me another link if you know.
I got u John but my question is different from this thread. I want a button for COmpact & Repair in form view with its code or link with any macro just like REFRESH button in navigation. My Database is not on sharing, it is on single use.
Hi Experts,
My question is that is there any way to use Compact & Repair tool using Button in form, when ever I press that button, it should call main Compact & Repair tool directly because if I disable the FULL Toolbar option in my project, it also blocks the tool menu and Compact & Repair...
David you r awesome, great man.......... you made it easy for me........ I'll work on forms to use that append query......... I didn't know about types of query before...........
Thanks a lot buddy......
But this will be very difficult for me to rebuild.... ! is it possible for you to amend on my project as you want and upload it so will get your idea as it is.......... it could help me.......!
Hi David,
Is it not possible to store history on same table.......? or if I create history table, what could be the procedure to send data to history table from my current table.......?
What should I do to remove duplicate entries / fields.............?
Thanks in advance...........
Hi Experts,
I am not certified Access developer but have passion to learn it... I made this project any how (unprofessional style), now I hanged around in one situation, this project is just like any calculator that calculates Time & salary of each employee with complex units system and working...
Sorry Dear....... I was on vacation for few days, that's why I didn't reply.
with well I want to ask that why you need to add all records every time.........?
well this could be simple if you create relationship among 2 tables. If 1st table contains wagens details and 2nd contains each wagen's...
Hi Nigel;
Well don't think about everybody, just think about your work. If you don't have Adobe Photoshop and don't want to spend money, then you can download trial version then you would be able to do this.
If access supports transparency and not supports PNG then it is not the matter of...
Hi Experts,
DESCRIPTION:
I am working on a database form with some bound text boxes like HOURS (57), PUNITS (170), SUNITS (49), TUNITS (14), MUNITS, FUNITS, PERUNIT, SALARY, INCOME, SUMFUNITS;
Where MUNITS = (HOURS - 48) * 3 & i.e...
Hi Simon,
Well there could be one thing as I think....... you should check your front end tables. Link Manager creates link between front-end and back-end, its mean your front-end table linked with back-end. You can confirm it when you look at Table icon of front-end, there will be an arrow...
Yes, you are right.... but PNG format are use where transparency & shadow are required, and GIF is less quality.... but if you use adobe photoshop to make GIF, it will give you option for quality like 50%, 80% even 100%. Just for try... you can use GIF. The question raises if Access supports...