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...

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...

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 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...

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...

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...

I would like to know the SQL to delete the first record in a table/query. I need only keep 10 records (calculation data) in a table. When it gets to 11 records I would like to delete the first record. What is the SQL to do that. The table is called tblzeroize with an ID field and time...

I would like to make a two dimensional array based on a combo box select. I have a table (XY Pairs) with three fields: capability, X Value and Y Value. I need to do some computations but it must be in an array first. Capability is a number (1 to ??), X and Y values are also numbers). If...

I have users input a list of alternatives for specific functions in their project. Example (The letters represent the alternatives): Each alternative takes up one cell in Excel. Function 1 Function 2 Function 3 A B C D E F I would...

I would like to make a table of a predefined query. An input box (text box) on a form asks the user for the table name and hits a command button to make the table. This is to archieve the query each year. Is there an easy way to do that using code? Thanks in advance for any help. Greg

I would like to compare an inputted Birthday (ShortDate) with today's date. Display in a query the birthdays within 7 days of today's date (before and after Date()). Thank you for any assistance. Greg

Is there any way to take records from two tables and make historical records from them. I have tried the append and delete queries but the table has duplicates after two rounds. Is there an easy way to do this. Thank you in advance Greg

I have a form that has the main form from a conference table that holds conference data (location, dates, name, etc.) and a sub form that show the people that will go to the conference (conference_coverage table). There is one to many relationship. If you add a new conference on the form the...

I have a query based on a form. I have a Check_box that if check for all records of that query, I would like to delete the datefield (make it null) and then reset the check_box field. Can this be done. I am running an append query prior to this so I don't lose data. Thanks Greg

I would like to take the contents (record) of a form which displays the contents of conferences. The subfrom displays the people that will attend the conference. This is a one to many relationship (conference to conference_coverage). I would like to be able to send selected records to a table...

I would like to take the contents (record) of a form which displays the contents of conferences. The subfrom displays the people that will attend the conference. This is a one to many relationship (conference to conference_coverage). I would like to be able to send selected records to a table...