Hello,
First of all, I'm very sorry i mistakenly posted this message to the "articles" forum rather than this one and am unable to erase it from there. I apologize for the cross-posting.
Does anyone know a workaround for the lack of subroutines/functions in C shell scripts? I an unable to switch to Korn, Bourne, bash, et al. scripting as we have software that absolutely requires C shell scripts. I'm...
bbasberg
Last Activity: May 24 '07, 08:29 PM
Joined: Oct 31 '06
Location: michigan, U.S.A.
-
C shell workaround for lack of subroutines/functions
-
how to move text repeatedly in 360+ Word documents without opening them
Hello,
I have been asked to move a paragraph to a new location in over 360 Word documents. I was shocked to find out that changing an attached template will only affect documents produced from the template in the future. So it doesn't work like a style sheet, for example. But, I digress, my question is: is there a means in Visual Basic, or using a macro, or anything else that can help me automate this? I have no doubt the boss... -
getting value from another column based on a status column, with a twist
Hi,
I am wondering how to get a value from one column based on another, using visual basic for applications. Here are the criteria: The first column contains status and we want the next row in the list after the last row that contains "completed" .
The second column contains a value that I want to use in a chart. So, in other words, I want to automatically find the value in the second column that is in... -
It's me again :-) I have another clue:
Originally I had this line to begin the Function:
If I change it to:Code:Public Function ProcessFileImport(ByVal sFile As String, ByVal sTable As String) As String
I can Debug..Step IntoCode:Public Function ProcessFileImport()
Could someone please explain to this newbie why I cannot "step into" when I am not using a function with parameters...Leave a comment:
-
what could cause inability to "Debug..step into" code?
Hello,
I am a neophyte with Visual Basic but have been trying to hurry and get up to speed. I used to be able to "step into" code using Debug..step into but for the last couple of days I am unable to. Regardless of where in the code I place my cursor, I hear a microsoft error "thunk" and step into doesn't work. I am using VBA in Access if that matters.
here's one possible clue but it may just be... -
EXCEL listbox: carrying selected value over to amother worksheet
Hello,
I am wondering how to "carry over" a value from a listbox on one worksheet in the workbook to a cell in another worksheet in the same workbook.
For example, to just copy over a value from a textbox (as opposed to a listbox), this code in the destination cell does the trick:
='Source Worksheet Name'!E21
where E21 is the cell in the source (origin) worksheet that has the data.... -
good idea.Leave a comment:
-
Thanks anyway. I got it working. It turns out everything worked great once I saw that I was looking in the excel workbook the program was running from rather than the individual workbooks that I was processing. So the value in the cell of the incoming workbook was never being compared to the riskIndex in the Access database.
I REALLY learned the value of using strategically placed Debug.Print statements and debug with step into!! ...Leave a comment:
-
Thanks anyway. I got it working. It turns out everything worked great once I saw that I was looking in the excel workbook the program was running from rather than the individual workbooks that I was processing. So the value in the cell of the incoming workbook was never being compared to the riskIndex in the Access database.Leave a comment:
-
Thanks for the reply Adrian. Even though it's almost 1 am here I had to try your suggestion. I'm wondering about it though (after I got an error) because riskIndex is an index in the Access database while the range for the excel spreadsheet (actually it's just one cell) is called STRrtitle. The field in the database is called rtitle. It is only the index that's called riskIndex. Also, I have another reference to rs.index that isn't commented...Leave a comment:
-
Hi Raj,
I use this code (modify name of database and path (in 2 places) to suit your environment):
...Code:Sub ShowUserRoster() Dim cn As New ADODB.Connection Dim cn2 As New ADODB.Connection Dim rs As New ADODB.Recordset Dim i, j As Long cn.Provider = "Microsoft.Jet.OLEDB.4.0" cn.Open "Data Source=c:\yourdatabase_with_path.mdb"Leave a comment:
-
bbasberg started a topic Insert from excel to access works, update I cannot figure out the proper codein Visual BasicInsert from excel to access works, update I cannot figure out the proper code
I have been working hard to clean up my code but I am still wondering why all incoming records go to the "AddNew" part of the IF statement and never to the Edit alternative. I believe that it must be because my rs.index never really receives the value from the cell in the spreadsheet that it should use to compare to the corresponding field in the Access DB. I have named the field "rtitle" in Access and made it an index called... -
I have been working hard to clean up my code but I am still wondering why all incoming records go to the "AddNew" part of the IF statement and never to the Edit alternative. I believe that it must be because my rs.index never really receives the value from the cell in the spreadsheet that it should use to compare to the corresponding field in the Access DB. I have named the field "rtitle" in Access and made it an index called...Leave a comment:
-
Thanks, I will keep working but I am hoping someone can point me in the right direction as I don't really know how to compare the incoming excel data with the Access data to do the update. I really am lost as I've been trying for many days and still cannot get it. Any other gurus have any ideas or have solved this type of problem before?
Thanks....Leave a comment:
-
Thanks "killer" you are right. Toward the end I was getting desperate and trying things. Should I have two recordsets? How can I compare what is in the Access DB ("risk.mdb") with the record coming in from Excel? Each workbook with worksheet contains only one record. In other words, I'm looking at one incoming record from a single worksheet in each workbook in the directory.
Thanks. I'm going to be working...Leave a comment:
-
updating an Access DB with Excel data via VBA (am I off track here?)
Hello,
I have been struggling with this problem for DAYS and have googled my heart out as well as reading any books I could get my hands on but I cannot find any specific references to my problem. I have been able to successfully loop through a directory reading spreadsheets that insert records into an Access database. The spreadsheets in said directory are all of the same format but have different values in the cells. It's when... -
bbasberg replied to "triaging" records from external DB to either update or insert into local access DBin AccessMaybe I should ask one thing at a time instead of building such an elaborate scenario. How about for the first step I ask: Is there a way to "compare" two tables to see which records are new?
Thanks for hanging in with my long-winded questions....Leave a comment:
-
bbasberg replied to "triaging" records from external DB to either update or insert into local access DBin AccessHi Mary,
The external Access database will be a file that comes from another group, is cumulative, and refreshed daily with new records added and/or changed. I need to import the data and insert new records into our version of the database, and update existing records. There are extra fields in our local Access DB so it isn't an exact copy but it will have all the fields in the external Access DB. I don't think that's a problem....Leave a comment:
-
bbasberg replied to "triaging" records from external DB to either update or insert into local access DBin AccessHi again,
Did I make this post hard to understand? I'm a little sleep deprived so please let me know if I should rewrite this so that it makes more sense ;-) and it's clearer what I'm asking.
Thanks.Leave a comment:
No activity results to display
Leave a comment: