I am new to c# and just begining to develop a simple application toregister and track employees data. I've done most of what i wanted to acheive, however now i am stuck with developing a OrgChart that would dynamically show reporting of the employees. I have visited many forumes but i couldnt get what i was looking for. I dont know where to start and i hope someone in this forum could point me into right direction.
I have a SQL...
Adict
Last Activity: Jan 28 '21, 07:28 AM
Joined: Nov 9 '17
Location: Papua New Guinea
-
Org Charts on WFP winforms
-
How can i get a unique id to identify this attachment belong to this email? Apology, I ma having my head cracked by this. Really appreciate all your feedback. -
Thanks Zmdb, I did try that by inserting a code on the outlook to run a insert function when a new mail arrived into the Inbox. However it didn't run as intended. Here the code i wrote in outlook that I ended up getting error with...Code:Dim HRSWorkflow As MailItem Set HRSWorkflow = Application.Session.GetRecipientFromID(EntryIDCollection) Dim WkfSubject As String, WkfSender As String, wrfSenderEmail As String, wkfrequestdate As Date,
Leave a comment:
-
Thank you, i wish to run the code from my access database.
1. I have link the particular outlook mail box into my database but i only get text which since into my table called email.
2. What i intend to achieve is to extract outlook attachment into each records with a click event from Access Database.
3.Extract the specific email into a shared network folder and have the link inserted into my table.
...Leave a comment:
-
So the code above runs well but its looking at all the emails in the outlook folder and extracting emails, what i need is something like every email received gets registered into my internal table called Inbox with the rest of the text and attachment from that single email. Search much but didn't come across any . appreciate if i can be pointed to right directionLeave a comment:
-
Extract Email Attachment into MS database
I am working on simple task monitoring tool build in MS Access 2016. I have link the outlook inbox into my access db. but I am only getting text, I am looking hit how I could get attachment from the emails into the db as well.
Is it possible to do this through vba? I have wrote this code but its not working as intended. Any help will be greatly appreciated.
...Code:Private Sub GetAttachments() Dim ns As Namespace -
Twinnyfo - thank you very much. your codes just worked perfect on what i was trying to do. Just love your work
RegardsLeave a comment:
-
Auto resize to fit screen
I'VE done followed some thread on auto resizing a access form to fit current screen in vba for access forms but have no luck. I want the form to automatically resize to fit current screen. I dint know where to where to start, appreciate if any help. -
Thanks Neopa - i realized that at the SQL back-end tables i had the table as read only so i changed that and i was able to insert into the table. I simply inserted a new column in sql tables with an int identity(1,1) datatype and it all worked.Leave a comment:
-
Thank you Rabbit
I've successfully managed to do remove the inner join and the rows has been picked up when i ran the column, however, I am receiving another error, file conversion error. I will have a workaround with the datatype i guess. Thank you for the assistance.Leave a comment:
-
Below is my query
...Code:INSERT INTO dbo_TblMaster ( HRAPSNo, AlphaCode, FirstName, LastName, Branch, Dept, Loc, CostCtr, DateStarted, EndDate, Status, PayRate, AnnualSalary, BirthDate, Sex, MaritalStatus, Dep, PositionNumber, PositionTitle, Netuser, DateCreated, DateModified, [Counter] ) SELECT NewData.HRAPSNo, NewData.AlphaCode, NewData.FirstName, NewData.LastName, NewData.Branch, NewData.Dept, NewData.Loc,
Last edited by twinnyfo; Jun 7 '18, 04:53 PM. Reason: added code tags and formatted to fit forum betterLeave a comment:
-
Uploading Bulk Data into an existing Table
I have problem with my append query
I have a query Name NewData with exist in a temporary and i have created an Append query name Appenddata. When i run this query i would like the data from temporary table to be inserted into dbo_Master table which reside in MS SQL server. However when i run the appenddata query in is appending zero data into the master table. The master table has several relationships with other tables - need some... -
Thanks NeoPa _ i am looking at some threads to assist me with this but still not getting it right. I am now thinking of recreating the tables from within SQL as the current tables where migrated from .mdb file to sql server.Leave a comment:
-
Unable to insert data into my backend SQL Database from MS Access FE
I have recently, migrated all my table from ms access .mdb into SQL Server 2012. I have relinked all the tables successfully and can view the records. However, i am unable to write back into SQL Database from all my access forms. I have tried looking all treads here but none of them is helping. Appreciate any input and feedback. All my forms are bound to dbo_tables. -
Thanks twinnyfo and Neopa. I have used recordset and achieved the results. The reason why i want a redundant data is to ensure that every data changes users make on the main master file. This is to achieve audit trails for master data.
Thanks muchLeave a comment:
-
Inserting date into a date unbound table with date datatype
I am trying to log my users action into a back-end table if a employee master data is change. Below is my code but i am getting an error with inserting a date.
...Code:Dim strSQL As String strSQL = "INSERT INTO TblMasterBackEnd " & _ "( HRAPSNO, AlphaCode, FirstName, LastName, " & _ "Branch, Dept, Loc, CostCtr, Netuser, " & _ "DateModified, DateStarted, -
Unlocking Password Protected Word Document
I've been trying to unlock a MS word document that was password protected and editing is disabled. The document owner has left and no one knows the password. All I want is a simple vba code to unlock it and start editing it. I run few codes but found no success. - Appreciate your assistance
No activity results to display
Leave a comment: