Hi
I've got an Access form and I want the border of each control to be certain colour and width the control is active. I've done this by using ENTER and EXIT events for each one, but wondered if there is a more elegant way of doing this.
I've found examples where the active control format is changed, but none that revert the formatting when the control is deselected.
Cheers - Chris
chrisdavies
Last Activity: Feb 29 '08, 12:00 PM
Joined: Jul 11 '07
Location:
-
Access Form - Highlight Active Controls
-
Preview JPEG & PDF withing Access Forms
Hi Guys
I'm trying to display a preview of jpg and pdf files from within an access form. I've created a tool to copy files to various locations on the network, but need users to have check that the file is what it should be. Hope that makes sense!
I can't use an unbound object frame because this will not display jpgs in Office 2003 without installing Office Picture 2000 (or somthing like that..). I've tired the Activex... -
Update Specifc Record in Non-Referenced Tables
Hi Guys
I'm really stuck.
I'm trying to update a specific record in table1 with data from a specific record in table2. There are no common IDs in the tables.
Can I get write something that will update NAME in table1 where ID = 4 with NAME in table2 where ID =6 (for example).
Thanks for reading...
Chris -
Brilliant!!!! Cheers for that.
Chris... -
My short term solution is to check whether the created info fields are null. I would like something more robust though...Leave a comment:
-
Add user and time stamp only to new records?
Hi Guys - I've got a SQL Server backend and access front end.
I suspect this is pretty simple, but I want to add created by and when info to new records in my database, and modified by and when, when records are updated.
My question is, how do I get add the created details to new records ONLY. So for eg. if record is new...... then do etc.
Hope this makes sense.
Thanks - Chris -
Split Site with Slow Network = Slow Database :(
Hello!
I've developed an access database for a company split over two sites. The network connection is VERY slow between the two sites and therefore one set of users will be using a VERY slow database unless I come up with a solution.
They all need access to the same (live) tables at the same time.
Anybody have any ideas? It's making my head hurt.
Chris
PS I've already steamlined... -
Thanks for the help. The code is doing it's job but I've also decided to ask users to wait for light on the stick to stop flashing!
BTW - I'm doing this in MS Access.Leave a comment:
-
Kill Files! Pause code until files deleted?
Hi
I've written the following code:
ConfirmDel = MsgBox("Do you want to delete all files from the memory stick?", vbYesNo)
If ConfirmDel = vbYes Then
Kill FromPath & "*.*"
MsgBox "All files have been deleted. You may now remove the memory stick."
Else
MsgBox "You may now remove the memory stick."... -
Sorted! Thought I'd post what I found:
Sub USBLetter()
Dim oFSO, oDrive, objFolder, oDestination, oUsbdrive
Const USBDRIVE = 1
Set oFSO = CreateObject("S cripting.FileSy stemObject")
'Get USB drive letter
For Each oDrive In oFSO.Drives
If oDrive.Drivetyp e = USBDRIVE And oDrive.DriveLet ter <> "A" Then
oUsbdrive = oDrive.DriveLet ter & ":\"...Leave a comment:
-
Using Drive Names rather than Letters
Hi People! I use this site loads but this is my first post - so hope you can help!
I've got an access database and I'm writing some code to move contents of USB memory sticks to certain locations on the network depending on the owner of the stick and date and things like that.
The problem is how I get this to work on everybody's PC. The stick do not always have the same drive letter, but they do have the same name (KINGSTON...
No activity results to display
Leave a comment: