Recent content by Eniac

Hi. forgive me, this might be a newbie question but I'm very new to MS Access still. I'm building a small application for myself and in order to give myself a small challenge I decided I'd create my own set of navigation and operation buttons that would be used in all my forms as a sub-form...

I like to share the results of my work when I got helped by people and when i think it can be useful others. So here it is. It's a mix of what SJ attached to his first post and what I already had done before posting. Basically, its a generic function that accepts a Group name and a form name...

Hey thanks SJ, that was precisely what I was searching for, it implements exactly what I did my my "labels" table. I really like the way you've used numbers and a loop to indicate what fields and labels are for processing. I'm still a little concerned about the performance when I'll I separate...

Hello there, I'm currently developing an MS Access 2002 application that I'd like to be bilingual. I'm used to making bilingual stuff but for websites and I find it quite different to do it efficiently when dealing with forms. Currently, I have tried to use a web technique and convert it for...

Ah geez.... I cant believe I fell for that one. I found the problem, my query was using "reserved" words and it was creating a problem with ADO. Nevermind, sorry for bothering ya :)

Here's a part of the function I'm doing : (I'll explain prob after) Private Sub Load_Association_Labels() Dim objXML As MSXML2.DOMDocument40 Dim objStream As ADODB.Stream Dim objConn As ADODB.Connection Dim objRS As ADODB.Recordset Dim strSQL As String Set objConn = CurrentProject.Connection...

thanks! Hey, yer a king mile :D Thanks for the tip, i knew it was simple, so simple I almost blushed when I saw it was an argument of the openform command. though, im still surprised to see that the hidden/visible status can only be set upon opening the form. Anyhow, problem solved!

Hello, first, I must apologize, I'm sure this topic has been covered in the past but wasn't able to find an answer using the search engine so I resorted to posting about it, forgive me if this topic already exist ... somewhere.... buried ... :rolleyes: I'm building a BE/FE system. one of...

Hum.... maybe its just me that does not understand correctly.... you want to produce a MS Word Document by programming ? If that's the case, you don't need the "OfficeCodeBehind" class, heck, i don't even know what it does :) I've made several word report controlled via VB and using MS Word...

I'm not exactly sure how the mess up occured but this URL told me how to solve it... http://www.google.ca/search?q=cache:x2oIUBYbo_4J:vbcity.com/forums/topic.asp%3Ftid%3D7741+a+problem+occured+while+microsoft+access+was+communicating+with+the+ole+server+or+activex+control&hl=en as for your...

Here's an error i keep getting with my Access database (see screenshot) In the screenshot, it occurs for the onload event of the mainform but every single button in the footer triggers the same error. I can't understand why its doing that. I've tried putting a breakpoint in the code to see...

forgot to add this function, its an homemade function that behaves more to my liking (won't crash on "empty" variables) '************************************************** Function ToLong(ByVal prmvarValue, ByVal prmlngDefault) On Error Resume Next Dim lngCrasher lngCrasher =...

Here's a function I regularly use.... Basically, its doing a bitwise check on a number. In my case, we one field to store multiple access rights for a system. Examples of access rights are : Update Project = 1 Add Project = 2 Delete Project = 4 Read Project = 8 Then field would store up to...

That's what I do, I use homesite to build my SQL :) It's only that when comes times to coding, I like using Courier New because I can align everything and i find it much easier to read

Something that has been bugging me for a long time is the inability to modify the SQL window default look. I mean... its so small and difficult to build any good SQL with that window. is there *any* way to put my own font in there ?? Now, I ain't talking about datasheet, I know this one can...