Recent content by Massinova

I have a database whereby three or more tables need data appended using Stored proceedures depending on the criteria of a field. On the form, I want the user to click a submit button that will run the correct SP based on the selection critieria under Case_Type I'm a bit unclear how to address...

I have a question as to what would prevent a Database Diagram (SQL 2005 database) from displaying as an access object in an ADP. History: Our office is in the process of upgrading/migrating SQL 2000 databases from one network server to another network with SQL 2005. I’ve moved two databases...

Listed below is the solution that I found to work. 'Constant Select statement for the RowSource strSQL = "SELECT dbo.Location.Recno_Location, dbo.Location.ID_Number, dbo.Location.County, dbo.Location.Meridian, dbo.Location.State, dbo.Location.Township, dbo.Location.Township_Dir...

I currently have an unbound form that I use to search records from 2 tables (Header and Location) in an sql database. A user asked that I include an aditional field from another table (Leases) located in the same database to include in for record search. listed below is the code that I'm...

Using the above code, I 'm getting a run-time error '3067': "Query input must contain at least one tbale or query" I'm not exactly sure how or where to make the code find the queries that need to be changed (which is happens to be all). Any suggestions?

Thanks a million Jerry, I'll give this a shot ...I'll let you know how it works

I'm presuming from the lack of responses, that there is no solution to this problem?

The destination tables are not linked or joined to the "primary" database. The "Make-Table" queries have one thing in common, and that is the destination path to the outgoing database are the all the same. The only visible solution I can see at the moment is to edit the MsSysQueries table, but...

I have an access database with many "make-table" queries that have accumulated in size/number over time. All queries originate from this one access database and the "new-tables" are directed to another database. I have run into new situation, wherby I need to redirect/change the make-table...

I just wanted to do a follow up on this thread. Basically I found that if you use the upsize wizard to convert an access mdb to and apd, the sysproperties and some other tables will be populated. If you export the individual tables to its designated SQL database, the sysproperties (and some of...

Ok, here's a brief history: -The database was originally created in MS Access and upgraded to SQL server. - Eventually, changes were made to certain fields in one of the database tables because they were unused, obsolete, and/or confusing to the managers/users. These changes were made through...

Recently, I modified a table in my database (removing a field and renaming another). Apparently, the changes didn't fully register with one of the database system files. Is there a way of repairing or correcting the system database tables in a graceful manner without restoring the original...

Thanks for all your great help cmmrfds! Your help and support to myself as well as to other's here at tek-tips has been greatly appreciated. Have a great day =)

Well, I included the above line and still got no returns If Not IsNull(Me.txtStart_Date) Or Not IsNull(Me.txtEnd_Date) Then strWhere = strWhere & " Convert(varchar(10),dbo.Header.Approved_Date,101) Between '" & Format(Me.txtStart_Date) & "' AND '" & Format(Me.txtEnd_Date) & "'));" End If I...

Ok, I changed the following statement to read as follows: If Not IsNull(Me.txtStart_Date) Or Not IsNull(Me.txtEnd_Date) Then strWhere = strWhere & " Convert(varchar(10),dbo.Header.Approved_Date,101) Between '%" & Format(Me.txtStart_Date) & "%' AND '%" & Format(Me.txtEnd_Date) & "%'));" End If...