Search results for query: *

They are opening a form to a filtered record from the parent form. I guess I could run a query as the recordsourse to only include the 1 record, but it is easier to just use the openfrom command with the filter option. Some of the the values on the new form opened refer to the parent form. If...

That mousetrap from papwaler.com works great for windows xp, but again, the ocx won't register in vista x64. Let's forget about the mousewheel for a second. Maybe there is a way just to prevent the user from going to the next record, even if they click the next arrow. Is there a way to capture...

What is in your table that lets you know the dog is transferred? Is it a yes/no field or a date field? Once you move a dog from untransfered to transfered, something would have to be updated, right? Make your report use that criteria. Does that make sense? If you make your question a little...

yeah, that uses the mousewheel.dll, which won't register with vista (x64)

Where are all you smart people at?

http://support.microsoft.com/kb/94397

You might want to put me.refresh after you update your last textbox (use the "afterupdate" option) and before you print. See if that works.

Put all that same code in the forms onCurrent event. Then when the form opens, or changes records, they will still be there. you may need to do an error check on the onCurrent, because if you go to a new record and your comboBox doesn't have anything in it, it might give you an error. Something...

use me.refresh. You can use it in the field's "afterupdate" event or anywhere that works for you.

Assuming your empid and and courseID are numeric, it should look like this instead. strSQL = "SELECT lnkCourseEmployee.EmpCourseID, lnkCourseEmployee.CourseID, lnkCourseEmployee.EmpID, " & _ "lnkCourseEmployee.DateComplete,lnkCourseEmployee.HoursTrained,lnkCourseEmployeeCompleted, " & _...

OK, So I've seen the demos all over the internet about the mousewheel.dll, and getting that setup in the load event and close event of the form. That works great for windows xp, but I have vista x64 and the dll won't register. So, I still need to stop the mousewheel from moving to the next...

Did you figure the query out? It looks like there are a few errors in what you posted. but if you figured it out already, it doesn't matter.

This might help, I needed to do the same thing you are doing and I simply created an append query that had the ID field of the query = to ID field of the form. I selected every field in the table except the autonumber field. When I ran the query, it added the exact record to the table and...

That showed me how to center the column headers, but I didn't see where to center the actual text in the columns. Any ideas?

Sorry, I posted this yesterday, but wrongly asked regarding a listbox. I actually need to know if you can center the text in a listview column? Thanks.

Is there a way to center the text horizontally in each filed in a listbox?

Currently, vertical lines seperate my fields in a listbox. Is there a way to have horizontal lines as well or do I need to change the control?

make sure your in your properties for the button that enable = true. Then in the onClick event for your button you do this docmd.setwarning false 'I do this so that it won't remind me I am about to append records docmd.openquery "YourQueryName" button1.enable = false 'this will disable your...

That worked like a charm, thank you. One more question. Is there a way to center the text vertically in the textboxes? In one control, I have notes, which expands all the boxes. In another control, I have a date field. And becuase the notes field makes all the other fields increase in size...

I'm not sure I can explain this, but I'll try. I'm trying to make the detail section look sort of like a spreadsheet. Meaning that there are rows and columns. Some of the "cells" or fields are set to "can grow" because some of the text is long and needs to wrap. The problem is that when just...