Search results

I know I have used a reference add-on called Mousewheel.dll which disabled it totally. Again do a search here and the net. If I find where I got it before you, I will post it.

"Embarassing" twice now. Sorry about that. Trying to become a regular here and pick up some knowledge. Hopefully I will only be making coding errors and not making people errors. Sorry, tell him I said Hi.

I think this should work: NewDate = Format([OldDate], "mmm dd yyyy")

Embarassing how simply the solution is when you see it. I didn't even know about that function. After hours of playing around with it, it was solved in less than 2 minutes. Pat you are a good man. Thanks.

Sorry I may be missing something. I am definately not as smart as some of the other posters here, so their input is more than welcome to correct me. Is your form bound to a table, and does that table have a field called Active? As far as I know, you can not give control to a field that is not...

So by changing any field on the screen which is currently displaying a record from the Furniture table, you want a new record to be written with a new ItemID while not changing the old record? Is this correct ?

I was thinking of something along your lines as well. Private Sub cboDiv_GotFocus () Me!cboDiv.Requery End Sub I used a table with over 2000 entries and it was nearly unoticeable the requery. I updated a text field, and it was populated within the combobox as soon as I clicked on it. If I...

Does such an Data Source Exist called "Active", you did you just make it up?

Is there a reason you are running the Query every time you click on it. Are multiple instances being used and the data within the combobox is being updated minute by minute ? Have you tried to Requery it instead?

yes, go into design mode for the form. Then go to properties for that form. There is a Close Button Option (Yes/No) under format.

Neileg, Not to Hyjack the thread, but I am having a problem with doing a Query that involves Date and Time. Is there a way to do a Query and a Date and Time field only ONLY the date. I would like to Count the occurance of a date but becuase the field also has time within it, it does not see...

I am getting an automation error when using the combobox wizard, right after when I select the sorting order the error message comes up? Anybody know why, or if there is a fix for it ? Access 2003.

Ex? Office: Acme Corp. 1 Main Street New York, NY 10029 (212) 123-4567 Contacts: John Doe...... (All his Info) Jane Doe...... (All her info) John Smith.....(All his info) Something like this. And if you select a diffect office, it will have possible new contacts? A subform and a...

Off hand, I have to say No. If you have it set up as a Number field, then numbers are all you are allowed to enter. I could be wrong, just given my opinion as I do not know of a way to do that. I am sure that are work arounds for it. Do you use this field for any calculations? I often use...

If you are worried about your database since it is live, if you have a backup database, use that. You can also wait to try this when you know the users will not be using it as it may slow the databse up until it finishes. Have a Blank Excel Document Somewhere. In Access: To export data from...

So the old data is all on 1 line like? (1 Ex) John Doe 1 Main Street New York New York 10029 (2 Ex) John Doe, 1 Main Street, New York, New York, 10029 If your lines are the (2 EX) then it is easy, if it is (1 Ex) then it is going to be difficult. I can think of a little trick in Visual...

I know I must be missing something very easy here, but I am not seeing it. Perhaps my problem is how I am handling the original data. If you guys can give your ideas on how I should go about formatting that data correctly, maybe it will smooth the way forward. The original data looks like...

Please bare with my insanity of yet another question: OK, I got everything how I want it. If I want the last 2 weeks of sales, it will list: Vendor1.......1 Jan 2005........25 Vendor1.......2 Jan 2005........10 Vendor1.......3 Jan 2005.........5 Vendor2.......4 Jan 2005.........1...

Lol, sorry for having a conversation with myself. Everytime I finally give up and post my problem, I kind of find a solution. Line should read: strlinkcriteria = "Day1 between " & Chr(34) & StartDate & Chr(34) & " and " & Chr(34) & EndDate & Chr(34) & ""

Stuff is goingto drive me crazy. I got the Queries just like I want them, but now when trying to grab data with a Start and End Date, it keeps returning with blank results. Query3: SELECT VendorQ1.Vendor1, Count(VendorQ1.Vendor1) AS CountofVendor, Format([Date1],"dd mmm yyyy") AS Day1 FROM...