Search results

What took y'all so long to reply ??? :) Thanks for the suggestions! What I was / am trying to do is to use a "Save" button to work whether a record is edited or a new record is added. Perhaps I confused "poor little Access." I'm just trying to stay away from writing a ton of code (one part...

I've got a bound form that works quite well. My question is.... I'm putting a command button on the form that will "save" the record when it is clicked. For a reason not obviously apparent to me, I usually end up with two records being saved to the table that's bound to the form. What might...

How very nice of you! I appreciate the offer, but I've got Acc 2000 at home and can do that myself. I really like your kind offer, though. That's what makes these forums wonderful.... the willingness of folks to help and to advise. Wow! :D

Does Access 97 have the ability to save as Data Access Page?? I didn't see it as a "Save As" type.... :confused:

I had already tried that.... and you're right. It didn't come anywhere near to what I had in mind. Oh, well...... I'll just code the thing from scratch. Thanks for replying.

Outside of manual coding, is there an easier way to convert Access 97 forms to HTML? Just the form itself, not the data related to the form. I'm hoping there might be something out there for a "lazyman's approach." Thanks!

Thanks for your reply. I already had that in my code, and still got the message. :confused:

I've gt a form with a combo box. On the combo box, I've got code for adding a record into the combo box that pulls up another form solely for the purpose of adding a record. At the end of my little routine, I get that "The text you entered isn't an item on the list" message, which I don't...

I'd love to know how you figured this out also........ :o

Which is the way I'm thinking of doing. Thanks for the info! Also, I don't have any .mdw file with user data and am using a home-rolled bunch of code for security, so I don't think the CurrentUser will truly work, since by default, that function puts in an ID of 'admin' when you don't use .mdw...

That sounds good to me! And of course, leads to another question.... what if then another person logged on and was to make some changes to the record ? Would the original userid be replaced by the changing person's userid? Should I at this point start thinking of a history / audit process...

I've got a form bound to a table. On the form, some of my fields are based on the table fields, and some others are unbound. In particular, I use an unbound field in order to pull the user's name and then place it into an unbound field on the form. Here's my questions: in an "add" process...

That sounds doable..... does that cause any increase in size of your database, say if you have a lot of activity to your tables? Thanks for your response.

I've seen some interesting code and ideas about Audit Trail procedures in this forum, but have one question..... and perhaps I missed it..... The Audit procedures discussed here seem to circle around adding or changing records. What do you do when it comes to deleting records? How would you...

It worked!! Pat, A quick note to say IT WORKED!! :D Now I can go home for the weekend and get loaded! (Not really). I am happy, however, and wish to again express my appreciation for your suggestions and assistance. Can we clone you????? :)

Perfect!! That's what I thought! When I got home last night and was pacing while thinking, I told myself I most likely could use Pat's concept and expand it to an "outie and innie" type loop. So if I understand you correctly what I basically should do is place my courses where you have names...

Actually, this is where I was starting from.... a combo box on the main form, where I could select one course, and then a subform, where I could then select as many students as desired to be enrolled into that one course. My thinking was to change the main form combo box into a multi-select...

It still doesn't work I've tried your ideas, but my screen still doesn't work. When I have a combo box, "Add An Enrollment", set up to select only one course for many students, everything works OK. But...when I change the combo box to a list box, to select many courses for many students, only...

Thanks to all who have replied to my plight - your answers are appreciated. And, they give food for thought. I'll definitely keep the advice i mind. Actually, I had used a third table comprised of the keys of the courses table and the student table. And the original form and adding of...

I've got a form with one subform. What the form attempts is to allow users to choose one or many courses in which to enroll one or many students. It doesn't work. What I want to have happen is when the user presses a SAVE button, to have it go through each course (in a Course table) and add...