I am trying to see my query in Design View, but its only coming up in SQL (I am clicking Design View not SQL View).
I'm not that good at SQL so I need to see it in Design view. Anyone know how to fix this?
I have several formulas in different cells. I wanted to show the formula not the value so I thought of adding ' to =
I went to Home-->Find and replace--> = with '=
It did work
Then I wanted to do the reverse and replacing '= with = but I got error message saying could not find '=
I want to understand Developer-->Design mode and what is used for. I read this post
and Parry said: ""If you select the Control Toolbox to draw a control etc, you will notice that design mode automatically comes on.""...
This seems quite simple to me but i'm a bit rusty and i just cant figure it out.
I have a table full of orders (which gets added to) with
order number/garment type/design type/fabric colour/printing colour/size
i want to order them, starting with the...
I need to design a spreadsheet, almost a monthly planner to yearly to show
Key meetings per month by month /date
Attendees (same 4 people)
What’s the best way to design this? I’ve thought of various designs but they don’t include all info I need.
Any help on...
Apologies for my less descriptive title. There is more nuance to the situation, but I couldn't fit it in a short title.
The situation I am dealing with is this. We have a master takeoffs spreadsheet that we've created with about 8 different tabs in it. For the longest time there...
I am in the design phase and looking to get some ideas on the best way to design my spreadsheet.
We have a small private org that makes purchases and hold fundraisers. Some items we buy in Japanese yen and some we buy in US Dollars. We also receive Japanese Yen and US dollars. What is the best...
I'm new to this forum. I tried to look for related posts first but to no avail.
I created a userform with tons of (working) controls, uploaded to cloud and downloaded it on other conputers. The file's main usage will be on the userform. The issue is, on most computers, the userform...
I was wondering if this would be possible to do, and if so how to apply the correct steps in the power query to achieve it? The Query pulls a certain sheet from a workbook, lets call it sheet1, loads the contents of that worksheet, and then in column 5, IF there is the words "Lathe...
I've just released a very large project for my office and my first tester is the only person I can find in 6 different people that can't type or even select the only combobox in the workbook. The office is mixed running 2013 and 2016, I've found people can use this box regardless...
Out of Range
Hi I would like a function that will detect if a value is outside the design parameters.
DESIGN 1 is only compatible if the total size is between 1000 & 4000 inclusive. How can I write a...
- On the Insert tab, in the Text group, click Header & Footer.
- Under Header, click either the left, center, or right header selection box.
- On the Design tab of the Header & Footer Tools, in the Header & Footer
elements group, click Picture and then find the picture that you want to
Please help me with my problem about Switchboard.
I created my Switchboard with the usual process of creating a simple Switchboard. I used the Default Main Switchboard and i think there is no problem with that if I use that or by creating a new one. Then I input the items on the...
I have place a command button on a worksheet to run a macro, but when I click the button it says that it cannot find the macro. I wanted to delete everything and start again, but when I enter Design Mode on the Control Toolbar I cannot select the button, move it, or anything. Any advice would...
I just discovered what I consider a major flaw in the design of the Union (comma) operator. As illustrated in the workbook here:
The Sum function, when applied to a union of overlapping ranges, will sum the values in the...
When I create a custom pivot table design it shows under "custom" in my pivot table designs. But, when I close out of Excel and go back in...it's not there!
How do I save my custom designs to show up when I open Excel?
Office 2010 version.
Hi, I'm new here :nya: Pleased to make your acquaintance.
There is something not quite working about my VBA code and based on the results I'm getting from this function I suspect the problem has something to do with my Do Until IsEmpty() loop. It seems to me like it's only running once. Could...