Search results

I'll get back to her and let you know the outcome Thanks for all your ideas

but why just with no.1? and why does the text box accept it if is set for a number? Thanks

A user has complained that in one particular text box, if she types a "1" it shows as "!" and vice versa. This is only in one textbox and only if she types a 1 not 2 or 3 etc. moreover the box is set for numbers only yet it accepts the "!". The capitals or shift are not being pressed! I cannot...

A third party exe program which seems to have been created using VB or the likes, uses an Access MDB as a backend. When opened using WIN XP (on a PC with Access 2003) the form displays what seems to be a subform consisting of a grid which contains data and is populated by the backend MDB...

I am posting this as a separate thread even though I had tagged it onto another thread as I fear it may be missed! I would like to know whether there is any way for a module to convert all sheets of an excel file into csv. i.e sheet1 becomes csv1, sheet2 becomes csv2 etc. I have looked in a few...

opposite Just wondered how to do the opposite. I want to write a module that goes thru every sheet of an excel file and create a csv for each one. sheet1 to csv1, sheet2 to csv2 etc. Any ideas Thanks

Nope! tried all the options to no avail!! Help!! this getting beyond a joke!

Access 2003, Yes until now it remenbere the last setup (like the old 'save cofiguration on exit!) but now It has somehow forgotten. So where is the view which is the good old default view! Thanks

Until now , when viewing code for a form or report in vba, Pressing the relevant button opened vba with the project explorer,properties and immediate windows besides for of course the code itself. Now when opening I have to open each one seperately and it still doesnt look right even after I...

Hi Is there any way you could briefly explain a bit more about using html reports from within access? I want to replace tags using a record in the db into a predefined html webpage using code and then preview/print it do you have any method for this? I would appreciate your reply Thanks

Thanks! will test it out If it works - its just what I needed:) Thanks again

I have code which runs on the forms resize event. However I only want it to run when maximized not when minimized. Any way to trap this? Thanks

I think I've solved it! Thanks to your prodding I re-examined all the code and found that the command button switching between forms had docmd.minimize code in its click event so that when I switched to the other form it would minimze itself. As such, when the form was switched on again it was...

Nope! Doesn't work. firstly a label has no tab index and even when I set a text box to be the first in tab index it does not automatically get the focus when the form is viewed. Ajetrumpet you asked for a visual. what do you want to see? My code in form_gotFocus. the whole Db would be too...

If I set the tab order for a label (for example) to be the first, then could I run code on the get focus of that control? Just an idea!

Checked that Still no joy! Am I missing something obvious Thanks to you all for your interest

Thanks for replies! When clicking a control in form A, I pick up some values from form A (into public variable) and open form B and then set control in B to that value. That works fine if form B is opening for the first time but if it is already open, just behind form A I can't get the event to...

Thanks for the replies but I still seem to be missing something.:confused: My situation is that often I have two forms open and I am switching from one to the other. As I switch to "form B" from "form A" I want to set certain values in controls on form B. I am looking for the event which I can...

Thats helpful unclejoe BUT if a form has visible controls etc , what event can you fire so when a form gets the focus then a particular control should set itself to a value? The form can sometimes be opened on its own or sometimes be switched to from another form after being opened. Thanks again...

The following is a quote from MS VB help:- Note The Activate event doesn't occur when a form receives focus back from a dialog box, popup, or another form. My question is so what event occurs if a form gets the focus from another form? I tried the got focus event and put a breakpoint there...