Search results

I've converted a 2000 database to 2007 and most of it seems to work okay. It's a small db, with 1 table, not very many queries or macros, etc. I'm just trying to debug a couple of small glitches and cannot get the "Run/Sub" to run in the code window. It keeps giving me a "Macro" window, where...

I've upgraded from Win98 to XP Pro. The 1st errors I got were "Unable to find VBA6.dll", whenever I clicked on anything on any form, etc. I reinstalled VBA6.DLL and it fixed that (almost...). Now I'm getting occassional errors when code executes, usually in a form. I've managed to narrow it...

I have a form that seems to auto-center itself when displayed. This happens upon update, or when changing to a different record, etc. How do I get it to display the top part? I have the auto-center turned off. I can't seem to find any VB code that will force it to justify from the top down. If...

I need to print a text field (an autonumber-generated field) on all pages of a form. The form has a subform, which gets filled with entries. If there are enough entries, it will spill onto another page for printing. I want the text field (on the main form) to print on all pages for that record...

I've got an index in a table that keeps users from entering identical records. It works fine. Upon entering an indentical record the Access message box comes up with the warning. I'd like to replace that message box with one of my own. How do I do that? Thanks a lot. John

Is there way to find the row count (number of entries) on a subform? Mine has 4 columns per line, which get put into its own table. I need it to figure the number of entries I've made so I can have it automatically enter that number into a textbox on the main form. I've tried to dim an...

I have a listbox (4 columns) on a master form that gets its data from another listbox. The user can select and de-select items. When I update the form, the selected data (rows) gets added to a table. 2 of the columns are ordernumbers. 1 of these is the autonumber that comes up on the form...

Haven't been able to dig up the answer to this, so I'll break down and ask it here. How do you go about deleting an item in a listbox, and then have the listbox update itself. In VB you can just removeitem the item in the array. Access doesn't seem to support this. Also, please note that...

How would I populate a listbox from choices made in a combo box? I want to be able to choose from the combo box repeatedly. Both boxes have 3 columns. Basically, I want the selected item in the combo box to be copied to the listbox, adding it to whatever is already in the listbox. Then, upon...