Search results

The TIN format varies but typically either xx-xxxxxx or xxx-xx-xxxx however the source system does not validate the data entered into this field therefore the query would need to look at the field and replace numbers with an X and leave dashes where the exist to retain the format. Hope this helps!

Hello: Thanks for all the feedback, sorry for the delay this deadline looming with a variety of regulatory reporting changes related to COVID. The TIN (taxpayer identification number aka social security number or employer identification number) is in the table because it's used for other...

Thanks everyone for the great suggestions. The masking is in accordance to the US IRS rules. At this time I am just opening the table with the print data and using simple find and replace, replacing all numbers with an X while retaining the format of the TaxIDs, which varies dependent on the...

Hello: Looking for a function to use in a query to mask the tax ID numbers and print on tax forms. Any suggestions? Appreciate the help! Tracy

Is anyone familiar with using Windows active directory for the SQL connections, this is what we are interested in utilizing. Tracy

DBguy: This is exactly what I need to address this issue, I was aware of the other security issue with the ODBC settings/registry entries on computers as well but yesterday when I looked it appears Microsoft may of fixed this registry problem. I am going to review this information now. Thanks...

Hello: We use Access as a report writer for one of our enterprise systems. The enterprise software vendor delivers their reporter software in Access in MDB format with ODBC linked tables. We began to use the save passwords option when linking the SQL tables via ODBC to bypass the need for the...

Hello

Thanks MickJav now that I am fulltime IT, I need to grow my access skills into more complex solutions this will help a lot!

Thanks I found them not sure where I was in the forum yesterday when I received the error but able to locate now. Happy Friday

Hello: I was on the download section of the forum looking for examples to study and learn but it appears this option is not working. Can anyone suggest a resource to find some good advanced access database examples to review for learning? Thanks for the help. Tracy

Good luck sounds like you may have a resolution to this issue.

The master child link is a field that's always has a value like year or company code and is consistent. Check the default view on the sub reports, open the sub report in design view and verify the default view, I noticed some of mine are set to report preview and others to print preview...

I built complex reports which contain many sub reports to bypass the issue I linked them on a core data value that's common between both they work in print and report views.

I was having issue we disabled the leasing as recommended than applied recent Windows updates it was resolved :)

Hi Pat You hit the nail on the head, data definitely not coming through as TEXT. I have other technical issues going on that may be impacting the VBA code - data types. I am testing ODBC driver updates for SQL 2016 due to Access issues with linking to SQL2016 data types. Probably a bad time...

Here is the code almost working, now receiving runtime error 94 invalid use of Null. appears to be on the string dlookup line. I see other examples on web using Nz or IsNull … these two tables will only have one record, neither have a null in the version number field in table at this time...

Thanks Pat Going to give this a try. I am having a learning curve therefore studying at night to sharpen my skills. I appreciate the help and patience. I work with the syntax which has been part of my issue as well. Tracy

Hello The macro I wrote is not working so I am back to using the VBA code. Here is the full code I have embedded on the form property OnLoad. It appears the code is not recognizing the two tables and field names I have defined in the string. Also I already have code for this event so do I...

Thanks to everyone for the assistance I was able to get this working as needed. Using the two tables I created I built the comparison check in a macro than added the macro to form on onload event property. It is working as properly. Tracy:)