Search results for query: *

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

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

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

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

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

Hello all, I have a report that I need to create that needs solid gridlines around all of the detail line fields that I need to print. Any help with this would be greatly appreciated ... Thanks Tom Tom Moran Lansing, Michigan

I have a date fld that I need help in converting into a string using leading zeroes for month and day as needed. depdte(date/time) has date value of 9/1/2004 tried this but didnt work wsdte = Format(DatePart("m", Irs.Fields("depdte"), "00")) This returns: 9 I need it to...

Hi All, I have a FORM (tomsform) that has a combo box on it (Combo15) that I want to makek Invisible based on the value currently in another Combo box (discind) on the same form. Is there a way to set this conditional attribute ?? Something like If tomsform.Combo15 <> 'SUW' then...

I have changed the server that a number of access db's have linked tables to. I could not find an option that would allow me to modify my linked tables to the new system DSN name. Can this be done ??? Or do I have to relinnk every table again and point to the new sys DSN in that process.\...

I have a button on a form with code which opens WORD but I would like it to open a specific document when it opens. The file I want to open has spaces in the filename. ex "\\Treas_data_fs1\DATA\Senior Citizen\Letter.doc" Any help would be greatly appreciated ... thanks Tom Here is my...

I have a ? concerning a query that keeps giving me a "data type mismatch" when the qry runs. the criteria looks for 2 date flds being equal. One fld is from a table (data type = date) and the other fld is on a form as a text box with a format of short date. Can you help me with this ??? Thanks...

I have a database with multiple forms that req the same Button. My problem is when I copy the Button to the addl forms the event proc is not copied also. My question is: Is there a way to reference this ONE Event Proc from multiple Forms with the same button ??? I dont want to have to copy...

I have an app that I need to group multiple lines on EACH letter. I assume a grouping option could do this some way ??? Example of table with 3 rows pertaining to Bill: Would like one letter sent to BILL with all 3 amts in the body of the letter. bill,123 bill,766 bill,898 Example of Mail...

Any advice on where to obtain info on sqlsrv32.dll that s/b used with MDAC 2.7. The 2.7 install I did did not alter this ODBC driver and I need to know if a more current version is avail and how to obtain it. I chked MS web site but could not find a download for this there. thanks Tom Moran...