Hi
I happened to bump into the aforementioned article shortly after I posted my questions. Took me a while to try the solution. Yes, it has helped to resolve the issue I have. Thanks!
Regards,
Clarence
clarencelai
Last Activity: Sep 30 '16, 11:21 PM
Joined: Oct 16 '07
Location:
-
Transfer MS Word Form data to MS Access Tables
I'm trying to import data from the MS Word Form to multiple access tables in a one to many relationship.
The MS Word Form contained the applicant’s personal details (Table CustDetails) and the training sessions applied (Table Sessions).
With the help of the below article posted on Bytes, I managed to do it successfully.
https://bytes.com/topic/access/answers/773541-word-form-access-tables-data-transfer... -
Thanks for sharing the sample database and data. It's really cool!
This will definitely help to resolve the issue I have no hand now.
Thanks much!
ClarenceLeave a comment:
-
Thanks again for responding to my questions. I hope you are getting better.
I am afraid that my knowledge about VBA is limited to fully appreciate the work you have done.
After heeding your advice to insert the 2 class modules (clsforcast and clsNameValueInt Date) and the procedure (executeSQL), the program run a little further and hit another error where it says FileExists 'Sub or Function not defined'.
Do...Leave a comment:
-
Thanks for sharing your experience with me. Yes, I wished I have better control with the data source.
Thanks for the codes. I am not very familiar with VBA so I tried to duplicate yours and see how I can amend it later to suit my purpose.
1. I created a spreadsheet with the same fields provided in your Excelimport.jpg .
2. Created a button in MS Access with an event procedure that runs your code.
...Leave a comment:
-
Thanks for your advice, NeoPa.Leave a comment:
-
Thank you for your advice.
The data was collected via Google Form / Sheets in a grid question format and imported into MS Access. I was hoping I can utilize the data collected.Leave a comment:
-
Group by data found in multiple fields
Hello..
I have a table of availability submitted by part-timers for various dates. The availability options are "Available" , "Morning" and "Not Available".
I would like to create a query to count the number of Available, Morning and Not Available.
I have attached sample of the table and the desired query result for your advice.
Thanks
Clarence
[IMGNOTH... -
Thanks a lot, Phil.
It works!
ClarenceLeave a comment:
-
Code:SELECT Partition(Minute([Date_Time]),0,1440,15) AS Range, Sum([Transaction by DateTime and Ope].Sold) AS TotalSold FROM [Transaction by DateTime and Ope] GROUP BY Partition(Minute([Date_Time]),0,1440,15);
...Code:SELECT Partition([Date_Time],TimeSerial(0,0,0),TimeSerial(23,59,0),TimeSerial(0,15,0)) AS Range, Sum([Transaction by DateTime and Ope].Sold) AS TotalSold FROM [Transaction by DateTime and Ope] GROUP
Leave a comment:
-
Grouping time in intervals using Partition Function
I have a field (date_time) containing various timings (short time format) and another field (sold) containing the number of items customers has purchased.
I would like to sum the number of items sold during the day in 15 mins interval. The desired outcome will be 4:00PM:4:15PM, 10 sold; 4:16PM:4:30PM, 15 sold, and so on.
I tried to achieve it by using PARTITION in query to no avail.
Example 1:
... -
Hi..
Thanks for your help!
Regards,
Clarence...Leave a comment:
-
Constructing Strings in Visual Basic
Hi all,
I need to run a SQL statement in Microsoft VB.
The following statement returns an error "Compile Error: Expected: end of statement". yyyy was highlighted when the error was encountered.
I believe that there are something wrong with my syntax. It could be the quotes (") that I have used to enclose the date format.
I would appreciate if anyone could help to correct.... -
Hi Denburt,
Thanks for your reply.
I would like the output to be formatted text. For example, if the text stored in the table is "</b>TEST</b>", the output text should be a bold TEST.
Preferably, I could output this to a MS Access Report.
Regards,
Clarence...Leave a comment:
-
Displaying fields containing HTML codes
Hi,
I have a field that store HTML codes.
How do I output them to MS Access Report / MS Word in HTML format or text format?
Kindly advise.
Regards,
Clarence -
Sorry.. the Chinese characters should not display at all.. it will appear something like.. "⽙"...Leave a comment:
-
Displaying Chinese Characters
Hi..
I am extracting information from Oracle database table.
I could not display the Chinese characters stored in one of the field. It was displayed as "Oriental Folk Music 亘古通今弦管情"
I would appreciate if anyone could help me.
Regards,
Clarence -
Hi Jimmy,
Your sample database works perfectly for me!!!
Thank you so much!
Cheers
ClarenceLeave a comment:
-
Hi Jim,
I do not know how to attach a file here.
My table name is Email and the field names are EmailAdd (email addresses) and CAT (category).
Please let me know if this is what you have requested.
Regards,
Clarence...Leave a comment:
-
Hi Jim,
Thanks for your reply.
In fact, I would not need to select email addresses once I have chosen the category.
The form should send emails based on the category I have selected.
The flow should be, select the category, type in the notification text and click on the SEND button. The form should send to all email addresses belonged to the CAT I have selected.
Regards,...Leave a comment:
No activity results to display
Leave a comment: