Search results for query: *

I've got an Access 2003 database (on WinXP) that will occasionally start highlighting text fields where I have my cursor - from the right side of the field to wherever the cursor is gets highlighted, no matter where I click. I am not holding down the shift key. (Normally the cursor would just...

I am trying to electronically open an APG cash drawer through MS Access. It connects as a USB Human Interface Device (HID). I know how to and can write to USB ports (to tell the cash drawer to open, or tell a pole display what to write), but I don't know how to access or talk to an HID. It...

We just got a Zebra LP 2844 receipt printer. My POS system is in Access and it would be easiest if I could just print the receipt straight from Access. It will start to do this, but then stop after three lines and give me an error message (occasionally the error message is "out of paper", even...

Our scanner is a QuickScan QS2500 and can read most barcodes on things. Our barcode printer is a Cognitive DelSolLX. I am printing the barcodes from Access - I installed a Code 128 font and a 39 font in Access that I downloaded from the Grand Zebu site that has been recommened here before...

We just got a Zebra LP 2844 receipt printer. My POS system is in Access and it would be easiest if I could just print the receipt straight from Access. It will start to do this, but then stop after three lines and give me an error message (occasionally the error message is "out of paper", even...

I'm using an AutoKeys macro, and I want to use Ctl-1 to call a piece of code, but I want to be able to use the number 1 from the keypad. This is not recognized. Is it possible to use the keypad to call an AutoKeys macro? If so, what syntax do I use? Thanks.

I have a table with about 50K records. I'm trying to improve the performance of a query on the table, that has four criteria fields, triggered by KeyUp on a form. It filters the results based on what people are typing. My info is currently in an Access linked table, but I'm testing speeds with...

I want to change my MySQL server variable to ft_min_word_len = 1; and get have it not read the stopword file (ft_stopword_file). This is running on my website's webhost. It is already running and I believe they have the access to the config files.. I tried setting it through a query, and while...

Used code from How can I format my ListBox? faq702-5329 to create a listview on my form. It worked fine, but now it won't show any data. It loads it, the headers are at appropriate widths, and there should be records (my sql works fine in a query), and even will give the first record in the...

Currently my records are in a continuous form set up for easy scrolling. I can requery the records with keystrokes from textboxes above. This is too slow, however, and I'd like to move to a listview, which seems to work very fast and nice. The form is based on a query that combines four other...

I have a report of address labels, and the text boxes are set to Can Grow = Yes and that works fine (when the city/state/zip line is too long it makes a new line). Now, I need it to format the addresses in capital letters (I don't want to have the addresses be in capitals for anything else; it...

I want to filter a subform from an option group on the main form. Basically, when the Onclick fires for the Option group, I want to enter IfThen statements, so that if OptionGroup = 1, then filter the subform so that the Status field = "For Sale"; if OptionGroup=2, then Filter the...

I'm using a textbox to filter a subform, using the KeyUp event to refresh the query, and the space key won't respond. It will refresh the query, but immediately delete the space I just entered. I can trap the space key using the case is: (Case Is = 32 ' space) which allows me to type the...

I'm using a textbox to filter a form (thanks flo79!). I have the KeyUp event set for this textbox, so the filter is based on what is typed into the textbox and changes with every keystroke. However, the KeyUp event recognizes the arrow keys, and I don't want it to (I want to be able to...

I want my address lines to be centered on the label, but since I can't figure out how to do this automatically I placed the text boxes so they are in the middle. This works perfectly for three lines; a fourth is a bit low (and thus the whole address is a bit offcenter) but still OK...

This is probably easy, but: When I'm entering records, sometimes data in fields is similar and I want to have it carryover into the new record. (This is called a Sticky Field, in a different database I have.) Is there a way I can set this up to be able to click on the label, and have its...

I have a subform that shows all the records. Can I place a textbox on the main form that will filter the records in the subform? I'd really like it to query the filter with every keystroke, and not have to hit a "search/filter" button, but... Is this even possible in Access 2K?

I have a continuous subform that, when a record is double clicked, it pops up another form, which is essentially a more detailed record of what I double-clicked. On the pop-up, I have a button that will let me go to the next record (which matches the next record on the subform). Is there a...

I have a form called JPGS which I'd like to keep in list form. I know I can display this as a datasheet, or in continuous forms so it looks like a datasheet. I have the onDblClick event set so if I click on any record, it opens up the same form in Single Form/Edit mode, which is how I want to...

I know how to add a value to the value list for a NotInList event, but can I do this without having a message box popup to confirm? I would much rather have it be added without the user having to say OK. I can't figure out which, if any, lines I can take out to get this. Here is my code...