Search results

Is it possible to detect the Up or Down arrow keys? I've tried using the following in the Form's Key Press event; MsgBox "You pressed the " & KeyAscii & " Key" Which returns the ASCII code for most other key but not the arrow keys :confused:

Are you bored with the way the Access Forums look try viewing through the filter of this site :p

To make your code easier to read, please use the Code tag around your code, this will ensure that any code you copy and paste from your DB retains it's formatting making it easier to read and follow; Firstly click on the Code button, that's the button at the top of the posting window with the...

Not sure if this has been requested before, but a strike through font would be handy from time to time.

I'm having trouble with DLookup() using dates as part of a multiple criteria. I'm using the following; If IsNull(DLookup("ExchRate", "TBL_DDPExchRates", "CurID = " & Me.Combo4 & " AND ExchDate = #" & Me.ShipOBDate & "#")) And Me.Combo4 <> 2 Then It seems that if ShipOBDate is any date between...

I'm currently trying to print a report to a sheet of self adhesive labels (Avery J8163, 99.1 x 38.1 MM x14) I have the page set up with all the appropriate margins and columns. Now the report is a set of Cocktail recipes, that have a Group header and footer. The header contains the cocktail...

This sample demonstrates the use of the Not In List and On Double Click events of a combo box to firstly notify the user that the item they have attempted to enter is not in the list and that they should Double Click the Combo box to add that item. As a modification of the usual double click...

I have ten records each of which can be assigned a value from one to ten, but no two records can hold the same value so there are ten factorial combination. What I need to do is come up with a procedure to iterate through each of those 10! combinations (yes that's 3,628,800). I'm having trouble...

Out of curiosity I have been amusing my self by building a pop up calculator form. I have noticed that if I set an unbound field to zero (0) value, despite this fact, when the field is interrogated it returns a Null value :confused: How can I force this field to hold a value of zero rather...

I was looking at this thread last night and had, what I thought was, a good idea :rolleyes: I figured that if the various criteria where separated by, say a comma, or other readily identifiable charter, then you could use the Replace() function to insert the Or operator into the string. Then...

This cascading Combo box sample, is an example of a Post Code (Zip Code) database, with a State, Suburb schema (using a fully normalise table structure) with the ability to push back a selection from an unbound Post Code Text box. The DB shows how a combo box can cascade from an initial unbound...

My understanding is that Application.FollowHyperlink "should" open the hyperlink in the default browser. However on my desktop PC it opens the link in IE rather than Firefox which is the default on that machine. I'm sure there must be a setting that is forcing the link to open in IE, but I just...

I have set up a piece of code to makes the tool tips for a List box, show the contents of a memo field, that relates to the record in the list that currently hold focus. All fine no problems. My question is, is there a way to control the size and shape of the tool tips, or is that purely...

I've been having a play with the function posted here by ajetrumpet and have run into trouble with the line of code; Dim xl As New Excel.Application I'm getting a Compile error "User-defined type not defined" What should that line read?

This DB is a modification of a search tool that was posted in these forums several years ago. The tool allows the user to type text into a text box (the text is matched against any part of a number of fields) with the results being shown dynamically in a list box as the user types. Essentially...

I'm currently playing around with a very simple DB to decode text that has been encoded using a very simple transposition cipher. It all works fine, however I'm having trouble with carriage returns. I'm currently using the following snippet to detect and insert carriage returns, as part of a...

Looks very neat. I did however have to close and re-open the gallery page to get the camera model combo to refresh after adding a new model. A date picker would be nice on the image date. I presume the search functionality is a feature you are still working on. I like what you've done thus far.

Here's a link to a series of short animations shown on the Japanese MTV. It revolves around the misadventures of a couple of miscreant rabbits locked up in a Russian prison. A pleasant way to waist a half hour or so :)

Using the export to HTML function in Access 2007, is it possible to create an indexed version of a report. For example at the head of the report there would be the letters of the alphabet corresponding to the first letter of the name of the items in the report. Letters that did not have an item...

I have a DB with a FE/BE set up. The BE resides on my desk top PC running Access 03, under Windows XP. There is a FE on this machine and another on a lap top running Access 07 under Vista. There is also an identical set of image files that reside on both machines. The FE references the images on...