Search results for query: *

Where would that code go ?? Tom Moran Lansing, Michigan

I have a list box that is using the MultiSelect propery to allow selecting more than one listed Item. I also have a button on this form that will print a report based on the items selected in the list box. I would like to code an event that would CLEAR the selected entries from the list box...

Roy, I determined it by a watch smt and putting a STOP in the code. Tom Moran Lansing, Michigan

The sSql string is what is getting truncated ... Here is the code ============================================================ Set ctlList = Me.Units sSql = "SELECT tbl_Event.*, tbl_Task.*, tbl_UnitNames.* FROM (tbl_Event INNER JOIN tbl_Task ON tbl_Event.Event_ID = tbl_Task.Event_ID) INNER JOIN...

this is what ends up in the string sSql : "SELECT tbl_UnitNames.UnitName, tbl_Event.*, tbl_Task.*, tbl_UnitsAssigned.*, tbl_UnitNames.* FROM (tbl_Event INNER JOIN tbl_Task ON tbl_Event.Event_ID=tbl_Task.Event_ID) INNER JOI Tom Moran Lansing, Michigan

The problem is When I set the string with the stmt in the example it gets truncated. Tom Moran Lansing, Michigan

I have a variable that keeps getting truncated when I try to set it. Is there a limit to size of string ??? How can I get this whole string in a varibale Thanks for any help dim sSql as string sSql = "SELECT tbl_Event.*, tbl_Task.*, tbl_UnitNames.* FROM (tbl_Event INNER JOIN tbl_Task ON...

I need help in defining a form that will allow selecting multipe items (or just one) from a list box (?) to be included in a report. As an example. I have a table that is the source of a list box that contains a number of empl names. I would like the user to be able to select MULTIPLE empl...

I have an existing report that I want to automate creating an external rtf file. can this be done using an event procedure behind a command button. Thanks for any help Tom Tom Moran Lansing, Michigan

Iam opening a batch file as Output and using Print command to create a external batch file and would like to be able to use the USERPROFILE variable . EX I have a ftp script in a text file called ftpscr.txt I would like to be able to create a line in this file like this that would use the...

Thanks PHV That worked ... Tom Moran Lansing, Michigan

Hi LJT, There is no dec place prop for the List Box. I did verify that the merchant nbr in the db tabel is set to 0 dec places and format of Fixed. tom Tom Moran Lansing, Michigan

I have a List Box with a control source that lists a merchant number in my application. This control src is defined as Number(long integer) in my db. (The row source is a query) My problem is " the merchant nbr displayed in my list box appears with 2 decimal places. ex 591432.00 (instead of...

I have an external disk file that I want to read into a table and keep records in the seq from the original file. When I used Importdata command I lost control over the sequencing. Does anyone know of a command that would allow me to bld a tbl from this external data that would be in the SAME...

I have some code that I would like to set the path variable on within the FileDialog box. I have not been able to fig out how to setit . It defaults to the DB "default DB Folder" The following rtn works OK but its always used this def db location as the path. I want ot bea able to control that...

Iam using ver 2002. Do you know of any sample code that might be available as a template ??? Tom Moran Lansing, Michigan

I have an application that uses docmd.TransferText AcImportFixed ... statement I would like to be able to use code to open up a window to browse to the file I want to import with this stmt. I looked thru the FAQ's but could not find a solution. Thanks for any help on this one ... Tom Tom...

It was happening if the file already existed on disk. Tom Moran Lansing, Michigan

I have an access xp database that is displaying this Error mssg all of a sudden when my code trys to to a ExportFixed command. DoCmd.TransferText acExportFixed, "bai_format", "tbl_bai_format", "c:file.txt", False Any help would be greatly appreciated ... Tom Tom Moran Lansing, Michigan

I have a report with the ON NO Data event proc set to the following code: =========================================== MsgBox ("No data for this report today - report cancelled ...") Cancel = True ============================================ The msg box appears fine but after I click on OK I get...