Search results

I am working in Windows 10. I am wanting to set a default view for NEW folders as LIST view, DESCENDING sort without affecting existing folders. I asked for some help, but the "know-it-all" in my office ended up applying this view to my entire folder structure before I could stop him. "Oh, I...

I have a workbook with several sheets in it. Each sheet has macros to perform certain functions, like copy/paste, move input data to a table, delete certain cells' contents, etc. I'm concerned about hitting the wrong shortcut for the macros and running the wrong process on the wrong sheet...

Hi all. For a legal-case management database, I had tables parent OurFirmsTable and child OurLawyersTable. Using the FirmName field in OurFirmsTable, I would choose from a dropdown in a case-related form and pull the personnel list to be viewed in the form. Then, I wanted a table for...

Hi all. I have a call log in a subform (subform is based on a table). Simplest description is Date, Initials, Note. I'd like to sort on the Date descending, which I did in the OrderBy property of the Date control. But, I also want the new entry to be at the top... but it's at the bottom and I...

I need a query to use as the source for a combo box dropdown for a control in a spreadsheet-format subform. I have a table of firm names (FirmsTable) with a FirmName field, and a related table with the names of the attorneys working at those firms (AttorneysTable) with an AttorneyName field...

Hello. I'd like to make the short date format of mm/dd/yy as my default. When I search on 'setting short date as default' all I find is setting the short date format default in Windows, which is not what I want. Currently, when I type a date the format comes up dd-MMM. I don't want to...

I've been asked by a coworker if it is possible to display entries in a cell as if they were divided by 1,000. He does an extraction from his legacy database and pastes the results into excel. He *could* paste the data in another section and write formulae that divide by 1000 in his display...

Hello all. It's been a long time since I wrote my own database, so I'm getting jammed up on some things I used to know... and any help is greatly appreciated. I've attached my database as I have it now. I am trying to create what amounts to an activity log. I have created my main...

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

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

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

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

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

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!

Hello. I'd like to apply formatting to a cell, let's say A1, if the value in A1 equals the value in any cell in a range, such as A26:Y50 . So, for example... assume that cell A1 holds the numeric value "156". If 156 appears (cell value, not a portion) anywhere in A26:Y50 , I want the...

Hello all. Here's the backstory: I'm in the process of putting together a series of clues, physical challenges and locked 'treasure boxes' and the like as a series of 'quests' for my grandkids (aged 10 and under). I have cryptex-type locked items where they have to figure out the clues to the...

A couple friends of mine are trying to sell me on the idea of a registry cleaner to speed up my laptop... a desirable goal, by the way. However, in doing some research, I'm finding precious little information on these programs. Plus, the "reviews" sites concern me as they seem to be either...