Search results

Your query has 16 tables and no join fields. What you have is called a cartesian product... Basically every table is trying to reference every field against all the other tables... You need to read up a little bit about how tables link together in a relational database. When you run the...

The simplest way would be to create a query from your table that filtered all checked records... and then create and identical report that uses that query as the basis. You could also create a new query with a parameter prompt, to prompt the user for a checked (or not checked) value, although...

It's not a rounding issue, from what I understand, since 36.9 does not round down to 36.5.... Using her examples: A datediff() function, calculated in Months, should yeild a whole month integer value... So: 36.9 would yeild 36... and 37.1 would yeild 37... at which point you should be able to...

There's probably a better way to do this from the get-go... but if you did concatenate these values in your crosstab, you could always use that crosstab query as the basis for another select query and then parse out the [Contact] field with a couple string functions. Like: Mid([Contact], 1...

I think DateDiff("m",#BIRTHDAY DATE#,Date()) will get you the number of months... then just add .5 to it... So something like: CDbl(DateDiff("m",[Birthday_Date_Field],Date()) & ".5")

Assuming the items reference were just an example of the type of data... SQL code might be more like: SELECT customer_number, activity_name, due_date, DateAdd("d", 30, due_date) AS ThirtyDaysAfterIntroduction FROM YourTableNameHere No?

You could simply create a preliminary query with all the filters you want (i.e. dataset you're looking for)... then create your crosstab using said query as the base (vs. using a table directly)....no? Or if your crosstab is based on a query already... just filter your base query.

I am not sure what your pre-formated template looks like, but what I would do is export the query to Excel using docmd.transferspreasheet, then programatically format your excel spreadsheet, from the MS Access VBA... That way the format will always be the same but allow for changes in record...

JHB I am sorry you're bent out of shape by my remark, The post in question was started by me 4/26. To wit, I got very little response. You state that: spikepl pointed it out in post #4, that you where missing the references. In fact this is all spikepl said in post #4: That didn't help...

My answer was solved here:http://www.access-programmers.co.uk/forums/showthread.php?t=264202

Yes, thanks... I was just reading up on that. I changed this section of my code: xlWB.Sheets("Obs and Commits by LIRN").Select xlWB.ActiveSheet.PivotTables("PivotTable1").PivotSelect "SBH[All]", xlLabelOnly, _ True xlWB.ActiveSheet.PivotTables("PivotTable1").ChangePivotCache...

I keep running into this same issue and it's driving me nuts. I have an Excel workbook with a Pivot Table in it. Basically all I want to do is push data from an MS Access query into an Excel worksheet and then refresh the pivot table. I need to do this all from an MS Access form. With a button...

Well, I figured out what I was trying to do, this code takes a list you've copied onto your clipboard an pastes it into a table. Basically it loops through the values in your clipboard and uses a recordset to append to your table. My tables name was [VALUES] and the text field name was...

Hmm... Yes I see, now, I wasn't very specific... To answer your questions: There would be one and only one field in the clipboard and also in the table I would paste the clipboard data into. The size of each data element would probably never be much longer than 13 (or so) characters, but it...

I can copy (Ctrl+C) a list of data from wherever and post that into a string variable strVal. When I run MsgBox(strVal) It shows me the list I just copied... as a list. What I'd like to do is append the data from this string variable (i.e. strVal) directly into a table as a list (i.e. each...

Can someone please take a look and see what I am doing wrong here...?

I am trying to make a little tool using access. I want to take a list (excel, flat file, access table, whatever...) past it into a table then click a button and have access spit out an IN() function. That way, whenever I have a list I want to throw into the criteria section of a query (SQL...

This is a stripped down version. It's pretty simple. There's a single table and a single form. The form has a button OnClick Event; when you click it, it spits out an excel sheet to your desktop, formats it, then closes it. Now, if you hit the button again... You'll be prompted to overwrite...

Make a listing of all schools (i.e. a seperate table)... Using a recordset/VBA, loop though each delimited field with each school name, building a table that itterates a person count each time a school is mentioned in your delimited field. The general idea would be something like: If...

I found this: Private Sub SaveRecordsetToExcelRange() ' Excel constants: Const strcXLPath As String = "C:\\MyData\MyWorkbook.xls" Const strcWorksheetName As String = "Sheet1" Const strcCellAddress As String = "A1" ' Access constants: Const strcQueryName As String = "MyQuery"...