Search results

Yes, you are absolutely right, hence the reason for this post. My code is causing this issue to happen which I do not want. I am currently completing this within a test environment to test my code, of course my end users will not be able to do this, I have simply outlined the steps to...

Hi all, I was wondering if someone could confirm/deny and inform me of any workaround for what I feel is a bug within Microsoft Access VBA? Steps to reproduce: Create a form with a text box that is bound to a table, and ensure that text box is bound to a column. Set the form's AllowEdits...

Hi all, Just a quick one for me. I have a 'passwords' table which holds an amount of information which I would use alongside other authorised people. I have implemented my own terms of security: You can only access the DB if your Windows Login user name is stored in the BE Input masks to...

Hi all, I have a log table, which is essentially a dumping ground of checks that I and others have completed. Each person has a set amount of checks to complete, there are three checks, Check 1, Check 2, Check 3. There must be three Checks of Check 1, two of Check 2, and 1 of Check 3. Please...

Hi all, I am having trouble with what I believe is bound columns. I have followed the tutorial listed here for 'Cascading Combo Boxes' - https://www.fmsinc.com/MicrosoftAccess/Forms/combo-boxes/cascading.html. Within the database itself, the tutorial given works a dream and causes me no...

Hi all, I am having a problem with parsing the array value to Froms!<arraryvaluehere>.dirty. Please see the code below: Public strListOfForms(0 To 2) As String strListOfForms(0) = "frmForm1" strListOfForms(1) = "frmForm2" strListOfForms(2) = "frmForm3" For i = 0 To 2 Debug.Print...

Hi all, I am trying to achieve the ability to navigate to another form with a single click, however I want it to go to the same record that it was in previously. For example: frmInformation has 500 records frmDiscipline has 500 records When I am on frmInformation (249th record) and press the...

Hi all, Has anyone encountered this particular issue before, and if so how did you resolve it? I have recently encrypted my Access BE DB. I used to use Excel to connect read only to the .accdb so that I could report on some statistics. I accomplished this by setting up a new Excel...

Okay. It is now working - different network, browser and device.

Hi all, I've had a bit on inactivity on my account, now when I have come back I cannot post a question in the General sub? It always redirects me to the login screen, which upon entering my details keeps looping. Didn't know where else to place this. Best regards.

All, I am now trying to tip toe into priviledges. For example, if the user has admin priviledges he/she can go into/see locked places of the Form. I have a table with all of my users set up. The table headings are as follows: Name-Email Address-Number-Priviledge Basically, on the form...

All, Could someone help me understand the following issue? Basically, I have copied the scrolling text example from this forum, slightly modified with a dlookup to the BE Database. The way I have everything set up is off of a main form, or what I call a 'Switchboard'. The switchboard has...

Well, they actually are: txt_name txt_name_1 txt_name_2 txt_name_3 txt_name_4 txt_name_5 I can see that the first text box will be a problem - but I'll fix that my end. I will be performing the calculation in On Current, so that regardless of the record it will count how many textboxes are...

Hi all, I have 7 textboxes on a form, 6 - for data manipulation and another to display how many of those 6 filled out. The text boxes are called: txt_name through to txt_name_5 And the display is called: txt_count What I am trying to do is create a loop that will count how many of those...

Solved! For anyone else having the same issue: Check the following options under the Format tab: Top Margin Bottom Margin Left Margin Right Margin Top Padding Bottom Padding Left Padding Right Padding. Confirm that these are the same as the others, and you are good to go!

All, I am having issue with the controls on my form. No so much an issue, rather than a question. When I select a table, and press the Form button it auto populates the form with the various controls etc. I have noticed that for example a text box will show the control source but with a...

It doesn't offend me, I already know it from a personal level. I find it hard to explain, then get lost in explaining and not everything comes out . . . Kind of frustrating at times. :o

Here is my working and final solution: If Me.cmb_name.ListIndex > -1 And Me.cmb_outcome.ListIndex > -1 Then If DCount("[cmb_outcome]", "tbl_log", "[name]= """ & Me.cmb_name & """ AND [Outcome]= '" & Me.cmb_outcome & "'") = 0 Then Call MsgBox("You do not have any " & Me.cmb_outcome...

That worked. :) Thanks pr2 - Thanks coming your way! In the next post, I'll show my working solution for all.

Slightly difficult as I over explain things. Basically I want the dcount to check for the amount of selected outcomes against a selected person. If the value is 0 I want a messagebox to show saying that there is no outcome against that person. If the value > 0 then it will requery. _____...