Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: Diezz
  • Order by date
  1. Diezz

    Full screen form - record selector - first record

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

    counting in query everytime the record appear

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

    Textbox or cbobox value = value from cbobox in previous form

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

    Saving problem

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

    Saving problem

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

    Saving problem

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

    Saving problem

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

    Query in form

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

    Query in form

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

    Textbox or cbobox value = value from cbobox in previous form

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

    Textbox or cbobox value = value from cbobox in previous form

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

    Sharing data via mdb in a network

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

    Textbox or cbobox value = value from cbobox in previous form

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

    Sharing data via mdb in a network

    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?
  15. Diezz

    Back/Front - End Database = > installing on every PC?

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

    EXCEL - SHARED WORKBOOK - PIVOT TABLE

    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?
  17. Diezz

    SetFocus to first empty cell on a column

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

    Sharing data via mdb in a network

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

    EXCEL - inserting fields depending on date creation

    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())...
  20. Diezz

    EXCEL - Pivot table based on multiple ranges

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

Part and Inventory Search

Back
Top