Recent content by ubgu3

Wise ones… I have a main table where I am trying to introduce a risk rating capability. There are 8 risk that are all contributing to the overall risk rating. The main table draws from other tables via “lookup” so there is a combo box to pick the risk description. The source tables have 3...

Wise one, I have looked at several examples within this forum but can't seem to implement any suggestions. My plight is this: I want to introduce a progress status to my database. I would like to do this by depicting a traffic light (green, amber or red). The user needs to be able to pick one...

Solved but additional question Disregard last. I have put the output at the top of the page outside the tab control and this works fine. I use it for several text boxes so I ended up using this code in all the boxes I need the counter to work on: Private Sub txtTheBox_Change()...

Flicker problem It never stops amazing me what you guys know, which unfortunately highlights what I don’t! Both scripts work OK but I encounter a “flicker” every time I enter a character. My text box is housed within a tab control. Could this be the problem? Cheers, Rene

Wise one, I have looked for this throughout the forum but could not fiend an answer. Could you help? I have found a little script to display the number of characters entered into a text box so at to warn the user if they are getting close to the maximum number of characters allowed. See...

The table the data is sourced from is called tblClientData. The columns are called strUpdateNov06 and strUpdateDec06. So each client has 2 columns in which data is displayed. My form is called frmClientData. In this form I'm trying to create a combo box which will give the user the choice...

I have searched and looked for this throughout the forum but can't find it. I have a simple text box which I want to populate based on a combo box. The combo needs to display the table's field name and the text box needs to display the record. Is this possible? Cheers, Rene

To my tutors - I have it working - my hat off to you both.

Mmmm. That didn't do it for me. Could you have a look and tell me where it is going wrong?

Cheers, I understand a little more. DoCmd.OpenForm "frmMain", , , ingUserID = Me.cboEmployee DoCmd.Close acForm, "frmLogon", acSaveNo This seems to open the form without any data? How do you express this: Where records in the tblClients - ingUserID = ingUserID in Me.cboEmployee...

Greeting wise one... I have implemented a logon script found in this forum - many thanks. In essance, the script opens a form with info based on a table. Could I filter the records of the form by only only including those records that are associated with the UserID of the user that just logged...

Thanks for your help on this Security is my number one priority. Data maintenance: My database is based on a table with client information (extremely sensitive). Each client is investigated by an investigator. An investigator could have several clients. The investigator needs to update the...

Hi, I'm building a DB where I have multiple users. I would like to have all data in 1 table but only give access to records created by the individual user. Is this possible? Alternatively, if each user has it's own table, how can I report on the sum of all tables.:confused: Cheers, Rene