Search results for query: *

Ok, thank you for the help.

Ok. That was what i thought also. Still trying to experiment with arrays and making it "easier" without the table creating procedure even if it would make the work easier. Thank you.

Is it possible to create temporary tables in Access? My DB will have several users so a table with static name is not possible.

Thank you for your replies, but they didn't actually work the way i wanted. The Dictionary object with the "set fd=" functions only within the same procedure as it's called. I would need somekind of global variable where i can choose several ID's to a "basket"/array and then make a filter of...

I have a slight problem with arraylist in Access VB. I want to select different report ID's into a basket. From the basket i want to just show the selected reports and then print or copy them to my hard disk. The problem comes when i try to create an array or use the arraylist. I don't exactly...

Thanks to everyone. Linney's post/link worked the best Download: http://www.jsifaq.com/docs/files/76011/snetcfg.zip unzip and place into %windir%\system32 The Start,Run, CMD snetcfg_wxp -v -u MS_Server snetcfg_wxp -v -l %system%\inf \netserv.inf -c S -i MS_Server snetcfg_wxp -v -u MS_Server...

Hi, I have a weird problem with sharing on my XP Home, computer. It says that the server service isn't enabled and i can't figure out how to enable it, because it doesn't exist in the Services under Administrator tools. I tried to search Google and MS knowledge base, but without any luck...

Make a query with this as the SQL syntax. This creates a table with 1 record and 2 columns. One column with the current max number and a other column with the next number that you need. SELECT Max(Table1.number) AS MaxOfnumber, Max([number]+1) AS Expr1 FROM Table1;

I was thinking of this kind of solution to update the check boxes and similar to add a new record. But this is not a good solution either, because it's more memory consuming to have a this for every check box, than just a "update" function (already inside access) and a un-normalized table. I...

I have that solution for other types of usages. But for this specific form it would be good for the sake of simplicity for the user to immediately see what is disabled and what is not. So check boxes should be used.

Ok, thank you. First that actually answered my question. Next, if i use the normalization which i have a version of already. So how would i update the one to many relationship. Working now with somekind of VB update recordset, any ideas for that?

I know the database normalization, not perfect but quite well. I've done the rest of my database into 3rd normal form, but in this case both of the options make it difficult. When the database is normalized i know how to get the information out (as i wrote before), but what i don't know is how...

And then to my initial problem, if i make the normalized table. How do i update the Nose = True into the table "tblThingControls" as the normalization implicates. And alos remove that record when a check box is chosen to False. Normalization in this case makes it so much more complicated...

What does this kind of normalization help? I still get a table with some duplicate fields + i get 2 extra tables which isn't that much of a help. I don't have a problem of doing this i'm just wondering how this will help. You can select all of the dog records because the dog is the primary...

It's supposed to enable and disable certain controls depending on what kind of "tool" is under editing. For example for a "TV" i don't need to insert the number of wheels so i should disable the control in a Form so that user can't insert the number of wheels into the TV record.

It's intentionally not normalized. It's only controlling a maximum of 10 records, so i decided that i wont win anything in this situation. It's not good if i overnormalize a simple table either.

Hi, I have a problem which i can't figure out how to do it. I have a table ie. : steering_wheel wheels nose boat true true false dog false false true bike false true false What i want is to populate a listbox with the...

I struggled with the problem to update records in a subform, i got some good advice from people here, thanks Remou. I just want to make a simplified version of Microsoft's solution that can be used in a subform. My version isn't completely used as a function, but as a sub. There is nothing that...

Thank you. This was totally awesome.

I'm still fighting with the problem i described earlier. Here is some more information on how i want it to work. Maybe it's little too difficult programming in VB, but i'm sure it should work. Beneath is a pic of the front-end where i want to update the sub-form. The selection is "painted"...