Search results for query: *

I have an employee that I’d like to enroll in online Access classes. There are downloads involved in taking the classes from this particular vendor but the classes are in Access 2016 and we use 2013. In general, would anyone in the Tek-tips forum community know if importing objects from 2016...

In a query I have an expression that calculates a person's age based on today's date and their DOB. Is it possible to create another expression that calculates all these people's ages and gives me an average. Could I do this at the query level or do I have to do it at the report design level...

At my office we recently upgraded to Access 2013. All my Access databases are "timing out" and "freezing" on me after 15 minutes or so. Here's the prompt message I get: "Your network access was interrupted. To continue, close the database, and then open it again." OK; Help Of course when...

I'm always hearing stories about Access being phased out, discontinued, no longer supported etc. Any feedback on this? I have a lot of Access databases I've programmed over the years that are still in use, both at the office and at home. I'm using Access 2010.

I have a report with rows and rows of record lines. In my field [LastNameFirstName], I'd like to write an expression in an unbound text box (for the report header)that would give me a number count of all names in the report, but I need the expression to eliminate the duplicates from the total...

When Googling for Access 2007 files size limitations I am told that the file space is "2 gigabytes, minus the space needed for system objects". Not sure what they mean by system objects. I thought queries, forms, macros, reports were the system objects. Would someone be able to explain a...

I'm having trouble with the syntax of a WHERE clause. I need to open rptAvery5160 in print preview WHERE tblConstituents.Profile Type = "Individual" AND tblConstituents.Status = "Active" AND tblConstituents.EmailOK = "Yes" AND tblConstituents.SCP-M = "Yes" The two yeses (EmailOK and SCP-M)...

I need to have this form, that when it opens, it opens up to the highest record number [RecNo] that is in the table. The data type of the field [RecNo] is a long integer. I'm guessing a DMax "On Open" event but not sure what to write. Any suggestions would be most appreciated. Bill6868

I have a field named [Stations] in my table, in which resides the names of our service stations I.e. “A Westport Cooperative Services”, “B Westport Cooperative Services”, “Spectrum Home Health”, “Don Bosco Center” etc. I want to filter by station, so in the criteria line of the query (which is...

On a report I have a field named “Respite” – any client who receives respite care gets a “Y” in the field. This is not a yes/no field it is a text field. In the report footer I need a count of all the “Y’s” but I can’t seem to get the syntax correct in the unbound textbox expression. The...

I’m developing a donor database for our non-profit. I have a table which holds the donor’s profile info…one donor – one profile, with an ID Record Number [DonorID]. This donor makes multiple donations and the donations are held in a separate table which holds the Donor’s ID number and creates...

I've been using my Linked Table Manager (on the External Data Tab)to link tables, not the manager is grayed out and won't operate. How do I get this feature back? I'm using Access 2010. Bill6868

I inherited a piece of database software at work which is a good database but doesn’t give us the reports or allow us to make the statistical queries we need. All of the objects are protected, except for the data itself, which is stored in an Access database (just the tables). I can get all I...

I have a date field that lists all our volunteer’s birthdays. I need to sort/list them by month and exclude the day and year. I’m looking to get a list of all January birthdays, February birthdays…and so on. The format in this field is 01/08/1930. If I create an expression to extract just...

Would anyone know how to set font and color defaults for new forms and reports? Using Access 2010.

Using Access 2007 I’d like to create a database that would store lots of .pdf files. A one-to-many relationship: an employee’s profile would have many records associated with it and each of these records would contain one .pdf file embedded in the form in a Bound Object Frame. I can do this...

When I open up a table how do I get to the last record quickly? I usually use the scroll bar, but when you have a few thousand records this takes some time. Is there an easier way? Bill

Is there a simple code to attach to an event procedure to compact a database? I'd like to have the db compact and repair when I click the Exit command button on my form. Some of the threads I've read are really difficult for my level of programming. Thanks for any suggestions. bill6868

Too Many Objects in Database? I have a database I’ve been using for about 10 years, and over the years it has gone through a lot of evolving developments. I have quite a collection of objects – macros, forms, reports and queries. My concern is with the number of these objects. Can you reach...

I have a prospective client/employer who is using Access 2000. Before I begin developing databases in Access 2000 – will I have any problems with my codes, macros and other objects once the databases are eventually converted to Access 2010? If so, I may encourage them to acquire Access 2010...