Thanks for the replies:
arperry - My customer does not want to disable the Auto Complete feature in her browser as she likes it for other things. She has filled in a 'name' field incorrectly numerous times and blames it on auto complete, (which is BS if you ask me) so she wants us to try to...
How can I 'watch' a folder to move a file with a name that will vary from day to day?
The customer uploads a file to our server with the name "mmdd(cyclenumber)", where cycle number varies with no pattern.
I've got a timer that runs a stored procedure every few minutes to see if a file...
I would like to pad a text field (Address - lngth 50) with spaces, so that I can easily export to a fixed length text file.
What format/padding options are there within a field in an Access 2002 table?
Thanks...
Thank You Stew,
I see the concept of making the first letter appear in a field.
But how do I get the letter to print at only the first page of the 'A's', then the first page of the 'B's', then the first page of the 'C's', etc..
26 groups?..
Thanks, Shfog
--I am the Hub, you are the...
Thsanks for your reply.
I use Access 2002 and I can't find your reference in the Access Help section.
If you could be a bit more specific I think that would help.
If I got it to work for the group header, would I need 26 groups to make it work as an address book?
So far I have created the Address Book Report with Page Breaks at the end of each Section (A,B,C etc)
But I still don't see how to add an "A" at the top of the first page of the A's,
and then a "B" at the top of the first page of the B's, etc.
If I only had a brain...
My Goal: Address Book Report (Access 2002)
No Report Header-
Nice big text box with Letter 'A' or 'B' at the top of page for the A's B's C's, etc-
The info (a few pages each of the A's, B's C's etc)-
ForceNewPage at the end of each letters' section-
No Report Footer-
Any help appreciated-
Do I...
How do I change the output size of my report? I want it to be one column, 8.5 x 5.5. I can get 8.5 x 11 landscape with two columns (which is close to what I want), but I'm having trouble getting farther.
Thanks, Shfog
Choose the "Attachment Security Options" link by Ken Slovak. The other listed on the page may be good also, but I can only vouch for the Ken Slovak one.
Hello,
I had the same problem with Outlook 2002 not letting me recieve a database file that I needed. No options: It just wouldn't let me open it.
Then I found this great add-in from Slipstick Systems. It's free and I've used it for about 4 months with no problems.
It allows you to do what...
It looks like blank text fields in the VB are part of the problem. If all boxes have text, I don't get an error.
Is there a way to send the empty string as NULL in VB?
Or should I adjust my stored procedure? And how?
Thanks
steve@accucopy.com
The code below gives me an error message:
"Implicit conversion from datatype 'text' to 'varchar' is not allowed. Use CONVERT function to run this query"
Where and how do I use the convert or cast function?
In the VB Program? In the Stored Procedure? Where?
Thanks for any help...
I have some code that will allow me to pull data from a normal Excel sheet into a list view in VB.
Can this code be modified to allow me to select only certain cells (same ones each time) and put them into text boxes so that they can be modified or edited?
If conExcel.ConnectionString <>...
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.