Search results

See this thread for your answer.

I can't speak for 2007, but the similar message when creating an MDE in 2003 is almost always due to a dodgy line of code somewhere. In 2003, going into code view (ALT+F11), then selecting Debug / Compile... will not only attempt to compile the code in the same way that creating an MDE will do...

Blimy, what a busy thread this has been. To add a little more, Morphius, the example I gave you was a simple .mdb for testing purposes. I personally always split my database into a front end and back end, password protect the backend, then convert my front end to an MDE (Access 2003 here)...

I use a similar range of lockdowns for my databases, coupled with multi-user login screens. The attached example is a very simplistic, cut down version of this security, which might go some way to satisfy what you're looking for. It should be fairly straightforward to follow. Your guiding...

Aah, gotcha! Thanks Gemma. As always, you are a huge benefit to these forums :)

Sorry, I'm not too sure I get you. I know how I can easily test whether the tables are linked or not, but what I'm after is some kind of code or module that checks the BE is present before loading anything that would rely on said BE. If it finds it missing, I want to completely control what...

Ok, this is really just a general query more than anything, but I've been unable to find the answer either here on on the internet in general. I have a secured database. BE is password protected and all objects are hidden. FE is MDE, all objects hidden, shift disabled, special keys disabled...

Gemma, you are - as always - an utter and complete star! If had foolishly forgotten to close a Block If statement on one form, which ran fine in the MDB, but was clearly the cause of the MDE creation issue. Compiling localy from the code highlighted the exact problem, and now the project...

Right, this is the classic programmer's paradox. Day one, project compiles into an MDE without complaint. Day two, same project refuses to do so. I have an ongoing project that I'm writing for work. Various features/functions are being tweaked all the time, and everyso often I produce...

Update. I can now embed the webpage (which contains the XML returned data in the format of <fieldname>data</fieldname>) into a form. This works fine, but I'm still desperate to find a way to have VB - when I click a button - grab the data bit from off the webform so I can use it in the local...

Right, so I have a perfectly functioning database that works beautifully and is fully controlled. It runs on modal popups, and a variety of techniques have been used to prevent the users from ever getting to - or even seeing - Access behind. I have now had a request from work to add the three...

Indeed not; the Me.SetFocus was the remains of some form code that used to sit between the minimize command and it and set the focus to one of the popup forms, which got accidentally left in. It was missed as did nothing, but thanks for spotting it; now removed! :) However, the original issue...

Just a quick one. I have a split database written in Access 2003 with a ton of VB code running most of the features. The whole database works beautifully. One feature of the database is that when started, Access itself is minimized and the first form (a modal popup) appears on the user's...

Is something like this what you're looking for? As well as preventing the user from getting to Access behind the scenes, this also disables the trick of holding down the Shift key when the database is opening to bypass the startup routines.

Ah, fantastic thanks Gemma. Everything now behaves properly, with a log being saved and the listbox instantly updating to show the new log.

Two options: 1 - Macro On the Objects menu, click Macros, then New. Use the dropdown list to select OpenForm, then set your required parameters in the box at the bottom of the window. Finally, when you save the Macro, ensure you call it autoexec (very important). When the database is next...

Hi all, Hokay, I've been toying with this one for a while now, but would greatly appreciate people's advice. To keep it simple, say I have a form, frmDetails. On this form is an unbound text box, Notes, and a Listbox, ListBox, which is based on a query. The query calls all records in a...

Heh. Simultaneous post. As you were typing the above, I had just spotted my mistake of using rogue apostrophes. Apostrophes removed, now the check works! Thanks for pointing me in the right direction, pbaldy.

Thanks for the help, but I'm still getting nowhere. I'ver tried including code in the OnClick of my button: If DCount("*", "tblMembers", "[MemberNumber] = '" & Me![MemberNumber] & "'") > 0 Then MsgBox "This Number is already in use.", vbExclamation, "Error" End If but this...

One of my old databases allowed users to open a template in Word, which would then auto-populate Word bookmarks, based on the information in the form. You're more than welcome to poach my old code if it will suit your needs. You just need to alter the bits in red to your individual...