Search results

Hi guys, I am really stuck on this and I would appreciate any help. What I have been doing in my code so far is importing an Excel sheet's data into an Access table in order to use the values imported for calculations. The end result of this code and all of the calculations in it, is a value...

Does anyone know what is wrong with this line of code: If Err.Number = 3146 Then 'For an odbc timeout SendKeys ["{F5}", True] 'pressing F5 so the code would go on End If I keep getting this error: Run-time error 2465, Microsoft Access can't find field 'l1' referred to in your expression.

Hi, I'm trying to get values from an Excel file by its row and column. The row and column column names don't change throughout different files, but their locations do, thus I cannot really search for them through their numbered/alphabetized location (D:8)...I can only search the values through...

Hi, my code works just fine but sometimes there's a run time error (i think that was it) where the user would just need to press 'F5' to keep it running. It does this bc I am using access and sql and my tables are kinda in both and there's no way I can change that. Is there a way of avoiding...

Does anyone know how to take values from an excel file, use them in a form in a database, and then go back to that excel file and add the new values to another place in the excel file? Do the value places have to be evenly spaced out? I already know how to take columns from an excel file and...

Does anyone see anything wrong with this line of code? It keeps giving me a syntax error. thanks. If DCount("[OrderNumber], [ItemNumber]", "[dbo_EntryStructure]", "[OrderNumber] LIKE '" & varCod & "*' AND [OrderNumber] LIKE '*" & OrderItemRep & "' AND [ItemNumber LIKE] '*" & ItemOrderRep &...

Hi, my code is behaving a little weird. I'm trying to store all the OrderNumber + Item combinations in 2 arrays and then because the OrderNumber column really contains 2 values I'm interested in, I splite it up and store that column's values in 2 arrays. So in total, I have 3 arrays. An array...

Hi, I have values in an array that are formatted like this: {00123-2396667, 46932-780, 8708-0987, 456-22} What I am trying to do is break/split the array into 2 arrays so the result would look like this: {00123, 46932, 8708, 456} AND {2396667, 780, 0987, 22} Does anyone know how to...

Hi, I am having trouble checking if the last array value is equal to 'D'. This is what i have so far but it keeps saying that 'subscript is out of range'... 'g' by the way is equal to 1. It just really means that there's only one value in ArrAC. If Not ArrAC(g) = "D" Then

Hi, I'm having trouble viewing values that exist in table 'tblTest2' to the user. The first set of code (below) doesn NOT work. Yet the second set of code (all the way at the bottom) DOES work. And by work I mean that it erases the old values and only puts the tblTest2's new values. The first...

Hi, I'm really stuck on this. Been looking at it for a few days now (even though I'm sure it's not that hard of a problem) and I would appreciate any help! Here is my code: Set rstt = CurrentDb.OpenRecordset( _ "Select Distinct RepId from CalculateTotal...

I was testing a part of my code that I'd modified and then accidentaly clicked save when I didn't want to do that. So in order to undo what I had just done, I quickly closed the database! Now my code won't open! Did I just lose all my hard work??? Please help!!!

Hi, I'm stuck on this one part of my code where I am trying to count values in a column called 'ItemQty' in table 'dbo_Item'. I only want to count the values with the associated values in column 'OrderNumber'. I am getting the values of 'OrderNumber' from an array. Here is my code...(it doesn't...

Hi, I'm trying to put an image into some kind of box soley for the reason to connect one box to another in a flowchart manner. Does anyone know how to do that? If not, do you have a better idea as to connecting 2 images to one another? Thank you!

Does anyone know what's wrong with this line of code? strSQL = ("INSERT INTO " & strTable & " Select c.OrderNumber, c.Item, c.RepId, p.ProductNbr, p.Name, [tbl_LBP_Sales Location Num].[Rep Region Code] FROM CalculateTotal c, dbo_PartNew p, [tbl_LBP_Sales Location Num] WHERE ([Structure]...

Hi, this is a really dumb question but I cannot seem to figure out how to open up the view of all the tables I have! There's no arrow or anything coming up when I slide the mouse over the sides to make it larger...please help:o

Hi, I'm trying to import an excel file that includes a column of Part Numbers that I am interested in. I am trying to import that excel file into an access table called 'TableForImport'. That table has a column called 'PartNumber'. Thing is it's not just one Excel file that I am...

Hi, I hope someone can help me with this. I'm still researching for help but thought I'd post it here. whichever one helps me get the answer the fastest I guess. Anyways, I'd appreciate any help. Thanks in advance. I realize the second if statement is incorrect since my code isn't compeletly...

Hi, How do I delete values in an array? I want to reuse that array but first I need to delete its values so I would start with Arr(0) rather than where I stopped off with the last loop at Arr(10) [assuming the last calculation inserted until Arr(9)] Here is my code: Set rst =...

Hi, I'm trying to put values into a temporary table for the user to view the work behind a returned calculated value. Here is my code: Sub SearchPartNumber_Entered() Dim txtPartNumber As Variant Dim rst As Recordset Dim rstt As Recordset Dim u As Variant Dim i As Integer Dim n As...