Search results

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...

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)...

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...

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)...

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...

As u see in the queries below, when running the 2nd query the result will be: PatientId, LastName, FirstName, TotalSumPayed and Debt: (TblHostelInfo].EconomyPayment-QryEconomyPaymentDebt.TotalSumPayed). I would like to "upgrade" the query. If the patient didn't pay any kind of fee to...

In my current DB there are the following Tables and Queries TblPatient : PatientId LastName FirstName HostelId DateOfEnterance (the date the patient entered) TblEconomyPayment : EconomyPaymentId PatientId ReferenceId PamentDate PaymentMethod SumPayed PaymentForMonth (for what month within...

Automatic notification of expiry date Hey guys, i really didn't know what to put in the topic but i need help :-) . Anyway, this is the full story : In my DB there is Expiration date of a cretin product. Whenever the date has expired I would like that a MsgBox will appear: "Product has...

I am trying to create a query that calculates the sum of specific trip expanses. I have two talbes: 1) TripInfo : TripId TripName CalculatedExpences (The sum of all expenses detailed on the TripExpence Table) . 2) TripExpences : TripId (Linked to TripInfo Table) TripExpenceId...

Well guys iam in a big problem an i hope some one can save me. When ever i delete a record trough a certin form (with an action button) i get this wired msg : "The Microsoft Jet database engine cannot find a record in the table with key matching field(s) . (Error 3101)" What is then problem...