Search results

  1. F

    Create table with info found in form

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

    Scrolling thru records

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

    Duplicates

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

    Fill a subform with values from diff tables dep on listbox

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

    How do I store an IP adress?

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

    Reflexive relation

    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!
Back
Top Bottom