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

Please, if anyone is there, plz could you help me out, I would really appreciate it, please :)

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

yes, txt box - called Body. text box name same, - wait,... now its working, i changed the "." in between [form].[form name] etc, to an "!" - like this .Body = [Forms]![frmReminders]![Body] working fine, thank you Next issue now, is there maybe a way to make the "body" text box display...

.Body = [Forms].[frmReminders].[Body]

Thank you. When I change the .Body line, it gives me the error: This object does not support this property or method...

here is a txt attachment with the code...

Function AddOutLookTask() Dim appOutLook As Outlook.Application Dim taskOutLook As Outlook.TaskItem Set appOutLook = CreateObject("Outlook.Application") Set taskOutLook = appOutLook.CreateItem(olTaskItem) With taskOutLook .Subject = "This is...

Function AddOutLookTask() Dim appOutLook As Outlook.Application Dim taskOutLook As Outlook.TaskItem Set appOutLook = CreateObject("Outlook.Application") Set taskOutLook = appOutLook.CreateItem(olTaskItem) With taskOutLook .Subject = "This is...

Function AddOutLookTask() Dim appOutLook As Outlook.Application Dim taskOutLook As Outlook.TaskItem Set appOutLook = CreateObject("Outlook.Application") Set taskOutLook = appOutLook.CreateItem(olTaskItem) With taskOutLook .Subject = "This is...

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 Adam thank u for the reply. I understand your reasoning for rather having a type field for client and lead rather than 2 tables. the reason I wanted to have a "conversion" option from lead to client - is to be able to view the "conversion rate" for clients. Eg, to see that I entered 10...

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 HiTech thank u so much for your help. however - how do I select an application type, and application status, if I am not to use lookup fields at table level? Thank you so much again

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

Thank you so much. I will do the category tables according to your suggestion. As far as I know, clients will only be in 1 category. how would I execute sending the bulk mails from Access? (If possible) and also, is it possible to setup reminders in access to call the clients? Thank you again...