Search results

I have a form with 5 option groups. Each group has an append query written to retrieve questions pertaining to the choice made in each group. There is a continue button on the form that runs the 5 queries. When pressed the questions go to a results table. The problem is multiple...

This didn't work as expected. It's running the queries but my table is filling up with duplicates. I'm going to start another thread about it, I don't think it would get answered here.

Thanks! I've stumbled upon another little problem and when I get it fixed I'll let you know how this works! thanks again! Rhonda

I have 5 append queries that I want to run from the push of a single command button but I don't know how to string together the code. I was instructed to build a button to run one query and then copy the code down 4 times and rename each one according to the querie names. Currently the...

Thanks, that's what I get for being in a hurry and/or lazy!:p As always you're my champion!! take care Rhonda

Is there a way to make a selection in cmb 1 and have it limit the available information in cmb 2? For example, the info in cmb 1 is contract numbers, the info in cmb 2 is subcontract numbers. The subcontract numbers are specific to the contract number and I only want to show those instead of...

thanks for the tip. These numbers will not be used in calculations so they should be text. They are heading numbers.

Thanks Wayne. I've put it in two number fields. Rhonda

Oh GAWD I think my brain has fallen out!!! Since they took the 97 version off my machine I thought....well I just won't go there! Thank you Miles for steering me in the right direction!!! I'm glad that at least I can amuse you!! Here's the older copy. At least I learned (or relearned?)...

Wayne, if I have 3 digits after each decimal it reads; 4.1 = 4.100, 4.10 = 4.100, 4.100 = 4.100. That doesn't do me a lot of good. But what would I do if I had this broken down into two columns? Bob, I'm sorry I can't convert to 97, they took it away from us. :( I hate to sound like an...

Hi Wayne, I'd be glad to split this into 2 fields. I'll work on that tomorrow. I'm assuming 1st cell is the whole number, and the other cell is the decimal, but without the decimal?? I might need some help putting that together :) I sometimes feel like I'll always be a "beginner"!! I have...

I've been doing some reading in the archives and can't find a solution to my problem. I have a table (tbl_QualityControl)with several hundred questions. These questions are coded to relate to different work types. Some questions may relate to 1, 2 or all of the codes. In trying to normalize...

LOL!!! I did that and didn't even realize that it had reset the numbers! Thanks buddy, for always being there for me!!! You're the best! Rhonda

I've been doing testing in my database, and now that it's ready to go, I want to reset the auto numbers to 1. These are located on a couple of forms. I have the following tables, tblNextSurveyNumber, tblSurveyNumber and a query, qryNextSurveyNumber. I didn't set these up myself, and I'm still...

Yes I did, but I just talked to the boss. He's okay with me placing the range of dates on the report header. So each time I change the query I'll change that range of dates too. That will probably be more condensed too! Looks like it's gonna be okay. Thanks for your interest pal...

Thanks for the tip! Unfortunately I didn't get it worked out. I jumped the gun! It's totaling the count again but doesn't display the date because I used "where"... I'm back to trying to figure it out. Maybe I can just display the date range on my report somehow...

Oh heck, never mind. I needed to change my total to "where"

Help~I broke my query! All was fine until my boss asked to sort between two dates. The original query showed which questions were answered "no" and counted how many times for each question. Then I added a field to display that information between two dates. >=#9/1/03# And <=#9/26/03# Now...

I figured out what I did on this form. I had turned off the "allow edits" when I built the form, so it wouldn't allow me to make selections in the combo box.

I have a combo box on a list form that opens but will not allow me to make a selection. The combo box is based on a query. the row source is: SELECT [qryCmbUserScore].[Name] FROM qryCmbUserScore; After making a selection I have a search button to filter the information on the list to show...