Recent content by jegenes

Thanks a lot. I'll give that a go. --john

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...

Never mind about the last post. I found MsgBox in the VBA library. It's pointing to a file called: msvbvm60.dll I tried renaming other files as that one and using them. It fixed the MsgBox problem but caused other similar ones. I'm 90 percent sure that it's this file that's causing my...

One other thing... What object library would MsgBox be in? I'm thinking that maybe it's pointing to the wrong library. Thanks John

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 have a quick question with regards to this. How do you export a comma as text? In other words, how would you export a field that looks like this: 13245 and then attach a comma to it so it comes out in the text file looking like this: 13245, I've tried appending a comma with: & ","...

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 forgot to mention that the table prevents duplicate records by comparing 2 fields in each record. Neither of these fields is unique, so each can be duplicated by itself. In other words, if FieldA = 123, and FieldB = 500, you can only have one occurance of that combination. You can have...

Pat, I added a textbox with the control source as you suggested. ( =Count(*) ) As I add records to the subform, it stays at zero. But, if I select one of the records and delete it, the box updates to the correct number of records. So, I assume it needs to do some kind of requery in order to...

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...

You might try this: Go into Windows Explorer and find your database file. Right-click on it and select "Properties". At the bottom of the window, under "Attributes" see if the "Read Only" box is checked. If it is, just click it to de-select it. Hope it works. John

Yes, I would love a copy of that code. The R-L button idea is a good one. Exactly what I want. I'm really surprised that this isn't just a plug-in piece of code, that you could set up with the wizard. Seems like a pretty common application to me. Oh, and I should have said that I DO have 2...