Recent content by Icecream7

Hi TheAceMan1, thanks for the advice on the subform. This whole project is begining to make me very frustrated. The realationships is what I seem to be having a problem with. I did create a subform on the main but it needs tweeking. My customers form is saving to a table but the subform isn't so...

So then I will need to declare the sql in the save button's click event? Also, if my user chooses multiple items from the listbox how would I write it to begin a new row for each selection? Thanks for the help

This may be a stupid question but I need to ask it......Can you have 2 recordsets in one event. With my form I want some of the information to write to one table and the rest to the other. I got the suggestion of splitting my table into two which I like, I'm just trying to figure it out before I...

I'm not sure if this will work for you but it has for me. I use this to write the selected items to a table. For Each varItem In Me.lstTub.ItemsSelected .Fields("lstToilets") = Me.lstTub.Column(0, varItem) .Update Next varItem You will declare the varItem and then on the save button or click...

Ok so I have been working with seperating the table but running into a wall with writing to the other one. How can I get it to write to a new row on the table? Do I create a new recordset and can I have them both set at the save button? With the strSelected code it is writing the options to the...

Thanks again, I will work on seperating the table so it isn't an overload on the main table.

Thanks Remou, I will try that. I need some advice on something......As I've said I have about 20 listboxes on this form, with the table I'm writing to should I have a cell for each listbox or just generic cells that are only for the ones chosen? Right now I have corresponding table cells for...

I have been working on a form that has several listboxes that are set up for multiselection. When the user clicks the save button the choices write to a table. What I am having a problem with is getting all selections in the listbox to write to the table.So far I am only able to get the first...

Hi Eupher, I have about 20 listboxes on the form each with 2 columns. What the form is for is.....they have a business where they create job bids based on several different kits. The kits are for various things and from what they have told me they do use different kits under one category...

Thanks guys I'll try the suggestions. I was a bit nervy on the ItemsSelected because I didn't get the drop down suggestions and when I did it only had InSelection.

Hi, I've been working on this database for someone for some time now and I have run stuck again. I do not totally understand how to get the multiple choice selections from a list box to a table. I've been able to get the other information to write but run stuck here. I also want to find a way...

Hi Ken Yes I have several back ups of the database. I create one before I do any major changing incase I need to go back to an earlier form of it. This is the first time I've worked with code in Access, I've done the basic creating a table,query etc but never the code behind it. As for the sql...

Hi KenReay I'll give them both a try. Only thing I'm wondering is if I have the sub form already created will it get messed up with changing it? I am supposed to have this project done in a few weeks so I'm trying to find the fastest easiest way possible. Do you know anything about connecting...

The sub form is created from a table but I need it to save to a different table. What the big picture of it is..... I also have several list boxes on the form which contain several options that they can select more than one thing. What I want to happen is for the customer information (cust...

I'm working on a form that I need to get the information from a sub form saved to a table when the save button is clicked. I've tried several different things that I have found and none of it seems to work. When I was messing around I created a Public Sub Information() and it inserted the...