Search results for query: *

Yep that was it! I guess I "assumed" that I had made a primary key. Now I feel like an idiot! Thanks River guy

Hello All, I have a Microsoft Access 2000 database that has linked tables to a SQL 2005 Server. I connect to the database using the Native Client connection. However my users cannot delete data from the SQL Server when they execute the Query from Access. What Login/Role is the default...

Thanks Ace. Perfect!

OK So I've created a shortcut menu popup for when users right click on a control. Now that I've created it how do I edit it? Where is it stored within the database?

PHV, Thanks you're a life saver! Was banging my head trying to figure it out. Heres the acutal code snippet I used. Application.Screen.ActiveControl.ControlName The ControlName actually doesn't pop up but if you add a watch to the Application.Screen and drill down on the properties the...

I was wondering if there is anyway to tell which control caused my function to fire up? Basically I have a TextBox that has an OnDoubleClick Event. I have set the event to fire up a procedure in a module. So is there anyway of dicerning which textbox was clicked without specifically passing it...

OK I solved it! Basically I wrote a Module to handle writing the data to the unbound fields. Problem solved now I just have to work on the speed of the calculation.

Try typing the location of the path instead of using mapped drives. The P: asn S: Drives I take it depeneding on the user point to the same locations? These are your mapped drive letters. Instead try using the file location EG: \\Server\User\Shared Either that or set up a logon script on your...

I've inherited a database wirth securities set up on it and its a handfull to administer. Like JBinQLD said copy the "security.mdw" from a working computer. I have the security.mdw in the same file location that the database resides. My people can't access the database directly either. I've made...

Try making it Form view in contiunous forms instead. I think your controls are limited in datasheet view. The listbox then becomes the value list you set up for the field in your table. You can mimic the datasheet view by adding a form header, and then running a continous form view in the...

Have you tried using a combobox instead of a listbox?

I'm trying to populate some unbound Textbox controls in the subform based on the criteria of the records as they are being wirtten in the contiunous SubForm. I have a production Database where pieces are being produced at different locations on different dates. I'm displaying all of the...

Hey All, I'm needing some help with a form in Access 2000. I have a form that has a subform. The subform is set to a query and takes parameters from the parent form. The problem I'm having is I need to access each record from the query on the subform as it is written to the form. I'm looking for...