Recent content by key

code check Hi, I got the run-time error '3219' but I cannot figure out what is wrong with this code... I think it's because the property 'type' is read-only. Is there any way to change the field type via vba? Dim tdf As TableDef Dim fld As DAO.Field Dim dbs As Database Set dbs = CurrentDb...

Quick question How I can change just one fields' name and type (I have to change field: 'nummer' in number and type: 'text' in 'number' Thank you, Key

you're right... Pat, - o.k. the # was just the abbrivation for 'number' (in the table it's 'acc_number'). - Table2 is reference table (to define the subaccounts) - My fault: Table3 contains also Year keys: Table1: Acc# (PK) Table2: AccSub#(PK), Acc#(FK) Table3: AccSub#, Month and Year are PK...

Hi guys, Now, I really need your help. I tried left joins, I tried subselects... :-( I gave up! You are my last hope... Here are the tables: Table1 -------- Acc# Amount Month Year...

Hi Access-Friends, I'm stuckt with the following query: I'd like to build a total sum for the whole year. In table1 is Amount in table2 is the changedAmount. Unfortunately, I got a wrong Sum. I assume it's because of the 'group by' function. Am I on the right track? Thanx for any suggestions...

Hi, just two quick questions: - is it possible to change columns' data type? - is ist possible to change columns' name? in VBA? Thank you, Key

nope, doesn't work... :-(

Select it is a select statement (Select Amount From table where month = me!txtMonth.value) if I use the 'lstListbox.requery' eg. it works, but I don't want to let the user click on the button to see the results... AND on form_open the listbox.requery doesn't work...

Hi All, I'm stuck with the following problem: I've got two forms. On form1 are 12 buttons (for each month), if the user clicks on one of them, form2 opens and a text box shows the chosen month. Now, I've a list box (form2) and want to show records for the chosen month. Using the query builder...

quick question.. First of all: thanx a lot, it works!! To make myself happy: how do I implement a Sum function - because, an amount can be changed 0, one or more times, so what I need to do is something like: (Amount)- Sum(Nz(ChangedAmount,0)... But this doesn't work. Many, many thanx, Key

Hi Access-Friends, I'm stuck with the following problem: in Tab1 are Account No. and Amounts and it is possible to change the amounts. The changed Number is stored in Tab2. Now, I want to show the actual amounts, it means: if there is a changedAmount in Tab2 show the calculated amount. Example...

Hi, I think it's gonna be a really easy question... but I cannot figure it out! I've a combo box and month values (Jan, Feb, Mar,...). This comb box is not bound to any table or field, so the data is stored in the Row Source property. My question is: how I can figure it out which month is...

0001 001, so it didn't truncate the last 3 digits, it truncates the first three '0'. Sorry for the misunderstanding. Anyway, do you know how I can let him keept the first three '0'? Thanx, Key

still the same problem: access truncate the last 3 digits!!! No idea why! Key

what do you mean? I'm sorry, I'm not sure if I understand your point.... What do you mean by saying "respnose"? Where I should set it? Thanx Key