Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations Rhinorhino on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. ChrisHaynes

    Check file exist's on computers in network

    Hi all, I need help figuring out a way to check that all the computers on the company domain have a file existing in a certain directory (same on every computer). We recently edited the current login script to add this file to all of the computers, but need to know that it is definately there...
  2. ChrisHaynes

    Order By Highest First?

    Hi, I have a form (frmRegistryFiles) and need to show records in order of the highest value first in one of the fields. The field is 'RegNo' and contains 4 digit numbers. I need the highest reg number to show first, then next highest and so on. I know there is an 'Order by' property on the form...
  3. ChrisHaynes

    Need help on table relationships

    Hi, I have 2 separate tables, the main table has a list of all the computers in the company along with details about them. I then have a scanner table which lists all the scanners and contains 'Make', 'Model' etc. along with a 'Department' field and 'PC Name' drop-down field (to show what...
  4. ChrisHaynes

    Update record on 2 tables??

    Hi, I have 2 separate forms, both have a field which I have created a relationship between. They both link to records on 2 serparate tables. However, when I rename the field on one form, which I often have to do, this doesn't update the record in the other table, which causes the data to be...
  5. ChrisHaynes

    Dlookup function is not working

    Hi. I have a register form, which is unbound. When I click the command button to create a new user, it is supposed to use the Dlookup function to check that there aren't any records including the first name and surname in the User table. However, this doesn't work and the form still add's the...
  6. ChrisHaynes

    Minimise all other forms when one is loaded

    How do I do this? I have tried using code in the GotFocus event of the form and tried to reference it to the other forms by using docmd.minimise, "Forms!frmHome" This isn't working though. Can anyone help?? Thanks, Chris.
  7. ChrisHaynes

    Close form after another has been opened?

    Hi, I have a command button on a form (frmHome) which opens a form (frmHardware). Wot code do I use after docmd.openform "frmHardware" to then close the original form (frmHome) I have tried DoCmd.Close acForm "frmHome" but this doesn't seem to work? Any ideas?? Your help would be greatly...
  8. ChrisHaynes

    IF (form is open) THEN??

    Hi there, I don't know the expression to say IF a form is open THEN Can anyone help? Thanks
  9. ChrisHaynes

    Set the minimum amount of characters in a text box

    Hi, How can I check that a field in my form contains a minimum of say, 5 characters when I click a command button? I am going to use it with an if statement for example: if Me!Password (is less than 5 characters long) then msbox "Password needs to contain a minimum of 5 characters" Thanks, Chris
  10. ChrisHaynes

    Register Form

    Hi. I am trying to create a registration form to add new users to my database. I have created the form and have several fields linked to my user table (tblUsers). I have a command button at the bottom of my form which I would like to add the new user record to my table after checking...
  11. ChrisHaynes

    Search 'yes' criteria?

    Hi everyone. I am trying to create a search tool on my main form. I have a combo box (test) listing all the fields to search by. These fields are all tick boxes on the main table (yes/no as the data type) I am trying to create a command button that will open the form containg all the records...
  12. ChrisHaynes

    Adding a Proper Case module

    Hi, I was looking at this archived thread: thread702-928808 about vbProperCase and creating my own proper case module. I have added the module to my database. Then I tried adding the code Me.User = MyProperCase(Me.User, 0) to the 'after update' section of my 'User' field text box. However...
  13. ChrisHaynes

    Text box to calculate total records in a table?

    Hi, I have a text box on my main form which I need to calculate the total records in 1 of my tables and display the total. What code do I need to put in the control source of the text box?? Cheers, Chris.
  14. ChrisHaynes

    I need my code to link to field names with spaces??

    Hi, I have a code which links a combo box to fields in a query. It works for all the fields with no spaces between the words. How can I edit the code to work with fields with spaces? I have tried entering brackets but this hasn't worked. Can anyone help...
  15. ChrisHaynes

    How do I format a combo box to delete part of the value???

    Hi, I have a combo box with values that I have entered myself. These values are linked to fields in a query. The values are sums of certain records in a table. Meaning the field names have been set to 'SumOf'followed by the original field name eg. 'SumOfAcrobat', 'SumOfOffice XP'. Is there a way...
  16. ChrisHaynes

    How can I use a combo box entry to complete the name of a field?

    I am trying to use a combo box entry to complete the name of a field in a query. I have put this code behind a text box and I want it to look at the query and use the start of the field as 'SumOf' and then the combobox entry to be used as the text to add next to it. Then the data in this field...
  17. ChrisHaynes

    Autofill date field when adding a record?

    Does anyone know how to autofill the date field with the current date when adding a new record? Any help will be greatly appreciated. Cheers. Chris.
  18. ChrisHaynes

    Logon form not working properly??

    Hi there. I know there has been many posts about this which I have been researching, however can't understand why my code isn't morking. I am creating a simple logon form for my database. Firstly, I have a user table (tblUsers) containg a 'Username' field and a 'Password' field. And a logon...
  19. ChrisHaynes

    Combo box to select a field to search by

    I'm fairly new to Access but have been trying to create a hardware database for work. I have one main form and then 3 separate forms for each type of hardware(Printers, Scanners, Routers). Each form contains records with relevant fields for each hardware type. For example, the printer form...
  20. ChrisHaynes

    Clear text box on enter??

    I have a text box in a form with a default value. Does anybody know how to clear any text already in the text box when the user clicks/enters it? Any help will be much appreciated! Cheers. Chris.

Part and Inventory Search

Back
Top