Search results

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...

The previous poster is right, I remember seeing an example of how to backup a database in the FAQ i think.... BUT! that will be no use if you have no write access on the disk. The error you mentionned often occur when you trying to write on a remote disk (like mapped drive ?) Most of the...

I saw a thread regarding this in the FAQ section... http://www.access-programmers.co.uk/forums/showthread.php?t=61060 maybe it will help. what is grayed out ? The menu item "Reference" or the actual item you need to reference ? Make sure you have the module opened and you have write access...

Looks like you got better search capabilities than me, I did see the numerous posts of mile-o but not that one. So its "currentproject" i was searching for.. i probably would have never found it that easily. I like the ADO approach because I'm much more conformtable with it, thanks for your help.

Hum... I remember having such a problem wayyyyyy back. Try this : 1. Delete any relationship that table (remember them for later....) 2. Go in design mode for the table and change your primary key as a long integer number type (anything than autonumber should do) 3. Save and exit. Click yes...

As in everything, surely there's a reason and a situation for both. As far as my own knowledge goes, DAO would be more for database handling situation. Meaning messing with the database itself, manipulating its objects...etc. ADO would be more for querying. But what do i know, i never used...