Search results for query: *

ANYONE HAVE IT TO SEND ME? I FOUND ON THE INTERNET A CCRP DATETIMEPICKER EXECUTEABLE THAT WHEN RUN IT REGISTERED IT AND SHOWED UP IN ACCESS REFERENCES. I USED IT WHEN THE MICROSOFT ONE DIDN'T RUN RIGHT. I REPLACED THE NAME OF THE MICROSOFT ONE WITH THE CCRP ONE AND THE FIELD FOR THE DATE...

I used instead CCRPDateTimePicker.ocx as it came as an EXE and it registered itself and it showed up in Access. Used similiar code as above.

I have a field on a form called ActiveXCtl42 to choose the date and I want it to update a field called "WeekEnding". The choose date field is using MCConCtl.DTpicker. "WeekEnding" is a date field. I used the code: Private Sub ActiveXCtl42_LostFocus() [WeekEnd] =...

In the Control panel/Internet Options programs/email/microsoft outlook. I have outlook opn and if someone address is @juno.com juno opens if @yahoo.com yahoo opens I want to open outlook with the email address on the send to line

One for Access 97 works but the one for Access 2000 doesn't. What am I missing?

Want to click on it to open message in Outlook with e-mail address inserted. What do I need?

Want to click on it to open message in Outlook with e-mail address inserted. What do I need?

Hunter, I went to the MS for the link you gave me. I do have Jet40SP5_9xnt installed and MDAC 2.61. I would have to look up on how to do the loop, I have only done it in a class. I do find that F0 pressed when back in the SubForm does a re-indexing. (I remembered it from 1-2-3, Excel, etc.)...

When I am in the Products Form it is based on the qryProducts. The SubForm based on query: Order Details Extended. When still in the Products form the new item does not show up.

In Access 2000 Northwind.mdb I have a "Enter new Product" Button on Orders Form and on the "New Product" Form (based on qryProducts) I have a "Save" and "Close Form" button. When back to Orders Form and in the Subform the New Product does not show up. I...

In Access 2000 Northwind.mdb I have a "Enter new Product" Button on Orders Form and on the "New Product" Form (based on qryProducts) I have a "Save" and "Close Form" button. When back to Orders Form and in the Subform the New Product does not show up. I...

Tyrone, I put it in the AfterUpdate along with code to deduct 6 days for the WeekBegin date and it worked. Thank you, Paul

Validate [WeekEnd] Date is only a Sunday I put in: = Weekday(1) as Validation Rule for [WeekEnd] on Data Tab and get error message. I used the Expression Builder to make it. Also tried DatePart("d",[WeekEnd])=1 and that didn't work. The WeekBegin Date is automatically done...

I did that before but productid then categoryid , productname.p Took out productid and only have orderid, categoryid, productname. It now works. Thanks. Solved

Invoice Report sorting of detail band by CatergoryName, Product Name Using Northwind.mdb as an example, I tried sorting the Invoices Query but that doesn't do it. I put Order By On in report and then Order By [CatergoryName], [ProductName] and that doesn't do it. I sorted the Order Details...

Had a brainstorm while driving in the car. (I do my best programming in my head then with a note pad handy.) I solved the problem of exporting fixed fields for the Grouped Orders and Order Details. The queries and parameters were all done with SQL statements. All the bands were done only in...

Access, Crystal Reports and R&R are good for paper reports but their text export adds extra spaces. Any suggestions on a third party report writer that has exact column beginning and ending alignment?

You may have to follow the thread of the formula which goes in the form. I am out of town and the computer doesn't have Access on it. Orders Form is base on Orders Qry. I believe Access just knows when the CustomerID is chosen to fill in the other fields. The Ship To is from the After Update...

Third Part Report writer for exporting fixed field text to mainframe. Crystal Reports and R&R are good for paper as they add a space between fields. Don't need space between fields.

Use the Northwind or Nwind sample from Microsoft. Go to Orders form and look at that code. Northwind is on the office CD or you can download.