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

Skip, I agree with everything you say, but they are just not willing to do work in anything but Excel with the people in the field. My job is to make it work, to get the data into Access. My real issue is the fact that Excel cells, even when emptied, are no long null cells for Access, they...

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

The people created a very lengthy and complex workbook to gather data about a ton of characteristics about large buildings. They set it up in almost 20 different tabs (worksheets), each of which covered a certain aspect of the building. Things like insulation, cooling systems, types of motors...

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 would like to add to my original queston. In short, I want to run append queries in Access that will get data from an ongoing string of excel spreadsheets. By ongoing, I mean that they will continue to arrive over a period of time. In time order, here is what I foresee happening: 1. On day...

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 see the Event and should be able to make that work. I still have the send part of the problem to deal with. How to refer to the check box controls. In Access, each one would have a name and I could just change the property of the check box to make it be checked or not checked. I do not see...

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

Thank you for the help. I need to go read up on Countifs.

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

First, I should admit that I am not a SQL guy. I sort of understand it, but when I cannot use the Access Query interface, I need to go to books for how to adjust the SQL. I believe I have discovered an easier way to do this. If I first to a sub query, use the property and survey fields...

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

The r937 article is a good primer on relational database design. But I am really looking for very specific advice, not the general discussion in that article. I am still thinking that I need to just bit the bullet and add the extra field that indicates which version of the estimate each set of...

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

The short answer is that your second post is the answer. I have had similar issues with History tables for marketing purposes where users want to see all contact that has existed with a customer. When calling on a customer or prospect, it is important to see the notes from previous...

There are aspects of this database that are important and which I do not know about your data. But, with that said ... You should be able to first add the field to the customer table (an empty field with no data). Then copy the data from the field in the product table to the field in the...

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