Search results

How would I grab a table column using a number rather than using the name of the column. I have a table with x number of columns and y number of rows. I would like to get the first column and put it into a variant. I would like to loop through and do this for all of the columns. I don't know...

How would I grab the records in a table, put them into a variant, and pass them to a custom function?

I have multiple db and they all do things. Is it possible to have a main access db that has form with buttons that link to forms in other db? I would like to have a button that opens the other ms access db or opens a form inside of it.

I would like to import and append a excel file to an existing table every week. The excel file has a bunch of non-important data at the top of the sheet. How would I create an import function to skip the first six or so lines and import starting from the 7th row?

I have a table of a years worth of data. date,sales data 1/1/04 , 2 1/2/04 , 10 1/3/04 , 6 . . . 7/1/04 , 9 I would like to enter in a date range. Ex) 1/1/04 - 2/1/04 and have the query print out the sum of the sales data by week. ex) week 1 , 30 week 2 , 50 If any one knows how to do this...

I have a table with sales data and a date associated with each entry. I want to create a query that will prompt me for a date range and then group the data by week. I am able to get the data to display for each day or grouped for the period, but I am unable to get it to group in 7 day week...