Search results for query: *

I created a SQL backend for a 2007 Access database using Microsoft 2008 SQL Server Management Studio Import/Export to load the existing Access tables. I created Primary keys or indexes where I thought were needed. I then linked these tables to Access and used existing queries/ forms/reports...

Thanks so much....works great!!

I created a SQL backend for a 2007 Access database using Microsoft 2008 SQL Server Management Studio Import/Export to load the existing Access tables. I noticed one of the fields in the Access table was an autonumber field. After it was imported into SQL - it was not autonumber. How do you...

I needed to create a SQL backend for an Access 2007 database so I used Microsoft 2008 SQL Server Management Studio Import/Export option to import Access tables. All appeared to go smoothly – no errors, but I noticed the Primary keys and default values for the tables did not transfer. I added...

THANKS BOBLARSON!!! YOU HAVE MADE A LOT OF USERS VERY HAPPY!! YOU GET A STAR...THANKS FOR THE QUICK RESPONSE.

Thanks Bob...But I'm new at this.... I'm in Tools > References - but unsure what you mean by "one marked missing".

I have just updated from Access 2002 to 2007. When the users attempt to use the new database they get the OWC10.DLL error. I don't get the error. Any ideas what is happening. We are in an urgent state with multiple users unable to work in 2007.

THANK YOU MAJP!!! It's working great....I can't thank you enough for responding to me. YOU'VE GOT A STAR!!

I'll try this.... When I ran Debug on the error it pointed to "me.filteron = true" This is strange - it really did work for a number of years....

Thanks MajP for responding....those "similar posts" are mine and I'm desperate for some help. As suggested I am not using the "docmd.applyfilter". I added your steps: Private Sub InpEmpID_AfterUpdate() txtUserUpdated = False 'DoCmd.ApplyFilter , "EMPL_ID = Forms!CheckInOutTools!InpEmpID"...

I converted a 2003 database to 2007 and all works well except for one form – which worked perfectly in 2003. This form opens to only a gray screen. This form is the only one that opens with a filter – and I feel sure this is the problem. I did not create this database and I'm not sure how to...

I converted a 2003 database to 2007 and all works well except for one form – which worked perfectly in 2003. This form opens to only a gray screen. This form is the only one that opens with a filter – and I feel sure this is the problem. I did not create this database and I’m not sure how to...

It works great in 2003...the form opens with zero records and you type in an empl nr (or choose from pulldown) in the UNBOUND FIELD: INPEMPID... It's something in this form that 2007 does not like. I don't have a clue what it is?

I converted a 2003 database to 2007 and all works well except for one form. This form opens to only a gray screen. This form is the only one that opens with a filter - I'm not sure if this is the problem. PROPERTIES: RECORD SOURCE = EMPLOYEEWITHTOOLS FILTER: EMPL_ID =...

THANK YOU SO MUCH!! IT WORKED.

YYYYMMDD

I am having a problem making a String Date field to a true Date field so I can compare with other dates. I'm using Crystal 7. I've tried DSToDate and the new field appears to be a date field but there is no data in it. Please help....