haltonbj
Last Activity: Nov 21 '06, 08:41 AM
Joined: Oct 20 '06
Location: England
-
There are viruses that can corrupt access databases. Have you run a virus scan -
One of the invaluable learning resources I have (other than this community) is Smith,R and Sussman,D (2003) Beginning Access 2000 VBA, Wrox Press
its a must read for newbiesLeave a comment:
-
Mobiles and messages
I have a Nokia mobile phone that I can connect via infrared and text individuals by typing a message from my portable.
What I also now have, is a club members database of both emails and mobile numbers of personal details of individuals The email from the Access part works OK, not brill but OK
Is there any way in which to link a text message from my access database to a text mobile phone in order to send bulk text messages... -
How to Create Help files
I'm new to access but I've almost finished a dbase and only need to split the data and finalise the security. I've even written a lousy word manual however how do I amalgamate/create the document as an individual help package within access
I'm sure there are many Accesseloreates that have done this but I've no idea where to start -
I'm only a newbie and there may be severe limitations using this method and perhaps it may be appear overly complicated but it works for me at least the 4 people I've tested it on.
I include a column in a member table of email addresses and a column email y/n and link this to the display of details in a personal details main form so that individuals to receive email can be set
I do a query selecting all individuals...Leave a comment:
-
I'm only a newbie myself and I don't know whether you can create a form however if you can create a new form and add a button called enable and then attach to that button
Private Sub Enable_Click()
Dim db As DAO.Database
On Error Resume Next
Dim prp As DAO.Property
Set db = CurrentDb
db.Properties.D elete "AllowBypassKey "
Set prp = db.CreateProper ty("AllowBypass Key",...Leave a comment:
-
Its a bit late now however I disable the shift key by using somewhere on one of the pictures displayed, a tiny hidden form that has enable shift and another somewhere else that has disable shift. But I backed up the db before playing with making the changesLeave a comment:
-
Thanks for your help I'm fairly new to access.
But only just found the problem and solution
It was the On error resume which should have also had On error go to 0
I used this method to seperate photos from main table. Makes it easier when photos are limited. I load a blank.jpg if there is no photo available
Solution works well, data is held as text in dbase and it saves lots of space. Not my idea ...Leave a comment:
-
Loading images and hanging access
I am developing a free resource offline UK swimming database under MS Access 2003 and I am trying to link competitors images via code in the main table to a form displaying other personal information.
The images are in the database directory and the photos are always named as the primary key.jpg but it was likely there would not be photos for each individual and so a dummy jpg file is loaded when there is none available.
A text link...
No activity results to display
Leave a comment: