Search results for query: *

I agree you should not be opening the workbook. Just itenerate through each worksheet programmatically, then have the program do the paste special. so.. Workbook a is the master. your program spits out the 60 worksheets into a new workbook, b. 1. call a procedure that opens to the master...

I am thinking that each worksheet is basically identical? If they are, can you create a "Master" worksheet in a separate workbook, with all the formating complete. 1. You could consider calling a macro that would then select and copy the entire working MASTER worksheet. 2. Have the macro...

Hello djmousis, You just about had it right all the way around. It only took a little bit of testing and some very minor changes to get it right. So, now you should be able to export data directly to the excel sheet and also multiple sheets. Just drop this code behind a button and away you...

Did you ever get this project working. I recently got called back to active duty and am stuck in Iraq without most of my resources. For the most part I am not working in my career field, or even my old army MOS, which is probably a good thing LOL. I am trying to do something very similiar to...

Thanks for the input. My plan is to use a table of just one record. Thanks again.

Frequently, I am asked to change the starting and ending dates for a report. There are several locations in several cascading querys that require modification. A sample of the working model is: between #9/26/05# and #10/30/05# What I am looking for is something like --- "Between...

Willir.... That was it... The Auto Correct dictionary had exactly tath to that in it. I deleted out the offending correction and it worked great. Thanks for the help.

I have a text field, Lname. When the last name is entered as TATH, the field automatically changes to THAT. I've cheated by putting a semi-quote "'" as the 5th charector of the last name. Does anyone have any ideas what is turned on. I have not seen this before in Access. Thanks Paul

Roy, Thanks for the tip on that thread. That certainly looks promissing. I will give it a shot and let you know. Thanks again.

Thanks for the response. I already have that option set to work that way. I wanted to be able to export the program and not have to worry about the condition of that option. Any VBA idea? Thanks

I have a datasheet (sub form) with 6 columns, the left most column is already populated. The clerks want/need to be able to move to the next row upon pressing enter, rather than moving to the adjacent column. How would I set this up in VBA. Thank you.

Roy-Vidar ... Great catch!!! You hit that nail right on the head!!! I am going to make sure that I understand the properties of the different options. Thanks I had been watching the error prompt come up for so long, that when the data finally stored msgbox displayed, I was thinking...

This DB was originally developed with all the tables internal to the program. I am attempting to mirgrate the raw data to a separate Access DB tables. The process worked fine using the orginal table inside the current Access program. When I attempt to use the external table (tbl_Drops), I get...

Kerryl Did you ever find a solution for this. I was unable to figure out the group name.

Wow, I certainly need to read up on how to ask a good question. If you take a sorted list... a,b,c,d,e,f, and you wanted to get ONLY the value of max-1 or max-2, is there a way to do that? Meaning select e, or d respectively. Thanks.

Is it possible to select the max value -1? Thanks in advance.

I have the following data. Date Period U PC G V 04/12/2004 12:15:00 AM 2 2 0 NOV 04/12/2004 12:15:00 AM 3 3 0 MMT 04/12/2004 12:15:00 AM 18 19 0 VGT 04/12/2004 12:45:00 AM 1 1 0 NOV 04/12/2004 12:45:00 AM 1 1 0 SDG 04/12/2004 12:45:00 AM 1 1 0 SED 04/12/2004 12:45:00 AM 6 6 0 MMT...

Thanks for the help. I took the advice and brought in the lastscan time in to a sub form. I created an unbound object (Ago) on the form that pointed to the time of the lastscan (Subform) and calculated the difference between that time and now(). Made the subform invisible and now we know the...

I will give it another try and post the results.

I must not have been clear in my description. The clock portion of the swithboard is working fine. I am looking at how to bring the results of the query to the swithboard, to tell me the time of the last scan. SELECT Max([Date]+[timeMS]) AS lastScanEvent...