Search results

  1. lacampeona

    Solved How to block User From Choosing Next Combo Box

    Hello experts, I have one idea. I dont know if that is possible. hmmmmm Lets say I have 7 combo boxes.I want to prevent users to start entering data lets say in combo box 3 ( table) I want that user must start entering data in order...first combo1, then combo2, combo3..and so on.. Name of...
  2. lacampeona

    Solved Update field and Validation criteria

    Hello experts I have some problems. I have a form with several combo boxes and text boxes. I am using validation rule for saving the records. I have a problem with one combobox who is updating the status of the status field. ( user can choose 5 different statuses). Here I am using the UPDATE...
  3. lacampeona

    What is locking my form?

    Hello experts Recently I notice that sometimes my forms ( not all the forms) are locked and data entry in the form is set to No and some of my buttons are enabled? Who is doing that? my vba code? :confused: Ok I have to say yes I have some code on the current and and on the load event of the...
  4. lacampeona

    Check ItemID and status value

    Hello Experts I need some ideas how to make something. I have a tableA which constains field status and I have field ID and ItemID. Field status can have three values. Field status can be empty (field contain no data, empty field), entered or approved. Now my problem is how to check that the...
  5. lacampeona

    Solved Validate required and close form

    Hello experts I manage to write something by myself... :rolleyes: now I need your opinion if what I make is correct or not?:unsure: I have some validation funcion in module... What i Want is that. 1. user opens and close the form...nothing happen..no saving records 2. users open the form and...
  6. lacampeona

    Solved Tab and command button disabled or enabled?

    Hello experts, I have one problem. I have a form with serveral tabs ( pages). I want to force user to click Page2. If the user will not click the page 2 then the button1 is disabled. If he will click the page2 then the button1 will be enabled? It is possible to force user to click specific...
  7. lacampeona

    Solved Error 3662 You must use the dbSeeChanges option with OpenRecordSet when accessing a SQL Server table that has an IDENTITY column

    I managed to connect sql server and ms access database and now I am gettting some errror. "You must use the dbSeeChanges option with OpenRecordSet when accessing a SQL Server table that has an IDENTITY column". This error appears when you open recordset that contains IDENTITY column. I search...
  8. lacampeona

    Solved Module collecting audit data

    Hello i have a form and some memo field called Updates. When i make changes on my form (called frmA ) the module audit data write all the audit data to the memo field called Updates. this is working perfectly. now i want to make also audit data on my subform. i try the same module but i...
  9. lacampeona

    Solved Before previous and current value on form

    Hello experts, I need some help. I have a tbl1 and combobox called Status which can contain different statuses. From my combo box user can choose different statuses for the item; In stock, InUse, Released, Testing,Sended,Out of use, Destroyed. Lets say user make some borrowing and the statuses...
  10. lacampeona

    Solved Check data from main form to subform

    Hello experts, Is it possible being on main form and tell to access to check if some value exist on subform and if the data exist prevent from user to enter this data again? I try something with DCount and Lookup and I get lost in strings......I mean I manage to check only that if my last...
  11. lacampeona

    Solved How to show status on the form

    Hello experts I need some ideas, help how to make something: I Have two problems. 1. Problem ( Inform the user that some of statuses was already assigned for that item), My problem: Lets say i have items A; B,C;D... Item A has ID 1, B= 2,C= 3,D= 4.... And for each item user can choose differens...
  12. lacampeona

    Solved Tree View form opening 2 different forms

    Hello experts, i will attach some tree view form example. I need some help. I dont know what i am doing wrong. I want to open two different form depends if you click parent or the chield field.. I managed to open one and then i get error to the 2 form...and i manage to open the first form and...
  13. lacampeona

    MS Access Database ready for use... What is next?

    Hello experts I have some questions about...what happens when you finish MS access database. My database is prepared for users? what i have to check before i can say ...yes you can start using the database. What next i have to do? Lets say that my database will be used maybe for 1-50...
  14. lacampeona

    Solved Comvo box checking value from one form to main form

    Hello experts I need some ideas how to make something: I have two forms. Form A and form B. On form A I have text box that contains value house. On form B I have combo box that has some values inside. Value1, Value2, Value3. Now I need some ideas how to resolve that: User can choose Value3...
  15. lacampeona

    Sending records from one user to another user

    Hello experts, I have some questions if something is possible. It is possible to make in MS Access a form ( formX) that will be used for sending records from one user to another user? User1 make some new records and user2 must sign that records. I have 4 forms and user1 can produce records...
  16. lacampeona

    Format() function not changing date variable format or literal code

    I have a small problem here you experts. I live in Europe and our date format is supposed to be ""04-07-2020"" for July 4th, 2020 and my code, no matter how I write it, is returning the format ""4. 07. 2020"". Here is an example of what I tried first: Dim dtePwdDate As Date If...
  17. lacampeona

    Exercices to practice relationship

    Hello maybe somebody know where I can find some exercises to practice creating relationship? Thank you Elena
  18. lacampeona

    Primary key and foreign key-what I am doing wrong?

    Hello In attachments please see my 3 tables. Can somebody look and tell me why I cant create a relationship beetween them? What I am doing wrong? the most important thing is the field SerijskaStevilka ( serial numner of the colon) 1. tblKolone ( table Colons) 2. audKolone ( audit table for...
  19. lacampeona

    What you have to do to make perfect ms database?

    Hello I am creating my database and I want to create perfect database. What is perfect database? Can you experts suggest me what is nice to have, what is bettter to avoid when you want to create perfect database? Is possible to manage perfect database? How do you know that you make perfect...
  20. lacampeona

    How to open specific form depending on User Level/Access Level

    Hello I have login form PasswordLogin RC4 5.3 version from user IslaDogs , the login form has 3 access levels. 1. Default User 2. Administrator 3. Developer when user login i want to hide ribbon and want to open specific form to him, and dirrent form for admin and different form for...
Top Bottom