Search results for query: *

Could not delete from specified tables but you can "SELECT" the right records to delete The delete query contains multiple tables, and the UniqueRecords property is set to No RESOLUTION Set the UniqueRecords property of the query to Yes . To set the UniqueRecords property of the...

Could not delete from specified tables but you can "SELECT" the right records to delete The delete query contains multiple tables, and the UniqueRecords property is set to No RESOLUTION Set the UniqueRecords property of the query to Yes . To set the UniqueRecords property of the...

Access 2000 Under Tools...Options...General (Tab).. on the right is a box that says Name Autocorrect... uncheck the appropriate boxes :P Cool Tip !!! <MeGaHuRtZ>

Thanks Linda There was some decent stuff butI find the docs out there lacking in RealWorld Application. I wrote a Macro that has PrintOut,3 Update w/&quot;Y&quot; , 3 Append & 3 deletes based on &quot;Y&quot; key of TripSheetPrint. The Goal was to make it as simple as possible.. it's a one...

I have 3 Tables TripStart, TripData, TripMoves all share the common field Driver_Run. I have a form that has TripStart as the Parent and TripMoves, TripData as subforms. heres how it works [TripStart] has a unique Driver_run (PrimaryKey) Number There can be many Trips per Run [TripData] There...

I am curious too I need to make an ODBC Connection to an Oracle Database (7.1.3) I think I have something, but can't get it to work correctly yet Oracle Connect String Personal Oracle Connect String If you want to connect to a local installation of Personal Oracle, you can use 2: to indicate...

This DB wont get complex I was tasked with extracting out a list of users who have registered to a particular website but have not hit hte site since they recieved their login/pwd What I had was a table of all reg users CN and a table on CN's that hit the site. It is one to many relationship...

Thanks, That worked perfectly!!! Is Null was the ticket :P I usually do all my own queries by hand or use SQL code and convert that !! -Mega-

During this process they should create local copies of the master tables and do their dammage there :P you might be able to make up some code on a form/other that forces them to do this. I assume you are using the switchboard to lock down the app and deny direct table/query/form manipulation. if...

OK I know this is a easy one I am just stumped on it and can't find any good info in access help I have Master table Contains All users (CN=key field) Active table Contains Active users (CN has multiple user entries) both join on CN How do I query for the the non-active users? I have tried Not...

Tools, Startup, Display Forms/Page select your form Access help is pretty decent and will help you code I looked this up: Timer Event The Timer event occurs for a form at regular intervals as specified by the form's TimerInterval property. Remarks To run a...

Tools, Startup, Display Forms/Page select your form Access help is pretty decent and will help you code I looked this up: Timer Event The Timer event occurs for a form at regular intervals as specified by the form's TimerInterval property. Remarks To run a...