Recent content by ossse

I've now tried that and it still does not work. This doesn't make sense to me!!! What is wrong with the code?

I am trying to change the data type of a column. I have tried the following; DoCmd.RunSQL "ALTER TABLE ZEvaluate ALTER COLUMN PM Basis MEMO;" CurrentDb.Execute "ALTER TABLE ZEvaluate ALTER COLUMN PM Basis MEMO;" For both I get a Syntax error. Do you know what I am doing wrong.

I figured it out. To create a table that is a copy of the Query: strSQL="SELECT * INTO NewTable FROM tblTable" db.Execute strSQL To change a field data type: ALTER TABLE tblTable ALTER COLUMN ThisMemo TEXT (255) Thank you though!!!

The problem was that; the query that I was exporting had the field as a Text type. This was because I concatenated 2 fields together to create this particular field. To get around the problem I created a Make Table Query. the Table put this field as a Memo. I was then able to use...

Thank you... can you do the 'Make Table Query' using a Module? If so, what command do you use?

I am/need to do it programatically, I am using TransferSpreadsheet (outputTo command doesn't work... it opens it in Excel 95/5.0 which only allows 255 characters). Any ideas? An idea that I have (not sure if possible) is programatically; - create a Table that is a Copy of the Query - change...

I have two quick questions, where I'm trying to use Modules in MS Access 1- Is it possible to create a table that is the same as a query (copy the query as a table)? 2- Is it possible to use a Module to change the data type of a table? (change a Text to a Memo) If you could also point me in...

PM Basis is a field in a Query. I am going to send the Query to excel. However excel shortens that field, but not others. I am assuming that it is shortening the field, because it is considered a 'Text' field. Other fields that are NOT shortened are directly from the tables (not...

I am using the TransferSpreadsheet command to send an access query to excel. There are two fields in the query that may contain greater than 255 characters. I am transferring to Excel 97. When I run the TransferSpreadsheet command and open the excel file, one of the fields is shortened to 255...

I have manually created a query. One of the field concatenates two table-fields, and looks as follows; PM Basis: [riskRankingBasisMitigated] & " - " & [taskDetails] I would like to make this field a memo field. Both 'riskRankingBasisMitigated' and 'taskDetail' are memo fields. Does anybody...

Sorry for all the questions, but I just came across this problem, and I need to have everything done tomorrow, and I'm no master programmer Just to be clear, right now I have 1- the user filters the table 2- the user runs a module 3- the module sends the filtered table to excel (with max 255...

A user will filter the table, I don't want it to be filtered automatically. Is there any way of choosing which excel format to use, I want '97-Excel 2003 & 5.0/95 Workbook'.

Thank you for the quick reply... I didn't mention; I am first filtering the Table, then sending the filtered table to excel. When I use TransferSpreadsheet, it sends the whole table (unfiltered). Any other ideas?

I am trying to output an Access table to Excel. I regularly have the option of saving an excel file as either; 'Microsoft Excel 5.0/95 Workbook' OR 'Microsoft Excel 97-Excel 2003 & 5.0/95 Workbook' When I output the Access table to excel it defaults to 'Excel 5.0/95 Workbook' and cuts off...

Sorry, I just figured it out... here is how it is done: strMsg1 = "Do you want the sequence number to begin at 1?" & (Chr(13)) & (Chr(13)) & "(Click 'No' if you want to begin the sequence number at a different number)" BUT ... I have another question. I would like to display a message box...