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. Cyntalan

    I have a subform displaying a table

    By "didn't seem to affect it any", I meant that the column in datasheet view was still editable.
  2. Cyntalan

    I have a subform displaying a table

    Currently, unless I'm mistaken on how to set it up in design mode, I did try setting the text boxes that represent each column in the datasheet as locked, but that didn't seem to affect it any. Also, selecting a column in datasheet view doesn't give you an individual setting for locked, only the...
  3. Cyntalan

    I have a subform displaying a table

    I have a subform displaying a table in a datasheet view for the purpose of being able to edit on column from the datasheet only. However, I can't seem to figure out how to prevent data from the other columns from being edited. Is this possible, or is there another way to display the table in a...
  4. Cyntalan

    VBA Macro - "Code execution has been interrupted" error

    I've actually had this same thing happen to me on occasion, especially on long-running macros. Eventually, something happens in which it interrupts the macro as if I were to hit Ctrl+Break, even down to letting me continue. No actual error occurs, and the break happens at any given line of the...
  5. Cyntalan

    Precarious report format issues

    I have a very particular report request. It is currently being generated from an outside program that I'm attempting to get away from by regenerating it within Access. This program generates text files on the side, and I've been very successful in getting Access to do the database assembly...
  6. Cyntalan

    IE-embedded PDFs

    I realize that my follow-up replies really deserved their own thread instead, so ignore the posts there. The only relation to them is the history, which can be found here: http://www.tek-tips.com/viewthread.cfm?qid=1383608 To sum it up, I have a report system that generates these reports via...
  7. Cyntalan

    Bizzare Setup Approaching - VBA and Internet Explorer.

    Since I see no edit function... Also, I have one more hurdle. Once I get to the point I need to get to, I will have to then save the PDF somewhere. Since this is in IE, the only way I have to do this is by download. This will cause a download prompt. How do I automate this process, to save in a...
  8. Cyntalan

    Bizzare Setup Approaching - VBA and Internet Explorer.

    I actually have run into a new problem in my continuing development for this. I have been successful in doing my original function of generating this reports. These are now running in the background as a batch and printing fine. My next task yet finished with this same function, is PDF...
  9. Cyntalan

    Bizzare Setup Approaching - VBA and Internet Explorer.

    Ok, I figured it out. Sadly, the OnClick function did not appear in the locals window under that function. Instead, it was under OuterHTML along with a couple other configurations. Though, my error was solved by treating that object variable as an array, and pulling up objUknown(1).Click...
  10. Cyntalan

    Bizzare Setup Approaching - VBA and Internet Explorer.

    Would you believe that both are under the same form? From the Locals window, I have two items stored. Both the same name. One button at the top of the page, the other at the bottom. To humor myself, I checked the uniqueIDs on them, which were different, and attempted to use those to call them...
  11. Cyntalan

    Bizzare Setup Approaching - VBA and Internet Explorer.

    I actually had tried both of those prior. .Click of the object gave me an "Object doesn't support this property or method" error, and doing the form.submit made the page load something, but nothing occurred, and no report was generated. I'm not sure WHY .Click didn't work, though.
  12. Cyntalan

    Bizzare Setup Approaching - VBA and Internet Explorer.

    Also, I noticed one other flaw in my plan. Unlike the login script that exists, treating the button to login as an input type "Submit", the page that is to generate the reports is of input type "button", with an onClick command to submit the job. Any ideas? Sorry for the double-post, if there's...
  13. Cyntalan

    Bizzare Setup Approaching - VBA and Internet Explorer.

    Well, it did work. But I always get an error at first, claiming "Object variable or With block variable not set", which I'm not sure as to why. If I hit debug and force it to continue, everything goes according to plan, so I could always just turn off errors for the duration, but then I noticed...
  14. Cyntalan

    Bizzare Setup Approaching - VBA and Internet Explorer.

    First off, a history. A report generator I use is based in HTML. I get a series of 20-30 numbers for each report to be generated, and the method of generation is to open up Internet Explorer, login to a rudimentary user system, load up a simple local form, entering one number, hitting submit...

Part and Inventory Search

Back
Top