Search results for query: *

I am not used to using bound controls, but I am helping another group add search to their database, so I am not sure what to do with this. I have a database with a tab control in the main form, and two of the tabs are "search" and "edit project." I have a bunch of unbound controls in the...

I searched around, but did not see a thread or FAQ on this. I have a database where the front end and back end are separated. The front end is about as secure as it can be, and I want to keep it that way. I need to have a few select people be able to create ad hoc queries off of the backend...

This is probably something simple, but I can't find the answer in help or the forums. I am trying to automate an e-mail that is sent when a project is updated. I want to include the fields that are updated, with line breaks in-between each field so it does not look messy in the e-mail. Is...

I am trying to concatenate a integer that increases by one each time a loop runs to the end of two Me.txtBox's. I am not sure of the syntax to do this, and I couldn't find anything in help, any of the books I have, or any of these forums. I know this is wrong, but here is what I have: Do...

I have a form that is a dynamic questionnaire. The number and content of the questions will change on a regular basis, so I am trying to make a form that will allow me to automatically pull the current questions and have the correct number of text boxes to display them on the form, along with...

Hi all, I have a database that is used by 20 or so people now, but will soon be used by a hundred or so people (I know, Access is going to freak under the stress....). I need to put in some user level security that prohibits certain fields from being edited based on the login that the user...

Hi all, I searched the forum, but couldn't find an answer to my question. I have a report showing community service hours and donations for the year that pulls from several tables. The tables often have no data for donations or hours for a particular month, so the source query for the report...

Ok, I'm not sure if this can be done, but here is what I am trying to do. I have a report of classes taken that is currently grouped by actual year, but I need it to be grouped by fiscal year. I am trying to create a query that looks at the group header of year when determining the results...

I have a command button that exports a report to a new Excel file (or overwrites the existing one, if it's there), which works fine, but I have some conditional formatting in the report that the OutputTo command does not keep. The strange part is that if I export using file>export, it keeps the...

Hey all, I have a query that is trying to pull data from two tables, tblTemp and tblClasses, but for some reason it isn't pulling the correct data. SELECT tblClasses.fldClassName, tblClasses.fldRequired, tblTemp.Group, tblClasses.fldClassType FROM tblClasses LEFT JOIN tblTemp ON...

Hey all, I'm trying to total some values in the footer of a group for two different text boxes that have nz(field, 0) in the sql statement. When I try to run the report, I receive an error that says "The Microsoft Jet database could not execute the SQL statement because it contains a field...

Hey all, I couldn't find this in another post, but if there is something similar out there, please point me to it. The title pretty much says it all. I am working in Access 97. I have two tables, pc_inventory (lists basic employee information, pulled from another database) and tblProblems...

Ok, hopefully this is a simple one. I have a subreport with a couple of groupings that list the results of the query that the report is tied to like this: Group heading result1 result2 result3 etc. The results go down, but I want them to go right, and then down, as if it were...

If this is already answered in another post, please point me to it. I'm new to Access 97 and VBA, so I'm not sure how some things work. I have a form with about 20 or so text boxes on the lower part, and a combo box and command button on the top. The combo box lists all users and their ID's...

I didn't see another thread mentioning this topic, but please point me to it if it exists. I am working in Access 97. I am trying to combine multiple queries on one form, but the results that it gives me are not even close to what I need. I have a few tables that list employee information...