- Strength to Increase Rep
- +0
- Strength to Decrease Rep
- -0
- Upvotes Received
- 1
- Posts with Upvotes
- 1
- Upvoting Members
- 1
- Downvotes Received
- 2
- Posts with Downvotes
- 2
- Downvoting Members
- 2
44 Posted Topics
 | Please, I need someone to show me the correct synatx - code to FTP a file (in an Access table) to a server. The access table contains the following information: Open 10.8.44.34 Username Password File path - sourcefile destinationfile Quit. I tried to run the code below and I get: …  |
| | [B][/B] Hi all, I am trying trying to make both the "Tab Key" behave as the "Enter" key. keys. In otherwords, both the Tab and Enter should acheive the same objective. I am using the code below but only the "Enter" key is working, but the "Tab" key is not … |
| | Hi everyone, I have a weired situation right here. My module was working perfectly all along. This morning I tried to run and got a run-time error: 1004 Application-defined or Object-defined error on this line of code. [code] With xlWksht.Range(Cells(ii + 1, 1), Cells(ii + 1, 5)) [/code] Below is …  |
| | Good morning everybody: I am attempting to populate a listview control on Form Load() and I get a Run-Time Error: 380 - Invalid property value. Below is the line to generates the error: [code]lvw.ListItems(lvw.ListItems.Count).SubItems(1) = OutlookAddressEntry.Address [/code] Below is alos my entire FormLoad module: [code] Private Sub Form_Load() Set OutlookApp … |
| | [B][/B] Good morning everyone, can anyone give me example of how to programatically copy an existing database to another location and rename the copied version - sort of a backup. I have a database name "DbProd" which is located on a server, and I want to copy this database to …  |
| | Hello everyone, I have an exce spreadsheet called "ProjectStatus.xls" in my local folder "C:\ProjectStatus.xls". I need to send it as an attachment to someone and I am using these codes: [code] Set OutlookApp = CreateObject("Outlook.Application") Set OutlookMail = OutlookApp.CreateItem(Outlookmailitem) OutlookMail.To = "giftxtian@yahoo.com" OutlookMail.Subject = "Project Status" OutlookMail.Body = "This is … |
| | [B][/B] I am trying to display/open MS Access report and I get: [B]RunTime error 2486 - You can't not carry out this action at the present time[/B] on this line of code:[code] DoCmd.OpenReport stDocName, acViewNormal[/code] Below is my module: [Code] Set rsUnclaimedRptqry = dbUnclaimed.OpenRecordset("SELECT DISTINCT tblUnclaimed.L1L2, tblUnclaimed.PassNumber, tblUnclaimed.EmployeeName, tblUnclaimed.Status " … |
| | [B][/B] Ladies and gentlemen, I have an issue inserting records into my new table Output table is: [B]"TblProgrammersHours".[/B] In this table, RequestID and ProgrammerInitials are combined to form my Primary key - so each has unique value. input tables are: [B]"TblRequests" and "TblPersonnel"[/B] Note: I was not able to attached … |
| | [B][/B] Hi all sorry for the inconveniences, I just wanna get this syntax thing out of my back. I modified my vb module and now I'm getting[B] "Run-Time error 3075 syntax error(Missing operator) - query expression"[/B] Then it displayed this line of code as the problem line: [Code] 'TblPersonnel.[Name] = … |
| | [B][/B] Hello members, I am trying to execute the module below (SQL statement) and I am getting the above error: "Syntax error in FROM clause" on this line [code]Call db.Execute(strSQL)[/code]. When I hovered the mouse over the SQL string variable, it shows this line of code: [code]strSQL = "Insert Into … |
| | [B][/B] Gentlemen, I have two badly designed tables - I didn't design these table, they where passed on to me. The tables are so cumbersome I have to create a new table, to be able to use their data. [B]Please see attachments to have a clear idea of the table … |
| | [B][/B] [B]Ladies and gentlemen, first I want to wish each and every one of you a wonderful and prosperous new year.[/B] This is not really a problem. I am looking for an efficient and quick way to copy table content from one database to identical tables in another identical database. … |
| | [B][/B] Hello everyone, I'm not sure if this is the right place to ask this question. If not, could someone please direct me to the correct forum. Here is my problem: [B]This is a CPU scheduling math calculations:[/B] The following is a set of processes with the length of CPU … |
| | Hi everyone, I am attempting to access a database that is located in a shared server/ directory "K:\". Assuming I don't know where the database is located, how can I programatically tell vb to locate this database by searching all the network server directory? My database name is called: `PTS.mdb` …  |
| | [B][/B] VB6 - Generate a new/blank sheet each time I execute my program. Hello everybody, can someone show me the best way I can programatically generate a new blank spreadsheet for my report. Currently, I am populating a spreadsheet using access files (query). The spreadsheet template is located in my … |
| | Hi, I need help setting a spreadsheet printing Range because when I print, after printing the area with data, it prints additional blank pages. So how can I set my print range from "A1" to the last cell that has data? Example: [code] xlWksht.PageSetup.PrintArea = xlWksht.Range("A1:???????").Address[/code] Note: in the code … |
| | Hello everyone, I am creating an excel spreadsheet using VB 6.0. After running my program, I may process either one or more records, but when I printView and initiate a print, it prints the page with one or more records and prints additional unnecessary blank pages. How can I programatically … |
| | VB6 - Spreadsheet generates blank pages with no records. Good morning everyone. I'm sure everybody is now familiar with my non-stop posting with my spreadsheet issues. I am populating a spreadsheet/report using vb. I am using a query/table as my input files. The problem is even if program executes and … |
| | [B][/B] Hi everybody. I have a code that formats the "Comments" field row in my spreadsheet. The objective is to begin a new paragraph whenever it encounters a date field within the text data. Below is how it is currently formating the "comments" field in the spreadsheet: [U]Example 1:[/U] Comments: … |
| | Hello everybody, my program have been working and today I'm getting run time error 1004 - invalid number of arguments on this line of code: [code]mystr = "Comments:" & "'" & xlApp.Clean(Trim(rsin![Comments]))[/code] Also, I am getting a "Runtime error 1004 - unable to set the RowHeight Property of the range … |
| | [B][/B] Hi Members, please can anyone show me how I can write a blank line after writing each records? My intension is to space out the data in the spreadsheet for readability. So far the code I'm using is not doing it. Seem my module below: [code] i = 5 …  |
| | [B][/B] Hello everyone, I have a spreadsheet that has data in a report format. The last column "Description", has long text value which are all bunched up inside one cell. My intension is to merge(expand) the text to fill other cells (G, H, I) and make it readable. [B]See spreadsheet … |
| | Good people, Please can someone show me how I can add a permanent comment to the end (footer) of my spreadsheet. I want this comment to be visible when the spreadsheet is printed. I know how to add the comment on the spreadsheet that is visible only when you hover … |
| | Hello everyone, I am having a display problem within my spreadsheet. The data in the spreadsheet row is hidden. Looking at the spreadsheet, you will see that the row that contains the "comments" is hidden, but when you manually expand the cells, you see the data. I have a code … |
| | Good people, I need your assistance. I have a spreadsheet. My objective is to draw a line after writing each record. The purpose of this is for clarity - to denote the end of each record. Please see attachment for example of my spreadsheet and where I want the line … |
| | Hello everybody, My objective is to split a record, write 90% of the record on one row and write the remaining 10% on the next row(right underneath the other half). The spreadsheet was formated exactly the way I want it. Now I am using similar code and technique to format … |
| | VB6 - "FindFirst" with multiple search Criteria Hi everyone, I am trying to modify and expedite the execution of this VB module that was started by an someone else. If you look at the underlying module, you'll see that there are numerous nested loops(Loops within a loop). I understand that … |
| | Hello members I reading - Looping through a recordset (MS Access Query) that has 49 records. Note: the query is generate on the fly(dynamically). The processing is supposed to exit the loop at EOF but it keeps processing indefinitely (sort of an infinite loop). Does anybody know why this is … |
| | People, this is a wired one for me. I am executing my module and I am getting a compile error - "Loop without a Do" even though I do have a "Do". Below is my module: [code] ii = 5 ii = ii + 1 Do Until M.qBW.EOF xlWksht.Cells(ii, 1).Value … |
| | Hi Members, I am directly referring to you because you have firsthand idea of what I went through developing this little piece of vb apps. which produces an excel spreadsheet. However, the program is working perfectly okay, but when I make the spreadsheet visible or when I print the spreadsheet, … |
| | Good morning, I modified the code accordingly and got another "Run-Time error 1004 - Unable to set the RowHeight property of the range class" on the code below. Also, please look at the spreadsheet attachment. Is there any way I can get rid of the spacing(gap) that separates the line …  |
| | Hello all, I am populating a spreadsheet with data from access file. I am splitting each record into two lines so that it writes on two lines(some of the records writes on one row and the other half writes on the next row. I am doing this because some of … |
| | I am importing data from access file to a spreadsheet. One of the input field is a "comment" field with a full paragraph of comments. Some of the target cells in the spreadsheet displays "##########". But when I click on the cell, the Menu bar on top of the spreadsheet …  |
| | Good morning everybody. I need a quick direction here. A column ("Comments") in my spreadsheet that is is supposed to have text values is displaying: "#VALUE!" Note: my input data is coming from an access query. The underlined Below is the data in the "Comments" field in the query (recordset): … |
| | Hello all, I am trying to populate a spreadsheet with data from access query. Even though the recordset(input file) has approximately 49 records, only 1 record is written on the spreadsheet. What am I doing wrong? Below is my code: [code] Set rsin = M.DB.OpenRecordset("qBiWeeklyPeriodCombined", dbOpenDynaset) If rsin.RecordCount < 0 … |
| | Hi all, I need some input from you smart folks. I am populating an excel spreadsheet. Each time, I want to clear the spreadsheet content before repopulating it. I am using the codes below and it is clearing the first 3 rows in the spreadsheet and every other data stays … |
| | Hello everyone, is there a posibility that I can look up email addresses from outlook email address book instead of accepting email address from an inputbox or hard-coding it? See my codes below: Thanks. [code] SENDEMAIL: Set OutlookApp = CreateObject("Outlook.Application") Set OutlookMail = OutlookApp.CreateItem(0) OutlookMail.To = EmailID OutlookMail.Subject = "Project … |
| | Hello everyone, I am having a problem completing my outlook email setup through VB. I am gettin Run-time error 424 - Object required: Actually someone got me to this point, but I'm bumming out on this line: "[B][U]lvw.ListItems.Add , , OutlookAddressEntry.Name"[/U][/B] - basically all the lines that have the prefix … |
| | VB6 - Email attachment not working Hi, I wrote this program to send email through VB. The email is working okay but the attachment I need to attach to the email is not being attached. See my codes below: [code] Set OutlookApp = CreateObject("Outlook.Application") Set OutlookMail = OutlookApp.CreateItem(0) Set NSpace … |
| | Hi everyone, I have included a "Send mail" module in my vb module, but I want to accept the email address from an input box instead of hard-coding the recipients email address because the recipient may be different each given time. Below is my code: [code] SENDEMAIL: Set OutlookApp = … |
| | Hi everyone, if you can recall from my previous posting, I had explained that my "spreadshit does not fit into the same page", but I've now unraveled what the other programmer did to accomplish this goal: looking at the input table to my spreadsheet, he first used "queryDef" to generate … |
| | I have a spreadsheet that I populated from an access table (file). when I print the data in the spreadsheet, part of the data prints on one page and the other half prints on another page. In otherwords, I have to paste two pages together to see the complete record. … |
| | Good morning everyone - I am using VB6. I need your assistance. I used the "CopyFromRecordset" function to populate my spreadsheet. Some of the fields in the access file has date values and some has number values (integers), but after importing into the spreadsheet, the numbers convert to date values(1/1/1900) … |
| | Hello everyone, I am using VB6 to generate a report in Excel but I am having a printing problem. I generated a spreadsheet using an access file. The data in the spreadsheet stretches all the way from Column A through S. When I print, columns A through M prints on … |
The End.