Search results

OK, i have 1 table which contains salesfacts. There are 2 things I want: 1. Show the revenue and store number. 2. Show only the store with the lowest revenue. the first one is simple: Select store_key, sum(dollar_sales) from SALES_FACT group by store_key; This shows the revenue per store...

Can someone give me a good clear example of column prompts. Is it a prompt where the user can select the columns he wants to see? or else? Thanks in advance. ice

Hi, I have a question about query's. I am writing a document about business intelligence, and i came across the following elements: can someone give me an example of what is mend here? Thank you. iCe-9

HI i never needed help this much. i worked on an access application for 1/2 year. Everything went fine. But now we wanted to start working with it, some older acces versions are acting weird. I have a form that contains a subform datasheet, and the datasheet has a datasheetsubform aswell...

strSQL = ("SELECT onespace2(MeetingMinutes!MinutesID, '.' ) & " - " & [MinutesTitle] AS Item, MeetingMinutes.MeetingCode, Minutes.*, MeetingMinutes.MinutesCode, MeetingMinutes.MinutesID ") strSQL = strSQL & ("FROM Minutes INNER JOIN MeetingMinutes ON Minutes.MinutesCode =...

I have 2 combo boxes on a datasheet. combo 2 is depedent on comboxbox 1. But when i work on futhter and click other occurenses, the values change (because of the query looking at the first combobox) this is very annoying. can someone pleeeeease help, ive been trying for 2 days now thanks Joost

How do i call a existing query and use its fields. i have the following Dim cnn As ADODB.Connection Dim rs As New ADODB.Recordset Set cnn = CurrentProject.Connection rs.Open "CountFollowups", cnn CountFollowups is my query. But i keep getting the error 3001. Arguments are of the wrong...

Hi, I have a problem. I have a subform that is a datasheet on the left i have a subform that is a continuessubform. When the user presses the button on the left, in the continuesform, i want that the datasheet goes to that record. I do want that al other records are displayed, i just want it...

Hi, Ive never been stuck this much. i dont know what else to do. The problem is, i use the DoCmd.GoToRecord , , acNewRec to add a new record. It used to work fine, but to day, i keep getting the error 2105, Cannot go to secified record. i dont know why, and i dont know what else to do...

Hi, i have a combobox with two subforms and 1 main form. the mainform is based on a query When i scroll, the records change, and the subforms corespond properly. BUT, when i use the combobox to change the records, i cant select anything. I see the list in the combox, but when i click i get...

ok a stupid question but i cant figur it out. I have 2 subforms and 1 mainform all i want is that subform1 comunicates with subform 2. subform 1 had a listbox that is filled with a query. When i click a value in the listbox the othersubform must navigate to that record.

Hi, i have a realy irritating problem i have a listbox. This listbox is on a form which has also a subform. I use the listbox to navigate trough the subform. I realized this by linking the subform to the keyvalue of the mainform/listbox using the child and master option. THe problem is that...

Hi, im trieing to update some attributes in a table, but i keep getting the error that the record, im seeking does not exists (EOF) i have a list, and i want to update all attributes related to a meeting. i tried the following: rivate Sub Command22_Click() Dim cn As ADODB.Connection Dim rs...

hi, I want to put spaces in a table. With spaces i mean for example: i have the word "hallo" and i want it to be writen in the table as: "____h____a_____l_____o" the _ are spaces. I have the string perfectly in a variable. But when i add it to the updatequery i get an syntax error on the...

hi, got a weird question. Im working on a form atm (duh) I have a form that exists in more tables. Now you have 2 solutions: I can use a query and generate the form, or i can make various subforms. what is the best option? or doesnt it make much diffrence?

Hi, i want to replace spaces in my query, but there are a few hard parts in it. I dont always know how many spaces. en second, the spaces that need to be replaced are after the first character. The rest needs to be removed. i have: ----1----1----2 the "-" are spaces!! and i want it to...

Hi, i did a search, but i coudnt find a sulotion. I want to selected a item in a listbox when a form opens. i tried: Me.ProjectView.Selected(1) = True but this locks the listbox, and nothingelse can be selected. i tried it with Me!ProjectView!Selected(1) = True this returns an error...

hi, can i set the location of my windowform? i have created a dummy tabstyle form. It exsist out of 3 forms. Those forms are on top of eachother. is there a way that i can lock the windowlocation. for example: form.left = 0 or someting like that? thanks

Hi, im realy realy stuck this time. This is the problem: i have 2 tables. groupproject, employeproject. Groupproject has: groupcode(pk), employeCode(pk), projectCode(pk) employeeGroup has: employeeCode(pk) and projectCode(pk) a project can have a group and a group can have members. A member...

I have to tables. one dummy and one main. The have the same fields. the dummy is filled by a form. i want to see where they are diffrent. But the query shows all the dummys records. I just want it to show the record that doesnt exists in the main table. SELECT DISTINCT...