Search results

Thanks again for your answer. However, its not what im looking for. Let me rephrase. I would like that the DataBase will have a certin background. The forms within, will have its own background. If for example i opened frm1 it will have a gray background, behind the form there will be the DB...

Thanks mate. ;)

I would like to change the DataBase backgournd from the ugly gray ( :D ) , into a custom made image. How it can be done? I would be happy to get an answer .

TblCurrentUser: User Name Password Authorization (Manager, Employee) I have created a main Toolbar which navigates through the forms in the DB. I would like that after the user has logged in (his information is saved in TblCurrentUser), some of the main toolbar menu controls will be invisible...

In my employee working trace form there is month combo box (mm/yyyy) which filters working dates. When inserting a new working date, I would like that instead of the users writing full dates (d/mm/yyyy), they will only choose the day in the month. The month will be filled out automatically. For...

Hello, In my form there are three options to view reports : Screen, Print, File . I would like that whenever the user clicks on the third option, a word document will open and show the selected report report in word (In the report preview, There is an option to view the report in word) . I...

Great Idea. How didn't i think about it. :) Thanks Mate.

In my DB there are Three Tables and three forms based on these tables: 1) Tbpatient (FrmPatient - Single Form) PatientId FirstName LaseName 2)TblPatientRelative (FrmPatientRelative - Continuous Form) RelativeId PatientId (One To Many relationship with TblPatient) RelativeName 2)...

Yey, i have found the code i needed its in the following address : http://www.mvps.org/access/api/api0004.htm (Shell and wait). Well thank you anyway guys.

u must have misunderstood me. I don't want the program to pause for number of seconds i choose (i can already do that with the sleep function). I want the program to freeze as long as other application is running. there might be a case that it will take for the program to finish it job 5...

Thank you For your help. I tried putting the command line : "Doevetns" after running rar.exe . However, its not working. The application exits fast, without compressing the file. * With the access sleep module, the application is running fine. However, i don't want to use this module (Reason...

Hello, In my current db, im using rar.exe application (with shell command). After downloading Api script for making access sleep for a period of time the Rar application is working just fine (compressing). However, there might be a case when period of time is not sufficient. In that case, the...

Thank you for your lovely post. I must admit you are 100% right. I sat down, talked to the manager first and he told me as followed (translated :D) : " At start everything looks hard and impossible to do cause its new. They (employees) will get used to it. " So i will make calender view...

Thank you very much for your help. However, my problem is not making the tables. I don't konw how to make the form as the employees wanted it to look (example above) . If you could help me make the form i'll be greatful.

Hello all. I am having trouble making db of Employee working trace. The clerks in the company wants that the form of inserting one work trace to look like this. Month / Year (Entered by the clerk) Employee Id (Entered by the clerk) Day In Month (Locked value) Day in week (locked value)...

Thank you very much. This is all i needed :D .

Okie, i should i have told the whole story. I have this table : TblWorkTrace : WorkTraceId EmployeeId DateOfWork StartHour EndHour In QrydailyWork : DailyWork = EndHour - StartHour . If The format of EndHour and StartHour will be "long" and not "date" how can i subtract between them...

LOOOOL :D :D . True, i wanted the total amount of work per month

I have made a query that displays total amount of hours employee worked (short time format). The huge problem is that I can't display more then 24 hours (again, because of the short time format). Any suggestions how to make a query that will show the total hours worked without the 24 hours...

Hello, i have trouble making a report. On each year or period of time the CEO get a report about Patients payment (each payment type is on its own). In the report, there are as followed: Headline (payment Type) Patient ID Payment for Month and Year (what month and year) Sum Paid Comments...