Microsoft Access / VBA Forum

I am trying to change the colors of a value in a list box when the values are is based on a select query. I only want the value to change colors, if another value associated with in the query meets the proper criteria. The code that I have does not work however here is what i have so far. If Me.Station01.Column(1) = "UI" Then...

Hello all, On my form I have an unbound combobox with with 3 columns. It gets its values from a query. On the property sheet of the combobox its BoundColumn property is set to 2 At runtime I want to change the BoundColumn property : Dim sOndertekenaar1 As String, sFunctieOndertekenaar1 As String Me!cbxOndertekenaar1.BoundColumn = 1...

High All I have set up an auto execute macro to run a report when the database is opened. Ideally I would prefer to have the report sent out on the first opening of the database each month. I presume that this would be set in the condition section of the macro but that's where my brain dries out. anyone help with the expression to enable me...

Hi all! This has happened to two different databases to me in two days. A query which has been working flawlessly for over 9 months suddenly won't run because the "ISNULL" function is undefined. Compact and Repair - no problems. JetComp utility - no problems. Then I try to edit a module, and the VB editor won't let me make any

I just browsed through some of my Access links when I came across the Ten Commandments of Access (http://www.mvps.org/access/tencommandments.htm). Some of the points I heartily agree with (and wish that my predecessor had followed) but -- alas -- being a relative beginner to Access, I can't see the reasoning behind one of the points and the...

I have created a simple select query (bound to a form in Access 2K) that calls my own public function and returns a result to an existing field in a table. I use the AS clause to reference the existing field name using the same field name in the AS clause. This works great, but I have never heard of the As clause being used like this. Will I...

Hello, Is there any possible way to use forms, created in MS Access environment, in external applications (through COM, etc.)? Regards, Vladimir.

I am trying to insert a record into a data base that has a referential integrity problem. The record does not get inserted, however an error is not thrown. Can anyone explain this to me.

I am trying to filter records in a primary form based on records in related tables. The data in the related tables is being displayed in the primary form through subforms. To be more specific, I have a primary form named TestResults, which is connected to data in a table named TestResults. There are basically two other tables that are...

Here is the problem. I have a table called Locations with a field called Location which holds a list of peoples names. I have a query (query1 say)which has two fields :- 1st field is a person's name 2nd field is a number. I want a query (query2 say)to join the table and query1 with a left join such that all the people listed in the...

Hello All, I was wondering if it is at all possible to have a single combo box update multiple fields in a single record. For example I have created an Employee Info form, and in that form there's a combo box (called "DirectorName") that contains the Directors Info that is connected to a table called "tblDirector" that has the Director's...

In an Access97 application I fetch data from an Oracle database via a linked table (via Odbc/sqlnet). The Oracle database now upgrades from 7.3 to 8.0. The Oracle odbc driver I use (2.0.3.1, supplied with 7.3) always worked fine on all Nt4 workstations. Now with the 8.0 db an odbc error occurs when the db is contacted: {ODBC Oracle...

Hey All, We are hosting our Access XP application via Citrix and are having some confusion about memory. The Citrix server has 2GB of RAM, and what we are perceiving is that only a fraction of this appears to be utilized by Access/Jet before it starts swapping in and out memory paging files. Is there any way to change this behavior to have...

Dear Folks: Question #1: I have not been able to find a method to acknowledge or indicate that a form is open (not necessarily have the focus). Any ideas on how to check if a particular form is open from VBA? Question #2: Is there anyway to trigger an event or DETECT that the Alt key (or any other key like SHIFT or CTRL) has been...

I need to migrate a (quite substantial) MS Access front end application to a web based application. Must not use any Microsoft tools on the server for this - we only run Red Hat Linux servers. All the actual data is stored on a PostgreSQL server on a Red Hat server. Has anyone done this and if so what software did you use?

Does anybody have (a link to) a reference of available SQL commands in MS-Access? I know you can use SOME VisualBasic commands, but I cannot find a reference anywhere! Among other things, I need to use an IF command, like this: SELECT IF (Field=5,"five","not five") AS NewField FROM Table I really need a reference on this! I havent been...

Hi, I have created a very simple query to link two tables on 4 fields. However, in certain cases, one of the fields used to link the table may contain nulls (in both tables, so this should still be a match). Access won't return these records. If the fields are filled with actual values, everything is fine. Can somebody help me on this...

Hi I want to use a tab control to display 2 records (there will only ever be a max. of 2 records). eg: Mr X (page 1), Mrs X (page 2) of the tab control. (Form is bound) At the moment, when the records are returned, obviously the 1st record is on tab 1 and to see the second record, you use the record selectors to go to the next record...

I know some of you here were following involved with, or annoyed with the volume of traffic in the recent thread I started called "Open Question...". I'm posting this message because, though I don't think anyone was terribly angry or inflamed, there are things I don't like about how I conducted myself in the discussion. I would like to...

anyone know where i can pick up a copy of office 2k developer? the only site that i've found is: http://www.emsps.com/oldtools/ thanks -- kent eilers kent@kaeServices.com

Hi there, I am running AccessXp and want to make use to the new filedialog object. the references are set to: VBA, MS Access 10.0 Object Library, Ole Automation, Microsoft Office 10.0 Object library, Ms Dao 2.5/3.5 compatible library. Public Function GetXXXfilePath() as String Dim objDlg as Office.Filedialog

allrite folks, got some questions here... 1) LAY-OUT OF REPORTS How is it possible to fundamentaly change the lay-out/form of a report in access? I dont really know it that "difficult", but listen up; Reports, the way I look at them, all present data downwards, in this way; TITLE data

Is there some relatively simple way that I could create some sort of number from a series of letters and numbers in a field on a form and then when a person purchases the software, supply a matching number to their unique number that could be put into a field in a table that would then enable the software. I think the idea would probably...

Anyone know of a good specific source (other than a standard VBA book) with lots of examples for using just the MS Access 2002 Built-In Functions? I find the "Expression Builder" and the help files a little lacking and less than comprehensive. Any sources or Web links would be highly appreciated. Denny G.

Hello all, I have made a form which takes input from the user (things like name,adress, reference number and so on). After filling in the form, the user presses a button. The program then takes all the values out of the controls, opens MS Word and uses these values to compose a letter with all the data pre-filled in. Now my question is : Can...