Search results

  1. L

    preview report from form

    I tried that, the problem with that is that it just opens to the first record in the table. I need to link the form and report so that it opens the report to the same record that is open in the table. For example if the form was open to the record with IRR# 123, I want the report to...
  2. L

    preview report from form

    Correction It does not display on the screen, just prints it out. I would just like it to display on the screen, NOT print out.
  3. L

    preview report from form

    I am trying to place a button on a form to preview a report, I want the report to open and display the same record that is in the form. Here is the code I used in the On_Click event of the button Dim stDocName As String Dim stLinkCriteria As String stDocName = "VIR Info Report"...
  4. L

    Trouble setting up Relationships

    The setup of tables was not my doing, I was given specifications for that. The SO Num or SO Num/IRR Num are used as the primary key in each table because it is the only thing that is unique. This is my first larger database with many tables so I appreciate any help that comes my way. There...
  5. L

    Trouble setting up Relationships

    I am having trouble setting up the relationships in my database correctly and looking for any help that anyone can provide. Here are my tables (some tables have many fields so I will only list the primary key which is the only similary field in the tables, if you need more info just ask) Table...
  6. L

    Record fills in if it exists

    I will most likely try both solutions and see which works best for me. Thank you both for your input. Autoeng, I am interested in any code you can supply me with to get this done. Thanks.
  7. L

    Record fills in if it exists

    The way my form is set up now, it is bases off a query that prompts the user for a SO Num. If the number exists the form opens displays the first record with that SO Num and they can flip through all other records with that number. If the SO Num does not exist the form opens blank and they can...
  8. L

    close two forms at once

    I have a form that data is entered in, a button is then pressed to accept the data and take the users to another form where they receive a number. When the users either press the button on the first form to accept the data and go to the other form, or press the close button on the second form...
  9. L

    detect data entry

    I have gotten an idea from someone but not sure if it will work. Can I set a variable in the open event of the form to true, then set the variable to false once data is entered into any of the fields. Then when the form is closed it checks to see if that variable is true and if so it allows...
  10. L

    detect data entry

    My date field is automatically set to put in today's date when the form is opened, would that make it dirty once that is put in? I am not quite sure how this 'dirty' thing works.
  11. L

    detect data entry

    I have a form where data is entered. Once a record is started I would not like the users to be able to close the form until all the required fields have data entered ( I have figured this part out with lots of help). The problem is, a user may open the form and then without entering any data...
  12. L

    Prevent form from closing

    There is something I have been trying to figure out for quite sometime that could solve several problems I am having with my database. My question is, Is there anyway to prevent a form from closing when the 'X' button is pressed. I have code on the Before_Update() event of the form that 1...
  13. L

    automatically filling in field if left null

    As you can tell, I am a beginner at VBA code so I appreciate all the help you have given me. I do now know however, to choose the names more wisely. I have a question. I tried to use code to check if the part # was null and I did use brackets: If IsNull (Me.[Part_#])Then MsgBox "Part #...
  14. L

    automatically filling in field if left null

    ??? Did you say though that the only way I would be able to use Part# in my VBA code was if I changed the name and took out the #? So then I would have to change the name everywhere that it is used in order to put a check on that field
  15. L

    automatically filling in field if left null

    That field name Part # (This db was created over a year ago, I now know better when creating field names) is in about 15 different queries, 15 reports and 6 forms, and also in some code. Is there an easy way to change the name or does it have to be done on each thing separatly?
  16. L

    automatically filling in field if left null

    When a required field is left empty and the user closes it there is an error message that says that field is required. However, after the user hit OK another message comes up and tells the user that the info will not be saved and asks if they want to close anyways. If the user closes the...
  17. L

    automatically filling in field if left null

    A little more info: Part# is a required field. The problem I am having is that users will leave a required field like Part# Null and then close the form. It does give a warning that the data will not be saved. Well then other users will go looking for this record but it does not exist in the...
  18. L

    automatically filling in field if left null

    Is there any way to automatically fill in a field on a form if it is left empty when the form is closed. I tried putting some code in the Before_Update() event of the form but that did not work. Here is what I put: If IsNull(Part#) Then Part#=Void End If Any suggestions?
  19. L

    searching for only part of a field

    I was just using that as an example. The field would contain several numbers 123456 being one of them. The field is called Heat Num and could contain one 6 digit number up to five 6 digit numbers, each separated by a comma for example: 123456, 987654, 111111, 222222, 333333 and I want to...
  20. L

    searching for only part of a field

    Let me explain my situation and hopefully it makes sense. I have a form with a field on it called Heat Num. I have used an input mask to allow the user to add up to 5 separate numbers in this field. Now I would like to create a query that allows the user to type in a six digit number and have...
Back
Top Bottom