Recent content by vince1818

Hello, I would like add a logo and table in an HTML EmailBody template, I am not sure how to do it right, I am hoping to get some tips from anyone. Let me know, I can post the code I created. Thanks, Vincent

Hello, I am hoping I could get some advice from experts here. Im trying to create a Job board that pulls some data in a linked database. I need to add some unbound fields because I am unable to add the fields in the linked database as I dont have access to add new fields. Here are the fields...

Hello, Is there a way I can use the DateAdd function and calculate only the working business days, excluding Sat and Sun? Thanks in advance! Vince

Hello - I created an access database using ms Access 2013 integrated to ODBC connection. ODBC works perfectly using 2013 version however when opening the file to 2010 and 2016 version of Access, im having an error. The error is "ODBC connection [Database] failed". Hope to hear any help for...

Hi Paul, Quick question on the parameters. Previously, I was able to create a parameter to run and append a query using a date range. Now, Im trying to add an additional parameter on a different field (Job No.) criteria [Forms]![Parameter Form]![JobNoQuery]. However, when I run the query, the...

Hi Paul, Im not sure where can I set Me.TextboxName = Date() do I need to put it in the append query button properties?

I attached the screenshot of my Parameter form. Im trying to set the last modified date whenever an append query is completed. Maybe there's other way to do it :) thanks!

Thanks Paul. I was able to follow use the same criteria you provided. One last question for now, Im trying to put a "last modified date" in the form, but i dont know how, any suggestions? Thanks again

Thanks Paul! That really helps. Follow up question, after I run the query, can I append it to an existing table using the form I used to enter the parameters? And also, on a side question, what is the best way to delete duplicate records in an existing table? Thank you and hoping to hear...

Hi All - Happy New Year! I just wanted to check if there's anyway I can create a Macro or any suggestions on how to update a Criteria in the query window without going through the design view. Maybe I can create a form where our staff can update the criteria in a sort of a form, button using...

Hi Paul, quick question, unfortunately, I dont have the ability to add fields in the backend because im importing the DB from the application we are using. Is there any other way to create a check box(es) in my subform? Thanks

Is it possible to add new fields in a linked table?

Hi Paul, Thanks for your reply. Im not sure how I can add the fields since I am using a query from the linked DB. I cant add new fields unless I create a new table. Any thoughts? Thanks!

Hi MS access experts, I have a continuous subform linked in a data query, I added some check box to select for each record. However, everytime I check a checkbox, it also check the same checkbox on the next record. My check box consists of Shipping options - FEDEX, COURIER and HAND DELIVERY...

Hi, Im trying to update the tables from the ODBC so it will have realtime data. Sorry for the confusion. Hope to hear back from you. Thanks!