Search results for query: *

I have a data input form that is very straight-forward. I would like the user to be able to enter a name in the same form and be able to look up to see if there is already a record for that name. Is there an easy way to do this? Trying to think this through, it is possible there will be more...

I am stuck on an issue that revolves around the difference between a null cell versus an empty cell in Excel and Access. The scenario is that we have people doing data entry in many tabs in an Excel file, data which will then be imported into Access. In many of the tabs, we do not know in...

We have people in the field collecting data about buildings into multi-tab spreadsheets. (between 10 and 20 tabs total). We then want to copy this data into Access. I might try to do this a bit differently if given a choice, but I have no option but to have data collected in Excel and for...

I need to append data from a spreadsheet (many spreadsheets over time) into an access table. There are several aspects of this I am not sure how to do. First is that the spreadsheets have many tabs and within each tab are “tables” that contain the data. Thus, I believe that I need to...

I need to do two things in VBA that I do not really have a clue how to do and am hoping for specific advice. Fist, I need to use the DIR function to loop through a number of Excel files, perform actions from them one by one, then end the process when each file has been processed. Second...

I need to import data from spreadsheets into Access on an ongoing basis. I know how to set up the queries themselves. But there are 2 things I do not know how to do. 1. I would normally tell the query where to look for its data, that is the name and location of the spreadsheet. But I will...

I am spoiled by some of the functionality in Access when I use Excel, and am also amazed at what people have figured out how to do in Excel. What I would like to to in Excel: When I leave the current cell, 1. evaluate the contents of the cell I am leaving (essentially determining if it is...

I would like to to do oountif that counts instances where a value is between the values in two other columns. In my case, I am using time, but I suspect the format of the data is not terribly relevant. An example of the data would be the following in columns A and B beginning in row 1 (these...

I need to query a table that contains results of surveys for various pieces of property. One of the fields will be number, beginning with 1, that indicated which survey this set of data represents. I will definitely at times want the data from the first survey and that is an easy query. But...

I am trying to set up an Access database in which I am not sure how to deal with one set of data and would really appreciate suggestions of how to structure the table(s). The data in question is various expense items to repair/rehab condominiums. there will be other tables to do with tracking...

I have used Yahoo for a lot of email for a specific purpose. I would like to get a list of the email addresses of people in the inbox. When i go on line to ask how export the email from Yahoo, the general answer is to connect it to Outlook or Outlook Express and then export the email. And...