Search results

and as per usual my first attempt at attaching the file didn't work :D here's another go.

AHAAAA - sussed it. (and quite chuffed with it too!!!!) one easy way is to have each image hidden as default, with the startup image showing. so VNF (front image showing at startup) is visable, VNB (the alternate image) is not visable. VNF on Mousemove has the following code: Me.VNB.Visible =...

hi, thanks for the suggesiton. i tried but it seems to come up with the debug fault. I'm not quite sure i've done it correctly to be honest. from my understanding, the code [If Me.ImageControlA.Visible = False Then Me.ImagecontrolA.visible = True End If ] shoud be attached to a command...

Hello, Not sure if this has been covered or not, but i've been trying to get a form, with some buttons on it. What i want is to have the button show a graphic, but when the mouse is over the graphic, it change to a different one and also become active so that it can runa command when clicked...

hi, sorry - i didn't ignore the advice, i just thought i wasn;t clear of what data i was showing. Does this mean i'm going to have to totally re-design the database input table?

Hi, It appears my formatting was lost in the first post. Basically i have the following : Image1.jpg http://img155.imageshack.us/my.php?image=image1kf6.jpg Where 107 302 etc are the retailer numbers and RFS01 RFS02 etc are the question references. If possible i need to run a query to...

Hello All, I thought when i gave up on this it was just a Friday afternoon moment, but it seems to have lasted into today :confused:. I have a table with 242 rows (relating to retailer numbers) and 64 columns (relating to retailer answers to the questions. What i need is to be able to show...

hello, thanks for your reply. [Frm_main] is open when i run the CT query. the other query was just to check that the function should work, so the only one running is the CT query.

Hello all, I have a bit of a problem with my CT query. The normal query seeks it's reference from the code "[Forms]![Frm_main]![referencetextbox]" referencetextbox is a textbox on the main form of the screen and i want the CT query to look at this to then show detail. The normal query works...

Hello, Does anyone know the code for a html wweb page to open an access dayabase? the ref i have so far is: <td><p align="center"><a href="V:\Volkswagen Central Reporting\Primary Stock Database\Primary Stock Report.mdb"><img src="../Images/Image3.gif" but it comes up with the run box...

it's worked!!! that's brilliant. thanks for your help!

hi - i was loading it as the first command in the macro "autoexec". do you think it would be better for me to put it in the 'tools - startup - display form/page' then have it close as the last part of the running macros?

Hello All - I'm hoping this is just a simple one. Basically I have created a database where (what should happen is) a loading form/screen appears as the database runs some updating queries, then disappears when the macros and queries have run. One problem I have is that it runs the macros and...

that's a very good point, thanks for removing the dimness from my brain.

Hello All, I know i'm being dim , but my brain has hit a thought-trench. I have two table and need to compare data between the two and report the exceptions. Both TBL1 and TBL2 has two columns (C1 and C2) i need to reference against each other. I need to extract the following: Where C1 and C2...

Hello, I have tried to search the internet but keep getting confused. I have created a call-logging database in Access 2002 with various forms, queries, macros, reports and functions. What i need to do is make it a stand-alone program as some of the computers it will need to be used on don;t...