Search results

Hello, I haven't tried that yet but that is on the list of things to try. I already tried using an old backup and that obviously didn't work but if I get time today I am going to rebuild that form, or entering the query that way and see if it breaks the db. I will keep this post updated if I...

A little more debugging showed me with a fresh copy of a backup db that when I insert some sql code for a query that runs the form and save the query then re-open the form the dissappears. Now there are two other queries in the subforms on that form that the queries did not delete themselves...

I have encounter a rather wierd error within Access where it seems that somehow when I was making alterations to the form(adding a page) then saving the form Access seemed to have deleted the query the drives the form and the form becomes blank. A message pops up saying there needs to be a...

Hello, I tried that same setup before using the Query Builder or what I thought was the same thing and it was erroring out. However, I copied and pasted the SQL code into the query and now I see where I was going wrong. The error was in reference to the epression being wrong and I apparently...

I realized the DB never got attached. Sorry about that.

I have a problem trying to sum a numeric column based off another column in the same table. What I am trying to accomplish is to sum a numeric column if a corresponding column is Not Null. I have uploaded my sample DB that to illustrate my problem. The query I am testing with is called Query1...

Hello, I have figured out my joining problem.. The joins I have in place were fine I was just using the wrong field in my query to get the sum. The join I had was Test_Case.Test_case joined with Run.Test_case and the other join was between Run.run and Task.Group. I was running the query on...

Ziggy1, I am still having issues with summing with the join query. I posted a zipped version of the application I am making (well most of it I had to cut the file size down to upload it) But the neccessary tables and queries are there to look at. What I am trying to do is sum point values of...

I did some reading and I totally understand what you presented and believe it will work. I actually tried implementing it however, when I run the query it comes back with nothing so I think I just need to switch the type of JOIN I am doing. I will keep at it and get back to you if I come across...

Ziggy1, Thank you for your relpy. I will try your suggestions. Although I have a question on your first suggestion. You state to make the sum query first which I have done. Then your second suggestion is to join sum table to the query. So If I understand correctly you want to join the test...

I have a sum query issue I am trying to work out and I have trouble trying to coordinate it.I am trying to build sum queries inside one select query that would allow me to sum point values in a separate table. The problem I am foreseeing is that I have three tables all connected with...

I have successfully implemented what I needed to accomplish from the links you sent me. It took a tiny bit of tweaking but I figured it out. Thanks for your input.

Thanks for the link. I just browsed it real quick and it appears to be exactly what I am looking to accomplish. I will give it a shot and see what happens.

I have a form with drop down boxes that list 3 related fields and I have a search button that will requery based on the the input from these boxes. These boxes are all prepopulated with the data and I want to be able to select something from Box1 and then based off Box1 change whats populated in...

Thanks for your input on my issue. In regards to the first reply. I did notice that problem in my code. I actually using a similar approach I "re-worked" the query so that I was able to get the search to work the way I want. At this point I got the query to look at each of the combo boxes two...

Hello, I am struggling writing criteria that is based off of multiple combo boxes in a search form. I basically have a form setup in several pages the first page being a search page. This page consists of three combo boxes which are populated from the tables. These three boxes are all related...

I actually figured this one out from another forum post. In the On_Click(). The code was wrong. Instead of defining the requery as explained in the previous post. The correct code is : Me.SubformName.Form.Requery In my case I hade four different subforms so I had four lines with the...

I resolved the issue by using the inserting the code statements into the Criteria field using an IIf() statement. Thanks for everyone's help.

I have a main form setup with pages the first page (page0) is a search page which has combo boxes to list the items in 2 separate tables and the user will be able to pick selections and view those selections in the other 4 pages. The other four pages consist of a subform that is a query. These...

Thanks for these instructions... it doesn't seem that bad to do... I will give it a shot on Monday when I am back in the office. I will keep you posted.. because I am sure I will have some more questions.