Search results for query: *

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

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...

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

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...

is it possible to use the Common dialog without a form-- Never done--question asked by another programmer Thanks--

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...

Trying to pull last value in Table--and then increment by one--Here is code Private Sub DateRequest_AfterUpdate() Dim EDPTRACK As Database Dim RsTblProject As Recordset Dim MySql As String Dim strAA As String Dim StrDate As String Dim StrOut As String Dim Rstsx As Variant 'UserControl Value...

Have office 2000 installed--getting something crazy--when look at References under tools in code page get several copies of Visual Basic for Applications and two for package deployment wizard and a couple of others -- has this happened to anyone else--when installed did have problems...

get error Runtime error 2342-- A RunSql action requires an argument consisting of a SQL Statement Below is the code--started on this last week-- Trying to creat Unique ID Field--General Discussion tblyearvalue consists of two fields UserGroup Value UI-2001 1 AS-2001...

get error Runtime error 2342-- A RunSql action requires an argument consisting of a SQL Statement Below is the code--started on this last week-- Trying to creat Unique ID Field--General Discussion tblyearvalue consists of two fields UserGroup Value UI-2001 1 AS-2001...

Trying to create a unique identifier for a service request by requestin area--we input a two character code like UI then the date--(it pulls the year for the the next 4 blocks so we have UI-2001-XXX--want xxx be the next in line for UI or AS or whatever (about 10 sections)if have ui-2001-015 in...

Is it possible to use IIF to control backgound color of a calculated text box on a form--do not think conditional formatting will work--have tried--

started a VB6 project--want to use Access 2000 mdb--referenced to Version 9 of Access (2000) still will not work --have been working with both 97 & 2000--using VBA all time-can link to any 97 mdb but not on the 2000 version of same mdb--????? any ideas