Search results

so, thanks jdraw and vbaInet for your tips and clues and guidance.

So, it turns out, this was close. You havde to back all the attributes out unti get to EITHER 1 or 0. 1 = One-to-One 0 = One-to-Many so, as I hope I've made plenty visible to anyone else who may follow, it all you really want to know it the type, all you really need to know is odd or even. If...

ok, so, since the real solution to the actual question turns out to be really simple (al-be-it derived from a troublesome learning process), there really isn't any need of a detailed code solution. however, since (for whatever reason) I must have needed to go thorugh the exercise of...

ok guys, I'd bet money there is somebody who frequents these boards laughing their asses off at us.... Include myself cause I can laugh at myself too. So, I do have some code, and I will post it below, but first a reminder of what the only remaining question I actually have: "What is the...

got a late start today but am working on it. Will try to post some functional code for this tomorrow THANKS ALL!!!

Interesting stuff too vbaInet! But here too, I am out time for today and will pick this back up on Monday. I can, in the man time tell you that the attribute values I have forthe 5 realtionships I've tested are: RelAttributes****RelName******************************Actual Type...

Hmmm, Thanks again jdraw. I'll have to soak through this on Monday. I haven't previously seen any of it per se (although I did already know how to get the Relationships out of MSysObjects). Thanks again and I'll let you know what I find out.

you could also access a windows API and monitor the task

Have you tried this yet? SELECT Format([tblProcedure]![Charge_Amount],"Currency") AS ...

Hi jdraw, Yes, I’ve read through that page. It has been very helpful in the past, but if there is a clue on this challenge, I must be missing it. I appear to have figured out at least part of the puzzle. I can get the name of the Foreign Table’s field using...

I haven't used the old fashioned macros in many long years. looking in Access 2010, it does still contain the "EMailDatabaseObject" item so presumably you could hunt and pect your way through it till it works. I would personally advise to start learning VBA and use it. You may struggle at...

Hi All and sorry to bother you with what may prove to be rather obvious to you but seems to be escaping me. For reasons I need not get into as it generally proves to be a distraction, I need to document the relationships in databases. I've been playing around with .Relations with some success...

anybody have any clues? when I search the internet, all I seem to find are data connections using DAO and ADODB. I need to be able to open the FE as an object

hmmm, well I appreciate it but that is not sounding applicable. The scenario here is: a mdb back end a mdb front end Both the BE and FE are in the workgroup managed by the mdw. They work together fine and this quest is NOT in relationship to that. We can open either of them directly within...

Does anybody have any old code snippets you've used to open a Workgroup restricted MDF file using VBA. To be clear, this is NOT via ADODB or DAO. This needs to be within an Access.Application Object. I have code that uses objOrigin.OpenCurrentDatabase just fine for any unprotected database...

ok, well, it turns out I found the answer.... for SQL Server, the general rule for string criteria is SINGLE QUOTES. Thus, the correct and working code is as follows:With rstRPT If FirstRecord = True Then .Open "SELECT Min([" & SourceTbl & "].[3Order ID]) AS MinOf3OrderID " & _...

Maybe this might help, maybe not, but if you add a reference to Excel in your project, you can call Excel Functions with "Excel.WorkbookFunction"...

Maybe try something like this: Dim xlApp as Excel.Application Dim xlWB as Excel.Workbook Set xlApp = New Excel.Application Set xlWB.Workbooks.Open "C:\AccountSpreadsheet\test.xls", True, False xlWB.Columns("a:c").EntireColumn.AutoFit I've used "a:c" but you could replace with whatever columns...

Ok, I’m stumped. Connecting Access FE to SQL SERVER BE Connection is fine. I can open and close it and other queries work fine. I have only one problem with the SQL in one queryWith rstRPT If FirstRecord = True Then .Open "SELECT Min([" & SourceTbl & "].[3Order ID]) AS MinOf3OrderID...

I think it might have to do with how you've declared them. instead of defining xlApp as "New" you could define it simply as Excel.Application Then in your code Set xlApp as New Excel.Application Then Set wb as xlApp... But as long as it works, and the instance is closed, you're probably ok