Search results

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

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

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

Hi Friends, I've got a field in a table like xxxx xxx and want to have xxxxxxx. Here is my code: Do Until RS.EOF RS.Edit varString = RS![Number] varString = Left(varString, 4) & Right(varString, 3) varString = CLng(varString) RS![Number] = varString RS.Update...

Hey Access-Friends, I've got a combo box on my form and an event 'not in the list'. So, the user goes to a second form adds new color and clicks on 'Save'. What I'm trying to do is I want to requery the combo box in order to show the new color in the box. But it doesn't work... :-( There is a...

Hi Access-Friends, I've got a table (field1, field2) with x records and want to save the records in a two dimensional array. What I have is: ReDim ArrayY(0 To countRecords, 0 To 1) For k = 0 To countRecords For j = 0 To 1 ArrayY(j, k) = RS!field1...

Hi all, I've got the following (dynamic) SQL query: SQLString = "SELECT field1, field2 FROM table1 WHERE ID=" & cboId & "AND No.=" & cboNo I need to group this SQLString by ID. I've tried several ways and every time got the error message. Do you have any suggestions where I should add the...

Hi Access-Friends, I'm asking myself for 4 hours how can I run a query and save the result in a variable? I'd like to place it in the Form_Open event, because the user shouldn't notice that). The variable is Boolean. Could someone give me a small/big hint how to do it? Many, many thanx in...

Hi all, how I can save the selected items from a multiple listbox in an array? Do you have any examples for me? I really appreciate it, Key

Hi Access-Friends, I want to run a query and show the result in a listbox. Does anybody know how to do it? Here is what I have: .... (multiselect from a listbox) ..... Set DB = CurrentDb() 'Set Q = DB.QueryDefs("Query11") Q.SQL = "Select Field1 From Table1 Where [ID]=" & Criteria Q.Close...

Hi, I'm trying to show the notepad icon on my form. The code below is the result approach. Anyway, it doesn't work... I don't know how to refer to the hInst and hDC (see question marks). It should be the application object and form object... I'm trying, trying... Many thanx for any suggestions...

I have a field (listbox) that shows we the value of a query. If the amount is negative, it should appear in red. I've solved the problem using the select property, but the field appears black (it's maybe less then 1 sec. but the user can see it). -Do you know other way, how to retrieve a data...

I've got the following code, and want to enable/disable a command button dependent on the value in the list. I don't know why, but it doesn't work (I guess it's maybe because of 'null'?) I would appreciate your suggestions. Key Me!List1.Selected(0) = True If Me!ListItemData(0) = Null Then...

How do I get the listbox to display the data align to the right and not to the left?

How I can find a record whose key are 3 different fields? dim var1 as integer, var2 as integer, var3 as integer, var1 = cmbCombo1.Column(0) var2 = cmbCombo2.Column(0) var3 = txtJan.Value var4 = ???????????????? (& doesn't work) .......... ........ rs.findfirst var4 ......... .......

I want to import an Excelspreadsheet to my database and want to delete the first three raws from this spreadsheet (IMPORTANT: before I've imported the file) Thanx Key