Search results

I have another embarrassingly simple question - how do I read a Table using the Primary Key? I have a Table (called ‘Sciflat’) which has a two-field Primary Key (‘Genus’ and ‘Species’). I want to retrieve the ‘Family’ of a specific genus and species. I thought the SELECT statement would do the...

I guess I should have been able to figure out the 'DoCmd.Close' statement myself but I am still a little new working with Access. The only change I made was that I put the code into the 'OnClick' property of the Command Button instead of the 'BeforeUpdate' property of the Form - works like a...

Just wanted to let you know that I convinced my supervisor to give me the go-ahead to install Leban's hack - works great! Thanks again for all of your help!

Cooool! I knew there must be a 'simple' solution to this problem. Can't wait to try it out tomorrow when I go back to work. Thanks again!

OK, I don’t think I am making myself clear as I am doing almost exactly what you suggest with no luck. So let‘s start with the ‘Close‘ command button. In the OnClick property I run a Macro which consists only of the ‘Close‘ statement so naturally when I click on the command button the Form...

To try the Leban’s solution I just created two dummy command buttons and copied the following code into the ‘OnClick’ Event Procedure of each button.. Private Sub Command14_Click() Dim blRet As Boolean blRet = MouseWheelOFF End Sub Private Sub Command15_Click() Dim blRet As Boolean blRet...

There has got to be a simple solution to this problem but I can’t seem to be able to find it… I created a Form to add records to a Table. There are Command Buttons to Save the record and Close the Form. I also load half a dozen fields with default values using the OnCurrent Event Procedure...

I was unable to get this to work but I don't think its worth pursuing further. I volunteer for a non-profit organization and much of their hardware and software is rather outdated (they're still running on Windows XP) and so we just try to make do with what we have. I think the simplest solution...

Hello, I created a Form to add records to a database and one of my users accidentally scrolled the Mouse wheel while on the Form. This action added several blank records to the table. Is there a command I can use to temporarily disable the user's Mouse wheel? Just curious. Thank you.

vbaInet - Just wanted to let you know that the following code worked great (and thanks for the tip regarding Intellisense) Me.CBZOOM.HyperlinkAddress = Me.DRIP You guys rock!

vbaInet - Thanks for the advice (I am still rather new at using Access). I did a little more research and I think Property name I am looking for is "HyperlinkAddress" (one word). I will give it a try on Monday and also look into your Application.FollowHyperlink suggestion. Thanks again for all...

I think I found a solution to my problem but I need one more piece of information... I created a Command Button ("CBZOOM") on my form and assigned the Hyperlink Address a value of "C:\Photos\07999.jpg". When I click on the Command Button it displays a Windows Internet Explorer image which I...

Hello, I created a Form where I display a JPG image using the following code: Me![DRImageFrame].Picture = Me.[DRIP] This works great. If I view the same JPG using "Windows Picture and Fax Viewer” I am able to zoom in on the image. And so my question is, is there a way I can zoom in on...

G37Sam - Just a follow-up for what its worth, if you change the property of 'sPath' from 'String' to 'Variant' the macro will not blow up with an 'Invalid use of the Null' error if an invalid path is used. Otherwise this is really a great and useful subroutine - a real life-saver. Thanks again.

vbaInet - Of course, should have thought of that. I will save the record before running the query. Thx.

Hello, I created a Tabular Form where each row has a check-box which the user can check if he wants to view the record in detail. I also have two Command Buttons which run Update Queries. One query checks all of the boxes and the other query clears all of the boxes. I also turned off the...

G37Sam - Works great! Thx.

Hello, I would like to check if a file exists before I process it. Is there a command or routine I could run which would determine the existence of a file if I provide it with a path\filename, e.g. "C:\Photos\01234.jpg"? Thank you.

spikepl - Sorry for not responding sooner. I could not get this query to work until I changed the plus '+' operator to the concatenate '&' operator.... MyField: [Fieldname1] & [FieldName2] & ... Thanks for the tip, this is much cleaner and will save me some diskspace to boot.

spikepl - That certainly is elegant alright. I will give it a try. Thx.