Search results

Hi there I have tblEmployees with all employee details also, I am updating the template from microsoft for employee hours worked, however, the attendance I need to track of the employees is not per hours worked, I only need to summarize "days " worked, as they are paid per day How could I do...

Good Day I wonder if someone could plz assist me with general table design. I need to create a database which manages cash received for petrol as well as a running loan. Eg, "John" receives R1000.00 from the company which is distributed amoung the staff for petrol - this needs to be recorded -...

Good Day I wonder if someone could plz assist me with general table design. I need to create a database which manages cash received for petrol as well as a running loan. Eg, "John" receives R1000.00 from the company which is distributed amoung the staff for petrol - this needs to be recorded...

Hi there. I am struggling so hard with such a simple query - I need qryDueToSteven to calculate what we owe Steven. When you subtract "TotalReceivedFromSteven" ( it is a loan), from "TotalPaidToSteven" (refund for loans), it should calculate what we owe steven, however it is showing the same...

Hi there I have inserted an "add outlook reminder" button to my database, this is working perfectly. Now, i would like the "body" of the outlook task to get its data from a list box on my reminders form it is currently getting the "body" from a text box on the reminders form, which works...

Hi there I am using the following code to send reminders to outllook using acess: Function AddOutLookTask() Dim appOutLook As Outlook.Application Dim taskOutLook As Outlook.TaskItem Set appOutLook = CreateObject("Outlook.Application") Set taskOutLook...

Hi there I would like a quite bit of advice on creating tables for producing invoices. I currently have the following tables from which the invoice will be generated: tblClients - holds basic client contact info ect tblApplications - holds info for each application which is process for each...

Hi. Does anyone perhaps know how would I execute sending bulk mails to clients (per category) from Access? (If possible) and also, is it possible to setup reminders in access to call the clients? Thank you

Hi there I have tables: tblLeads, and tblClients Once the "lead" becomes I client, I would like it to be moved to the tblClients How could I do this? possible a button which can be clicked in the "frmLeads" which sends the record to the clients table and form? Please can someone point me...

Please can someone assist me with a table which will allow me to put my clients into categories which I can bulk email, ? If this is possible....(through outlook perhaps) and then also how to go about setting reminders in MsAccess which will come up to remind me to contact clients on certain...

Hi there I am designing a database for a Visa and Passport company which will manage the companies applications for visas and passports, etc I have a table for clients info, application info, documents required for the application, and docs received for the application Now I need to create a...

hi there I hope you can guide me in the right direction. I am looking to design a database that among other things, can tell me what documents are still missing and at what stage of the appication ( to complete the application process for visa's etc). I would like to make reminders for myself...

Hi There I hope someone can assist me. I am creating a database for a Security Company. I would like to create a form (which looks like a calendar), where I can select the name of the client in a combo box on the top of the form, and then a calendar displays for that specific client. I...