Search results for query: *

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

Thanks cmmrfrds, I'll insert the convert function today to see if that works. As for using "between" versus ">= & <=". I'll use what ever works. The only thing I'm looking at is having the user search records by a either a date range or other search parameter that works in conjunction with...

I've modified a search/filter form (http://www.tek-tips.com/faqs.cfm?fid=3702) to accomodate my ADP project. Basically this code passes the search results to a list box. For the most part everything works well except for searching a date range. Basically, I want my users to be able to enter a...

Good grief, such a simple overlooked solution (Red-faced) but at least I got it working now ...Thanks :)

Hi, I'm attempting to utilize the below code in an ADP project. It works great with an MDB, but our data will be residing permanently on a SQL server. What I'm encountering is that I'm unable to get the results on the list-box, but the list box does see and read the field names of the table on...

I see that there were no takers ...I assume then that is is not possible?