Search results for query: *

Just a little background real quick - I’m an accounting person by trade and tinker with access. The HR director in the state agency I’m working in, has to maintain 22 reports that are done in Word and Excel. The reports all contain variations of data pertaining to the Employees (personal...

I'm working with a contact database (I'm self taught so I use that term "database" loosely ;) ) and, I was asked if I can create a report based on a query that will show when a customer had a visit during a month... it's a visual thing for them. So, it would look like this...

Can someone direct me to some easy to understand directions/examples of how to create a data input form that uses selection boxes? Here is a made up example of what I'm trying to do... If I have contracts that I sign with my customers, and there are 5 specific contract types which a customer...

Sounds very strange, huh?? I think it is. I have a table with city names (tblMunicipality). I have a contact table where we list cities that we visit for work purposes(tblContacts). (The city is our client so to speak). I have a third table where we list the city and the conference they...

I had some help regarding how to count some items in a query. It's a contact log and I wanted to count the number of visits and calls made to our "clients'. Someone helped by creating a "count type" query which looked through the contact log and for each "client" would...

I have a question about queries that I hope someone can help with I'm working with City/Town's of my state in a customer like capacity. We see many of the cities/towns at events and also make visits to see them. 4 tables - tblCities (info like city name, population, contact person there, also...

I have a database where we input contacts we have with clients. Currently there is a field titled "contactedby" and we have sometimes input a visit by multiple staff as "Cindy, Don" or "Cindy & Don" but, I want to be consistent and want to be able to query how...

I have a contact database where I log a client and a contact date (Client and ContactDate fields). I then compare this table to a table of all clients to find clients that have not had a contact (null). What I'd like to do, if possible, is be able to pull the unmatched records that haven't had...

I created a contact database where I track contacts based on visits to a customer and seeing a customer at a conference in two tables (visit and conference). I ran two queries for both tables against a customer name table and pulled the unmatched on the visit and conference tables. This...

I am building a switchboard and have a button for the users to click to generate a report. Once the button is clicked, it gives the user the ability to enter a query parameter. However, if the "cancel" button is clicked on the parameter box, I recieve the "Run-time error...

I created a report which is driven by a query. I put the date parameter code in the criteria field. I get the start date and end date boxes just fine. Can anyone tell me how to make it so the dates are formatted in the boxes, and how to make a warning come up if the dates entered aren't...

I've been looking for a free script which when clicked on, it will open up an email application and the person just fills in the receiver's email address. The URL and the webpage is sent to the receiver. Any idea where I can find this? I noticed on on the following webpage and thought it was...