Search results for query: *

Hello, I've built (thanks to Tek-Tips community) a database, then split it and right now around 10 persons use it. However there are some bugs that i would like to fix. 1. Full screen - i would like all of my forms to open in full screen (i've deactivated the min max buttons and the close...

Hello, This is unusual but it's not for me, it's for a client:). The table is : ID Name 1 A 2 A 3 B 4 A The query will have the ID field, the name field and an occurence. The result should be : 1 A 1 2 A 2 3 B 1 4 A 3 So it should counts how many time it appearad until...

Hello, i have 2 tables Employees (IdEmp, NameEmp, PasswordEMP) and Calls(IdEmp, NoCall, problem, description, case) Case take up values from "Yes", "No", "Suivi","Error". I've created a log on form that works very well (frm logon), using a combo box(cboEmployee)and a field where one can...

Hello, I have a form where different persons will instert data. I want to bound/paste to the form a query in the result mode(like a table). So when someone will click "insert data", i would want in that table to appear the new data that he just insterted. I'm not sure if it's possible...

Hello, I have a login form (frmUSER) that check up the values in the table "USERS", and each user must choose from a cbobox (cboUSERID) his name and write his password in the textbox "txtPassword". If everything it's ok they go on to frmCalls where they insert every call they have on a...

Hello, If i use a Database Splitter to build a fe/be Database, i would have to make copies (and just copies??) of the FE on every PC? I've read many FAQs and it says that i'll have to install the FE on every user's PC, but how do i do it? i just copy the file? Also i don't understant the...

Hello, Can i update a pivot table in a shared workbook? Since i shared it , the PT won't update anymore, is it something i missed?

Hello, I'm trying to build a pivot table based on more ranges, in the same workbook but in different sheets. The problem is that after i select all the ranges and i try to build the layout of the PT, it won't show me the columns of the tables that i join in it. My 5 sheets have 5 identical...

Hello, It's about a shared workbook where 5 persons have acces. Every person should work in a certain sheet, however sometimes they add data in other's sheet and this misguides the whole team. So, i would like for every person to have acces only to his sheet. John should be the only one...

Hello, When i open my workbook i would like it to instantly set focus on the first empty cell in the column A. So if the cell where i last insterted data was a30 and i close my workbook, when i re-open it i would like to focus set to a31. Also if i would try then to move my mouse to a32...

Hello, As login for windows we use code numbers, for example mine is "701000602". There are others who use the same workbook as i am and i would like them to set focus on different cells. This is what i've tried for myself : "Private Sub Workbook_Open() If Environ("701000602") Then...

Hello, I'm still thinking on the project and i would need some opinions to know how it would be the most suited. I would like to build a database in acces and it would be used by more users in the same time. There would be max 6 users, me, 4 of my collegues and my boss. When my collegues...

Hello, Is it possible? When using a shared workbook, i would like to setfocus on different cells depending on user that signs in. Also i would like to create certain acces for every user, for example a would not be able to change but some cells, and b some other cells etc... Thanks

Hello, I would like to create automaticaly create a sheet with the name of the month at the start of each month in various XLS files. For example in a.xls, at 1 june, i would like to be created the sheet named "june", and so on for b,c,d and total.xls. I think it can be made in vba but i...

Hello, I have a buton on my form witch opens a link, www.tek-tips.com for example. I'm using as my default browser Mozilla Firefox and i'ld like it if i don't change that. Can i set the buton somehow to force the opening of the link using Internet Explorer? Thanks

Hello, I have 2 sheets, one named "Case", and one "Relance". Each case has a date of creation (witch i would like to be inserted automaticaly when i write the case number) and in the second sheet, i want at a certain date (for example after 30 days of the creation of the case), for the name...

I m having 2 forms, "frmApp" and "frmRes". In frmapp i have 2 combo box, cboProb and cboMVS. If i make the selection "Applications MVS" from cboProb, then cboMVS becomes visible, this box is put on visible false by default. Then i can click the buton resolution and it opens the new form...

Hello, I have 2 combo box, 1: cboTypePb, 2: cboMVS. The second combo box has .visible = false. I want it to turn true for a certain record in the first combo so this is what i've done. Private Sub cboTypePb_Change() If cboTypePb.Value = "Applications MVS" Then cboTypePb.SetFocus [MVS...

Hello, I have a checkbox "chkExplication" and text box "txtExplication". I ve set txtExplication.visible = false when i start the application. And now i imagine the code like that : If chkExplication.value = 1 then txtExplication.visible = true Else txt.explication.visible = false end if...

Hello, My form contains 2 combo box, they are already synchronised, so for every ProductCategory i choose in the first combo box, i see only the products i should in the second. However, i would like to have a description in the left of both combo box: a text box(if anyone have other ideeas...