Search results

  1. A

    Network connection may have been lost

    Hi Gurus, Anyone have a clue? From within an access database, I create an external database on the fly, I create a table inside of this new database and fill it with data from my first database. Then I export a report based on this table. I then open the external database, and open the report...
  2. A

    query truncate memo

    Hi to the Gurus, I have a table with a memo field. Then a very complex union query with three parts to a report. My problem is that the query truncates the memo field to 255 characters. Does anyone have a clue how to solve this? Thanks, Andrea
  3. A

    memo field on report

    Hi, I have a field in a table that is of size memo. On my report I pick a textbox to display the field in, yet, it insists on showing only 255 characters. How do I display the whole memo field? Thanks
  4. A

    create database on the fly

    I want to put a push button on a form. When the user pushes the button, I want to create a new mdb on the fly, and put all the related data in the tables that I create on the fly in this database. Does anyone know how I can do this? Thanks
  5. A

    create database

    I want to put a push button on a form. When the user pushes the button, I want to create a new mdb on the fly, and put all the related data in the tables that I create on the fly in this database. Does anyone know how I can do this? Thanks
  6. A

    no footer on first page

    How can I prevent my page footer to appear on the front page of my report?
  7. A

    save report with pictures

    How can I possibly save an access report with pictures lines and data so that I can work with the file again afterwords? RTF does not support images or lines. Is there any other format or way I can save it so that all my pictures and lines will display and I can still make changes to the format...
  8. A

    citrix and MS access

    One of our users runs MS access through citrix. On all the other environments the database gives no probs but on citrix we get errors that some of the functions cannot be understood or read. Is there anything I can do about this? Thanks!!!
  9. A

    Please help!!!

    I am using a query in my code ssql5 = "select * from [my table] " _ & "where [my field1] = " & rstmyrecordset![my field1] _ & " and [my field2] = " & rstemyrecordset![my field2] I then open the recordset like this Set rsttemp = dbscurrent.OpenRecordset(ssql5, dbOpenDynaset) My problem is...
  10. A

    Data problem - Please help!!!!!

    I am using a query in my code ssql5 = "select * from [my table] " _ & "where [my field1] = " & rstmyrecordset![my field1] _ & " and [my field2] = " & rstemyrecordset![my field2] I then open the recordset like this Set rsttemp = dbscurrent.OpenRecordset(ssql5, dbOpenDynaset) My...
  11. A

    don't want my data (R) to be read as trademark

    Access understands my data (R) as the trademark registered. When trying to pick this from a combo box, it gives me an error that it doesn't exist in the list....sigh.... :D What can I do about this?
Back
Top Bottom