Search results

I'm sure it might be pretty easy to do, but once those items are added into that one field and are comma delimited, can I get Access to count each of those items as one "individual" item?

I understand what you're saying, but here's an example of what I'm doing. I have a set of clients that have different types of needs. I have to keep track of what their reason for calling was. So, I might have Joe Bob who calls for tire rotation and brakes service. So, in my form (and in the...

I have a field where I have a selection of terms that I can enter. I would like to know what method of separating the items should I use in order for each item to be counted individually. For example: Let's say I have the two items "toothbrush" and "toothpaste". Would I enter them as...

Thank you for your help. Just to let you know, I do know how to split databases, it's just that I've encountered issues when moving the necessary parts to different locations other than its original location.

So, can I only give the users the front end portion of the database or do I have to give them the backend also? Or can I leave that on a shared folder on the network and just relink all the tables? Thanks for the help.

So, I had to create a whole new database after my last one got wrecked. I also learned that any security features that I enabled on the database are lost upon transferral to another users computer on the network. So, this is what I want to try: I'm not even sure about creating individual...

I created a listbox with multiple items from a table that I created. Each item that I added to the table has a primary key that is set to autonumber each new item added to the field with a new id number. Now, why is it that when I use the list box the items are available for selection by...

This was a great source of information. My only question is: What portions of the code would I have to change in order to cater it to my needs?

I'll give this a try. Thanks. But, when I do move the mdw file, do I have to change the workgroup file to the new location of the mdw file? Also, will I have to relink the tables for every user that moves the front end to their computer? Thanks again.

My friends, today I have learned to dangers of securing your databases before placing them in their final destination. So, here's my question: If I created a split database on my computer using an .mdw file that is on my network location, when moving this database to a public folder, would I...

Yeah, everything worked out fine. Thanks for the help.

So, I go to Tools>Macro>Visual Basic Editor, go to the Debug drop down menu and then select compile, right? I did that and didn't get any messages. Don't know if I should have. But now, when I go back to that menu, the page just opens to blank page with a grey background. Does that the...

Unfortunately, that didn't work. Any other suggestions available?

No, but I'll give it ago.

Okay, I've been googling this issue for quite some time and apparently most instances of this occur when dealing with databases that contain vba code, none of which have I utilized in my database. So, here's what's happening: I go to Tools>Database Utilities>Make MDE File, create a new file...

Thanks for all the info. I think I'll go ahead with implementing the one to many relationship you mentioned. But, here's a quick question: Is it possible to do like you mentioned? As in, each time the user selects another item from the list or combo box, a new record is created in the...

I'm still learning how to express myself properly in Access terms, so forgive me. I should have said that I created a lookup field, for one of the fields in my table, and it contains multiple items. I hope that's the correct way of stating it. And now I just want the user to be able to...

Okay, I have a field with a list of items, all of which may be applicable to the person completing the form. What kind of form control can I create that would allow someone to select more than one of these items. I know that combo and list boxes are out of the question, as are option groups...

Thanks a lot Pat. Your knowledge has been priceless.

Great suggestion. Here's the expression that I came up with: DCount («expr», «domain», «criteria») = Forms![GeneralForm]![NumberOfChildrenInHome] But, I am lost at a certain step: For my expression, which function do I use to count the amount of rows. I know that there is a "Count"...