Recent content by pokeymonsc

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