Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Chriss Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Dontremb
  • Content: Threads
  • Order by date
  1. Dontremb

    Pull a field from a Subreport to the Main Report

    Ok, hopefully, this is a simple problem. I have a report, with a subreport on it. This subreport has a field on it, and all I want to do, is reference that field in the main report. That's it. From what I've been able to research, (which is nothing) this is completely impossible in every...
  2. Dontremb

    Use a Query to Make a Table

    Ok, here's the problem I'm running into. (Some of you may remember part of the problem from other posts.) I've got a lot of queries that count other queries. All of these queries need to be displayed on one report. I don't want to use subreports because they're very annoying. I originally...
  3. Dontremb

    Query Too Complex

    Ok, it seems that this message is my bane. Antithesis, if you will. I have a lot of calculated numbers from many different queries, which I then have combined all in one query (this query is nothing but a holding query: it holds no calculations, it simply has the ONE field from each of my...
  4. Dontremb

    Text Box in Master Report from a SubReport

    Ok, this is a simple question, but I'm not sure if it can be done. I've got a Master Report, with about 30-50 sub reports on it. Each of the subreports show a single number, which I'm getting from BILLIONS of queries. (I'm not real worried about the number of queries, my naming convention is...
  5. Dontremb

    How to make a lookup.

    Ok, I've got a form with subforms and stuff in it... The main problem is this: The combo box wizard won't allow me to make a look up. Someone mentioned that it's possible I don't have the database normalized, but I read all the rules before and since, and I THINK I'm following at least 1-3...
  6. Dontremb

    How to filter by a field that has multiple selections.

    Ok, I just need to set up a criteria that filters my query based on whether or not that field has more than one selection or not. I.E.: The field is a combo box with, "red, white, blue" User can select multiple values. However, when I'm running the calculations, I need to know how many...
  7. Dontremb

    Make a Report from Unrelated Queries

    Ok. I'm sure this is super simple for all the experts we have out here. All I'm trying to do is make up a report that links some calculations done by several queries. My queries simply count values in other queries. But they're not related. I just want the report to be able to display the...
  8. Dontremb

    Just want to make a simple Look Up control on a form

    I don't know why I can't do this. I have a form with 3 tables as a source (linked, and one subform). I am just trying to make a simple look up field on the form, so I can search for a record by name. I tried doing the combo box wizard, but the option to make a lookup isn't there. I checked...
  9. Dontremb

    Hiding Columns in my Subform Makes it stop working.

    Ok, so, this is a bit of a problem. I've been trying for 3 days to figure out exactly what the issue is. I've TECHNICALLY figured out a workaround, but I don't like it, and it also means I don't fully understand how it's working. Ok, here goes: I have a Many-to-many relationship with...
  10. Dontremb

    Linking 2 records with Many to Many Relationship

    Not sure what's going on, but I really can't seem to get it. I'm getting this error: I'm seriously stuck.
  11. Dontremb

    Assign Preexisting Field to Current Field

    Ok, here's my problem: I have a many-to-many relationship set up like this: tblPersonnel: IDPersonnel LName Fname tblVacancies: IDVacancy VacancyNumber JobTitle tblCompilation: IDCompilation IDPersonnel (Foreign Key) IDVacancy (Foreign Key) Hired Y/N Next, I have a form that displays the...
  12. Dontremb

    Many to Many Relationship help.

    Ok, first thanks for reading. This is my problem: I'm making a database, and I've created many databases, but this one requires something slightly different, and I absolutely can't figure it out. Basically, I need to link two tables. Table 1: Job Vacancies. Simple table, it just has...
  13. Dontremb

    Many to Many Relationship help.

    Ok, first thanks for reading. This is my problem: I'm making a database, and I've created many databases, but this one requires something slightly different, and I absolutely can't figure it out. Basically, I need to link two tables. Table 1: Job Vacancies. Simple table, it just has...
  14. Dontremb

    MS Office Access 2007 (How to display multiple records.

    Ok, first thanks for reading. This is my problem: I'm making a database, and I've created many databases, but this one requires something slightly different, and I absolutely can't figure it out. Basically, I need to link two tables. Table 1: Job Vacancies. Simple table, it just has...

Part and Inventory Search

Back
Top