Search results for query: *

My access help isn't working. If I want to output a query to excel, what's the abbreviation for excel? Also, is 1 correct for autostart? DoCmd.OutputTo acOutputQuery, "SRCus", ???, "SalesRep by Customer", 1 Thanks in advance! Kerri

this seems like it would be simple, but it's been awhile since i've worked with access and i can't figure it out. i have two forms, form 1 calls form 2 by the user pressing 1 of 3 command buttons. depending on which button is pushed, i want a field on form 2 to display a letter. if ADD button...

i'm splitting up a field, 1082 characters long, text, into 5 different fields. but when i do a "Date: Mid([Field1],62,8)" in the make table query, it automatically makes it a text field. how can i change this to a date/time with short date format??? thanks in advance! kerri

this can't be that hard, but i'm out of ideas! in my table i have: jobnum date qty elem1 elem2 ... elem11 i want my query to append to a new table: jobnum date qty elem instead of creating 11 different queries (one for each elem), i want to be able to rerun the same query and just change the...

i have a file that i want to link. every field after position 1082 is separated by a ;. The first part of the file, however is not. I'd like to separated the fields like this: Field 1 = everything before 1082. Field 2 = everything from 1082 to first ;. Field 3 = from first ; to second ...

is there a way to link a text file, starting with a specific position? i only want the job #, let's say positions 987-998, and everything after position 1082. thanks in advance, kerri

is there a way to code: if response = vbyes then ***(automatically press the RESUME button)*** else msgbox...

i'd like to automate linking a table into my db, but transfertext action won't allow me to change it. it also gives me errors such as permission denied or open by another user, (which i know it's not!). is there an alternative to using transfertext to link to a text file? if i manually link...

i'm not sure if this is the right forum for this, but here goes... on my form, within vba code, i'm linking a table, then copying it to another common table name for query purposes. when i go to run the query, it says it can't open it because it's exclusively opened by someone else. is the...

i'm getting an error on an append query, "cannot add 1046 records due to validation rule violation". i'm using 3 files to append to the table. NONE OF MY TABLES HAVE VALIDATION RULES or input masks! is there any other reason i would be getting this error? thanks in advance, kerri...

is there a way to open a .txt file in access? i'm trying to automate a daily procedure that runs multiple queries, and in the midsts of all these queries, the user needs to check a text file. it'd be sweet if i could open it from within the coding so they didn't have to go searching for it...

on my form i have 1 text field where the user enters the current date, ie 5/18/01. a second (locked) text field is bound to the 1st and formats the date to julian (01138). i need this 2nd date in a string format. when i code MyString = CStr(txtJulian), i get "5/18/01". i need...

is there a way to rename tables in the query with code? every morning i have 10+ queries i have to run. i have 4 queries that i need to go in to design and change the table name from last work day, suq_d051701, to current work day, suq_d051801. i'd like to automate these changes so i can hit...

is it possible to run 10+ queries, (append-select-update-makenewtable...) from the same submit button? if one takes 30 seconds or so to run, will it wait before it goes on to the next one? will it let you answer the "this will append..." confirmations? thanks in advance, kerri

i created a new make table query, ran it from the query tab and it ran fine. then i tried opening it from a form and running it from there and i got a numeric ovreflow error. when i tried running it from the query tab again, it kept giving me the same error. has this happened to anyone...