Search results

Finally figured it out well sorta anyway Something must have corrupted when I copied over the new copy of the front end Just copied it over again Ran the Access Linked Table Manager tool and repointed to the DEV ODBC Connection and it works fine Go Figure Thanks for the help SQL Hell RRII

So the primary keys are all there on the tables Now on the views they are not showing up if that makes sense They do show up on the Production SQL Server with the same front end Hmm So if I run one of the Access Queries that links to the view on the DEV box I cannot upate any records ON...

As for an error I cannot add an lines to the Tables within access it just grays out the add new line button

I know when I look at the views the keys are missing The DBA for the SQL server di the transfer of the DB from one server to the other so that is possible I will do some checking RRII

This seems easy but I am having a problem Have not touched this in a few months Have the front end MS Acccess DB using an odbc link to the backend MS SQL server SQL Server has both tables and views Production works fine I want to take a copy of the Front End and point it at a different backend...

Would like to say a belated Thank you for all the help I got very busy putting this into production and have just been able to get back to the forum TY RRII

I figured out my root problem The unbound boxes where not named what I was calling in the Query No bloody wonder it was not returning any data Just thick headed again!!!! Thanks for the direction and help RRII

You are correct on the query builder and yes that is the how I have the criteria setup So if the query builder has DateAllocated as the first column ModelName as the second and Usage status as the 3rd column that should make it easier Start Date should be column1 ModelName column 2 and...

So the Query prompts me for StartDate: Model: and Usage Status: If I enter the correct values I get the right data These are my inputs from the form The form has 3 unbound boxes First box is Txt box for the Start Date: We are using a > value so anything after dd/mm/year value we enter will show...

Actually it is returning multiply entries from the query and the Report. What this Report is suppose to do is show all the devices we have Allocated to a particular group since specified Date of Model yyyyyy with Serial numbers I am trying to get just the allocated part to work first. The...

dk I understand where you are going here but now I am getting multiply entrys for Usage Status Ie 1 for each Serial number which is the primary key RRII

I think I have confused this a bit I am looking for the report to provide the data and it is not at this point So everything seems to work except when I try to do the input via the form drop down list RRII

K Now when I run the form I get the no data event What's missing RRII

Still working away at this and relatively new to Access I have a Command Button that points to a subform The Subform uses an Unbound txt box to provide the list of items in a drop down list I have an Event Procedure that calls the Report on Click The Report uses a record source from a Query...

Still fighting with this I know the Stored Procedure is working correctly Did some additional testing over the weekend and I know it it returning the right results Do I need a different setup in the VB code to get the multiply entries out? The code only provides a single result at the moment...

If I just execute the SP it will not give a result because it needs the parameter Here is the error Msg 201, Level 16, State 4, Procedure Find_Product, Line 0 Procedure or function 'Find_Product' expects parameter '@searchstring', which was not supplied. If I plug in a value like 11 it...

SQL_Hell Here are the pieces you asked for Thanks again RRII Fields to search are SerialNumber, ModelName and WorkstationNumber Here is the current SP USE [CDN_Logistics] GO /****** Object: StoredProcedure [dbo].[Find_Product] Script Date: 08/14/2008 10:40:27 ******/ SET ANSI_NULLS ON GO...

K Again thank you for the help very much appreciated I checked the SP and it is using the suggested syntax Still having issues at the Access Form to get it to find more than a single instance of the variable As in if I search for a '1' It should come up with all the serial numbers workstation#s...

Well I figured out the 1stFound.Requiry It was the name of one of my unbound text boxes Next question I need to be able to plug in the value but with wildcards on each side of the data entered From Sql_Hell code that would be on each side of Text3 as in we are searching for part of a Serial...

I am trying to merge the code from the original form into the updated code from SQL_HELL It does not like 1stFound.Requery What am I missing??? Private Sub txtEntry_Change() On Error GoTo Err_txtEntry_Change Dim Conn1 As ADODB.Connection Dim Cmd1 As ADODB.Command Dim Rs1 As ADODB.Recordset Dim...