Search results for query: *

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...

Hi I have a project that I am working on for a business. It consists of a couple differnet forms that they can generate print outs for customers on. There will be 3 people accessing it, 2 from the office and 1 from home. What I'm wondering is...I have an FTP account and I am wondering if I...

Yes Zion7 the form does display the correct information when you click on a kit from the combo box. All of the kits that are listed in the combo box are bound to a kit information query. It's working good now...thanks for the help. Now on to the next portion. Not a problem Remou....thanks for...

Zion7 I tried the code you had suggested and it worked as far as being able to enter a new kit but.....the last auto number was 318. I tried to enter that number into the auto field and it wouldn't let me. When I tabbed to a different record and went back the system inserted 472. Doesn't it keep...

I'll try adding the code from Zion7 to see how that works. I am interested in your point also Remou but I don't know how to synchronise, can you give me some help on it? Yes ssatech the Record option is at the bottom of the form. It's based off of a query but it doesn't open throught a differnt...

I was reading this post to find out more about the ADO and DAO and it made me wonder about a database I'm doing for someone. So far I haven't done any programming because it's a new database and I've just finished up entering in the information and creating the tables,queries, & forms. I won't...