Search results

Working on a project for a client, and I'm usually pretty good at coming up with VBA solutions to unique problems. This one has me stumped. The recordsource is a query with over 6,000 records. The form currently lists the records in datasheet format with header and footer for things like...

I am designing a transactions database for some of my clerical staff. I've inserted a data entry subform into the main transactions form (which also has a subform that summarizes all the selected company's past transactions). This data entry subform actually has as it's record source a table...

I've done several Google searches on this topic, this morning, and have not found much useful that didn't cost hundreds of dollars. And I'm quite sure that my program is not going to fork over the money for a costly solution that will only save me an hour or so. I have an Access application...

I've tried several different manners to get this to work, but keep getting the same error when the event is triggered (i.e., the code is run): RunTime Error '3061': Too few parameters. Expected 1. I know this is happening because I'm not properly filtering my recordset, because if I instead...

I've been working for about a month now to add queries and reports to a database that will summarize a whole lot of data about public water systems into reports that we can further edit and then send to the water systems. What I currently have is an Access 2003 database linked to a bunch of (I...

I had this bit of my project done, until I realized that the entire project was so large that I was going to have to instead create a table that has been updated with data as the basis for my report. I am accessing another database via ODBC. This database contains many many tables, but at this...

I am adding some queries and reports to an existing Access database. My goal is to create a 2-5 page-per-record report for over 300 records that are filtered from a 3,000 record table. Of course, I have a lot of work to do breaking down some decision-making that takes place regarding these 300...

About 3 months ago, I created a database in a hurry (I had just started working here) so that I could begin tracking drinking water infrastructure construction projects. Now, I have some time to rethink how I hurriedly put it together so I want to reconstruct it, and add some useful...

I have created a listbox to show the results of a query, the first field of which is Name (last, First). In using the wizard, I selected to find my record based on what I type. However, this only scrolls in the list to the first LETTER I type. I would rather type the entire last name before the...

I've searched n searched on here for the solution, mostly because I don't like to wait for someone to respond to my question :p (which isn't to say I've ever had to wait real long for a response, lol). My database contains many, many linked tables (of which I only use maybe 10) from an oracle...

I've been working to create a report that will look like the attached word document. I have been able to duplicate everything but the leading .... tabs. Any suggestions? I thought perhaps I could use the onFormat event in the Report Detail and query the width of the Description and Amount...

Can someone suggest to me the way I would get this done? I have a button on a form for Projects, the button opens a form (Date Entry) to create a new Pay Request for the selected Project. I know how to "pass" the Project key to the Pay Request form, but what I am wanting to do is have one of...

Can someone tell me how to change the Dbl Click action or event so that it triggers when the user double clicks the RECORD on a subform that is in Datasheet view? I have been able to get the event to trigger when the user double clicks the record SELECTOR, but that seems like an extra step I'd...

you tried to exe query that did not include specified expr "" as part of aggregate Fn Here is the SQL for the query I'm trying to run: SELECT Sum(IIf(Survey![Q-3F]="-1",Survey![Q-1],0))/Sum(Survey![Q-1]) AS expr1, Sample.NAICS FROM Survey INNER JOIN Sample ON Survey.SampleID = Sample.SampleID...

I have a table called Survey with many, many fields that each represent a question on a survey to which businesses have responded. I need to crunch the data from the surveys to produce some tables based on different characteristics of the businesses. The first two quetions on the surveys simply...

I have a table called Survey with many, many fields that each represent a question on a survey to which businesses have responded. I need to crunch the data from the surveys to produce some tables based on different characteristics of the businesses. The first two quetions on the surveys simply...