The code works great for the months field... the years field displays some odd behavior, but ah well--I'll just assume that they are based on the same database field. Thanks again, Skip, you're a lifesaver!
Wow, Skip, thanks for taking the time to write that super-fancy code! That seems to almost do the trick!
I say "almost" because, oddly enough, it worked for one field and not the other. I have two fields, "Months" and "Years," which may or may not be based on the same data field. The macro...
I'm having trouble analyzing and replatforming some reports that are delivered in Excel, the data of which comes from a string of Access databases (oh, the horror!). This specific snag is about grouped fields in PivotTables. I've discovered the VBA code to find the connection string to a...
How can I bring up a list of changes to a database? The database will be used across three computers and the client would like to quickly review it each day to catch any obvious errors made by her volunteer staff. This seems like a common need- is there such a feature in Access, and I just...
Okay, I'm pretty confused here... it looks like you're saying you have three tables. I'll give an extremely oversimplified version of the definitions.
Table App
----------
App_ID
App_Name
Table Server
------------
Server_ID
Server_Name
Table App_Server
----------------
App_Server_ID
App_ID...
Hi! That's an interesting question you have there- I was totally clueless until I did some Googling!
A couple of thoughts for you: it's helpful if you post the EXACT error code and error message. :) Also, this "Import Specification" thingy looks like it's an Access 2007 feature only? That could...
It's hard to say- it would be helpful if you could post the VBA code in the "ElapsedTimeString" module. I have a few thoughts/questions for you:
Your function is named elapsedtimeSTRING. Does it return a string value or a number? If the former, can strings be averaged?
If that doesn't work, do...
For future reference, I did find the answer. Or "a" answer, although it doesn't seem to work very well.
When in doubt, write more queries.
One query? Two? Three? That would have been simple enough, and worked for the other queries. I'd be embarrassed to say how many I actually ended up...
Uh, thanks... but I kind of want that grouping. The report works find if I use something like:
County Ethnicity Percentage
------ --------- ----------
Otsego Caucasian 88%
Otsego African American 10%
Otsego Hispanic 2%
Osceola Caucasian...
I'm not certain of whether I should post in here or in the queries forum. I decided to post here because this error ONLY appears when I try to view the report; the underlying queries work just fine.
The report is meant to show the proportions of ethnicities for each county.
I have a base...
My mistake; I listed the correct error in the subject (3086, "Cannot delete from specified table,") but mistyped the error code in the post and neglected to provide the message as well. Hope that's more helpful!
Hmm. I'm not expert, so I'm not going to pretend I have the holy grail in hand here- just some ideas from someone else that's learning.
I don't really know how you intend to use this data- you can't just say something like
SELECT rcustomer_id FROM customer WHERE customer_id = (SELECT...
I have a bit of an odd situation here. The short short version: the database works fine for me after I added new features, but the client says reports are popping up with error 3089. Since I cannot duplicate this error or visit the site to see their computers, this will be tricky.
I do believe...
I think you might find the following page helpful: http://office.microsoft.com/en-us/access/HA010546621033.aspx?pid=CL100570041033
Look at the "dateadd" function specifically. If I understand what you want correctly (and I may be confused) you want to view all people whose training dates are...
Okay, I figured it out, finally (yay!) after guessing and researching many many different wrong ways to do it. I'll post the answer here as a reference (because many answers I find are from Googling forums like this one) The simple answer to filtering a report and its subreport is: you don't...
Wow, I must be more tired than I thought. Obviously I wasn't paying attention when I tested it- that did NOT fix the issue! So! Any thoughts on filtering both a report and subreport?
Never mind- I figured it out. I realized that it is possible after all to have the "totals" query run off the regular report query, simply grouping and summing it, minus the "county" field that groups it into sections in the main report. Then when the main report is filtered, the subreport is...
(This is a continuation of the thread at http://www.tek-tips.com/viewthread.cfm?qid=1398184&page=1)
Okay. I'm using VBA code to add filter critera in the DoCmd.OpenReport statement. I have a report based on one query with a subreport based on another query- both queries are based on the same...
Thanks! That was very helpful, the code worked like a charm with very little change. However, now I'm complicating things further! In order to have totals of the data (i.e. all the same data without the county or being grouped by county), I created a separate query that takes all the data from...
Thanks... so I take it your answer is that, of the various options I listed for using a multiple-selection list box as the base for a report... the best way is to use VBA and assemble recordsource string using the listbox values and the values from every other control on the form, then use the...
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.