Recent content by usr_X

Access runs out of memory when I use the following code to create a custom mouse pointer, if the mouse pointer moves over the text box for any period of time. Does anyone know how to fix this problem? Help is appreciated. Declare Function LoadCursorFromFile Lib "user32" Alias _...

I have a continuous form in Microsoft Access and I want to be able to copy data from it like one would copy from a spreadsheet (or datasheet view in Access 2007), i.e. being able to select and copy any combination of rows and columns. If you can figure this out... Help is appreciated.

If you wanted to limit the input to an exact string: Private Sub txtInputTest_KeyPress(KeyAscii As Integer) Dim strLimitInputTo As String Dim intConvert As Integer lblResults.Caption = "ASCII = " & KeyAscii strLimitInputTo = "P,R,I,D,E" If Len(txtInputTest.Text) < Len(strLimitInputTo) Then...

I have been fooling around with label controls, unsuccessfully, trying to get a border to show on only three sides of the label. By changing the gridline properties I get absolutely zero change in the label's appearance. Not sure what those properties are even supposed to do. Help is...

http://www.access-programmers.co.uk/forums/showthread.php?t=176224

Re: How do I programmatically change a built-in picture? What I have found so far: As far as I can tell, Access 2007 doesn't name built-in pictures. There's no way to access a built-in picture with VBA. However, I have found a solution of sorts: Use the .PictureData property to select the...

How do I programmatically change a built-in picture? Access 2007: When selecting a built-in picture on a command button on a form the picture property for any chosen image shows "(image)", i.e. there is no selectable file name/path for the picture. However, I think that there must be a way to...

Maybe I need to be more explicit. I want to be able to programmatically select one of the built-in pictures for a command button. When I return the cmdButton.Picture value for a built-in picture I get the value "(image)", but not a name or path or other selectable value. So, is there a way to...

Is there a way to do this? Thanks, Usr_X

I was experimenting with listboxes and what could be done with them. Probably the functionality I was exploring is better left to sub-forms on a form. Which raises the question, where and why does one use a listbox? (Please keep in mind I am complete novice with Access as I, hopefully...

Paul, thank you. I went ahead and got it to work using VBA (I have a *little* experience with VBA in Excel). Below is my solution. However, I have this question: Is the OnCurrent event at the form level the only way to get access to changes in the navigation buttons at the bottom of a form...

I want to be able to display a combobox on top of a listbox (acting as a field header in a listbox to search the field and select the matching record). It doesn't appear Access will let you do this. Is this possible? Thanks in advance, Usr_X

I have a form with a listbox displaying data from a table. I want to move the record counter in the form when the related record in the listbox is selected. Help is appreciated (as I experiment on this problem). Sincerely, Usr_X

Is it worth learning Macros or better just to bypass that since, as one advances, your power and utility will come from VBA anyway? Thanks, Usr_X

Paul, this does exactly what I need. I am exultantly pleased; thanks for you help. However, I have found one important item to note. Dcount() returns #Error if the field to count is not a numeric field, e.g. Dcount("fldString","tblData","fldString <= " & [fldString] & "") returns #Error...