Search results for query: *

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

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

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

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 &...

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

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

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

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

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

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

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

Thanks RobotMush: The first sentence was the key. "First off, the SQL Statement is accessed in your Query 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...

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

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

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

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

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'

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

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

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