Recent content by RoadrunnerII

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