Search results

This is possible by buying additional MS Access Developer Software, which enables you to create "Runtime" versions of your databases for distribution to users who do not have copies of Access installed on their machine

I've faced a similar issue with regards to .bak files, and the most succesful way I have found is to restore it into SQL Server, using Enterprise manager - as suggested above. I believe you can get SQL Server 2K (for a single desktop) license free, and SQL Server works fine running on a normal...

Hey Len I was not having a go, honest! I too am guilty (on very rare occasiosns :) ) of posting before searching. I was just reiterating the existance of the search facility incase you were unaware of it. I hope that you have found a workable solution PJL

Hi Len I believe your question has been answered many times before in this forum, by previous posts. I would suggest you use the "Search Forum" option that resides over the "Replies" & "Views" columns on the main forum page & and the Sample Database forum, and search for various keywords -...

Perhaps suggesting the obvious, but it seems as though you have either a corrupted version of Access (a pain), or a corrupted version of Windows (bigger pain but not beyond the realm of possibility!). I would suggest that you backup your databases, uninstall Access and reinstall your version of...

In addition, in the combobox properties, if you ensure that the "Limit to List" property is set to Yes, then users can only select the chocies you set. If this is set to No, then users can overtype the choices you predefine in the drop down box. HTH

Cheers chaps Bert - I will try the vb code, many thanks kh - Thanks for this, but I have diabled all menus and command bars, and for an easy way for me view the modules, without having to re-enter the db using the shift bypass, I wanted to launch vb from a cmb button. PJL

Hey Does anyone if it is possible / how to open the "Code" (VBA Editor) screens for modules and forms from a command button? Instead of going through Form>Design>(Code Icon), I want to be able to access the code from a command button. Does anyone know the code to trigger the vba editor to...

Usually the best way is to provide an explanation of the problems / issues / questions and attach a zipped copy of your db - be sure to remove sensitive & confidential info - to your post Hey presto, your db and questions are public, and I am sure the resident Access geniuses that grace this...

All versions of Access ship with db templates, one example being "Northwind." If all you want is to see database structure, functionality and application, peruse these. As mentioned above, it can be quite hard to discern how to "do" - for want of a better term! - database design, creation and...

All the best Mark, but my comments come with no liability or warranty ;)

My work pc has both versions 2K & 97, running Windows 2000, and I experience no problems. The only slight nuance is that v97 was installed first, and so the registry keys all point to v97 whenever you try to open a database - regardless of what version the db was created in. All you need to do...

Upon FormLoad on Form A, I have [Forms]![Form A]![id] = [Forms]![Master Table]![id] which pre-populates a value (id number) from the Master Form into a certain field in Form A, so that a record on sub form that relates to the Master Table record have the same id. The code on Form B, to...

Hey y'all I have some code that runs upon 'FormLoad' of Form A, and I am currently writing some more vba that is to open Form A from a Command Button on Form B. What I want is for the code that is on Form A, to be triggered upon the clicking of the Command button on Form B. I am using the...

Damm you guys are good! Cheers fellas, and good to see a bit of the old 'fastest finger first'!!! PJL

Hello All As the 'FormLoad' vba runs code when the form is loaded, does anyone know if there is an equilivant peice of code for 'Record Load'? I have a form driven db, where users only have access to the forms - as all good db's should be! What I want to do is run a bit of code everytime a...

Col Many thanks for your reply. I just exampled 'Name' and 'Date' for the purposes of ease of understanding for this thread - my real field names are much more obscure!!! Cheers for the help, is now sorted :D PJL

Hello everyone Simple question, I hope! I have an input box that appears 'afterupdate' on a field, and I want to instruct Access to return the inputbox value to another field within the same form. eg Afterupdate of 'Date', inputbox appears and instructs the user to type in a Name, which once...

Gentlemen, as always, my thanks for your time and dissemination of your knowledge Regards

Hello all I wonder if someone can help me. I want force Access, as a program, to maximise upon opening, but not to maxinise the switchboard/opening form. I have tried to use an Autoexec macro function of "Maximise," but this just maxises the first form, and not the Access window. Any ideas...