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 derfloh 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. pokeymonsc

    Running a Query from a form

    So simple I didn't think of that. It worked, thanks for pointing it out. %-
  2. pokeymonsc

    Running a Query from a form

    ...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! When I run the query I select the paygrade (09) and get all 09's reguardless of what step they are. Now the question: I'd like to be...
  3. pokeymonsc

    Sorting by expression field

    If I can intrude, I have a similar question. I have a report from an employee database that uses birth date and hire date to figure out retirement eligibility date. The calculations are quite lengthly and took up about a page. The report is printed out by name but I would like it to be printed...
  4. pokeymonsc

    Load combobox from recordset

    Roy: I tried the first method: set me.cbxautofctitle.recordset = rstEmp and got the same runtime error as: me.cbxautofctitle.rowsource = rstEmp. e.g. it didn't work. Then I tried the second with this code: Dim strSource As String Do While Not rstEmp.EOF strSource = strSource &...
  5. pokeymonsc

    combo box to find records on unbound form ADO

    I've tried using this code me.cbxautofctitlel.rowsource = rstEmpNames but I get a run error saying that Jet can't find a table or query with which to populate the combobox. With ADO I have to open a connection to a remote table and then use a recordset to import the data. What I'm doing now is...
  6. pokeymonsc

    Load combobox from recordset

    Thanks, guys, I'll try these solutions in the morning and let you know how it goes. I do appreciate the answers.
  7. pokeymonsc

    combo box to find records on unbound form ADO

    Ken: I was searching for an answer to a problem and saw this post and wondered if I could butt in to ask a related question? I have a data entry form and am selecting a manager's title in a combo box. The source for the combo box is a table in a different sql server database. I can open a cnn...
  8. pokeymonsc

    Load combobox from recordset

    Main reason is: To set up a linked table I would use an ODBC driver, which means that I would have to set manually up the link. Ultimately this ap is going to every desktop in our org and that's a lot of setup time and energy. With an ado connection I can code the connection, but I'm back to...
  9. 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...
  10. 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...
  11. 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...
  12. pokeymonsc

    Geting Combo Box to go Directly to Record

    ...object." I went to SQL view and studied the query statement and The Lord popped the answer into my head. My SQL was Select dbo_SalaryBenefit05.*, dbo_SalaryBenefit05.LastName from dbo_salaryBenefit05 Order by dbo_salaryBenefit05.LastName It was the .* that had LastName in the SQL...
  13. pokeymonsc

    Geting Combo Box to go Directly to Record

    Roy: Don't know if you are still watching this post, but ..... I'm using the above code to use a combo box to locate employees and force the form to go to their record. The form itself is based on a query and worked until I decided to sort the query using 'Last_Name'. Once I did this then I...
  14. 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...
  15. pokeymonsc

    Access Query Designer to make Pass Through query

    I appreciate the answer, but I think I emphasized the wrong point. My SP code protected the database (if @id1 is not null). I tested the procedure and found this out. If my code in the pass through query is: EXECUTE spDeleteChildRecords 'zwert1' the SP will delete those records from the...
  16. 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...
  17. pokeymonsc

    Prevent field edits

    PS: Roy, I put the suggestions into the module, but when I run the first one (just wanting to clear up loose ends even thought the 2nd works) I still get the same error. In your FAQ 5010 I don't see anywhere where you 'assign' ctl.controltype be fore using it like I did. Still don't quite 'get-it'
  18. pokeymonsc

    Prevent field edits

    Guys: While I was waiting for an answer I noticed that ctl in the 2nd was crl. I corrected the typo and the code works fine. Thank you. And Roy I did look at 5010 and it is great. Thanks to both of you for your time
  19. pokeymonsc

    Prevent field edits

    Sorry my bad, form is not a subform, but is called by a cmd btn with code: DoCmd.OpenForm Form2, , , stLinkCriteria Even with DoCmd.OpenForm Form2, , acReadOnly, stLinkCriteria form2 allows editing. ?????? I tried your code, doesn't work, but locking each textbox will. So I used this code to...
  20. pokeymonsc

    Prevent field edits

    blorf: I have the same problem as craiogram. The main form responds to 'allow edits' but a child form called by a button on the main form will not respond to 'allow edits = false' no matter how I write it. ??? But, your locked solution does work and so my question is: Do you have a good way of...

Part and Inventory Search

Back
Top