Recent content by Happy YN

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!