Search results for query: *

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

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

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

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

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

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

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

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

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

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

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.

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

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

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