I've never used a linked list in sharepoint and I've never created cascading combox boxes. I don't know if it is possible to make a SQL statement from the linked list if so how do you do it?
Linked list name is Systems Activity
I need to create combo box that drills down to another combo box
First combobox - Category
Second Combobox - SubCat
I've made the Category combobox bound...
jerelp
Last Activity: Apr 12 '10, 03:56 PM
Joined: Mar 11 '10
Location:
-
jerelp started a topic FORM - Cascading Combo Boxes from a linked list in SharePointin Visual BasicFORM - Cascading Combo Boxes from a linked list in SharePoint
-
jerelp replied to EXCEL: Highlight duplicate records from different spreadsheets in the same workbookin Visual BasicI have code for a single column on one spreadsheet but, how can i manipulate it to do what I need it to do
...Code:Sub TestForDups() Dim LLoop As Integer Dim LTestLoop As Integer Dim LClearRange As String Dim Lrows As Integer Dim LRange As String Dim LChangedValue As String Dim LTestValue As String 'Test first 200 rows in -
jerelp started a topic EXCEL: Highlight duplicate records from different spreadsheets in the same workbookin Visual BasicEXCEL: Highlight duplicate records from different spreadsheets in the same workbook
I need to make a macro that finds duplicate records in Column A in sheet1 and Column A in sheet2. If there is a duplicate I need both to be highlighted in red. If there is no duplicate in Column A sheet1 then color that record green. If there is no duplicate in Column A sheet2 color that record yellow.
the sample data is:
Sheet1
CONTAINER
ABC123
ABC234
ABC345
ABC456
... -
Thank you it worked perfectlyLeave a comment:
-
Where would i place that statement?
Hopefully this explanation will help.
I have one text box to one location of one excel spreadsheet
I have one button and that button gets the location of the file from the text box but it has to get 3 different locations in order to import all the data.
Example:
to Import file "test2.xls"
for table 2
it goes through ...Leave a comment:
-
Hiding error messages for DoCmd.TransferSpreadsheet
I have a form with one button the code for that button is
...Code:On Error Resume Next DoCmd.TransferSpreadsheet acImport, 8, "FuelConsumption NewData", Me.tb_FileName, 1, "sheet2$" On Error Resume Next DoCmd.TransferSpreadsheet acImport, 8, "Inbound NewData", Me.tb_FileName, 1, "Inbound Trains$" DoCmd.TransferSpreadsheet acImport, 8, "Outbound NewData",
-
Thanks! the file picker opens and populate the text box.
Now I've been trying to work on importing the data using a seperate button that gets the location of the file from the text box which the button uses and this code
...Code:Private Sub LPMH_Bttn_Click() Me.tb_FileName = strFilePath DoCmd.TransferSpreadsheet acImport], 8, "LPMH NEWDATA", strFilePath, 1,"March 09$"
Leave a comment:
-
I've also tried to use your code and made the button name: "btn_GetFileNam e" and made the text box "tb_FileNam e" I've also referenced to the:
"Windows Script Host Object Model"
and I'm still getting a compile error because "User defined-type not defined"
and it is highlighting
Here is the code that is on my button i've only change the location...Code:Dim fd As FileDialog
Leave a comment:
-
...Code:Private Declare Function GetOpenFileName Lib "comdlg32.dll" Alias _ "GetOpenFileNameA" (pOpenfilename As OPENFILENAME) As Long Private Type OPENFILENAME lStructSize As Long hwndOwner As Long hInstance As Long lpstrFilter As String lpstrCustomFilter As String nMaxCustFilter As Long nFilterIndex As Long lpstrFile As StringLeave a comment:
-
alright i understand. I am very sorry. Can we start this over again from the beginning and I'll try to be as specific as possible this time. I really do appreciate your help.Leave a comment:
-
It is now referenced and I'm still running into the same problemLeave a comment:
-
references is shaded grayLeave a comment:
-
i got a compile error
fd As FileDialog
it stated "User defined-type not defined"Leave a comment:
-
it says that strFilePath is EmptyLeave a comment:
-
I changed the location of where the file picker starts but, is there anything else I need to change? It didn't work for me. Sorry i'm a noob.
where would I include the DoCmd.TransferS preadsheet into my code. I used that before for my macro so How could I be able to select a spreadsheet in a workbook?Leave a comment:
-
Use a button to open a File dialog box to import a Excel spreadsheet
I need to create a Form that has a button and when you click the button it opens a box that lets you navigate through the computer's files and select a Excel spreadsheet to import that data to specified tables.
Note: I need to do this for 2 seperate Excel spreadsheets and 1 Excel Workbook (which contains 2 spreadsheets I need to import). and each import to a seperate table so in total there are 4 tables.
I don't know where...
No activity results to display
Leave a comment: