Recent content by bbxrider

and also thanks for showing how to change module name, so used to right click for properties just didn't notice the properties panel for name change below the main db panel, hoping to be more aware in the future

I just got an answer from a sister post in accessforums.net where I originally posted but that thread had seemed to have gone cold the answer is you need to include "()" in the function name supplied to the macro, so in this case the function name in the autoexec macro is...

ok thanks, still not seeing the module name change ability, but... that is not the issue for me right now, I have module2 which contains a public function that is specified in the autoexec macro, called Public Function delete_import_table() As String which is not the same name as module2, and it...

thanks for the ongoing replies in this case its "module2", but don't understand your reply, in my access 2016, there is no option to name modules, you just insert new, it asks standard or class module, it assigns names, module1, module2, etc and you don't have any option to rename it that I...

thanks for the reply, I just made the function explicitly declared public but still same result. the db has 2 standard modules, the one I chose has some public variables I need to access in the function. Public Function delete_import_table() As String Set db = CurrentDb() 'this is the...

not sure if to post this in macro or modules but trying here first created a 'autoexec' macro, it does run at startup or I can manually run I thought it could invoke a vba function, that is what I need, to exec some code, but the macro can't seem to find the function see pics of autoexec, and...

super thanks to MajP for your thoughtful, super comprehensive and super fast reply. I wish I could code up as fast you. And good advice about breaking up into modular design. with a couple of tweaks, spelling etc. its working. I will have to add some error trapping probably just debug.print...

thanks for the reply yes good sense of smell. data is originally coming into source tables from spreadsheets when you suggest field1 field2 are they the actual column names? if so thats what I want to avoid. wanting to use table properties to put actual column names into variables and then...

this is for an access 2016 db I have say 50 tables that have a total of say 100 unique columns so I can create a blank table with all 100 columns so table 1 might have cols 1, 10, 99, table 2 might have cols 2, 15, 27, etc I would prefer to programmically iterate through the 50 tables in the db...

galaxiom, thanks, duh I'm using ado/recordset and wasn't using the current rec value but the column name from the access db. this works do until recSet.eof for each x in recSet.fields if (x.name = "orientationDate") then response.write("days diff tween post and odate = " &...

I'm trying to compare 2 dates to see if one is greater than another, in traditional asp program, I'm using date diff, DateDiff("d",postDate,orientationdate) postDate is a string converted to a date, postDate = "04/27/2010" postDate = CDate(postDate) orientationDate is date/time field from an...

ok, working now, first I had to figure out why I couldn't do any updates, they were failing with 80070005 and the 4.5 installer had a popup error message, 'access denied'. turns out the permissions for the registry hk_classes_root was full control for everybody! hows that for security. when I...

will check again, I was current before the repair, and had to reinstall ie8 and thought between the 2 I was still up to date. After a repair some or all of the updates are lost?

thanks for the suggestion, however, I tried registering the whole list Microsoft Jet 4.0 OLE DB Provider Provider=Microsoft.Jet.OLEDB.4.0 C:\WINNT\System32\Msjetoledb40.dll C:\WINNT\System32\Msjet40.dll C:\WINNT\System32\Mswstr10.dll C:\WINNT\System32\Msjter40.dll C:\WINNT\System32\Msjint40.dll...

I just repaired my xp pro (from install disk) and for a previously working asp.net app I now get The 'microsoft.jet.oledb.4.0' provider is not registered on the local machine. so I tried the fix, regsvr32 msjet40.dll, in the system32 directory, got the successful register message but still...