Recent content by gal4y

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