Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: ossse
  • Order by date
  1. ossse

    ALTER TABLE syntax error

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

    ALTER TABLE syntax error

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

    change data type of a query field

    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!!!
  4. ossse

    TransferSpreadsheet problem

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

    2 quick questions

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

    change data type of a query field

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

    2 quick questions

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

    change data type of a query field

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

    TransferSpreadsheet problem

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

    change data type of a query field

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

    Output to excel truncating help.

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

    Output to excel truncating help.

    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'.
  13. ossse

    Output to excel truncating help.

    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?
  14. ossse

    Output to excel truncating help.

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

    How to start a new line in a msgBox

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

    How to start a new line in a msgBox

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

    form: datasheet, error "... too many fields ..."

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

    Can this be done using a Form?

    Thank you for the 'Thumbs Up', and the bit of direction. I am sure that I will have more specific questions once I start developing it. I know it is odd that I have experience with tables, queries and modules but not forms. I was taught the VERY basics of Access which included tables...
  19. ossse

    Can this be done using a Form?

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

    copy query to a table

    Works great! When I run it, a pop up window always asks me "You are about to paste 190 row(s) into a new table.... do you want to continue... Yes/No" Is there a way to prevent this pop up window? If not, it's no big deal

Part and Inventory Search

Back
Top