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

since there is no answer i'll relance my case. I've made the login form invisible and the value that i need it appears in the textbox. So for myself, the code is 1, it appears very well in USER_ID, it saves the record, then if i want to create another record it says that USER_ID is required...

I did some changes and now it gaves me another error message. He can't perform the saving procedure because the field it's empty, however the field it's not null.

Now it works but i have to select the user first. Before i had it by default = column(0) and it worked, however it wasn't bound to the table:), i think that was the problem. I'll try to put again the value par default and i'll check if it works now, that it's bound.

can i somehow keep the value? or what would be most suited to do?

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

Since i got no answer i'll relance my case:P

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

Sorry for spaming, Here is my code Private Sub cmdLogin_Click() If IsNull(Me.cboEmployee) Or Me.cboEmployee = "" Then MsgBox "Tre sa selectezi userul tau.", vbOKOnly, "Nevoie date" Me.cboEmployee.SetFocus Exit Sub End If If IsNull(Me.txtPassword) Or Me.txtPassword = "" Then MsgBox "Tre sa-ti...

I'm not sure if i understood well. However the login form will close so mostly openargs won't work, i think:P I tried what you said but it gaves me an error, the object is closed or dosen`t exist

yes, thank you very much, i was just curios:P, i like to understand the code and i wasn't sure about those.

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

question what is text 11 in If IsNull(Text11 = DLookup("[Textbox1]", "Usyslogoninfo", "[userid] = [Textbox1]")) Then MsgBox "You MUST select a valid User ID. Please try again!" the same what is text13? Do i have to build them?

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?

Yes, it finally worked. So.. Private Sub Workbook_Open() Select Case Environ("Username") Case 701000602 Worsheets("Ionut").Activate Worksheets("Ionut").Cells(4, 1).Select etc. It works really fine, thank you all for your help

This is great and it works very well. Thank you.

Quick question, Private Sub Worksheet_SelectionChange(ByVal Target As Range) If ActiveCell.Row < 4 And ActiveCell.Column Is Not 3 Then Exit Sub If ActiveCell.Value <> " " Then Exit Sub If ActiveCell.Offset(0, -1) <> "" Then Exit Sub ActiveCell.Offset(0, -1) = Day(Now()) & "/" & Month(Now())...

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