Search results for query: *

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

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

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

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

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

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.

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

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

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

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

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

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

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.

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

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

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

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.

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

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

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.