Search results

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...

so for writeups similar to this...

there are 3 2003 access db's dataDb - only tables with data objectsDb - all the queries reports, etc, all data tables are from links to dataDb securityDb - .mdw which controls persmissions to objectsDb so i can point access 2007 to the securityDb and get objectsDb open so I can convert it to...

thanks, tried that, post sitting there for 2 days, no reply yet, so thought i'd try here. one question, is there any difference between the access2000 and 2003 for date time fields? i have an app in traditional asp, that updates a date/time - general date with the built in variable, now(), that...

in access 2003, i created a date/time field, appDate, and set it to general date, which shows exactly as the rendered date below then i try to update it with Using command As New System.Data.OleDb.OleDbCommand("bapps3insert", db) 'Set the commandtype...

still trying but no luck, i chkd the date field in access and set it to 'general date' which indicates it has both a date and time. that didn't work with now() directly or the vb.net new date time variable type, dim dateVar as datetime datevar = now() now() displays out as 9/22/2009 2:26:07...