1. M

    Memo field on form in multiple columns?

    I feel like a grade schooler with access, but slowly getting my database to a usable format. I have a report, generated by inputting a person's last name, which produces a one page document of all issued equipment for that person. On that report, I have a Memo field, which I'm using to store...
  2. pcorpz

    macro to look through report and make changes based on value of cells

    Hi MVP's! Hoping to find a macro solution that will automate several manual adjustments I need to do in our Sales Report everytime. Here's a link of my report screenshot for your reference! 1) Some Credit Memo line items do...
  3. C

    Highlight Rows Based on the Sum of Multiple Cells

    Hello! I currently have the following macro that highlights "offsets" in my spreadsheet. Sub Offsets() Dim Cell As Variant For Each Cell In Range("B2:B2500") Dim rng As Range Set rng = Range(Cell, Cell.Offset(1, 0)) If Application.WorksheetFunction.CountIf(Range("B2:B2500"), Cell) > 1...
  4. J

    trouble with sorting by 'x' then 'z'

    hi my data loos like this <style type="text/css">p.p1 {margin: 0.0px 0.0px 0.0px 0.0px; font: 11.0px Helvetica}p.p2 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: center; font: 11.0px Helvetica}p.p3 {margin: 0.0px 0.0px 0.0px 0.0px; text-align: right; font: 11.0px Helvetica}table.t1...
  5. N

    Query Output Format

    I have an ID field that is a number field but is not currency. The ID field needs to return results with a () around the results and not "-". This field is uploaded into Quicken and then from there it is uploaded into another system; this other system will not accept the upload if it is not...
  6. B

    Access VBA "Runtime error 3188 - Could not update; currently locked by another session on this machine" when updating memo field

    Hi, I'm getting the above error when amending a record on a text box on a form that links to a Memo field. I mention this because this error has just started occurring on one record, and the text in the memo field exceeds 2k characters - looking at other internet searches, other people have had...
  7. S

    Formula to extract a specific line item name from different cell

    Hi, I have alot of random data. I am trying to find a formula that will extract the "PO" from my memo cells. A formula that will look into the cell and find that specific PO and extract to my other column? Can anyone please assist? <colgroup><col><col><col></colgroup><tbody> MEMO What I...
  8. T

    MS Access 2013 Memo Fields Truncated when exported to MS Excel 2013

    Good morning, I have multiple tables feeding to any of my queries. When I export any of my queries that contains a memo field to excel the cells are being truncated. Many of my cells have 10,000 characters as an average. I have hundreds of queries that are specific to what I need to export...
  9. M

    Entering comments into database

    Hello I want to thank you for your time for reading my question Background I have a database which i send RFQs (request for quotation) to my supplier which they add their prices and what not but at the bottom of the form they can also add comments (memo field) and so can I but when I do a...

Some videos you may like

This Week's Hot Topics