Search results

This should, perhaps, be posted in one of the regular forums instead of the introduction area, but for my money, there is very little reason to upgrade and many reasons not to. I've been teaching database applications since the days of DBase II. I currently use and teach Access 2007 and Access...

cat, Fluffy, who

Okay - I've made it a memo field. (I'm afraid that 255 characters would not be enough for some hyperlinks.) It works like a charm!! Of course, when I originally switched the field from hyperlink to text, Access did some wierd things, turning every link into a double, as in...

You can't insert a record between two records, you can only add to the end. But as Speakers_86 notes, you should have a field that sorts the records the way you want so that whatever record you add to the end immediately appears wherever you want it to. For example, in my table I have a field...

Would it be possible for you to just create a lookup on the table itself that gives you all the existing items for that field? I do this with my tables all the time. For example, I want people to enter Mr. or Ms. or Mrs. or Rev. or Dr. or whatever. They need to be able to add a new one, but...

Pat - that is the best explanation I have seen on BeforeUpdate for the form, which I didn't really understand. I'm definitely going to use that information for some of my requirements - though it wouldn't help for the name parsing and updating thing, which needs to be done immediately so the...

Hmmmm - I am wondering why, with all the really great, inexpensive and/or free testing programs around that already do everything that you need, why would you be using Access to write this? If you send me your email address, I'll send you an old version of ExamViewPro, which I used to use...

Hmmm - Thanks, Josh. The code that you gave me to make the double click follow the hyperlink may work, but I can't tell because I can't get the hyperlink not to follow on the single click. I have set the Is Hyperlink property to No, but the field still shows as a hyperlink and trying to click...

I think perhaps we would need more information to help you. Obviously, in some control object on the form, there is an error in a macro or procedure that launches when something is clicked. Without more background in exactly when this occurs and what controls exist in the form, there's not...

Can't you also just create a query with a parameter field that asks for the starting number, and then increment that number in another calculated field in the query and then print that on the report? That's the way I would do it. Then you wouldn't need programming.

Hi. I'm trying to figure out the best place/way to put certain subroutines to update certain fields in my form. I have tried to find a good explanation of the different options (On Click, Before Update, After Update, On Exit, ...etc.) but I haven't found one that describes the nuances well...

Hi. Thanks for answering the exact question I have (though this thread is a bit old). Could you please clarify, however? What I would really love is sample code that you used in the double click event. In my case I have a field call PrimaryWebPage. It might, for example, have the...

on Ellis Island

Hi everyone. I'm new to the forum, and I've been using it for weeks now getting lots of help from the existing posts. Great stuff!!! I'm not new to Access (I've been teaching Access for more than 15 years), but I'm not very familiar with VBA code or programming in forms, which I am now...