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 Rhinorhino 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: *

  1. IcePak

    Hiding Main Table/Query/Form Menu Bar with Popup

    Hi, I'm just trying to make sure no one alters the information in my database when using it. I have a popup form, and that's all that I want the user to see and use. I want the main menu area (that includes the tables, queries, forms, reports, macros and module tabs) to be hidden. I also have a...
  2. IcePak

    Cut down loading time on report with pictures

    Thanks alot mac I'll try it out.
  3. IcePak

    Form to display record data and allow changes to be made

    Hi I have a couple of questions that sum up to one problem... I have a form and a table. The form has 10 fields on it, I've been trying to get it to, once the first field is filled in, auto-fill in the other 9 based on the corresponding field data for the record (assuming that the first field...
  4. IcePak

    Cut down loading time on report with pictures

    Mac Thanks for the reply. See that's exactly what I WANT to do. I just haven't been able to do it successfully in Access. How should I go about it?
  5. IcePak

    Listbox Field to grab OLE objects from another table

    Hi, I have one main table with 150 entries. I have another table with 6 entries. This second table is just one field of OLE objects (metafile images). Each entry in my main table is associated with 1 of 6 images (the OLE images stored in the second table). I want to have a field in my main...
  6. IcePak

    Saving an access report in PDF Format

    I figured out a way to save an Access report as a .pdf file Here's how: Get the Adobe Acrobat Distiller (might be able to get it free off their site) This will allow you to print to a "printer" called Distiller Assistant (it's more like "scanned" to it). In order to do...
  7. IcePak

    Cut down loading time on report with pictures

    Hello forum, I have a report that has a page for each of 150 cables. On each page, there's a detail, subreported section and a picture. The pictures path on the harddrive is dependent on a field gathered from the main report's source query. Now, before I added the picture updating capabilities...
  8. IcePak

    display only ten rows max per report column

    Geno, Thanks for the expedient delivery! I looked at the snaking columns section of Access Help. It pretty much led me to the section on making extra columns and changing column size. I had played around with that before, to no avail, but I figured I'd try again. What caught my eye was the...
  9. IcePak

    display only ten rows max per report column

    Hi, I just want to have a report display 10 rows per column in a report, and then have any left over records be tossed to an adjacent column. For example: If I had only 6 records in a source, my report would look like this Column 1 A B C D E F But if i had 26 records in a source, my report...
  10. IcePak

    I desperately need help regarding Record Source

    Hey Lozere, sorry about that. thanks again for your reply. it's the same issue, just explained more clearly. I probably shouldn't have made a new thread. Anyway, I tried that before. Now, I'm generally new at this, especially when it comes to coding and the Event tab. I opened the properties of...
  11. IcePak

    PLEASE HELP with Table/Subreport Problem

    Hi everyone, I'm a standstill on this database at work. I can't go any further until I find out a way to do this. I have a query thats finds one record (row) from a main table. The row is then displayed in a report. In this report I have a subreport. I want the subreport to have its record...
  12. IcePak

    PLEASE HELP with Query/Subreport problem

    Hi everyone, I'm a standstill on this database at work. I can't go any further until I find out a way to do this. I have a query thats finds one record (row) from a main table. The row is then displayed in a report. In this report I have a subreport. I want the subreport to have its record...
  13. IcePak

    I desperately need help regarding Record Source

    Hi everyone, I'm a standstill on this database at work. I can't go any further until I find out a way to do this. I have a query thats finds one record (row) from a main table. The row is then displayed in a report. In this report I have a subreport. I want the subreport to have its record...
  14. IcePak

    Help Needed regarding Record Source

    Hi, This may not apply directly to this forum, but I didn't get a solution in the other forum and you guys and gals are usually right on. I have a report that has a subreport in it. The report displays a picture and one row of data. The subreport in the report will display information from a...
  15. IcePak

    Dependent Record Source on Subreport

    Hi, I just tried it. It comes up with a syntax error for the FROM statement. Then I tried to just put [Forms]![Test].[VARIABLE] and it actually looks for a table called "[Forms]![Test].[VARIABLE]" any suggestions?
  16. IcePak

    Dependent Record Source on Subreport

    Hi, I have a report that has a subreport in it. The report displays a picture and one row of data. The subreport in the report will display information from a table depending on the content of one of the cells in the row of data displayed. Is there any way to have the record source of the...
  17. IcePak

    query searches excluding input strings

    Hello. My second posting of the day is in regards to exlcuding certain entries by means of a query. After searching this forum, I came across the <> operator. This allowed me to run a query that would exlude all entries containing a inputted word. The only problem is that it will only return...
  18. IcePak

    Wanted: blank input strings to not show all entries in queries

    thanks alot guys!
  19. IcePak

    Wanted: blank input strings to not show all entries in queries

    Hey Maq, thanks again. OK, I'm realizing how much there is to learn about this program. You're right about how my form works, I had assigned a macro to run the query. I've never used the Event settings. I know that you can find On_Click by accessing the properties of the macro button assigned...
  20. IcePak

    Wanted: blank input strings to not show all entries in queries

    Thanks for the expedient reply Maq. I can follow your code, but I guess I don't know where to put it. I'm really a novice at SQL, I just really only know how to view it and do minor alterations to already-existing code. If there's any way you you could break down the process on a beginner...

Part and Inventory Search

Back
Top