Recent content by opostal

Wow it is that simple. So lets pretend I did not post this as I may have had a bad case of "forest for the trees" syndrome... Thank you very much.

I have a report from a user input query that lists the data and has it broken down into three "tiers" or subcategories. The last tier contains 4 fields, one of which is a numerical value. On the report built from the query, at the top of the third tier I use the =Sum function to give me a...

Excellent. I believe I have found the source of my problem as was stated above by the use of a macro. If I individually perform the steps, no problem. When done by macro, there is not a close statment on it. Thanks again!

Well I believed that would probably be the problem (opening and not closing). I have been unable to find the source of this problem. Let me provide the process and maybe you can suggest a likely source. I have a table that is regularly updated and there is extra lettering in each field due to...

I have a database that opens and runs a few queries such as delete query, append query etc to make things easy for the user. The database is accessed by a link from an internal company website. The problem I have is that sometimes (fairly often in fact) I get an error that says "The Microsoft...

I am looking for advice regarding using several access databases from a web page. The history is that I have put together about a half dozen databases that make our life very nice here at our small office. Additionally, I built a small web page for intranet usage locally as well. As it turns...

Well I gave it a variety of shots but not successful with the CInt item. The version I am using is CInt(Nz([FIELD6])). I have been successful with appending Val(Nz([FIELD6]),0) to another table but hate to add a whole new table to the mix for this one function...lol

Ok will give it a whirl. Thanks

I am still working with your suggestion. I seem to be struggling a bit but am not even close to done yet so will get back to you as soon as I have progression. Thank you for your input however.

I have a table with 19 fields that gets records automatically added to it daily. The source program that adds the data to the database gets its data from scanning documents and identifies each field to be inserted into the database by a two letter identifier at the beginning of the data...

I have a form that has 19 combo boxes which are linked to queries from a table. My intent is that the user should choose the applicable items from the drop down boxes on this first form, then hit a search button at the bottom which opens a new form that is filtered by the data from the first...

Hope that helped to clear it up a bit? Thanks again.

Well my apologies for not being clear enough. I am attaching the file here zipped up. I have removed all the bells and whistles from it to ensure that it would be as small as possible. The acutal one I am using will open to the startup form and the user will select the report they wish and...

I have a database that records 20 fields of information about a record. In two of these fields, it indicates if the record has been tested or not and if it passed or not. These are equated to 1 and 0 for yes and not respectively. In one additional field it indicates what type of test. I then...

Yes, I think I knew that I was just ummm testing you. I should have thought of that myself before posting. Thank you again.