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 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 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...
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...
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...
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?
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.
Need Third Part Report Generator as Access adds Trailing Spaces to fields and need no spaces between fields for upload to mainframe as Text file. Need to list one table (Products)in a detail band and one group (Orders and Order Details).
I am used to dBase copy to filename SDF that does it...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.