Search results

  1. B

    start up autoexec macro not invoking function

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

    dynamic columns for adding recs to access table

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

    access date format for use in datediff

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

    oledb 4.0 provider not registered

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

    convert 2003 to 2007 question

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

    datetime - data mismatch using datetime.now

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

    Question date/time not compatible with now()??

    using a stored query to insert and getting data type mismatch when using vb.net now() to populate an access date/time field? the error message, 5 - Data type mismatch in criteria expression. the query, INSERT INTO behaveapps ( applicationDate, firstName, lastName ) SELECT ? AS Expr1, ? AS...
  8. B

    saving sql based query in access

    i have an sql query that i build and run in a vb6 program, i want to be able to save it as make table query in the access db, so that users can run it on demand directly from access, or it can be run from the program that created it etc. been googling for an hour and not really found anything...
  9. B

    ado listing and deleting tables is very slow

    i check if a table is there before attempting a delete. this database has about 15 tables in addition to the access internal tables. granted, i'm running this in the debugger, but when it hits the 'set rstables...' command, it takes 4-5 minutes before that finishes. is that normal? and then same...
  10. B

    getting results across page instead of down

    i'm trying to get the results for a logical grouping of recs to list across the page instead of the ususal down. please see attachment1. for each customer there could be up to 12 categories of sales, what i'm trying so far unsuccessfully is to get the categories to list horizontally across the...
  11. B

    eliminate ms default validation message

    i have validation for form fields with a msg i created in the table, however after my msg is displayed when validation fails there is a ms default validation msg, that is overkill and i would much prefer to limit the validation msg to mine only. see attached for pic of the ms default msg. is...
Back
Top Bottom