Search results

I understand this is basic VBA appreciate the help so here is what I have still receiving error: Two tables: In Access FE - xx_tbl_SkyViewFP_SysVersionLocal. LocalversionNbr SQL - xx_tbl_SkyViewFP_SysVersion. versionNumber Versionnumber field specification: text Version number data format...

Hello All: My VBA skills are very basic. I need a little more help! I created two tables: SQL and one in the FE xx_VersionLocal.localversionNbr this is the front end table and field name xx_SQLversion.versionnumber this is the sql table the version number is stored as text in this...

I like this idea going to give it a shot now. TY

Thanks everyone for your responses. I plan to use the vba code next week got pulled onto another item at the moment!

this looks perfect but as another person stated may assume one record in SQL table, I will have more than one record forward. How should I handle this in the sub routine?

the SQL version table will have other records in it so maybe I should use a query to pull the last record from the table than compare how would I handle this in the sub routine?

Funny somehow I knew this I was trying to use onload first but moved to the open event. what action do I use to exit app in this line? "'add action here"

my access systems are basic with no login required and no security in place. i use a password on the database to control who can open and use the database. the databases open to a main form. the main form displays a version number in this format "mm.dd.yyyy" in a label. I created SQL table to...

Hello I use a version number on the main form in my access systems to track versions. We have users who are dragging the shared access database onto the windows computer desktops instead of the shortcuts. To help ensure users are using the latest version I been asked to track versions in a table...

we've been running 64 bit environment with no issues for several years. this issue was related to her due installs with one 32 bit and the other 64. Thank you

Thought you all might want to know the resolution to this item. User had two different Office installs on her computer one running 32 bit the other 64 bit. Once Access 32 bit was removed issue was resolved. I totally should of caught this luckily the IT tech did. Mystery solved. Thanks...

Thanks good info :)

we prefer the 64 bit environment. when I drilled down on this error on this users computer I began to receive bogus errors on table links which I know are solid. We uninstalled and reinstalled Access issue not resolved. 10+ other computers in this environment no others receiving this error

Hi Erin I am seeing some of the same type odd behaviors here as well. Be sure who is the developer of the systems is on a lower version (build of Windows and Access). The user computers should be at the same level or higher. That's my focus at the moment to stabilize our environment. Trace

TY DocMan I believe you are right it's related to the initial install. I did check Access version including 64 bit option. I am removing the Nz function from the builds. All other users are fine so I feel this best approach at this time. TY for help and feedback

Great input. Ironically the user having issues is a new staff member with a new computer setup. Since her new setup she's had this issue when others have not. I find this fact to be very interesting. Definitely something in her setup. I need to check the computer components as they relate to...

TY Jiri Not quite sure how to do the object library on the users PC. Google it now but if you have info to help much appreciated :)

The shared access container is the code base for reporting options, the backend (split) primary datasource is SQL database. The access database is a reporting tool provided with a financial software package I have built out extensively.

The users all use the same shared access container so I am not sure what reference you are referring to can you give me more details? TY

Hello I have a shared Access 2016 database for reporting used by 10+ users. One user continues to receive and error with the Nz function specifically "undefined function NZ in expression." To correct the last time I removed the Nz function used other method. Trying to understand why this error...