No luck with these suggestions unfortunately.. .I will be grateful to anyone who can help me with the connecting and linking from Access 2003 to Excel 2003.
Thank you.
ineedahelp
Last Activity: Jul 24 '07, 08:48 PM
Joined: Sep 11 '06
Location:
-
Trouble With Linking To Excel
Hi and HELP!,
I am using Excel and Access 2003. I am trying to create a link to an excel spreadsheet and append the data from a specific sheet called "PEJ". My error is runtime error 3125 "PEJ$" is not a valid name. When I perform these tasks manually it works...any help? Oh, I prefer to link because the spreadsheet data will change quite frequently and I will be performing this function on multiple sheets.... -
Thank you for your ideas...I have thought of this approach too. It seems so inefficient as I will only have 2-5 records in the subset at a time. I was hoping I could MARK the start and end of a new group of records (I have sorted my list so all matching symbols will be together) and return to the start point and RST.MOVENEXT through the list again and again as need be. I thought using a bookmark like feature could work, any thoughts on this or...Leave a comment:
-
I am basically cycling through records in a table. I need to perform some analysis and then depending on what happens here I need to perform a different analysis on the same subgroup of records. I thought I would use the bookmark 'function', but have been unsuccessful. The work around I found was using rst.movepreviou s by my variable 'counter'. Sorry for being unclear.Leave a comment:
-
Marking a record without bookmark?
Hi,
I am trying to evaluate data in a table. First I need to evaluate NotionalValue for Symbols that match. If it passes my parameters, I need to apply my "flags" to the flag field. Instead of using so many rst.movepreviou s and rst.movenext commands, is there a better way to "tag" a record so that I can return to it? I do not have a key field...symbol is my unique field. Also, with my current code, I am getting... -
I think I figured it out...for anyone who might have the same question, I used the following code to access the items selected in the multiple select list box:
...Code:Private Sub cmbRunSymbolSearch_Click() Dim varTable As Variant For Each varTable In Me.lstChooseTable.ItemsSelected Debug.Print Me![lstChooseTable].ItemData(varTable) Debug.Print varTable Next varTableLeave a comment:
-
I apologize for being so vague. I think what I need is actually quite simple, I just haven't done much with mulitiple selection list boxes. What I am hoping for is after the user has chosen "multiple" tables that I have made available through this statement in the row source of my list box:
SELECT MSysObjects.Nam e FROM MSysObjects WHERE (MSysObjects.Na me Like "LaB*") OR (MSysObjects.Na me Like "PAR*")...Leave a comment:
-
Thank you for all your help!...Leave a comment:
-
MULTILPLE SELECT list box
I would like to know how to use a mulitple selection list box to (1) select tables (2) pull data from each table using a query (3) and append this data to a temporary table to ultimately be used in a report. My guess is that is will look something like this...
do until "listbox number of items selected"
create query with first table selected
append data to temp table
loop
docmd.openrepor t.......... -
COMBO BOX...create with code
Has anyone created a combo box from scratch with vba in access? I would like the AFTER UPDATE event to create a combo box and populate it with items dependent on what the user selects. I know how to populate programatically , but haven't figured out how to CREATE the combo box programatically . Thank you in advance! -
Yes, it is an access database....Leave a comment:
-
MOVING tables to a backup database...
Does anyone have an efficient way to MOVE tables to a backup database using code? Thanks in advance for any help!! -
No Current Record???
I don't understand why I am getting the error message "No current record" at my code....Do While rs1!Symbol = rs2!Symbol....i t seems that rs1 has values, but rs2 is empty. Any help? Many thanks!!
...Code:Private Sub cmbFindLastEssentialData_Click() ' On Error GoTo Exit_MyProc DoCmd.RunSQL "DELETE * FROM LastGoodData;" strSQL = "SELECT DailyPrice.Symbol, DailyPrice.LocateDate, -
Thanks for the help!Leave a comment:
-
Dealing with NULL values in a recordset
Can anyone tell me if this is correct code? I have to deal with an occasional NULL value in MarketPrice. I am cycling through a recordset created by an SQL
If IsNull(rst!Mark etPrice) Then.... -
Unicode output...
Does anyone know how to programatically output a unicode symbol. My usage is that I want my query to have an IIF() statement that says "If X > 4, then display Unicode 2193 (U2193) in column called Results. I know how to do the query, but I don't know how to convert this U2193 to the "down arrow" symbol that it represents. Thanks in advance for any help! -
Yes, I did it and it worked! I actually changed the function given to work for more than 2 items! Thanks for all the support!Leave a comment:
-
I also like your function idea. I have never, but have always wanted to create a function. Would I create it in the modules area?Leave a comment:
-
To confirm...it is the MAX value I am looking for. My sql is:
SELECT Table1.RequestD ate, Table1.Symbol, Table1.Cusip, Table1.MLRate, Table1.TotalQty , Total1.TotalNV, Total1.JefRate, Total1.JefQty, Total1.QuadRate , Total1.QuadQty, IIf([QuadRate]>[JefRate],[QuadRate],[JefRate]) AS [Best Rate], [MLRate]*[TotalNV] AS [Current Cost], [Best Rate]*[TotalNV] AS [Best Cost], [Best Cost]-[Current Cost] AS Difference, IIf([Best Rate]=[JefRate],"Jefferies",II f([Best...Leave a comment:
-
Is there no MAX IN (list of fields) command?Leave a comment:
No activity results to display
Leave a comment: