Recent content by Fluffy

Hello, I have a form with information about hubs. When I enter the information of a new hub, and push the 'Save hub' button, next to saving all the info I want a new table to be created. I want the table to have the name of the hub (txtHubName on the form) and I want the number of fields in...

Thank you, but that just sorts the info that is already stored. Every time I enter a new one, it has to be sorted like that again. Is there a way this can be done automatically?

Hello, I have chosen my ID field as a text field. Some examples of existing ones are PC-0001 and PC-0018... When I create a new record, I can name it PC-0002, although PC-0018 already exists. I have made these scrollbuttons with the wizard, but when I scroll thru them, I get my records...

Hello, it works fine now. Thank you for your help, Oswald

I have an ID field in a table, stored as text. I have chosen the "unique, no duplicates" option. When I try to enter a string that already exists, it says 'no duplicates', which is good... When I enter a string that already exists in a form, it just stores it!! The text has an input mask...

This isn't the only info in the tables. (for instance: a printer doesn't have a hard drive, but a pc does) But it is the only info I want this query to show. That's why I have different tables. I'll check those links you posted. Thank you

Hey, I have 4 tables: Servers, PCs, Printers, XX. I also have a form with 2 listboxes: one listbox to chose the table to perform the query on, another listbox to chose whether warrenty on the chosen equipment is expired yes or no. For example: I want to see all the Printers that have an...

Hey, thank you very much!! It works!!

Nope, I had already tried that.

Hey, I need to store an IP adress in a field called SEIP in a table called Servers. I haven't found any inputmask I can use for this, so I guess I need to write a vba function for this. I have a form with a textbox where the IP nr should be entered. I've tried to split up the text string...

Both are used on the net (I tried both on google) I don't know which one is correct though...

Thank you!

And what about the second instance in relation to other tables... Do I relate the table 'PC's to both or only one of the 2 instances? I guess only one, but am not sure...

Okay, thanks... But, since one hub can be connected to more than one hub, I have an n to n relation... So, I have to add an extra instance in the relationships window and also create a new table to get rid of the n to n relation, am I right?

Hey, I have a table 'Hubs' with key 'Hubid'... Since a hub can be connected to another hub in a network, I have a reflexive relationship... How do I do this in Access? Any help would be appreciated!