Search results for query: *

Hi everyone. After trying to find my answer on this forum, and seeing how many people get confused by incomplete explanations, the beginning of this post is explanation. The code I need help with begins with 'HELP HERE.' I've been trying to learn about ADO. To do so, I've been building what...

I forgot to add: I have spent a few hours searching the forum for ideas, but either there are no topics or I just didn't use the right words. If there is a topic on it, I'm apologize. Posting a link to any you know of would help. mrmetal

Hello all, I have a form, called "frmmain." In this form is a subform called "subBills." The subform has a default view of continuous forms. The database program I am attempting to create using a few different external databases, all created in Access. So far, I have been able to connect...

Thanks, As this was the first time trying the InStr function, it seemed very confusing. But I have it working now.

I have a string expression that is carried over to a report. If this string expression has a certain word, I would like the report to reformat a bit by adding additional lines. I have everything set except for the fact that I can't figure out how to search established string expression for a...

Thank's guys - it worked very well. I'm trying to understand the code, however, and am confused what the numbers mean. Does it mean that: 1. the code reads the string from left to right 2. beginning at the first letter, everything gets capitalized 3. beginning at the second letter (because...

I have a string that is assembled from various fields. I would like to be able to convert this string to an actual sentence - first letter of first word capitalized, with no other capitalizations. I first tried an input mask, but because the values will be of varying length, that did not...

Never mind - stupid mistake. Somehow, I set the second form to only accept new records. Changing the setting fixed it.

Hi everyone (sorry about the long post, but I'm not sure if I explained my problem well enough). I am writing a simple (at least it is supposed to be) database for my personal use. I am a teacher and am trying to design a database to make writing lesson plans easier. Anyway, the database I am...

Thanks Ken, I think the combo is just a look-up. It doesn't store any information in any table. When I'm in Design View, it says "Unbound" in the combo box. But the row source is coming from the main form, of which the title is a piece, so maybe that's where it becomes bound? I am a novice...

I'm going crazy trying to solve this one. It seems as though it should a simple thing to do. Here's what I'm using in the NotInList procedure: Private Sub FindTitle_NotInList(NewData As String, Response As Integer) If MsgBox("This book is not in database. Do you wish to add it?"...

Thanks for the response KenReay, I tried everything in the FAQ, but I'm still getting the same loop. I get the message box, but when I click yes, the code to open the form doesn't work. Any other ideas? - Ed

Hello everybody, I am a teacher who is trying to develop a simple database for my classroom book collection. I have an unbound combobox on my main form that allows me to search for titles. What I would like to do is to be able to type a title in this box, and if there isn't a match, have the...

Thanks for the thoughtful response! That did it; I needed to change the settings to a memo. I'm not too worried about size, since I'm only designing this for my personal use. Again, thanks for writing a clear response - one that a novice programmer can follow. - Ed

What about writing a simple if...then procedure that makes the second button's enabled property go to "no" if the first button hasn't been clicked. As far as not being able to find the code, it's possible that none exists yet or that something has caused it to get deleted. If your OnClick...

I am a novice access programmer and am currently working on my first project. My knowledge of VBA is very limited, but I am trying to learn. I've searched in many books and in different forums across the net for the answer to this one, but can't find it anywhere. I've made a wizard-type...