Search results

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

ok thanks, i know its more of a programming question, but having no luck elsewhere so thought i'd try here

yah, its not about the user, its about a vb program creating access objects, like queries. i want to create an actual query in the access db. for example, create a query called 'getCustomers' that is a make table query that when run, creates a table called 'custs' and the sql that the query...

i guess i wasn't clear in the post, i want to do it from all from the program

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

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

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

ok found it, but its weird. the field was numeric month, so the validation rule is 'between 1 and 12' so if you enter 0, 13, etc, my validation message comes up. but if you enter say 'a', the ms default message comes up, so i guess it depends on how you code the validation rule, how...

well i thought i explained that i have already done that. when the field does not validate, a msgbox type of msg appears first with what i have put in the validation text. after that msg is acknowledged, a 2nd msgbox comes up, see attachment in original post. that 2nd message is some default...

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