Search results

Thanks that will help also - actually i was able to do it with the query - i realized i had forgotten to include a field that was required - thats why i was getting the error i was getting. thanks! - T

I'd like to know if its possible to copy an entire record within the same table. ie in table1 i have a record with 10 fields - the first being the primary key - an ID field i'd like to copy that record and create a NEW record with all the same information. I thought it would be easy to do...

hmmm sounds interesting i'll give that idea a go.. cheers, T

thats good to hear - maybe it won't be slow after all - guess only way to find out is to try it. can i ask how you determined the sequence? im thinking something like get the 1st # get the 2nd # see what the difference is if the difference is equal to or greater than the sequence the user...

but wouldn't using code be extremely slow? theres probably no other way than using code i suppose. thanks

I also put this under the Query Forum, but i thought i would try a module as well. Is it possible to write a query or code that can determine if a list of records are in sequential order? ie 1,2,3,4 what i want to do is find out of say 1000 records if there is are some free sequential #s. the...

Is it possible to write a query that can determine if a list of records are in sequential order? ie 1,2,3,4 what i want to do is find out of say 1000 records if there is are some free sequential #s. the sequential #s are then given to some other records for processing. also the user selects...

if the serial # is say 10 characters long and you want characters 3,4,5 you could use mid (SerialNo,3,2) - so it starts at the 3rd characters and ends two characters to the right - #5 in a query you would then say select modelname from table2 where modelno = mid (SerialNo,3,2) then you would...

Actually I did find some code to get the username, although its more complicated than yours.....so i'll try yours! it looks easier....and i was thinking that i could validate the username through the dB instead of having to get the password. that way the user just have to log onto their...

Quite Welcome =) only other option i can think of is in DOS you can copy a file to an lpt port - or printer port - not sure if that would work with excel files but it might. good luck! - T

Welcome, Sorry I dont know any other options...i think the code from the link allows you to run an excel macro from access...but im not 100% on that.... what is that your trying to print? is it not possible to print it in an access report? - T

does this link help?? it has a little bit about running excel hidden and running a macro from within excel? maybe then you would be able to open excel - use the macro to print the doc you want, then close excel?? http://www.mvps.org/access/modules/mdl0007.htm

in the access 97 helpfiles there is a list (below) of options for excel. perhaps changing the word.app to excel.app may work? or one of the other ones?? Set xlApp = CreateObject ("Excel.Application") Set xlApp = CreateObject("Excel.Workbook") Set xlApp = CreateObject ("Excel.WorkSheet") Set...

I've had similar problems to what you describe. The only real solution I could figure out was to create a string variable with the SQL statement for the report. I would then append to it the filter which was selected - when the report is opened you can program what the recordsource by point...

hi, i've done some searching and i can't find anything that answers my question so i apologize if i'm regurgating anything... i'd like to be able to validate users onto an access97 db through their network domain accounts. that way they only have to remember one password to log on and to log...

Your right that is overly simple - but ive bin lookin at this thing for so long - simple completely escapes me! hehe thanks! i'll give that a go! Cheers

hey there, i have a dB that i want to close programmatically. i know how to do this with the docmd.quit command. and i've bin able to setup a form with a timer which checks the value of a field in a table - when the times match the system shuts down fine. my only beef so far is on some of...

i didnt even see that! thanks! i'll give that a try. i was able to get it working turns out my filter wasn't setup properly in the first place - but its still doing something weird and that might be it. cheers

but i dont use a table for the recordsource i use that query. i could create a query using vba everytime the user wants to run the report. that would work for then i could add the dates into the query itself rather than using a filter. is that what you mean?

heres my sql statement which is written into the recordsource area of the report. i then use the docmd.openreport command with a variable filled with the filter, and placed in the filter option of the docmd. command SELECT tblASQuotes.QuoteNum, tblCustomers.OrganizationName...