Search results

Hello, I have a main table that has a field that is linked to sub table (using lookup, set row source to correct table using SELECT statement that selects two columns out of the sub table (e.g. the ID and Name Column)). When I run a query on the main table I would like to be able to set the...

Great!! :) thanks a lot. I still have a few questions: 1. Why should you use brackets [] in the controlsource? 2. What do you mean with this? 3. Why is only ID sufficient enough? Does Access sees the relationship automatically? 4. What was causing the actual problem? Thanks in advance.

Here is an Access 2003 version :) Thanks in advance.

Hello, I've made a small example to illustrate the error (see attachment). The example consists of two tables: Table 1: Table to store the customers personal data. Table 2: Table to store the appointments and two forms: FrmSearch: FrmSearch is a flexible search form that with a bouble...

They where already linked. The master field to the unique ID in Table A (TblA, primary key) and the child to the uniquecustomer ID that is table B (not the primary key) (TblB). The error still occurs even with these linked fields. the error is also produced int teh linkMasterFields property...

Some additional info on the problem: Well the "automation object 'CustomerInfo' " is actually Table A (TblA) I think. Every customer gets a unique ID (Primary key) that is stored in table A. In table A is also a lot of other info about this customer (first name, last name ect....). The...

Hello, I am modifying an excising database for a acquaintance. now I have the following problem: The database consists of two tables (TblA and TblB) and two forms (FrmA and FrmB). One of the two forms (FrmB) has a subform (SubA). Form A is used to populate data from table A using listbox and...

Another question: Here is a piece of code of the Autosize sub: ' Temp array to hold calculated Column Width Dim lngArray() As Long ' Temp array to hold calculated Column Widths Dim strArray() As String ' Temp array to hold calculated custom Column Widths 'Dim CustomStrArray As Variant ReDim...

The exact errors are : Error 94, "Invalid use off null" Error 91, "Object variable, or with block variable not set" Ok I fixed the cause of the errorcodes :) (some brackets where missing in the SQL statement. This because the table has got spaces in some of the fieldnames. I know this is not...

Hello, I use this class: http://www.lebans.com/listboxcolumnresize.htm to autosize the columns of my listbox. I use this listbox to populate data from my table using a textbox and a SQL statement. The problem is this code gives a error sometimes. The strange thing is I can't reproduce it. (the...

The problem is If I click the link I have to sign up (as I already said) ;)

The problem is I have a lot of checkboxes on my form but only want to use the for next on a selection of these checkboxes.

When I click the link I have to sign up?

Ok, after studying the option group a bit more I came to the conclusion this is not what I want. I want to set the checkbox value true or false, this is not possible with the option group. Is there another way to put/assign check boxes inside a frame so I can control the check boxes using this...

Hello, I've created a option group in my form. I've added some checkboxed into it using the control wizzard. Now I would like to add some more checkboxes to the option group. I can create them outside the option group and dragged it into it but when I run this code: For Each Control In...

Your code makes sense to me. I was struggling how to set the dimension of the array before the For Each is started. BTW: Is there also another way to get the field/column names (without opening the record set) into a array? Thanks.

Hello, I've got this code: Dim FieldNames() As String Dim Rst As Recordset Dim f As Field Dim Counter As Integer Set Rst = CurrentDb.OpenRecordset("TblParts") Counter = 0 For Each f In Rst.Fields FieldNames(Counter) = f.Name Counter = Counter + 1 Next...

Got it working. The problem was the table datatype for the numbers. It was set as text. I changed it to number and now it's working.

Thanks for the demo. The code looks good! Never thought about theleft and mid function. The problem is I've already split it into two fields and can't change it easily. The problem is that I let users decide which columns to sort using two combo boxes. Thats why I use VBA.

Thanks for answering my post ;)