Search results

  1. T

    Problem with Elseif statment

    I have an ElseIf statement. If the field is left blank when the tech hits the save/update button. It prompts them that the field is empty and to fill it in, then takes them to that field. Problem is that if the field is filled in, it still pops up the prompt and will not allow the tech to...
  2. T

    Import/Update Query to correct names

    Hello, I have a macro that dumps employee names into a temp table, then dumps them into the main Employee table. Yes, I could probably dump them straight into the main table. The temp table is used in another query as well. My goal is to fix the names in the query by using the "CorrectName"...
  3. T

    Notify Tech If Serial Is Missing Numbers

    I have a field that has Serial numbers from computer equipment. There are some that the serial number is incomplete. When the tech opens up the form to view the computer information, I would like it to popup a msgbox and inform the tech that the serial number needs completed. This will let the...
  4. T

    RTrim function

    can this be put in the table or query? or is it only available to the form fields?
  5. T

    Auto Correct last names with "MAC"

    Having problems getting this portion of the module to work. 'Look for and fix "Mac" If InStr(1, strName, "Mac") Then strName = Left(strName, InStr(1, strName, "Mac") - 1) & "Mac" & _ StrConv(Mid(strName, InStr(1, strName, "Mac") + 2), vbProperCase) End If No matter what you type, it will not...
  6. T

    LOCK a form so no one else can use it until 1 user is finished

    Hi all, I have a form that is constantly used by several people at the same time. I would like to be able to have one user have the form open, and lock others out from using it until the one user closes it. When the one user does have it open, and someone else tries to open it. I would...
  7. T

    Loop through records in a temp table before it loads into the form.

    Hello, I have a query that pulls data from a table based on user input. The data is stored in a temp table. After the user selects the data, could be from 1 to 5 or more, it puts it in a continuous form. What I would like to have happen is before the data is loaded into the form. loop...
  8. T

    Record does not exist, open an add form

    I want to add a feature to my query where if the record does not exist based on a field, it will inform the user and then try on another field. If both values do not exist then it will open a form to add the information. Basically, I have a button that before it opens the form, it runs a query...
Back
Top Bottom