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

...I'm sure this all sounds kind of confusing so if you aren't totally clear on something please ask because I can use all the help possible right now. I tried the suggestion from formerTexan and I received the following error: **For Each can only iterate over a collection object or an array**

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