Have tried this --- just tried again -- did not work --
just looked at what I wrote and let me try to put it a little better--
user opens form --- it is a 6 tab form -- they go to a tab, go in and change or add some information there and then have to go to another tab (page) then come back and...
Have a multi-tab form--when go from one page to another want focus to be set on the first field--have used setfocus but does not work--
What is happening is that user tabs to text field other than
first and leaves form--comes back and cursor in field that it was left in--want it to go back to...
In Visual Basic when I insert the Common Dialog box it has the ability to use the file name of a diskette on the A: drive--In Access 2000 want to do same---however commondialog does not have filename ability--am I overlooking or what?
Currently when importing a text file with a currency field containing an implied decimal--access puts the decimal at the end and adds two zeros---does anyone know how to import this correctly--
Thanks
have tried to go to site quoted in reply several times--only been able to get to once--right after you posted--got away on other projects when try to go to now--not there
have you updated link?
I do this in a couple of instances with my inhouse databases--what I have done is create a query to pull the information that I need for letters and mail merge---
call procedure from cmdbuttonPublic Sub PrintLetter()
On Error GoTo Err_Startword
Dim Wrd As Word.Application, IsRunning As...
Having severe brain cramps this am--Have multitude of diskettes coming in from outside sources for reports--suppose to have one of two names like xxxxxx or yyyyy.txt (one name for each forma)--however of the 1500 we get about 750 do not have these names--are in correct formats but get kicked out...
Have done that problem is that form in in landscape print and barcode for scanning purposes must in left margin--have tried to slide everything over and put in cell that is clear but when try to do (with the size font)will not work-cell expands and causes rest of data to go to next page--so must...
Need to Print Identifier (Acct#QtrDateTypeofwork)in margin--sheet prints out landscape need to put in left margin needs to be barcode so can be read by scanner--
any hints, help, etc would be appreciated
forgot to mention that can not move further up on page because using window envelopes and address is in correct place--is legal type document so nothing can be changed, or shortened--
Thanks
If less than 6 rows of data will fit on one page--over six goes to two pages--can be from one to 20 rows of information on subreport- have done can shrink, etc
Have a report that is used as a letter--it pulls up Name, Address, city, St, Zip and the basic letter--subreport pulls up listing of certain items from another table--both of these work fine--to a certain point---if have more than five (5) of items starts to put signature portion of letter on...
Networked database---user said no one else in database--checked after was told someone else using system---the data he was working with is unreadable--have tried to delete gives above error--moved from network to individual pc--changed from shared to exclusive--still same error---
will not let...
Know it has most likely been beat to death but not able to find in forum--
Going from input date (input by user) want to calculate 30 days from then disregarding weekends and holidays--
any leads
Thanks
just some general help--does anyone know of a good book on this subject--getting ready to start a project where the user will receive diskettes--need to check for two file names (two different formats)--after checking for file name reads file puts data elements into a common table--then will...
Have about 45 databases in house that have developed--going to NT Shop--having printer problems--will not hold landscape setting for some reports--have multiple drawer printers and now the print schemes for upper , middle and lower are mixed up--(Different forms for each drawer) can not get...
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.