Search results

  1. red2002yzfr1

    Add a carriage return in data

    I need to add a carriage return in a data field at "*break*" text. Also, would be nice if it deletes the search text.
  2. red2002yzfr1

    Extract Text (dollar amount) in Query

    I am looking to extract a dollar amount from a text box in a query. The dollar amount will reside in general text, "It cost $4,370 and was...." and can be anywhere within the text box. The dollar amount sometimes has cents. There will also be times that there will not be any dollar amount...
  3. red2002yzfr1

    Add a Hyperlink and Delete Button to Form (Subform)

    I am trying to add a button to a form that populates a sub form (data sheet) with hyperlinks. I also want to have a delete button available to delete these link(s), in case of wrong pick or attachment change. I have searched and researched the topics available with no success. I have come...
  4. red2002yzfr1

    Error 3041

    The error is Cannot open a database created with a previous version of your application. (Error 3041). I clicked on help and the content tells me "you have accessed a Db that is in an outdated format. Compact the Db & try the operation again." I can not compact it on the computer, will not...
  5. red2002yzfr1

    Option Group does not work when adding queries

    When I add a query to a form that has an option group, the option group fails to change when you click another option. Any fixes anyone knows of?
  6. red2002yzfr1

    Date and Time Popup

    I am looking for a pop up that will not only let me pick a date and fill it in a field, but also pick a time, not the present time, but a time in the future in 15 minute increments. Any direction is greatly appreciated.
  7. red2002yzfr1

    Run Time Error 3071

    I am having a Runtime Error 3071 in a report, but only on certain computers. It seems to be on the older/slower computers. On the newer/faster computers, the report will preview, but does take a little time to get to the preview. On the older/slower computers, when I preview the report, I get...
  8. red2002yzfr1

    Add Image Error (2220)

    I am getting a Run-time error (2220)-Microsoft Office Access can't open the file (then state path) on a form when a user attmpts to add an image and "Cancels" out of the file dialog box. I do not have any problems if the user continues to add the image. Any ideas, would be helpful
  9. red2002yzfr1

    set value in form from search form

    I am trying to get a form to set itself to a certain record based on a search form result. Not sure how to get my search forms result populate another form.
  10. red2002yzfr1

    OrderBy with Wildcards

    I am trying to get the OrderBy to recognize wildcards (or to that effect). A scenario would be I would have more than one name in a field, EX: Name2, 4, 6. How do I use wildcards in the OrderBy and they are recognized. ORDER BY (Table.Field)="Name1", (Table.Field)="Name2"...
  11. red2002yzfr1

    Sorting on a value in a field

    In a report I need to sort some records by a value in the field, but want to keep the rest of the records there. Ex: I have a DB with projects in them, need to sort the project managers so there report reflects there project(s) first but still shows all the projects from the entire...
  12. red2002yzfr1

    Database History File

    Is there a way to create or access a history file of all events in a database?
Top Bottom