Viewing 15 posts - 91 through 105 (of 274 total)
I believe it does, although I tend to avoid subqueries for this sort of thing and use a GroupBy. Take a look at Intermediate Microsoft Jet SQL for Access...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
March 10, 2015 at 8:46 am
Microsoft included a file that would support several new controls such as Rich Text text boxes, Date pickers, and a treeview. A treeview is much like what you see...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
March 6, 2015 at 9:11 am
Deleted files can be recovered using an Undelete Utility - but only if they have not been overwritten. And that means you shouldn't be saving any files on the...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
March 6, 2015 at 7:30 am
You are looking to use what are called "cascading combo boxes" in Access forms. The basic concept is that you update the rowsource for the School combo box whenever...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
March 5, 2015 at 9:16 pm
ODBC and Access in particular are pretty picky about who can see what in a database. It would appear that Role_A may not have rights sufficient to let the...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
March 4, 2015 at 7:45 am
Wayne West (2/27/2015)
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
March 2, 2015 at 3:47 pm
You may also find this Microsoft Community Office forum post to be helpful. There is substantial discussion about the trick of using text boxes over combo boxes to do...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
March 2, 2015 at 3:37 pm
It should be possible to define a function in VBA that is generic in nature, and returns the color sets for each control, and could be called by logic on...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
March 2, 2015 at 3:14 pm
Chances are you have some data in the missing records that don't fit within the schema that Access associates with each field - it only scans the first hundred or...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
March 2, 2015 at 3:09 pm
Is your main form a bound form or an unbound form? If it is bound I fail to see the reason for the text boxes that display the current...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
February 26, 2015 at 2:56 pm
Do all of your controls have MouseMove events procedures? (Note that Labels share the event with a control unless they are unassociated with a control, and that the detail...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
February 26, 2015 at 11:14 am
Actually, in some versions of Access there is the ability to automate a backup, but I agree with the idea of using SQL Server Express. If they are using...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
February 26, 2015 at 8:23 am
Access databases tend to be fairly fragile in an environment where peoples files are moving around, and it only takes one small glitch for the data to be corrupted, or...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
February 19, 2015 at 4:20 pm
I presume you are referring to a Microsoft Word mail merge document that is being merged using some VBA code. Unfortunately, doing that from a .ADP project appears to...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
February 18, 2015 at 11:07 am
Because you are working with an ADP Access project, you will need to use a different approach than if you were working with a .MDB or .ACCDB format front-end to...
Wendell
Colorful Colorado
You can't see the view if you don't climb the mountain!
February 18, 2015 at 10:39 am
Viewing 15 posts - 91 through 105 (of 274 total)