Search results for query: *

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 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...

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...

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...

I'm sure this is a very simple question, but I have NO experience with message boxes. I am displaying a message box, and would like to put a space between two lines of the message. I am told to display either (chr (13)) or (chr(10)), but I am not sure how I am suppose to display this. Here is...

I am trying to create a form from a table. I want the form to look like the table except with some hidden fields. The table has 36 fields. When I try to make the form (AutoForm: Datasheet) I get the following error; "The wizard is unable to create your form or report because you chose too...

So far I have done the following using Tables and Queries, however I have run into afew problems and everybody tells me that the user should not be dealing with Tables/Queries, but only Forms. I have experience with Tables, Queries and Modules, but NONE with Forms. Before I spend days trying...

I am trying to build my own table and incorporate the 'concatenate' function (found in FAQ701-4233: How to concatenate multiple child records into a single value). My two original table look as follows: Table: Tasks taskCEID taskID 1 6 1 6...

I am trying to use VBA to copy query results (a full query table) into a new Table. It sounds easy but I have been struggling with this all day; trying several different approaches with no luck. A point in the right direction will be much appreciated. Thanks

I am trying to concatenate multiple records that have the same ID number (same goal as thread705-1197128). I have been using faq701-4233 as a guide however I don't think that I am calling the concatenate function correctly. ID number field: 'taskCauseTaskID' Field to concatenate...

I am trying to run an access module that changes the row/record height of a table (table name = "Filtered"). I'm not sure where I am going wrong. The program runs fine but the row heights are never changed. Here is my code Sub rowheight() Dim dbs As DAO.Database, rst As DAO.Recordset Set...

I am trying to cycle through all of the rows in a field (field ='Comments') and return the number of characters of that cell. The field is a memo type. Could you please help with my module code. It does not like the following line: length = Len(fld(i)) Here is the code: Dim dbs As Database...

I have a field that is a 'memo' type. I would like to run a module that changes each row height in order to display the full text (with a fixed column width). If you have any ideas how to do this please let me know. Thanks in advance

From an Access Module I am trying to save an excel file under a new name. The problem is, I need to it to prompt the user for the file name and location. I've tried using the '.GetSaveFileName' that I found in VBA help, but it doesn't seem to work in Access. Any help is greatly appreciated...

I am trying to run an excel macro all from an Access madule. There are two parts to my problem. Here is the excel macro, however I would like xlLastCell instead of 'AD69' and instead of 'AD68' I would like 'one cell up from xlLastCell. Range("A2:AD69").Cut Destination:=Range("A1:AD68")...

When a table is filtered, I use the OutputTo command to save it as a .txt file. This works great, however the field names show up at the top of the text file, and the tab spacing is not how I would like it. Is there a way to get rid of the first line in the text file (field names)? Is there...

A user will filter a table. I then want to run a module that will create a new identical table (same fields) however with just the filtered records. I have no idea how to do this, my attempts have always copied all the records (not just the filtered records) Any direction/hints would be much...

I am sending a Query to excel, then I would like to run a macro in excel from the Access module. The macro is not already in excel. I can send it fine, I just don't know the commands to convert the macro. (Note: this is similar to Thread707-1337949). Any help or point in the right direction...

I am trying to copy an entire table (fields and records) from a different database. I used the same code to copy a query and it worked, however for a table it is not working at all. Below is my code, can you please try to figure out where I am going wrong. Also, is there a way to auto-allign...