Recent content by 3divine

Another option: Refer to Microsoft Knowledge Base Article - 232589 for detailed information. How to Import the Objects to a New Database Create a new database. This action will establish you as the database owner. Import all of the objects from your original database into the new database...

Another option: If the Workgroup Administrator is disabled in Access 97, how about 1. create a blank database in A2k. Close the database. 2. in access 97 open the database and if prompted with password you should be able to just click OK. 3. If prompted with "the current user does not have...

Didn’t mean to make it sound so complicated, because it really isn’t, it’s just that everything takes time. This is what I have to do from Access 97 to 2YK From Access 97 to XP is a little different. “Having reopened the database in Acc97 and gone to Security / User & Group Permissions”...

you need to find these 2 files: system.mdw and shsystem.mdw. One should be in Program files and the other is where ever is your network drive. Ungroup from the other and join the other. Trust me, this is a much easy way!!! I have a deadline to meet right now, I will give you detailed...

Reclaim ownership if you still need help, perhaps i can help. i ran into the same problem when we switched to XP.

To The_Doc_Man, Thanks for the feedback. Have too many details and I know it's difficult to help someone without seeing the whole picture. But I found a work around that. I deleted the expression in query design but on the report , I created a calculated textbox using the same control...

Can someone help me please figure out why I am getting an incorrect value (this is just one of the example) as a result of a calculation in my query. Access 97: Table- - - - - - - - >Fields- - - - -- - ->Values tblMth02- - -- - - ->Absorption- - - - >28632.70 tblAbsAll- - - - - - >MachineDir-...

Travis, I am stunned!!!! Thank you soooo much for your very big help! GEMMA

Help, We have a database created in VB3. Trying to get a report but I keep getting this message. Error: Error # 3146 has occured Error message {ODBC--call failed. [Oracle][ODBC Oracle Driver][Oracle OCI]ORA-01400:mandatory (NOT NULL) column is missing or NULL during insert. (#1400) } Can...

Harry, I won't know the result until noon but then why shouldn't it work? !!!!!!!!!!! Thank you very much! GEMMA

Hello I was testing a code from Microsoft website: http://support.microsoft.com I was successful but I needed to add 2 more lines of code without user intervention. a) After compacting the database, I want to delete the old/original database. b) Rename the new compacted database to the...

Just a comment for Harry: Confused? I thought DAO.Recordset is for Access 97 ( Dim rst As DAO.Recorset) and ADODB.Recordset is for AYK2? (Dim rst As New ADODB.Recordset) ?

Hello there! and Happy New Year! Thanks for the reply and good to hear from you! Glad that you recognized my field names. To answer your questions: I changed my mdb a bit where I combined all the 3 tables into one table where before I have it setup to draw data from 3 separate tables ( bad...

In my table I have one field called Description and each record has unique description. I also have a field called Category with values called Level1, Level2 and level3 and this field Category are what separates the 3 from each other. In my form called Main (temporary container that holds the...

Why don't you include in your code "on click" event a message to prevent users from creating records from incomplete data?