Hi Katie, I am not really clear on a couple of things.
1. Are you are using the huge SQL statement as actual query criteria, or are you selecting all records and then applying a filter that contains the huge SQL statement?
2. It seems that huge SQL statement is forcing your SQL server to...
I've dealt with similar situations in the past. I am not sure of the most elegant method for doing this in code.
Here is one idea that might be the easiest though.
What your attempting will take some creativity but its very possible.
Lets start with the main form. You have a text box. You...
I have a stong feeling this would not be possible. Although I've not tested it, I would think that access would not treat nulls as "unique values" which are critical to a Primary key.
Reading your scenario I see one problem.
If the table is empty and you open your form and execute the code this is what happens....
It hits the first line of code and tries to move to the last record (or "back" one record). Which it cannot do because there is no "last...
Jeremy,
I agree, While the unions aren't pretty the will work to solve her immediate problem. Its possible her "problem" was inherited from someone else's poor design work. Helping her out with that is the first priority. I agree it would be worthwhile for her to check into a redesign...
This is fairly straightforward to accomplish. You'll need to make use of a join and some crafty criteria usage to select the rows your are really needing to send letters too in your prospect table.
First- Set up a query that includes both the Prospect table and the Main table in the query...
To trigger a form to open when the database first opens do the following:
On the main toolbar for your database- click on "Tools" and then "StartUp".
You will then see a dialog box with a combo box labeled
"Display Form/Page"
Select your form name from the combo...
This sounds like you are attempting 3 different queries (to drive 3 different letters). IF this is not your plan, I would suggest using this strategy. Please let us know the name of that "common" property name field. I think I can help if you include this info to clear up these two...
This is a request that is difficult to handle inside of access. I believe your "viewer" is currently just displaying an external report file. Similar to viewing a web page in access using an active-X brower object.
I would just post a link to the report file on a form (like a...
Dave, in looking at your result sets it appears you have one field in common that you can use to your advantage. That is the YEAR field. If you join your two tables on the YEAR field, then you can work with the fields from both tables all in one query and the results for each year will be...
Nina, I think there is a simple solutions for your problem using unions in your query. This solution requires one important ingredient. ALL of your field names must be identical in every single table for this to work. (which you have already stated is true)
Using union as I've illustrated...
Using Dawns method is a straightforward, simple approach.
If you switch your query to SQL view, you can insert her criteria line into the WHERE clause.
Select * From tablename
Where YourDateField Between [Enter Beginning Date] And [Enter Ending Date]
If you'd like to include the dates...
First I'd attempt to have your network admin check to see if the server thinks someone is still in the database. If so, have him kill any connection to your database and try then to compact or try the repair utility first and then compact. Sometimes indexes can get corrupt and lead to some...
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.