Search results

This can be done a couple ways and should also answer your other post. select [employee] , EmpID INTO #MYEmp from [table1] where [Num]= 1 select t.[Meeting Time] from [Time] t (INNER | LEFT | RIGHT) JOIN #MyEmp m ON t.EmpID = m.EmpID -- You must have something in common between [Time]...

DoCmd.SetWarnings False

I don't believe it inherantly does, but I found lots of articles from a Google search, so ...

Why are you wanting to move the installation? I would leave the installation alone and relocate the data and log files. But ... If you are really wanting to move the installation, detach all of the databases, move the data and log files to a drive different from the new installation...

I believe you can just put this in the criteria for Field A: [Enter a value for A or leave blank] or [Enter a value for A or leave blank] is null

That would work fine for you. When you create the table, you can also set the permissions for your users as far as being able to add/edit/delete (INSERT, UPDATE, DELETE). You should build an interface to add/edit/delete the records.

If moving to a SQL backend is the only thing that changed, then I would look at security. How are you authenticating the users on SQL? What permissions does there login have? What happens if you grant this user sa rights? What is frm defined as? What line is generating the error?

It won't be an issue in QA with that setting as long as the field size for COL1 + COL2 doesn't exceed 4000. Is this the full scope of your issue? Don't mean to sound b!tchy, but first you have TSQL which appears you are running in QA, then, you ask about Stored Procedures only to be followed...

Hello, I was in Vegas for a few days. Have you tried stepping through your code? On what line do you get this error? Try this: Private Sub PopUsers_Click() Dim TheFile As String ListUsers.RowSource = "" TheFile = "M:\PBS Wealth Management\Head office\Operations\Staff Database\PBS - Wealth...

I'm running out the door, but it the path does need to be fully qualified with the extension, too. Call ShowUserRosterMultipleUsers("M:\PBS Wealth Management\Head office\Operations\Staff Database\PBS - Wealth Management Staff DB.mdb") Also, you need to populate your listbox While Not rs.EOF...

Yes, that would work. I used the Select Case to illustrate that you can optionally test for lots of things. BTW, the reason the function does not work just returning the string is what the query sees coming back is " 'a', 'b', 'c' ". So if your criteria is: IN (GetCrit([blah])) what the...

Re-creating the SQL from the form is a good idea using QueryDefs and updating the SQL. Depending on the values you will be having, another option is to create a calculated field and query against it. In my example I have created a table and put in values a, b, c, d, e, f, g, h. Here is my...

Please post this query.

Just to confirm, your query utilizing aliases looked like: SELECT * FROM [Subject Assessment] sa INNER JOIN [Staff Profiles] sp1 ON sa.[Teacher ID1]=sp1.[Teacher ID] INNER JOIN [Staff Profiles] sp2 ON sa.[Teacher ID2]=sp2.[Teacher ID]; If you are typing this in vs using the QBE, your error may...

isetea, name the command button whatever makes sense to you. I call it PopUsers: Private Sub PopUsers_Click() ListUsers.RowSource = "" Call ShowUserRosterMultipleUsers("ThePathToMyDB") End Sub You can use your code, but what are you looking for? I started with the exact same code...

I think I saw something posted somewhere about a Transpose function. Do a search on this forum for Transpose.

Think about it for a second. You have $656.00 associated to Additional Living Room signed 06/20/2006 and $2,000.00 associated to Bathroom in the garden signed 06/22/2006 VO VO_Signed SumOfVO_Price Additional Living Room 06/20/2006 $656.00 Bathroom in the garden...

Do you have any VBA code anywhere? If so, do a search on this forum for References.

Then you have to get rid of the VO & VO_Signed fields in your query. They have unique values that is throwing off the Group By: SELECT tblPhase.Phase_No, tblPhase.Roads_Bond_Received, tblPhase.Roads_Bond_Ref_No, tblPhase.Roads_Adopted, tblSite.Site_No, tblSite.Department_Number, tblSite.Name...

You can also run this in any Enterprise Manager ... Table Design View ... SQL and paste and run the text. Be sure to re-register the server in EM, though.