Recent content by AtlasAF

Hello everyone, We are having problems getting clear instructions and guidance on setting up a merge replication sync. Our setup is as follows: Server 1: DB Server MS SQL 2008 R2 Full Server 2: Web Server IIS 7 Services for application Remote Sites: Laptops running SQL 2008 R2 Express...

The DB is setup in FE BE. I know I can not modify the design in the front end but shouldn't I be able to modify the connection string? To explain further, I test the links to the table using another module and in the event that they link is broken, the user can select the backend and relink...

I'm trying to set the TableDef.connect property when my DB opens but it is coming through as a read only property. I have tried various methods and did a search online. All of the example I have found seem to line up with what I have coded in this module. Can anyone see a reason why I can't...

Can you post the rest of the code for review? AtlasAF

I figured out how to execute this code successfully. Not sure why, but it works. When I added in the DISTINCT line to the SQL code, the recordcount returned the correct number, however using the DISTINCT call I obviously couldn't edit the table. To combat this, I added another SQL string with...

What type of query is Query1 AtlasAF

This is the way I normally change record sources: DoCmd.OpenForm "Form2", acNormal Forms!Form2.RecordSource = "(New SQL Statement, table name or query name)" Forms!Form2.Requery If you want to close Form1 add: DoCmd.Close acForm, "Form1", acSaveNo AtlasAF

Maybe this will be helpful in figuring out my error: I removed all the if statements and added debug.print to see what the query is returning. Code modified to: strSQL = "SELECT tblAssignment.AEndDate, tblAssignment.AClosed, tblAssignment.TTID, tblAssignment.AssignID " & _ "FROM...

I did some further trials and found out the following. When there is ony one record in the table the record count returns 1. If that record is marked as closed the recordcount returns 0. When add new records to this table, the recordcount matches the total records in the table reguardless if...

I updated that line but the my problem is still there. For whatever reason, the recordcount is showing up for more that the query results. I should have a recordcount of 2 as the query only returns two records. Instead in comes up with a count of three. AtlasAF

*Smacks forhead* The records, I forgot to change that when I added the additional field to the sql query. Before it was: SELECT tblAssignmnet.AEndDate From tblAssignment Where ((tblAssignmnet.AEndDate) Is Null) and ((tblAssignment.TTID)="&[FORMS]![frmTTView]![TTID]&");" Note that the problem...

For intPos = 0 To rs.Fields.Count is setting the number of times the loop needs to run (if there is a cleaner way to do it, please let me know) AtlasAF

Hello, In the code below, I am trying to get a record count from a DAO recordset. The problem comes in when I attempt to get a recordcount of the recordset. The query only grabs the records that are open (determined by a yes/no field in the table) but the recordcount returns a count for every...

To docuement a resolution with this thread: I figured out a way to fix this mixing. The main report only opens one record based on what is currently displayed on the form. I created a grouping in the report based on the record id field. I moved the subreports to the details section of the...

Hmm... Try DoCmd.Close acReport, "reportname", acSaveNo AtlasAF USAF