memo

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

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! https://www.dropbox.com/s/i55v6gnh1c016mb/excelsalesreport.PNG?dl=0 1) Some Credit Memo line items do...

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

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

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

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

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

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

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