Posts
 
Reputation
Joined
Last Seen
Ranked #2K
Strength to Increase Rep
+5
Strength to Decrease Rep
-1
33% Quality Score
Upvotes Received
1
Posts with Upvotes
1
Upvoting Members
1
Downvotes Received
2
Posts with Downvotes
2
Downvoting Members
2
1 Commented Post
0 Endorsements
~15.5K People Reached
Favorite Tags
Member Avatar for tgifgemini

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: …

Member Avatar for evry1falls
0
297
Member Avatar for tgifgemini

[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 …

Member Avatar for zebnoon
0
3K
Member Avatar for tgifgemini

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 …

Member Avatar for AndreRet
0
320
Member Avatar for tgifgemini

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 …

Member Avatar for cschrishoo
0
468
Member Avatar for tgifgemini

[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 …

Member Avatar for kvprajapati
0
1K
Member Avatar for tgifgemini

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 …

Member Avatar for suba_wen
0
122
Member Avatar for tgifgemini

[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 " …

Member Avatar for tgifgemini
-1
537
Member Avatar for tgifgemini

[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 …

Member Avatar for tgifgemini
0
121
Member Avatar for tgifgemini

[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] = …

0
84
Member Avatar for tgifgemini

[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 …

0
76
Member Avatar for tgifgemini

[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 …

0
70
Member Avatar for tgifgemini

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

Member Avatar for hkdani
0
1K
Member Avatar for tgifgemini

[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 …

Member Avatar for tgifgemini
0
166
Member Avatar for tgifgemini

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` …

Member Avatar for debasisdas
0
136
Member Avatar for tgifgemini

[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 …

0
83
Member Avatar for tgifgemini

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 …

0
55
Member Avatar for tgifgemini

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 …

0
63
Member Avatar for tgifgemini

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 …

0
71
Member Avatar for tgifgemini

[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: …

0
53
Member Avatar for tgifgemini

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 …

Member Avatar for tgifgemini
0
518
Member Avatar for tgifgemini

[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 …

Member Avatar for binoj_daniel
0
204
Member Avatar for tgifgemini

[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 …

0
47
Member Avatar for tgifgemini

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 …

Member Avatar for tgifgemini
0
100
Member Avatar for tgifgemini

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 …

0
51
Member Avatar for tgifgemini

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 …

Member Avatar for tgifgemini
0
92
Member Avatar for tgifgemini

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 …

Member Avatar for tgifgemini
0
153
Member Avatar for tgifgemini

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 …

Member Avatar for tgifgemini
0
370
Member Avatar for tgifgemini

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 …

Member Avatar for tgifgemini
0
226
Member Avatar for tgifgemini

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 …

Member Avatar for tgifgemini
0
480
Member Avatar for tgifgemini

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, …

Member Avatar for tgifgemini
0
94