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!

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

Search results for query: *

  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

    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
  4. 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.
  5. 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...
  6. 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...
  7. 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
  8. 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...
  9. 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...
  10. JavaToPerlNowVB

    how to use '% XXXXXX%' in access

    SELECT MAPNUM, MAINTACTION, WO FROM GISADM_GNDLINEFACILITYMAINTPOLE WHERE (((MAPNUM) Like [Forms]![MainSearchForm]![MapNum_Text])); But some map numbers don't get recognize since they have some wild characters at the end of the map number. so I did direct sql in with wild cards on like this...
  11. JavaToPerlNowVB

    How to sum columns

    I have a query and I want to sum up all the columns, This is the sql query that I have SELECT CountSwitchGearInspectionByYear.[Inspection Year], CountSwitchDeficienciesByYear.Maint, CountSwitchGearInspectionByYear.[Units Inspected] FROM CountSwitchGearInspectionByYear INNER JOIN...
  12. JavaToPerlNowVB

    Help with SQL Queries

    I have these two queries and I would like to add "Units Inspected" column, which is in the second query to the first query. Is there away to do that, How could i do so... Here are the queries TRANSFORM Count(GISADM_GNDLINEFACILITYMAINTPOLE.GLFWM_MDB_KEY) AS CountOfGLFWM_MDB_KEY SELECT...
  13. JavaToPerlNowVB

    Help Access Reports

    I am not sure if I can bring to queries into a one report: I want to user some different columns from different queries. thanks
  14. JavaToPerlNowVB

    Help With SQL

    I am trying to rebuild some of the old Queries in old database and I came accross with this SELECT gl_maint_action.glfwm_key, [description] & IIf(IsNull([com_a]),""," (" & [com_a] & ")") & IIf(IsNull([com_b]),""," (" & [com_b] & ")") AS [Desc] FROM gl_maint_action INNER JOIN gl_maint_code ON...
  15. JavaToPerlNowVB

    Not null, not ' ' what are they?

    I have these tables and I don't know who did but the problem is that I have a field (Text Field) but have used to store a number. And there are blanks for some records. I want to change some those records to a number. I tried like this as a example SQL> select prefix, suffix, wo from...
  16. JavaToPerlNowVB

    Yes/No Msg Box

    I want to create a yes no msg box where if user press yes do something and if user press no exit out. thanks
  17. JavaToPerlNowVB

    help with update funtion

    I have this code in in my form Private Sub WorkOrderUpdate_button_Click() On Err GoTo err_WorkOrderUpdate_button_click Dim updateQryPole As String Dim updateQryPed, updateQrySWTGR, updateQryXFMR As String Dim searchWOnumPole As Variant Dim searchWOnumPed As Variant Dim...
  18. JavaToPerlNowVB

    how to handle check box

    I have a form which has for subforms which are get feeded by four queries. I created 4 check boxes in the main form. I want each subform to showup the data depend on the check box that user select Example If "checkbox is click" run this query : : I don't know how to handle...
  19. JavaToPerlNowVB

    Direct SQL Vs Access SQL

    I have this query in access, where it takes some information from the form to complete its task UPDATE GISADM_GNDLINEFACILITYMAINTPOLE SET GISADM_GNDLINEFACILITYMAINTPOLE.WO = [Forms]![MainSearchForm]![New_WorkOrder_Text] WHERE...
  20. JavaToPerlNowVB

    Form to add record

    I want to create a form to add record to a table only if that record is not in the table, Can I do this in access. thanks

Part and Inventory Search

Back
Top