Search results

Hello all. I haven't written a database in a long time as I have made a late-life transition to accounting, and need a little help with structure and relationships. I've attached a pic of the relationships to see if I've set up this simple DB correctly. I'm just setting up an activity log for...

Thanks, CJ, but that results in the same problem I'm having now, where no zero values show at all. What I am hoping to achieve is that zero values from calculations do not show in the cell, but that directly input zeroes do appear. For example, if cell C3 contains the formula =A3-B3 and the...

Hi all. Is there a way of having zero values that come from calculations (SUM of blank cells, etc.) to be formatted that the cell will appear blank but ... if a zero is entered directly into a cell, the zero shows? I get tired of having to use "=IF(SUM(A1:A10)=0,"",ELSE) or the like. This...

Thank you. Though I didn't get an answer, I did learn that I'm too f-ing stupid to communicate clearly enough for a "super moderator."

... Yes, I understand that. However, my real question is how to get the database to do it. So if I have a table with records 1,2,3,4,5,6,7,8,9,10 and tomorrow my extract has 4,5,6,7,8,9,10,11,12,13 what I want to have happen are the following: Drop 1,2,3 from the table (or the query...

Hi all. I'm working with an A/P department that is using "legacy technology" and has no capability for maintaining notes on invoices due, etc. I'd like to give them a database that would provide them with the features they need, but I'm running into a conceptual snag. I am able to extract...

Ahhh... the syntax. Thanks again, Jeff. I understand its purpose and it does work great. I was able to modify it to my need here and I see potential for many more applications. It's a matter of familiarity I guess. Is there a list of common VBA applications in Excel... an FAQ guide, so to...

Jeffrey: That appears to be EXACTLY what I need. In fact, I have numerous applications for this. Fantastic. THANK YOU. I do have two additional questions, though. I understand what is happening, but I don't understand this line: If Not Intersect(Target, Range("D2")) Is Nothing Then Can...

I was asked by a coworker if this is possible, but I cannot find a way to get around a circular reference problem. Simplest example I can think of is this: Let's say you have three related values such as radius, diameter and circumference. Is it possible to have three cells with these values...

Hi CJ. Thanks for the help. That seems to work great except it forces me to choose from the drop down or it thinks I'm adding a new record and stops me. I've attached my simple database. Thanks again. Tom

Hi all. I've been away from Access for a long time now and am struggling with a simple concept. I have a simple table, with two simple accounting fields: Account and Number. The Number field will have unique values and I can use that as a key field. The Account field holds the names of...

Is it possible to use the items on the shapes menu, or to draw shapes myself and use them, as the reported item in a vlookup? In other words, if I use the letter "a", I want a certain shape shown... "b" to give a different one, etc. THANKS for any help!

Thanks guys... with your help I have figured it out. To find the starting points for the subsequent "Principal" entries, I use the example above for the second one, and laid them out in a single row. To find the ending point, I used the FIND function to find the close parentheses that follows...

Thanks for the response. That gets me to the first and second iterations of the word "Principal"... so would I have to have 14 nested FINDs? Can I even do that? Also, what I want reported back is the name that follows, and those names will vary in length. Isn't there a way of asking for the...

HI all. A friend of mine asked for some help on this and I haven't been able to figure it out. He extracted some text from a PDF file, pasting it into Excel, and needs to find certain pieces of information. Problem is, the text came out as a long string instead of being broken into cells...

Hello. I appreciate any help on this. I would like to set up a "teaching" database that will display a set of related images together in random order, and require the user to put the images in correct order. I was able to accomplish this (strenuously - what a mess all the hidden columns and...

Hi guys. I want the output to show in a sheet called Handout, in column AP, starting in row 1. Tried the following. Works GREAT! Thanks again. Sub FindCells() Dim LookingForColor As Long LookingForColor = 255 Dim RR As Long RR = 1 Columns("AP:AP").Select Selection.ClearContents Dim R...

Hi Mihail. Thanks. Your code does find the red cells, but the report-back is a series of message boxes with the numeric values of the rows and columns showing where the red cells are. What I need is a listing of the cell values of the red cells. Is it possible to convert, in the code, the R...

I have a mass of cells, all of which contain numeric values. A subset of those cells have a certain format, specifically a fill. Is there a way of identifying the values in those cells with the specific fill and reporting them out in a list in another area of the spreadsheet? Thanks for any help!

Holy cow! That worked. THANKS! I have, for a long time, thought of myself as a pretty high-functioning Excel user. But then... I get jammed up and am given a simple solution to a seemingly difficult problem, making me realize just how little I know. Thanks again. This worked great!