Search results for query: *

Duane, your solution is simple, elegant and works perfectly - thanks! MajP: Thanks for your responses too!

I frequently use a combo box to select a person on a form. This allows auto-complete of the person ID, but also allows the person to be selected by name (the people are presented by ascending surname in the dropdown). The problem is that the values only fill in the dropdown while it is being...

Aha, so it needs to be PERSONAL.XLS!WhatFormula It works now. Thanks!

I agree. I wouldn't have built the sheet like this, but as I say, that's how I received it. That's also why my first step was to try to extract the hidden data using this function! It doesn't seem to be working though. I've used VBA quite a lot, but never to create custom functions before, so...

Thanks. I'll give it a go. I'm surprised there's no built-in function though. Since you ask, here's the reason I need to get at the formula: I received a spreadsheet that has lots of cells which use IF conditions on the cells next to them to return TRUE/FALSE, like so...

Should be a quick question. What's the function to refer to another cell's formula? eg. A1 has: =IF(1=1,"Hello","Goodbye") So the value of A1 is "Hello" In B1, I want to return the formula in A1 (or part of it, using left/right/mid). Like this: =LEFT(FORMULA(A1),5) This should return...

Maybe it was fixed in the service pack. Unfortunately it's on my work PC and I don't have any say in getting service packs applied! Thanks for trying it out anyway. I made my own workaround in VBA with a macro in my personal.xls. But I had to get it to skip any hidden sheets and stop at the...

Has anyone ever come across this problem, and is it a feature (with a specific reason) or a bug? (Using Excel 2003). I like to use the Ctrl+Page Up and Ctrl+Page Down shortcuts to move between worksheets (in fact, I have assigned these to buttons on my mouse). However, when I come to a...

I'm in the process of converting some databases from A97 to A2000 format. I'm getting some compile errors in my VBA where I've referred to a field name in a form's record source using me.[field name] If there is a control on the form with the same name, then it's fine, but otherwise it can't...

Thanks for the suggestions. Will keep trying! I need the checkboxes to display the current values, so they need to be bound to something. I might try replacing them with textboxes with some wingding tick/crosses and see if that helps.

Hi, I have a form that is based on a non-updatable recordset, and has a number of checkboxes. As the recordset cannot be updated just by clicking on the checkboxes, I have used VBA to run a line of SQL, which checks/unchecks the check box and refreshes the form. This works fine if the VBA is...

The 'Stop Previous Sound' option that you can associate with events & transitions in Powerpoint only seems to apply to .wav sounds that are associated with other events & transitions. I've got a sound object that plays a .wma file. This is set to stop after 11 slides, but the person viewing the...

I found this old solution to a query I had (it's astonishing that this is the only way to do such a simple thing!) Anyway, I have added the code to my Personal.xls, and the new commands appear in the cell right-click menu. However, they do not appear in the right-click menu if I am working in...

Lespaul: This particular database is for data analysis rather than for entering/displaying data with a nice front end. The only people who will use it are other 'experienced' users who need to build their own queries from the data according to whatever information requests we get. The table...

There are two reasons: 1. I am using this query to replace a table that had previously been made manually, so I wanted to keep the design of the table and its fields the same. I know that it makes no difference in terms of using the data; I just didn't want to cause any confusion for other...

Yes, I realised I can change the format in query designer, but that only changes the datasheet view of the query. The field in the resultant table still has Data Type = Number and viewing the table shows -1 and 0 values. I want the Data Type of the resulting table to be Yes/No so that when I...

Simple question. I have a make-table query that outputs -1 and 0 into fields to represent True/False values. If you make a table manually, and assign a field format to Yes/No, then when you view the table, you see checkboxes instead of -1 and 0. I would like the output table of my make-table...

CajunCenturion: This is what I wanted to do, but the error message was preventing me from getting to SQL view. I couldn't close the query because the other problem was forcing me to save (which I couldn't do, because of the error!). I should now be able to get around this problem, I'm just...

Thanks for that dRahme. The main startup form was, indeed setting setwarnings to false. I set it to true via the debug window and now it doesn't force me to save. Any idea about the SQL problem though? I don't know why Access should neglect to place square brackets around a long table name...

I'm having the weirdest problems with one particular database (Access 97) The first problem is as descibed in THIS thread. Access will not let me close a new query without saving it, and will automatically save a changed query without asking. This is compounded by another problem: building a...