Search results

DavidR, after using the code you suggested I was able to get it to work. I was using the expression and it didn't work - only the code. I don't know why but the important thing is that it works now. Thanks!

I only need to have leading and possibly trailing spaces removed. Trailing spaces don't seem to be entered to the table though, so it's mostly just the leading spaces. As for the combo box idea, I had thought of that and even had it in place at one point but it was not working well with what...

Thanks David, I'll give that a try, but that still doesn't explain why Trim() isn't working for me. Am I using it incorrectly?

I have a form on which users enter data. The text boxes are labelled F1, F2, F3, etc. and match the table name (box F1=field F1, etc). On text box F7, users are to enter a client ID and it must be exact - no spaces are allowed. I have set up that box with =Trim([F7]) on the AfterUpdate...

I tried that code on a form and it didn't work - the cursor up/down keys just moved horizontally. I tried to compile the code and I had a Variable not defined error on "adhcErrInvalidrow". Does it make a difference if I am using Access 97? [This message has been edited by ErikRP (edited...

Thanks Rich, I'll give that a shot and see how it works. I assume I would need to set this on each form?

Is it possible to (painlessly) allow users to have full control over their cursor keys? I have a few users who are very used to Excel and find it awkward having to shift between the mouse and the keyboard. They would like to be able to use the up and down arrow keys and have the cursor move up...

Thanks Pat, I think that's probably the way to go. My problem (and it's only one of many!) is that I have multiple forms and they are not always opened the same way. FORM A and FORM B need to be open for FORM C but I may just want to have FORM A open. I therefore can't have code in FORM A...

I should have been more clear on the process. To make matters more complicated, each of the first set of forms depends on some values from the other forms. To clarify: FORM A - looks at FORM B for values FORM B - looks at FORM A for values FORM C - independent for values FORM D - looks at...

I have several forms which use some fairly complex formulae to produce some results numbers. These forms feed one further form which uses the numbers generated in the first form. The user runs a macro which opens the first forms and then the last form. The problem is that the first forms are...

It worked great, David! That's 2 I owe you for this week! Thanks for your all of your help!

I have a similar problem and hopefully someone has a solution. I have a number to 2 decimal places, which is in percent. I need to round this number to the next highest tenth. For example: 91.10% = 91.1% 91.11% = 91.2% I know this follows no logical mathematical standard, but that's what I...

Thanks for the help, DavidR! I found this from Jack Cowley and it seems to be 99% of what I want. The only thing it won't do is populate the first field after I run the query - I have to manually type the first line - but for subsequent records it does the auto-populate. Works great...

I don't think I've changed things, but maybe I wasn't clear. I'll try again. Here is my table [BPO LONDON](simplified): BPO, QUARTER, OFFICE, ADJUSTER. Here is my query: SELECT [ENTER QUARTER (Q1, Q2, Q3 or Q4)] AS [Working Quarter] FROM [BPO London] WHERE [Quarter] = [ENTER QUARTER (Q1...

Hi David, Thanks for the links. The second example appears to be the most similar situation. I'll look at it a bit more closely in a few minutes... To answer your "counter-question", the value [WORKING QUARTER] is entered by the user: SELECT [ENTER QUARTER (Q1, Q2, Q3 or Q4)] AS [Working...

Hi David, It would give me the current date, but unfortunately users will want to view (and edit) previous quarters, which I don't think your solution will help. Isn't it possible to simply have the input value [WORKING QUARTER] as the default value? Well, it appears that it's not possible...

Hopefully this is a simple one for a Friday... I have a query as follows: SELECT [ENTER QUARTER (Q1, Q2, Q3 or Q4)] AS [Working Quarter], * FROM [BPO London] WHERE [Quarter] = [ENTER QUARTER (Q1, Q2, Q3 or Q4)]; I have a form that is based on this query. When the form opens it displays...

Thanks DavidR and Pat. The combobox seems to give me what I want. I'm not completely sure why the list box acts differently, but in any case I have what I want. Thanks again!!

When I say highlighting, I mean what happens when you have a list box and select a value. It is highlighted, i.e. the text and background reverses. Instead of my usual black text on white background I have white text on black background to show that I have selected that value from the list...

I have a form which is based on a query. One of the fields is a list box. When I open the form, the field that is a list box is highlighted. The form that I am using looks similar to a spreadsheet and has the same row repeated (different data of course). The list box in each row is...