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

i would do it in 2 forms. the first form is where you would enter the printer id or some field that uniquely identifies the printer. When you press enter, have it open a second form that's linked (finding specific data), and this will show you the information about the printer selected. On...

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

have you tried using the Mid, Left and Right functions? Left(Field_1, length from left) Right(Field_1, length from right) Mid(Field_1, start, length)

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

if the spaces are ALWAYS in the space spot (if there is one) then try this: if mid(field1,7,1)=" " then 'checking for 1st space field1a = left(field,6) 'take first six characters endif if mid(field1, 12,1)="" then 'checking for 2nd space field1b = right(field1,5)...

i posted a message like this a few weeks ago to no avail. i didn't come across the 'save' solution until last week though. in my query, i notice that a date/time field (not involved in the query at all, but in the table i'm getting the information from) was empty. this caused it to error...

assuming you know how to get a select query started, all you have to do to make it an update query is change the icon before the 'run' icon to update. choose your tables, click on the down arrow on the icon, choose update query and fill in the columns. i'm not sure how your table is set up...

i've taken care of that file, this is completely different. when i link with the transfertext method, it gives me errors when i go to run queries on it. i'm using it to create another table, not changing anything in the linked table itself. i was told there was another way to automate linking...

i need to use it in multiple calcs, i can't comprehend how this would work with a parameter query...

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

there's nothing separating the first part of the file from the 1082. it won't let me set a field separater there when i link it with delimited fields. it kinda looks like this: aolkj akdfu jaf45621 jalkjlkajsd kja dkaljf 5646 216543 154;62135432;46543210;5641 where 6 or 7 or sometimes 10...

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

are you typing in the date range somewhere? if you are on the form, in the query you can say in the criteria: between [Forms]![frmxxx]![LowDate] AND [Forms]![frmxxx]![HighDate] i'm not sure if this is what you're looking for. kerri

that's exactly what i'm looking for. thanks so much!!!

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

yes i'd like to know how. thank you so much!

i think my problem is that i'm using transfertext to link the table. if i go and link it manually, i have no problems. to create the common table, i'm using copyobject... that seems to be working.

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