Search results for query: *

I have a crosstab query that has different numbers of columns depending on one field in the query, called "Sequence". Depending on the value of Sequence (an integer), there could be anywhere from 3 to 15 columns. I'm trying to create a report from VBA code using DAO to find out how...

I have this ridicoulous code here: Select Case intStepCount Case 1 S1 Case 2 S2 Case 3 S3 Case 4 S4 Case 5 S5 Case 6...

I would like the report to print down, then across. However, I only want one record per column, even if it's only 3 rows (there will be a lot of text in each record). So when one record has finised I want the report to not start another record in the same column, but go to the next column and...

I'm writing a report by using code (I have my reasons...). The problem I'm running into is that when I try to put a label in acGroupLevel1Header I get the error "Run Time Error '2148': The number you used to refer to the form or report section is invalid." The code in question is...

Here's my code: Sub NormalReport() Dim rpt As Report Dim strReport As String strReport = "zrptActionTables" Set rpt = CreateReport(, strReport) ' Create minimized report. rpt.RecordSource = "qryStepActions_Design" DoCmd.Restore...

I can't find the solutions.mdb database with my installation of Office XP. Can someone either zip it up and send it to me at quintios at hotmail.com, or can someone tell me why it didn't install or where it should be if I have it? Thanks! thx! Q-

I posted this in the reports area by mistake.. This thread describes a lot of what I need to do: Thread703-562204 I need to make the columns fill the page. From what I gather from that thread, a dynamic crosstab report will have empty space as the boxes collapse down across the unused text...

This thread describes a lot of what I need to do: thread703-562204 I need to make the columns fill the page. From what I gather from that thread, a dynamic crosstab report will have empty space as the boxes collapse down across the unused text boxes (i.e. if you have all 12 months as columns...

I have a report in which I want to stuff a subreport, however, the subreport is based on a query that is dependent on the value used for grouping the main report. How can I get this value? The main report consists of several subereports; unfortunately, one of the subreports is quite...

I have a report in which I want to stuff a subreport, however, the subreport is based on a query that is dependent on the value used for grouping the main report. How can I get this value? The main report consists of several subereports; unfortunately, one of the subreports is quite...

I created a database a while back with a main report comprised of subreports. The database has been converted from Access 97 to Access 2002. I'm looking at the main report now in Design mode and for the life of me I can't figure out how I inserted subreports, nor am I able to see the...

My company upgraded from Access 97 to Access 2002 / XP. Can anyone recommend (include links if you would, please) some good books on Access 2002 / XP? I don't need books for beginners; I'm an intermediate to advanced user. For sure, one book I'm going to purchase is the Access 2002 Desktop...

I've been fighting with a query and I think I've found the solution. I have a main report that is created with the main sort on a number in a table called 'Sequence'. When the report is being created, I need to grab the actual number of the 'Sequence' and stuff it into a query, and then the...

I have a database in Access 97 format that I need to migrate to Access 2002. The original database is empty and is in a development stage; my company migrated their workstations to Office XP, so I decided to re-write the db. I want to keep the tables but ditch the front end, basically. How...

My company just switched over to Office XP, and I'm trying to automate some stuff in Outlook. There doesn't appear to be the ability to record macros, so I'm looking for the Object Model so I can figure out how to copy and paste emails from one folder to another. Can someone direct me to some...

I have this code in Excel: Option Explicit Sub Run_VBS_File() Dim WshShell As Object Set WshShell = CreateObject("Wscript.Shell") WshShell.Run "C:\xref\inventory.vbs" End Sub The VBS file has in the first few lines: Set oFSO =...

I have a text processing VBS file that takes a text file and turns it into a comma delimited file which I then copy into Excel. Because I want to distribute this in order to make it as simple as possible it would make sense to put the whole thing into the spreadsheet. So my questions: 1...

I don't know if this is the right category or not, but here goes. I have a databse with a bunch of functions that are not often used, so I've moved them up into a custom menu. The only problem is, that custom menu now appears in EVERY database that I open. I believe I didn't create a custom...

I have a subroutine that I use to set up Regular Expressions. From this I pull out certain pieces of text. Under certain circumstances, I want to pull out certain SubMatches from the Matches collection. Can I send this code: Match.SubMatches(1) & "," & Match.SubMatches(3) &...

OK, here's the setup. I have a string from which I want to extract two digits or two letters and may include the dollar sign, $. They are always surrounded by a colon and a comma. The following works for consistently pulling out the information (incomplete code, but you get the idea of what...