Recent content by gambitbt

  1. G

    I know I am missing something

    Is this what you need? Or do you need the design view of the tables?
  2. G

    I know I am missing something

    I know this is probably something very easy, but I may be doing it incorrect. I have two tables, MPL and MU by Prov, which both have a field called ACO Member. The trouble I am having is when I update the field on the MPL it does not update the MU by Prov table. I have set a relationship, ACO...
  3. G

    Code is too long in editor

    I have found a code to help send the information on my form as the body of my email. I was hoping that someone could help me on breaking it up so it is easier to view in the editor. I read about line continuation but for some reason it does not work. It gives me the error message Expected: end...
  4. G

    Auto update FE Help

    jdraw...the thread is called FRONT END Db DISTRIBUTION. When I say master file, it is the front end database created by the split where all the updates are made. I'll make the update, change the version number and save it. I call it the master file because in the utility it states, "Select...
  5. G

    Auto update FE Help

    So I have found the thread regarding auto updating the front end and applied it to my database. However, when the users hit ok, it deletes the existing file and instead of opening the new version they get the following error message, "Windows cannot find C:\Users\...\Desktop\MPL. make sure you...
  6. G

    Expression Help

    Ok in my table I have two fields, Tomcat Server name and Practice Code. I am trying to use an expression to pull the information from those two fields into a form called frmHostingServices, where the user can click on the file path to open the folder. The expression is producing the file path...
  7. G

    Expression Help

    CJ_London...I tried that and it gave me #Name?
  8. G

    Expression Help

    CJ_London...I tried that and it gave me #Name?
  9. G

    Expression Help

    Gina, that is copied and pasted from what I am using.
  10. G

    Expression Help

    Good Afternoon, I am trying to generate a link to a folder based on two fields in my datasheet. The current expression I have is: "=(\\ "& "[TOMCAT SERVER Name] "&" \d$\eClinicalWorks\tomcat6_ "& "[Practice Code] "&" \webapp\mobiledoc\jsp\catalog\xml) When I go to view it, it looks correct...
  11. G

    Audit Log

    I am stuck with two log tables. First one is called tblLog which logs the user name that is entered into the frmLogin, with form opened, date and time. The second one is an AuditLog which logs the users pc name along with the form, and field that was updated. The second one is the preferred one...
  12. G

    Hello from Houston, Tx

    Afternoon everyone, My real name is Mike not Gambit ;). However, he is my favorite X-men. Anyhow, when I am not working I like to play video games and sit with my puppies. On the weekends I play slow pitch softball, mostly for "the cause" type tournaments. I am new to Access. I have played...
Back
Top Bottom