Search results

Hi, I am coming to you once again to ask you help so that I can develop an ER Diagram of a Training Matrix Database that I am willing to build and replace the current Excel Spreadsheet. The current file is becoming difficult to follow-up on and some features were identified as a nice to have but...

Hi guys! I am working a pet project from my job, this DB is intended to manage employees, competence and trainings certificates, installations and the dynamics of crew changes and compliance of paperwork. I have posted this question in Stack Overflow 5 days ago but I had few inputs there, so I...

Hi all. It´s been a while since my last post and I hope everyone is OK! I recently started in a new job and my challenge is crew management of 3 offshore installations, all personnel involved needs to follow rotations and comply with training matrices to each installation they go. That means I...

Hi, I am trying to build a query that collects some information and export it to Excel. But since many values from the DB is coming from cascading Combobox. During the tests I noticed when I run the query it is duplicating the entries, i.e. I have just 4 records, but when I simply include...

Fellow Access Master, I would like to know if you could reference me to a tutorial or something similar to a tutorial or example that I could learn how to make a "report center" where the user can build up his own report. Appreciate any help on this!:)

Guys, I have a small DB and it has a form where users can input information. Since sometimes they have to input the basic information all the time, they asked me if it would be possible to have a "copy" of a certain record to paste it on the acNewRec, so they can change only the few things...

I have a form that would disable a button if user is editing data. However, when any combobox is changed it does not fire the Dirty even of the form. Is it s normal behavior on comboboxes? Thanks, Diogo Cuba

Guys, I have a combobox that is locked and disabled along with the rest of the controls but I click on it and even open the drop-down list whilst I won´t be able to select anything inside it. The controls are disabled and locked from their property sheet, not in any event from the form, but...

Access Heavyweights, I was building the buttons, controls and events one by one in a form and all was good. When I came to the the last button (cmdSave) the form start returning the "Error 2105: You Can´t Go to the Specified Record" on a the navigation buttons:Next, Previous, First and Last...

Hey, guys. :) I have a question that is not exactly equal to thousands of threads on the forum - which I have already asked before! - on how to prevent duplicates while ADDING new records to a table/query via form. I have a form that EDITS the employee information, for instance, and if a...

Hello again! I have a pretty simple question (For you, of course, too complex for me): Considering you have to record information (Like a complaint) coming from people that wants to be anonymous what would be the best approach when comes to database design? First I considered creating a...

Hey folks! I have been working on the Save_Click event of my form and I have raised error 2046 sometimes, saying the SaveRecord wasn´t available. I have used RuralGuy´s advice to work this around: If Me.Dirty Then Docmd.Save acForm End If But then I found a similar command...

L&G, I have been thinking about the use of Queries saved on my database vs building them via SQL on the runtime. Because of this I am thinking about these: :confused: Is it faster to have thee SQL built on the runtime or it would be slower? Does having a lot of saved queries will bloat the...

Hi, :( I spent my entire day trying to sort this out but I am giving up and asking for help::banghead: I have a small form that will load with all controls locked, except one that the user can enter information to search for a record. The code will change the RecordSource of the form to a...

Hey Guys! I am building my forms and as I am compulsive about colors I have found two interesting websites for finding the HEX and RGB codes. If anybody is interested: http://www.tayloredmktg.com/rgb/ https://htmlcolorcodes.com/

Hi! I am having a hard time with this string: Dim strSQL As String strSQL = "SELECT tbl1Cards.CardID, tbl1Cards.CardNumber, StatusCard AS Status, tbl1Categories.Category, tbl1Observers.[FirstName] & "" "" & [MiddleName] & "" "" & [Lastname] AS FullName " _ & "FROM tbl1Categories...

Hello again! Everytime I am staring at my DB´s relationships I get a feeling that I am creating them wrongly. The screenshot is attached. For instance, the relationship between tbl1Ratings and tbl1Cards, I related the RatingID from tbl1Ratings to the RatingFK on tbl1Cards. But I sense that I...

Hi, guys! Anyone can recommend a good tutorial to harness the MainForm/Subform iterations? :confused: I am having a hard time to set this duo on my form... :banghead: Thanks,

Hellos Masters! I am here again evoking your wisdom! How can I calculate the capacity Access has to handle records in a database? I have seem some people saying it has up to 2gb per table, but it looses Relational Integrity in some cases. Specifically in my case, I am learning DB Design...

Hello again Access Experts! I have a theory question that has been boggling my mind for a while and I would like you wisdom to answer it: Why one should use a query to underly a form instead of the table originating the query? :confused: I have seen a lot of people stating that but I do not...