Recent content by AndyBannister

Hi, Here's a problem that I'm finding a little tricky. Any advice would be greatly appreciated. I have a main form with an embedded subform that displays a series of records in datasheet view. I want my user to be able to select one or more records, by dragging in the margin, and then click a...

Pat, That's odd. I tried it, and it worked fine. Andy

Actually I think it could be done. Have a look at: http://www.experts-exchange.com/Databases/MS_Access/Q_20335899.html Is the solution posted there what you were trying to do? Andy

Have a look at the thread I've linked to below. It contains one approach to this: http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=22070

Oscar, Play around with the LeftMargin property of the text box in question. That should allow you to create an indent. Andy

Hi, Put the following code in the Exit event of the control in question (and replace 'text0' with the name of your control): If [Text0] > 100 Then Text0.BackColor = vbRed Else Text0.BackColor = vbWhite End If That will do the trick for you. Andy

Mine tend to be at the level of moving or hiding fields and their labels in order to generate a "user customised" report --- I haven't dynamically added or deleted fields. Have you considered including all the fields you need on the report and simply hiding or revealing them as appropriate? Andy

Ray, Sorry, I misread your first post and thought it was a form you were having trouble with, not a report. In what way are 'parts of the report are edited/created dynamically' in such a way that Access wants to save changes? I'm working on a project at the moment that dynamically changes /...

Ray, Simple use the following: DoCmd.Close acForm, "Form1", acSaveNo, But obviously replace "Form1" with the name of your open form. Access will close the form and not save it --- just what I think you were after. Cheers, Andy

Alphanumeric characters are represented by a numeric ASCII code so, yes, it is possible to 'increment characters.' Without knowing the context of what you are trying to do, I can only give you few pointers. If 'Text1' is a string variable holding, say, the letter "A" then the following piece of...

You can return the name of the control that has the focus with: Screen.ActiveControl.Name So to test whether a control you are interested in has the focus and if so, move the focus elsewhere: if Screen.ActiveControl.Name="MyTextBox" then DoCmd.GoToControl "AnotherTextBox" EndIf Hope...

Harry, Thanks. I'd hit upon the idea of sticking an apostrophe (or space) in front of the field before, but wanted to avoid the user then having to do a search and replace in Excel to remove them all. The format idea in Excel is perhaps a better solution. But it's still annoying that Access...

Hi, Harry, No --- Excel assigns the imported field a type of "general". Turning this back to "text" makes no difference; it seems that during the import Excel decides this field is numeric and 'helpfully removes' the zero. Thanks, Andy

I've tried that and it doesn't seem to work. When the text field is brought into Excel, Excel treats it as a numeric field and strips off the zero.

I am running a report that produces a field containing ISBN numbers, a 10 digit code which often consists of a leading zero. I have no problem at all handling the leading zero in Access. However, the problem comes when exporting that report to Excel. My users normally just use the button on the...