Recent content by gyang

I insert a row of fake data to the first row of my spreadsheet. The spreadsheet would look something like this. PrimaryKey Field1 Field2 Field3 999999 xxxxx xxxxx xxxxxx (fake data) 1 1234 1234 1234 (actual data) 2 5678 5678 5678 (actual data) This...

Thanks so much, Sohaila!!! I looked up in the MS Help and it had examples of what to put in the Column Headings. I would have no idea that I needed to do that. Thanks!:)

I'm not sure what I am suppose to put in the crosstab query under Column Headings: View-->Query Properties--> Column Headings. . . Right now it's blank. Is that where I'm suppose to put in something? Thanks.

When I entered the StartDate of anything greater than 07/16/1999 in this select query qryCrosstabTotalsDated (not a totals query, a regular select query) I'm getting an error that reads: The Microsoft Jet Database Engine doe snot recognize ''as a valid field name or expression...

oops, I found how to delete the extra macro, go into the macro section, duh=). Thanks.

I've been working on a database that has been converted from Access 97 to Access 2000 and then replicated. A few questions(I'm new with Builders.) -I lost 2 Macros, but not the Macro names. When I try to open up the Macro, it kept giving me the Expression Builder instead of the Macro Builder...

Okay, thanks. I'm new to replicating, but I'll give it a try with the FE/BE splitting. When you say modules, do you mean macros? I noticed some of the macros didn't get replicated as well. (sorry, this follow-up question should probably be in the Macros discussion).

I did a right click on the crosstab query in the queries menu: -selected "Export" -window pops up to save -I keep the same File name -Change the Save as type-->Microsoft Excel 97-2000 (instead of Microsoft Access) -hit Save The column and row headings look correct, but the actual value that are...

I created a replica of a database using "Tools-->Replication-->Create Replica...". The replicated database replicated tables and queries, but the forms and reports didn't get relicated. So I went into forms and did "File-->Get External Data-->Import" and try to import the forms in. It let me...

Thanks Tim and thouston. Since the mkTable loses it's crosstab format, I tried making another crosstab from the mkTable, but again the data was incorrect when I exported it into Excel. Quite puzzled why this happens? I'll stick with the copy and paste then.

I created a crosstab query from 1 table with the following fields: -Group by Activity_Type, Collaborating_Agency, Duration as row headings -Group by Client_Type as column heading -Sum of No_per_Client_Type as value The following is the raw SQL: TRANSFORM Sum(final.[No_per_Client_Type]) AS...