Recent content by tbarkdull

Yes, this is are ODBC linked table(s). The work-around I have found is this. Backup the database first. Synchronize with replica and check the box making the Replica the New Design Master temporarily. Open the New Design Master, add the linked table making sure the name is identical. Synchronize...

I am replicating the back end and users' access the replica. I added the link table to the design master. Just cannot replicate it.

I am using replication so others can access numerous web pages created linked to queries in this database. I cannot work in it when others are needing access. What design would you suggest I use?

I have a database (Access 2000) that is replicated. When I add a new link table, the replication option is missing under the properties window. I attached a screen shot. What is it I am doing wrong?

Combo Box not populated from Table I have a user with an Access 2000 database he himself created. Now that someone else has accessed it, most, but not all combo boxes do not show any information. All are pulling data from tables. Opening each table reveals the appropriate data. But, as I said...

Date Query Thanks to all, I got it working AND I understand it!

Date Query Still not returning info with null EndDate

Date Query Attached is what I have. I'm a little lost in the syntax. I apologize for my simple questions

Date Query Still getting invalid expression. Where does the fldEndDate come from?

Query Between Date EdFred, Yours looks like the solution I need. However, How to I use it? My query now resides in the Criteria line of the Date Query. How do I structure both statements? fldEndDate:IIf([RPT_NAIC_AF1]![EndDate] Is Null,Now(),[RPT_NAIC_AF1]![EndDate]) returns and invalid...

Query Between Dates The query as is returns data with two entries missing. These are records of Officers of a company with their Titles and beginning and ending dates. The last BeginDate is 12/6/2006 with a blank EndDate because he is still an Officer. The two records missing are dated...

Query by Date RPT_NAIC_AF1 is another query called from this query. I removed the [Forms]! references. I get an error that it is too complex. Ideally, I'd like to use today's date in place of a blank enddate. Thanks in advance for your help

Between Dates Query How can I substitute the current date as the end date? I think that would work in this case.

Between Dates query I did read JonK's post. The solution is what I am using now. I need a way of dealing with a enddate field that is blank (null). As a novice user, if there is something I'm missing, please explain.

I have a query built by someone else that I think is the root of my problem. The query runs and selects Officers of an Insurance Company based on the dates in a table stating when they were officers. The problem is one of the date (enddate) is blank since he/she may be a current officer. The...