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 wOOdy-Soft 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: *

  • Users: pokeymonsc
  • Content: Threads
  • Order by date
  1. pokeymonsc

    Running a Query from a form

    I have a query that uses an input from a form, the results being all people in a selected pay-grade. Since the field contains paygrade and step (04/05, 10/02, etc.)and I want all persons in paygrade 04 I use the following code: Like [forms]![frmGradeSelect]![cboGradeBegin] & "*" This works...
  2. pokeymonsc

    Load combobox from recordset

    I want to load a combobox on my form from a table in another sqlserver database. I can code to open the connection, load the recordset and debug.print it. But I was told in my 'Access:Developing Enterprise Applications' that I can't use a recordset as a source (to a form, table, query) and my...
  3. pokeymonsc

    Something similar to a Word Perfect macro

    Hi, This off the normal programming tract, but..... In Word Perfect we used to run a macro to put in a return address(about 7 lines long, which is why we automated it). This macro was on the network server where anyone in the office could access it. Well, now we are using MS Word and first off...
  4. pokeymonsc

    You do not have permission to use *.mdb object

    Help! Somehow I have done something to to my access application where when I try to open the mmis.mdb I get an error message: "You do not have the necessary permissions to use 'Path/mmis.mdb' object. Have your system admin or the person who created this object establish the appropriate...
  5. pokeymonsc

    Pass Through in Query Designer

    I've created a pass-through query to a stored procedure on SQL-Server using Query Designer in access. I've done this with another SP and the method works fine. The code for this SP is: EXECUTE spDeleteChildRecords [mmes_number] What I'm unsure about this time is the correct code to pass a...
  6. pokeymonsc

    Access Query Designer to make Pass Through query

    I've created a pass-through query to a stored procedure on SQL-Server using Query Designer in access. I've done this with another SP and the method works fine. The code for this SP is: EXECUTE spDeleteChildRecords [base_data.mmes_number] What I'm unsure about this time if this is the correct...
  7. pokeymonsc

    Another Loading an Unbound Subform

    I have a parent form linked to a multirecord unbound subform. I am using the following code to load the subform: Dim rs As DAO.Recordset Dim QDef As QueryDef Dim tmpID As Integer tmpID = Forms!SalaryBenefits!txtEmpID.Value Set QDef = CurrentDb.CreateQueryDef("", "select *...
  8. pokeymonsc

    Where clause in Access VBA with SQL server backend

    I have an access 2002 front end with an ODBC connection to a SQL server back end. I am trying to open my form using the following code: Dim rs As DAO.Recordset Dim QDef As QueryDef Dim tmpID As Integer If Not IsNull(Int(Me.EmpID.Value)) Then tmpID = Me.txtEmpID.Value...

Part and Inventory Search

Back
Top