Thanks Frank for the prompt response.
I can't place code on the excel sheet
because the Excel workbook is used online by
alot of people and the data is usually input manually
and I don't have editing rights on the workbook.
I have been tasked with automating the transfer of data
from an access Estimation program that I am writing.
I am new at VBA and don't know how to go about with the automation.
massamiya
Last Activity: Jul 13 '12, 02:58 PM
Joined: Aug 8 '10
Location:
-
How to export a row from Excel and save as a new CSV file?
I am trying to export a row from an excel sheet and then save it as a new CSV file but I have hit a
giant wall, any help would be highly appreciated.
This is the flow of my program.
First of all when the save button is clicked some data from a form is saved on the excel sheet since there is
need for users to correct or add on the saved data.
I want users to save and close the workbook.
And also want to save... -
Try to post my code in BYTES but can't
figure out how it is done.
Can someone give me an insight.
Thanks.Leave a comment:
-
[
Private Sub Form_Load()
Me.Caption = "【 Product Inventory List 】"
End Sub
Private Sub Form_Activate()
On Error Resume Next
DoCmd.Maximize
ClrScr
Me.Requery
Call UpDate_Click
End Sub
Public Sub ClrScr()
On Error GoTo Err_ClrScr
Me.Painting = False: DoCmd.Hourglass True:...Leave a comment:
-
Thanks indeed.
I am afraid I don't understand what you mean by
me sending my VB programs In BYTES.
The Show method you indicated earlier fails at compile.
I have a question,
Does "Show" and Forms![MyFORM].Visible = True both
achieve the same result of making a form visible ?
I didn't enclose the entire program just code on loading of
the form and filtering condition where I am encountering...Leave a comment:
-
ggeu;
Thanks very much for the prompt response to my
query. I am a newbie as regards programming in VBA.
I will try to edit my program and see whether it will
work based on my understanding of what you wrote.
Did you have a glance at my enclosed code to see what
I am doing wrong ?Leave a comment:
-
Focus doesn't Move to Main Form
Please help me.
I have hit a brickwall and can't figure out what the problem is
I have a main form call (Prods)and subform called Prodsub and both are unbound. I call the Mainform from a "start menu form" with the Docmd.OpenForm "prods" the mainform has a START and END date text box that the user has to input the date to filter data from a db with a query in the VB Code (not embedded in the form) and 3 Cmd buttons... -
Migrating data from Access 2000 to oracle 9i
Hi everyone, am a newbie and need help moving data back to
oracle from access.
There is an odbc link between access 2000 and oracle 9i
using the export command in access copied a complete table
with data to excel so that a user could edit it (delete and add records), I imported the edited table to access and want
to replace the linked oracle database in its entirety with the edited access version and don't know...
No activity results to display
Leave a comment: