Search results

  1. T

    Forms Help

    Hm....ok I got everything going. Except what is weird is that it calculates the total when you open just the subform. But it brings up an error when you open up the Orders with the subform. Hum....I will keep on trying here.
  2. T

    Forms Help

    If you send me something that I can edit, I can inport one of my forms that I have done and then just change the fields to match yours. If you want that done I can do it. Just send me a database I can edit.
  3. T

    Forms Help

    Ok, I looked at the database. Yeah, you are right it doesn't work right when you put the text box on the Main form. I know you want your subform to be in Datasheet view, but since you have so many fields and you have to scroll horizontally, it probably would look more professionally done if...
  4. T

    Enable Button Due To Criteria?

    Perfect. One question to better understand the code....what does the Nz mean? And what event would be the correct placement of this code?
  5. T

    Forms Help

    Says "File Not Found".
  6. T

    Enable Button Due To Criteria?

    I appreciate your helpfulnes. Ok...I can do everything, but not unsure how to check if they are populated? Could you give me more information on that? I tried this code: If Not(IsNull(Me.txtCompany And Me.txtAddress And Me.txtCity And Me.txtState)) Then Me.btnSave.Enabled = True But this...
  7. T

    Enable Button Due To Criteria?

    Just a simple problem that I can't seem to figure out. Background: I have a form and I have option to add a new company. Then when the user gets done filling out information they need to press Save. But the problem is that sometimes a blank record is saved... So what I thought was that...
  8. T

    Forms Help

    Ah, sorry for the confusion. I wouldn't know the equation right now. I would need to see your database to figure it out. So if you send an example or whatever, I can see if I can figure it out for you real quickly.
  9. T

    Forms Help

    Just click on the Properties of the field and go to Data and then Control Source and then click the elipses (SP?) and then create an equation.
  10. T

    Lock all Controls on a Tab?

    If it is a particular tab on a particular field, put the code in the On Lost Focus event of that field....and then unlock the controls on your desired field in the On Got Focus event.
  11. T

    Need to copy Text from one form to another

    DoCmd.RunCommand acCmdCopy I think that is the code.... And then put: DoCmd.RunCommand acCmdPaste I hope that helps.
  12. T

    Forms Help

    Maybe what I would do, but probably not the best way, is to create another text field in the mainform and then fiddle with the Control Source of that text field so everything you want to add from the subform is added. Hope that helps...
  13. T

    Searching particular Detail IN Report

    Alright. Good luck on the rest of your database.
  14. T

    Posting Date Criteria on Report from Query

    This is how I do mine. I input the dates from a form. But on your report make 2 text boxes. Put this in the first one's control's source: =[Forms]![frmName]![txtDateFirst] and then put on the second's contol source: =[Forms]![frmName]![txtDateLast] That works for me. Fill in your...
  15. T

    Searching particular Detail IN Report

    PM me and send me your database. I can help you.
  16. T

    report search

    Make a query. Include the fields that you want to show in your report. Fiddle with the criteria in the query because that is the most important part. Then make a form based on the query and make some buttons to open up the report. Finally save the query as a report. And you should be good...
  17. T

    Combobox with active employees

    I just dealt with this for Active/Inactive companies. What I did was when I wanted to delete a company, I would press a Delete button, but the company would only be inactive. It would not be deleted. It my table I had an Active/Inactive column. So when deleted, that field would be changed to...
  18. T

    Login Form in Access

    There is a problem with your IF statements. Or your End If. Maybe put End Select on a line above End If.
  19. T

    iPhone, is it worthit?

    I have an iPhone and it is worth it by far. Phone, GPS, REAL internet, iPod? What more do you want. And with this new update for the iPhone that just occurred, you can download applications such as games, instant message clients, navigation, TV apps, radio apps.....the list goes on and...
  20. T

    GoToRecord

    Another question, say there is two "Does". One in one company, and One in the other. When you go to the next company, the code doesnt work anymore and highlights the first record again. Any suggestions?
Back
Top Bottom