Search results

Thanks for comments GW and I am sure that your guess is not far off the mark. The reason that I think it's big is because it's empty. No forms, no, modules, no nothing - all deleted. I just started a new blank database and before I create anything it's 92KB so it seems to me that after deleting...

I'm no specialist but could it be a font problem? Do both computers have the font installed? If not, you might try using plain old Arial?

Solved: why does my mdb bloat? SOLVED - I Think!!!. Hi all, This is not about temporary tables or images etc. because there are none so I think it is about what Access is doing (or not doing) behind the scenes. I constantly Compact and Repair and I always work with a fresh copy when I make...

You are a Genius Sir. If Me.Dirty Then Me.Dirty = False Where does that come from? I would never have gone there and I still don't understand it but it works fine. Thank you. ps. I have a short piece of code that I use in continuous forms to mimic the Excel up/down thing. Dont suppose you'd...

thanks boblarson, i'll give it a try. I have found a soulition which is pretty ugly by closing frmMain when frmOptions is opened and then when frmOptions closes it re-opens frmMain. Also, am a bit worried about slowing the thing down as it's a be/fe setup over a rubbish network.

I have a parent frmMain with a subform called frmMainSub. On frmMain there are 10 hidden tick boxes that indicate if an option is required. The tick boxes are completed via a separate form called frmOptions which is opened by a button on frmMain. When I open frmOptions, tick a few and close...

Many thanks for the tips, I'll go back to the drawing board and change the stuctures. Before I go there is one other problem to do with code that is driving me nuts and I can't find this written up anywhere. I've had to remove every instance of Me.Refresh when used in a parent form (sub forms...

Hi Pat, Yes sure. It's manufacturing of special doors. At quote stage there is only a need for simple details like oak, sizes how many leafs (could be four folding doors and how many glass openings. At production stage there is more such as lippings hinges, up to 5 openings each with high...

Hi all. Great forum and a few of you guys stand out. I am just a lowly idiot who puts in tons of hours and definitely does it the hard and/or wrong way. I've searched and searched but I cant see a 'correct' way to go about this so heres my problem. Its to do with a Quotations/Orders...

Although 2003 will not make an mde from your 2000 code, I expect that it will run one created using an earlier version. Until you upgrade to 2003, try using your old 2000 version to make the mde.

Colby Let me know how it goes. Shout if you want my example. Mick

There is a way... sort of. 1) Create a single form that looks like a continuous one with no bound controls. 2) Add some (5 or so) unbound image controls and any other unbound controls you want. 3) Use DoCmd.GoToControl to skip forward loading the images (remember to use "If Not IsNull(ImageID)"...

Hi, How about trying... Me.Filter = "Country = " & myCombo 'or Me.Filter = "Country = " & myControl ' either would go in the afterupdate event of the controls ' you still need to turn the filter on with Me.FilterOn = True 'follow with Me.Refresh 'or Me.Requery Mike

Try *2003* or Like "*2003*" or Like "*" & 2003 & "*". Good luck.

I've created code for dissecting email bodies that removes carriage returns then puts them back in a uniform manner (different browsers send various bodies) so that a function can extract the data. It's pretty yukky as I'm a novice but it works fine. I'm sure the split method sounds the way to...

Thanks. I'll have a read and be a better person.

Not secure but educational Heres a very basic way. It’s not secure and can easily be hacked by opening the table and looking at the password. Another way would be to use vba code to put a small file on the hard drive which only you know about. That would have the added bonus that Access...

Dont go there. Its rubbish and if you use stuff like DCount or Requery etc. you'll want to kill yourself.

When I use the following to bring up the print dialogue, the report prints and the report closes but then everything hangs. The system line says “Formatting page: press Ctrl-Break to stop” which is useless anyway because all you can do is crash Access. Does anyone have any bright ideas, I need...

combo columns Hi Jason, I've always succeeded by refering to the columns of a combo. Say you have two columns but the first is hidden ( width = 0cm;2.5cm; ) containing ID then Names. To get the value from Names (column 2), use mycontrol = mycombo.column(1) or Dim myvariable, myvariable =...