Search results for query: *

Hope this is the right forum to ask this question. I'm trying to write a simple query based upon a single table and all I want is an extra column in the query that numbers the records in the query starting with 1 and ending with the number of records in the query. i.e if four records in the...

when creating a crosstab using the wizard, you are allowed only 3 row headings. haven't tried creating manually to see if that limit can be exceeded.

Thx for the input. I've considered this option. But Access crosstabs only allow for 3 row headings and I need more than that. If Access does not have this built in capability I'll just have to do it the long way.

Does anyone know if you can export an access table to an excel spreadsheet in a transposed format (column headings become row headings) directly without having to create an Excel object to make the manipulations? I'm hoping that Access has some function that's like...

Got it. Thx to both of ya. I knew it was something simple like that.

Thx John, I'm still pretty new with VB, but I'm not able to find the Workbook object. Within the Visual Basic Editor, I'm only seeing the worksheet and in the project explorer the only thing I see is ThisWorkbook under Excel objects. Where is the Workbook_BeforeClose event?

Hi I would like to save a second copy of an Excel worksheet onto a network drive upon a user exiting Excel. What event do I tie my subroutine to in order to trigger my subroutine? I was hoping that there was an unload or quit event in Excel that I can tie my subroutine too. Any suggestions?

I ended up having to write a function to do this and attached it to the control source of the textbox. Maybe there was a better/easier way??

If I have a txtboxProfiles textbox in the details portion of my report with the hide duplicates property set to true, if I have more records than it fits on one page then on every new page the value in txtboxProfiles shows up. This is fine but what is the trick so that when the value of...

Wow..Robert, just got back into the office and saw your post. Am in the process of understanding and testing it. Here are some of the quarks that I've found so far: Any integer value or someNumber.0 gives incorrect output i.e.: sigdig(2, 4) should show 2.000 not 20000 sigdig(2.0, 4) should...

functionname(0.21, 2) states given a value of 0.21 and the #of significant digits to keep (2) in this case, I want the function to return 0.21 either text or numeric (prefered) doesn't matter. What I really care about is that on the report the number shows up as 0.21 If the value passed is...

Thanks for the input. But even with the format function it seems that I will still have to write a fairly extensive user function and pass values to that function to get the functionality that I need.

Does anyone know if Access 2003 has a significant digits function? i.e. (3.0, 3) get 3.00 (3.1, 2) get 3.1 (0.2, 3) get 0.200 (0.21,3) get 0.210 I'm looking through the threads and help and haven't come across anything yet and was hoping someone had the answer. Thanks

duh...I feel so lame. Brain fart. Thx for the reply. =)

I'm brand new to access and have a question about building forms. How do I add a field list to a form if the form is already created without one? (i.e. built from 'create form in design view' link) I've tried setting the control source on a text field to a table and field like so...

Thx Mike. I had the same code but forgot to activate window before issuing the SELECT..TO SCREEN.

Hi all. Could some please show me how to direct the results of a query into a user defined window created using DEFINE WINDOW myWindow.... For the life of me, I can't seem to find the answer in the threads.

Mike that is some good stuff there. Thanks a lot! It totally eliminated all the extras. Thanks, -suey

Thanks for the input Mike. The reason that I had to do it the way I did was that I wanted to do something like this with a query on the orig. table: select avg(col_1) as avgCol1 for col_1 <> 0,; avg(col_2) as avgCol2 for col_1 <> 0; from mytable group by date For each day, I wanted an...

I used an array to hold multiple calculated values and wanted to take the contents of that array and dump it into an excel file. So I ended up creating a cursor and dumping contents of array into that and then taking the contents of the cursor into excel. Is there a better/cleaner/faster...