Recent content by DBLoser

Thanks Dhookom, I think you've helped me in the past and thanks for the link, there's good info on that site. The simplest fix was to just create a new ODBC connection to the SQL server but I wanted to do a DSN-less connection. For now, this worked: With...

We're replacing an old AS 400 database with a new SQL database. I've recreated the view in the SQL database but now I have an Excel spreadsheet referencing the AS 400 via DSN connection through a macro. Here is the current connection string: With...

MajP, I get what you are saying. I shouldn't treat the revision as a many-to-many; revisions are not stand alone entities. Thanks!

I'm building a database for document distribution. Right now I have a many to many relationship between Document and Revision. Document DocumentID (PK) DocumentTitle DocumentRevision DocumentID (FK) RevisionID (FK) Revision RevisionID (PK) Revision I also need to associate each...

I got this working but had to change the export to My Documents, rather than C:\. Also, the registry hack to allow saving as a .prn extension doesn't work so I had to export as fixed text to a .txt file and then used the Name command to rename the file to .prn Private Sub Export_Click()...

[bugeyed] Good suggestion but same with or without conversion.

I tried on an XP machine w/ Access 2007, same error. This should rule out the permissions/ownership issue. I also suspected a corrupt database so I restored it from a backup. It works fine as Access 2000 and I can convert to Access 2003 and open fine in Access 2003. When I convert or open it...

I just tried changing the .prn to .txt and get a new error. Run-time error '3011': The Microsoft Office Access database engine could not find the object '08142012#txt'. Make sure the object exists and that you spell its name and the path name correctly. When I mouse-over the variable...

Done. Same error.

I have a database that worked fine in Access 2003. Now that I'm using Access 2007, it gives a run-time 3027 error. It is breaking down on the DoCmd.TransferText line. I've tried this on multiple computers (XP, Win7) and the file is being saved to the C: drive and I have administrative...

I'm fairly new to Access 2007 having recently upgraded from 2003. I have a form and have added buttons to it but they don't show up when I view the form. I tried stacking and ungrouping the buttons but the new buttons still don't appear and their .visible property is set to true.

So does a Yes/No field recognize the value of 1? Or would I change the field type to a list with those three options?

Solved! IIf([Forms]![formMyForm]![frameComplete]=3,False,IIf([Forms]![formMyForm]![frameComplete]=2,True,[myTable]![Complete])) Which means, use whatever value is assigned to the Complete field or another way of writing SELECT ALL.

I have a query with a True/False field and a form with an option group with options 1=Both, 2=True, 3=False. I tried using a nested IIf but am not sure how to code the Both option to select all records. In other words, if option 1 is clicked then select ALL records. If option 2 is clicked...

I have built a many-to-many relationship via two one-to-many relationships. Table: tblDR Pkey: DRNum Table: tblDRPerson Fkey: DRNum Fkey: GroupID Table: tblGroup Pkey: GroupID Field: GroupName I have a form called formDR with a subform called “Groups subform”. I can select a group via the...