Search results

hi, I need to send an Email to my users and in the body of the email put a hyperlink that directs them to their local copy of the database installed in a standard folder in their C drive. How Do I insert the Hyperlink? Thanks

Hi. ACCESS Databases can not be converted to executables, The ACCESS DB engine has to be installed in order to run the DB. If you plan to distribute an ACCESS Database to users that do not have ACCESS you will need to purchase MS Office developer. MS Developer Edition has a runtime Version of...

The basic principle is this: A DB has a table that store the DB objects names and time of last update. If I compare this table with a table on another database I can extract the differences and triger an object to appear ( in this case a button and a label prompting to update) for the user to...

I use this on my continuous forms in the "on Current" Event: Private Sub Form_Current() If Me.RecordsetClone.RecordCount > 4 Then Me.ScrollBars = 2 Else Me.ScrollBars = 0 End If End Sub that will hide the scroll bars and show them when a number of records (in...

Great example. There is another one HERE, Passing global variables to do some nice tricks.

well I use a Simple routine that executes a batch file whenever the system tables in my "Update" front end differs from the system table in the back end. I Compare these two Using a simple query. I have had no problem so far with 20MB Plus databases that excede the 20 Users. Dont know if...

Not sure about that, but I would guess that as the Database grows those linked documents will have an impact on performance. Compact and repair FE and BE. Compile all your code, and create a MDE so it will run compacted always.

Bringin back Old Thread Sorry to bring back this old thread... I've been searching the forums for this solution without success. I was able to write task into outlook from ACCESS, what I need now is to insert a nice hyperlink with the Access Front end location into the body of the task, So...

not quite sure if it works on 97 User Name: Ronald Reagan Password: Ronald

Sure, my mistake, I have ACCESS XP, let me prepare a version on ACCESS 97... I'll be back

A Sample Login Review Sample located HERE User Name: Ronald Reagan Password: Ronald **Disclaimer** This login does not provided user level security as ACCESS built in security does. (anyway I dont like ACCESS built in security)

Maybe?? OK, I don't know if this will answer your Question. If I need a Custom Message box that have buttons outside from the optional VB stuff and the like, what I do is: Create a form attach an image a message and the buttons with their appropriate Macros/code, and set the border as...

Mutiple selection is best handled by using List boxes, rather that ComboBox Type ListBox in the ACCESS help.

Yes, it does make sense, when I try to explain to others I use the example found on the car sales website, where you can select brand, and depending on that select a model, and so on... That is Combo Box Cascade update, do a search in the forum, and there is also an example HERE This is...

Possible Solution Hi, I am in no way expert on Unbound fields, but your problem could be solved by the use of an unbound form that gets data from different tables and then transfers the data once a save button is pressed... Maybe someone can step in and provide some light into this issue...

See Screenshot Looks Good, very good use of the tabs and colors. One question though: It seems to have a good ammount of info in just one screen, How is the performance? I am assuming you have this Db on a client server configuration with multiple users. What strategies did you implement...

Fat Bloater, I don't think that It has to do with the attachment at all, rather than with the troublesome ACCESS Security on your Db... Ask for help in the General forum, and do a search on the forum using keywords like ACCESS Security Chances are you will find an answer there.... I can...

LOL Are you serious? The sample has been downloaded 13 times, you are the only one that reports that.... Please explain further so I can try and guess the misterious magic that was set free once the Db is open...LOL

Just to close this thread see the resolved problem on a sample DB on a thread located HERE Thanks

A Db is worth a thousand words Is this what you are looking for? See code behind OK button on Login = Section PASSING VARIABLE There is also a module on the form... First open it and Look at it. User: Ronald Reagan Password: Ronald If it works for you, the Shift bypass key and see code...