Search results

  1. R

    Access 2013

    If building an app for web usages isn't so good. How does sending email forms to customers and inputting their responses work?
  2. R

    Join name fields

    Aw thanks - that's precisely what I wanted to know. I need a full name field in the "Work Log" table. So I put a calculation to concatenate the 2 fields in the Employee table and include that in a query.
  3. R

    Join name fields

    Maybe this is a dumb question. I have a DB with 2 tables. An employee table and a work log table. Equally the same to populate them with 2 forms. The work log table is connected through the employee's ID number. But for confirmation I need to have the employees full name pop up on the work log...
  4. R

    Web Compatible too X

    My 2nd table has this error. ACCWeb107013 Error text Property value is not compatible with the Web. What it means The indicated Number field has its Format property set to something besides General Number, Percent or Standard. Only these formats are supported on the Web. What to do...
  5. R

    Web Compatable Error

    The following Code pops up when I run the "Web Compatible" check? ACCWeb107014 Error text A Table should have a Primary Key and it should be a number with field size 'long' to be compatible with the Web. What it means The indicated table has one of the following problems: · The...
  6. R

    32bit vrs 64 bit?

    I'm shopping to buy a new laptop and upgrade from A2010 to 2013. But I read that the 64 bit version may have some problems. Is it then a critical decision if the computer is 32 bit or 64 bit?
  7. R

    Please, please, please let somebody know how to do this....

    Open a form or report in Design view. Right click on a field or control and scroll down the pop up ribbon. I use this a lot on both forms and reports. Whew I hope this helps. My first opportunity to maybe help someone in return.
  8. R

    Nested "If/Then" stmt

    Thank you from the beginning. This will go along way to ensuring accurate data entry. This is my code. Did you mean I need to put each series in a separate section? Private Sub Form_BeforeUpdate(Cancel As Integer) (is this right?) If [Day2] <> 24 Then MsgBox "some error", vbOKOnly Cancel =...
  9. R

    Picture of Employee in a Form

    We'd have around 150 employees. And I can store them is a folder, no problem. My questions are. What format does Access like? Which format is best? jpg or.... When just how do I get each contact record through the form connect with the right picture. I've chase my tail, jumped through hoops etc...
  10. R

    Prevent enter

    Thanks CJ - I need it visible, so I'll try the other methods.
  11. R

    Prevent enter

    How can I prevent my staff from entering an un-bound control box calculation?
  12. R

    Nested "If/Then" stmt

    How do I write the code to do an "If/Then - Else" statement. I have 3 calculations in un-bound boxes. All three have to be correct for the record to be deemed "correct". 1) = 24 2) can't exceed 14 3) can't exceed 100 If there is any "false or no" then don't check the check box with a...
  13. R

    Nested "If/Then" stmt

    I have 3 conditions that must be met on a form before a record should be saved. I have a "Yes/No" field in a bound button. Condition 1) must equal 24. 2) can't exceed 14 3) can't exceed 100. Then if it's a "Yes" ( it needs to input a "yes" in the control or field), and then "open a new...
  14. R

    ON GotFocus

    "I'm a certified grandpa and proud of it. Not quite so valuable" heck no, your way more valuable now, got some precious lives to build into. I know :-)
  15. R

    ON GotFocus

    I should be more specific. The 2nd last button on my routine in filling a form is to "tab" to a "yes/no" button concurring if the record is correct or not. If it is a "no", the record may be wrong, but the information entered is what was reported to me on "hard copy", so I must enter it the way...
  16. R

    ON GotFocus

    Private Sub RecOK_GotFocus() [RecOK_Label].[BorderColor] = "#22B14C" End Sub Didn't like that, turned yellow
  17. R

    ON GotFocus

    To the Label so it creates quite a eye catching sign for the typist. Otherwise it's hard to see where the "Focus" is at.
  18. R

    ON GotFocus

    When I tab to this button I'd like the border to change color so the typist knows where her focus is for sure. I've tried numerous syntax to no avail. Why doesn't this one work? =[RecOK_Label].[BorderColor]="#22B14C"
  19. R

    Decimal display problem

    Yep double and triple checked and quadruple checked. I deleted the control in the form and put back a new one and it works fine. ????
Back
Top Bottom