Search results for query: *

Need to build a database of all hyperlinks on certain webpages which contains the web address. Some pages have log-ins so I need to be able to put that type of information before building the list. I have tried a few code elements but nothing really builds the full array. Does anyone have...

I am using the code below to backup certain folders/files quickly. It works perfectly but it copies the all files, folders and sub-folders within a source directory to a destination directory but I would like to only copy those files based on some file date modified parameter. Where and...

Thanks Zion7, Why List1.RowSource = Mid(strRowsource,2)? I think I understand teh strrowsouce but the Mid? Thanks Greg

I would like to take three single dimensional arrays and populate a listbox on a form. Each array should fill one column. I got this code off line and it doesn't work either. Code Below. Not sure what I am doing wrong. I have used the additem, column and rowsource properties. Dim MyArray()...

I would like to take three single dimensional arrays and populate a listbox on a form. Each array should fill one column. I got this code off line and it doesn't work either. Code Below. Not sure what I am doing wrong. I have used the additem, column and rowsource properties. Dim MyArray()...

I have a calendar (popup Form) that I would like to populate a list box (or combo box). I am building timesheet for work where users input various items. Consider I will force users to only select Saturday, I would like two columns: 1) List of Days (Saturday, Sunday, etc)-Column-1 2) List of...

Worked like a charm. Thank you so much Greg

Roy-Vidar, Can you give the recipe for doing that. I tried the where. No luck. It acts as a filter. I need all the records. I would be interested in trying the extra form and hiding it. Just not sure how to do that. Thanks for any help Greg

I have a form that I would like to open based on a user input on another form. The problem is I need to open the other form not only on a specific record but the combo and lists boxes have to be activated based on that record. Form A (MDEP Form) is where users input data and then Form B (Score...

I still get one record but when I dump the SQL string back into the query I get all the records. It has to do something with the IIF? I read somewhere that you have to use the case when. Thanks Greg

I would like to capture (record) the first records ID number (which starts with 1830) so I can use it with arrays. The ID number is a field in my Score table. How do I record that first ID number as a variable (StartID)?? Dim db As Database, rs As DAO.Recordset Dim SQLString As String Dim...

I need to generate a SQL statement for use in a recordset via VBA. I have 89000 records but when I run the query in VBA Module I have one record. The problem is the IIF statement. So I tried to use CASE WHEN but I get a "Missing Operator" Error. Thank you for you assistance in...

Thank you for your help. I understand a lot more than I did yesterday Greg

Zathras, I tried to code this but based on my experience I am not able to do it. I have the array and I know how to swap items but not to the level I need to. Can you help me get the framework down. Thank you Greg

Thank you so much

Zathras, Because I read the data into the array and it changes from time to time I need a way to make it dynamic. So I would like to hard code it. The other problem I may run into is when it increases to 5 companies or more. If there is a straight-forward algorithm for permuting the elements...

I have an array with 4 Company's that each of a duration time to complete some task. Based on some calculations on each of the companies and the amount of subtasks the scheme has various total ending times. FOr example (Time in minutes) Company A 15 Company B 17 Company C 20 Company D 16...

There is something called "Johnson's Algorithm" that I am trying to implement using VBA. There are follow-on spreadsheets that are only useful if I know the order the vehicles are supposed to go through the priming/painting stages as an array (example: a,b,c,d or b,d,c,a, etc.)...

If anyone could help me I would appreciate it. I need to sort an the array below first by priming and painting times together. Meaning there will be an 8 dimesional array. I have the following data in Excel: Type of Vehicle Priming Time Painting Time a 1.25 1.75 b...

Thank you so much!!