Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations John Tel on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Recent content by JavaToPerlNowVB

  1. JavaToPerlNowVB

    Link Tables according to user login

    I have an access form for user to login (username, Password) and depend on the user I want to link tables with the background sql database. In my tables I have a column to save the username at each login in time. Is there any place I can look into get some information to write this code. This...
  2. JavaToPerlNowVB

    Code for Link Table using login in Form

    I have an access form for user to login (username, Password) and depend on the user I want to link tables with the background sql database. In my tables I have a column to save the username at each login in time. Is there any place I can look into get some information to write this code. I dont...
  3. JavaToPerlNowVB

    Activate a Field for editing

    thanks, this means that it takes boolean value where i can do objelementreference.focus(true); or is there a function in vbs something like field.setEditable(true); I am so used to java so, sorry if i ask none related question.
  4. JavaToPerlNowVB

    Activate a Field for editing

    I have a form, which I have created using xml, and i use some vbscripting to handle some action in that form. I want to write a small code to activate a field to an editable mode when the user click a button. I dont VBScripting syntax that well. thanks
  5. JavaToPerlNowVB

    Can i get Help with VBS in this forum

    I have a form, which I have created using xml, and i use some vbscripting to handle some action in that form. I want to write a small code to activate a field to an editable mode when the user click a button.
  6. JavaToPerlNowVB

    How run query in the background

    Hi Everyone I have this code in a form, and I want to run few queries before the report grab data from those queries. I am not sure, if i should do docmd.openquery "queryName" but this way the query will open for the user and i don't want that to happen. Private Sub workDonePoles_Click() On...
  7. JavaToPerlNowVB

    Run Query Before Report

    Hi Everyone I have this code in a form, and I want to run few queries before the report grab data from those queries. I am not sure, if i should do docmd.openquery "queryName" but this way the query will open for the user and i don't want that to happen. Private Sub workDonePoles_Click() On...
  8. JavaToPerlNowVB

    Away to hide access tool bars???

    I am good ssatech, thanks for the info
  9. JavaToPerlNowVB

    Away to hide access tool bars???

    Is there away to hide access tool bars and menues when i bring up forms and reports. I am new to access so don't get mad at me for question like this.... thanks alot
  10. JavaToPerlNowVB

    Report not showing up in the screen

    Thanks Roy, you did it.
  11. JavaToPerlNowVB

    Report not showing up in the screen

    I have this code in a form as an action for a button, When the user hit the button in the form I want a report to showup in the screen, accoring to my code it doesn't showup in the screan but it gets send it to the printer. Private Sub poleSpecificReport_Click() On Error GoTo...
  12. JavaToPerlNowVB

    Cant see forms

    See your link table properties, my be you have to install the Database Conectivity in that computer and link the all the tables with the new database connectivity. JavaTOPerlNowVb
  13. JavaToPerlNowVB

    Sum Function

    I get columns according to the maintaction I want to add each column. I didnt find anything in the wizard. thanks
  14. JavaToPerlNowVB

    Sum Function

    I have this query and I want to include sum function to calculate the total of a column, I know how to use the sum function is a regular select statement but I am not sure how to add that to this query TRANSFORM Count(OBJECTID) AS CountOfOBJECTID SELECT DatePart("yyyy",[INSPECTDATE]) AS...
  15. JavaToPerlNowVB

    how to use '% XXXXXX%' in access

    WOW PHV You are the best, This forum is lucky to have a smart person like you. Once again Thanks alot

Part and Inventory Search

Back
Top