Thanks Veena. That worked too.
Have a wonderful weekend.
tgifgemini

Problem resolution:
Even though I have MS Access 9.0 Object library in my References, I have to physically create and instatiate a new Access object inside my vb code.



Dim MsAxs As...

Hi QVeena.
Is it a really a memory issue? No, I don't want the recordds to double each time I run the sql and populate the table.

Are you suggesting I delete the records in the table before...

I am trying to display/open MS Access report and I get: RunTime error 2486 - You can't not carry out this action at the present time on this line of code: DoCmd.OpenReport stDocName, acViewNormal
...

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

Okay, I'll do just that and give you guys a response. Creating another database and tables ain't no big thing, so it's not trouble at all.
Thanks.
tgif.

Hi,
No output was produced with this code:

SELECT TblRequests.RequestID, TblPersonnel.Initials, TblRequests.Prog1Hrs, TblRequests.PrevProg1Hrs, TblRequests.TotalProg1Hrs, 1 AS Positions
FROM...

Ladies and gentlemen,
I have an issue inserting records into my new table
Output table is: "TblProgrammersHours". In this table, RequestID and ProgrammerInitials are combined to form my Primary...

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 "Run-Time error 3075 syntax error(Missing operator) - query...

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 Call db.Execute(strSQL).
When I hovered the...

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

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.

...

Thanks guys.
your input was quite understand and implemented successfully.
Happy new year to you all.
tgif.

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

Thanks hkdani.
I've chosen an alternative way to acheive my objective and it worked perfectly:
here is what I did:

Private Sub CmdTableCopyUtility_Click()
Dim dbs As ADODB.Connection
Set dbs =...

Hi "hkdani" and BWV,
thanks for your input. However, is there such a syntax like database.movefirst or did you mean recordset.movefirst?

Also, PTSPROD and PTSTEST databases have about 15...

Ladies and gentlemen,
first I want to wish each and every one of you a wonderful and prosperous new year.

This is not really a problem. I am looking for an efficient and quick way to copy table...

Hi Salem.
Thanks for your input to my question. I took the time to look at some litteratures on this subject and I got the answers I needed.
I wish everybody in the forum a merry christmas.
tgif.

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:
This is a CPU scheduling math...

Sorry my previous post wasn't properly formated.

VB6 - Locate/Access Database in a Server directory

Hi everyone,
I am attempting to access a database that is located in a shared server/...

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

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

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

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

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

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

Problem solved.
The "Comments" field in my input table had null values, so I fixed it with this code:

If rsin![Comments] = "" Or IsNull(rsin![Comments]) Then
mystr = "Comments:" & Chr(10)...

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: mystr = "Comments:" & "'" &...

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

Hi Binoj,
thank you for your insight and help. I achieved the objective by simply increasing the row variable by either 1 or two to skip a space or two before writing another line:

i = 6...

I changed the code to:

xlWksht.Range(i + 1, 1).Insert(Shift:=xlDown)


Then it says: "Compile error: expected ="

when I type in your code and try to compile, it beeps and hilights it in red.

It says: "Compile error". Expected: List separator or )", then it hilights the semicolon ":".

Hi Binoj,
my module is not accepting the syntax: "xlWksht.Range(i + 1:1).Insert(Shift:=xlDown)". Hence, it's not working.
Thanks.
tgif

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

Hi Veena,
Haven't heard from you in a while. I hope everything is okay with you.
Thanks for your input. objective accomplished.
Have a good day.
tgif.

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

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

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

Hi Veena.
Thanks for your input. I do apppreciate it very much.
Have a wonderful weekend.
tgif.

Hello,
I tweaked it with the code below to accomplish the above objective, but is there a more efficient way of doing it?


xlWksht.Cells(ii + 1, 1).Value = "Comments:" & Chr(10) & "'" &...