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...
I'm the only one using the database so I'm not too concerned about splitting it at this time. It has a lot of .jpg photos which is adding to the size.
I have used the compact & repair procedure for years but in this IT environment I have been unable to do this. The process freezes up on me...
Thanks missinglinq. From what you mention I was able to view the system objects in the Objects Pane, but it wasn't until I ran a report in the Database Documenter was I able to see the file sizes of these objects. Even that was confusing...it tells me the file size is, for example, 8 or 128 or...
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...
JR..
I figured this out:
DoCmd.OpenReport "rptAvery5160", acViewPreview, , "(((tblConstituents.ProfileType) = 'Individual') AND ((tblConstituents.Status) = 'Active') AND ((tblConstituents.EmailOK) = True) AND ((tblConstituents.[SCP-M]) = True))"
"Individual" needed to be 'Individual' as well...
Thanks jr.
I wrote this:
DoCmd.OpenReport "rptAvery5160", acViewPreview, , "(((tblConstituents.ProfileType) = "Individual") AND ((tblConstituents.Status) = "Active") AND ((tblConstituents.EmailOK) = True) AND ((tblConstituents.[SCP-M])= True))"
but I'm still getting that nasty compile error...
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
MajP - there are no space(s) before the A. I changed the station's name to Westport Cooperative Services A and now I don't have a problem. Still a mystery as to why the "A Westport Cooperative Services" criteria line failed when running the query.
I dunno.
Thanks for everyone's input...
Duane,
I understand what you're saying about parameter prompts and I don't generally do this, but this is a report I'm creating on the fly for a purpose we only use once a year. Next year it will be something different. The report is only for me and not my users.
Bill
Skip,
The SQL in this field on the criteria line simply reads (for example) "B Westport Cooperative Services" - this work fine, as with any other station name I type in - it's when I enter "A Westport Cooperative Services" that no records are returned. It does not like that my first word is...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.