Search results for query: *

ItIsHardToProgram, Thanks for the feedback. I'm glad I'm not alone. But I'm sorry to hear you weren't able to fix it :( It does seem like a weird bug in Access. When you say "redo" the form do you mean renaming it and everything or did you delete the old one and create a new one with the same...

TheAceMan1, I tried the things you mentioned, Compact & Repair, and creating a blank ADP and importing the forms from the old ADP, but the problem still persists. I also checked the MS link that you provided. Do you have any other ideas? Thanks.

Oops sorry. I just noticed that the repair works for forms as well. Will give it a try and let you know.

Hi TheAceMan1, Thanks for the reply. I forgot to mention that my database is stored on SQL Server and I am using an Access ADP file for my forms. Do you have any other ideas?

I am having a very strange problem with Access 2003 sp2. I have a form called "frmListForm" that has four textboxes and a subform called "fsubListActivity". The four textboxes are defaulted to ".visible=false" and the subform has a default record source of "SELECT ActivityType, ActivityID FROM...

cmmrfrds, We need the flexibility that uniqueidentifiers provide. Our network has multiple SQL Servers in different locations and there is the possibility of migrating or merging in the future. The first version of the database was an MDB using autonumbers (identities) but in this migration to...

Crowley16, I don't understand what an identity is. Did you mean uniqueidentifier? Thanks.

For the stored procedure variables are you using the datatype varchar(10)? Also, for the input mask try "99/99/0000;0;_".

I've been working on migrating a database from and mdb to SQL Server and in the process changed most of my autonumbers to uniqueidentifiers. I'm having a problem with the unique identifiers set up as foreign keys. When I start creating a new record in any table with uniqueidentifier foreign keys...

Hello. I want to let you all know that this forum has been the best resource I've found since I started using Access in 2004. The following post changed the way I look at database design forever. thread958-849211 I was always taught to use tables as the basis for forms. After reading this post...