Search results for query: *

Thanks Pwise, I kind of thought it would involve a table, but I was somehow thinking I would have to dynamically append records into it. I don't know why I didn't think of your solution. Thanks again! greg

I have been asked to provide a blank attendance form for my users in an application. This is just supposed to be a form that they can print off and write on manually. So, I figured I would just create a Report with some rectangles and column headers, etc, to give the appearance of an...

I didn't get any responses, but I was able to come up with a work around in case anybody is interested. I decided to nix the code that disables the built-in menus and toolbars and instead I created a custom menu bar that has no actual commands in it. Then I set the startup settings such that...

Access 2003 At work we have a number of mini "applications" created in Access. Most of them do not have custom menus or toolbars, we just allow the built in ones. However, in one application, I am disabling all of the built in menus and toolbars for security reasons. I restore the built-in...

The criteria was intended to be joined with an AND statement. I noticed the difference in your example, but I did not feel the need to point it out. I really didn't think it was necessary as I understood that your example was merely provided to show me how to restructure the query using LEFT...

That does work, pwise. Thanks. Any ideas as to why my initial query does not work? It seems to me that my original query is not all that complex. And why would it work when tblExclusions is a local table, but not when it is a linked table?

I am using Access 2003 and SQL Server 2005. Database is broken up into BE/FE. I have a query that I have simplified in order to find the cause of my problem. I am trying to return two fields from a table that each have as their criteria a subquery which will exclude certain values. SELECT...

I am currently trying to evaluate Access 2010 beta. When I create a new database or open a database from within the Access application, I have no problem. But, when I am in Windows Explorer, and I simply double click on the accdb file to open the database, I get an error message that reads...

Joel, If there is no version update, then there is no error. Sometimes when there is a version update, there is no error. Other times when there is a version update, there is an error. Every time there is an attempted version update, I have been able to confirm that the new version is now on...

I have some code that is run on startup of the database that checks the version number of the client front-end and updates the front-end if a new version is found. I originally found this method in another post: http://www.tek-tips.com/viewthread.cfm?qid=1538641 For the most part, this method...

Thanks guys for the responses. I went down the route that Randy700 suggested. I was already trying to set the Filters via VBA code, but I was doing so on the Open Event of each subform with a generic Docmd.Applyfilter line of code. That didn't work! I still wanted the filters to be applied...

After further testing the problem I am having has to do with the filters applied to the individual forms. I can display the two forms fine without filters. But, if I click on the apply filter, only one of the forms filters properly.

I am not talking about a parent/child relationship. What I have is two seperate forms,each with data that is unrelated. I am trying to present the user with the data from both forms on one screen. I thought I could just take an unbound form and add each form to it. But, I can only add the...

Thanks for all the help. I have used the Report Where Condition before. That is my usual method. In this case, the users also want a continuous form based on the same selection criteria, which they can then use to update records as needed. So, it's not just a report. I decided to go ahead...

Here is a simplified version of the SQL. I only included the join fields and those that have selection criteria. There are actually more than 30 fields pulled from the three tables. SELECT dbo_Archive.INDEX FROM (dbo_Archive LEFT JOIN dbo_QCTable ON dbo_Archive.INDEX =...

I have a form that collects criteria for a report (and the underlying query). One of the criteria is a status. There are times when a user might want to see a specific status, for example, status = 1. No problem. But I want to also include the possibility to see all records where status is...

That works as well, PHV. Thanks! And I can express it in the query builder without typing straight SQL. For a user like me, that's good! I was trying to use a Group By, but I didn't think of a count expression. Cool. Thanks again, greg

Thanks pwise. I had to change the last AND to a WHERE and it works perfectly! I am terrible at joins and combining SQL statements. I would have never come up with that on my own! Thanks again, greg

I have some data as follows: Group Item Date 1 1a 06/01/2009 1 1b 2 2a 2 2b 2 2c 3 3a 3 3b 3 3c 3 3d 06/05/2009 What I want to do is return a single value for the Group where ALL items...