Search results

I have attached a screenshot so you can see what i'm on about. If the interface doesnt look ok, please feel free to criticise...

Hi, Could someone have a look to see where I am going wrong with this. You can see above what my problem is. I thought I had fixed the problem but I hadn’t. I used a tab menu to solve the problem. I set the focus to another tab, made the forms invisible then set the focus back to the...

Thanks a lot for your help. You have pointed me in the right direction.

I have normalised my database. This is for a form where the user modifies 3 values and a score is generated from the results. The results are not being stored to save space. I was just going to go through each record on afterUpdate to get the correct values. The way I would liked to have done...

If it helps, this is how to get the user name. (Works for win2000 and xp, dunno about the rest.) User = Environ("USERNAME")

Is this possible? Instead of, Me.answer1.Value = getProb(Me.bob1.Value, Me.dave1.Value, Me.Tim1.Value) Me.answer2.Value = getProb(Me.bob2.Value, Me.dave2.Value, Me.Tim2.Value) Me.answer3.Value = getProb(Me.bob3.Value, Me.dave3.Value, Me.Tim3.Value) Me.answer4.Value = getProb(Me.bob4.Value...

I have a funny problem. I have a sub form with some buttons on the left and when clicked, show and hide various forms on the right. This all works fine. The problem is that when you first run the form, the visio diagrams in the forms appear and disappear correctly but if you go into Design...

For anyone who is reading this, I fixed the problem. I added 2 lines of code to the onload part of the form. Form_Form1.Visible = False Form_Form2.Visible = False This enabled me to make them visible and invisible whenever I liked. Thanks to Mile-O-Phile for pointing me in the right direction...

So, to do as you suggested, I should 1) Make form1 visible : Form_frmOne.Visible = True 2) Give a control focus on form1 : Form_frmOne.Text65.SetFocus 3) Make form2 invisible : Form_ frmTwo.Visible = False Text65 is a text box that I added to test this. It still says that I cant set form2 to...

For your first comment, frmOne is visible so why cant I set the focus to it? For your second comment, I have set the focus to a text box previously, which is on the main menu. Why could I not hide the form after this? Thanks for replying. Joe.

Hi, I have been fiddling with my database and I need some help. It’s not the easiest thing to explain but here goes… I have a main menu with a tree view on the left. When the user clicks on an item in here, I have different forms appearing. For example if the user clicks on the top level...

Pat, You didnt suggest doing the solution the way I did, I meant after reading a page that you and also ghudson mentioned a database called mouse trap, i came up with the idea of a manual undo button. This was before I knew that access had a built in undo function... Sorry if I confused you...

Thanks very much! I spent about about 10 hours trying to fix this problem. I have about 70 lines of code and you did it on 1!!! I feel like a right plonker... Thanks again, Joe.

Hi, I have a form that contains text boxes that are bound to a table. When I enter new data in the text box, the database automatically adds the new data to the table. After reading Pat Harman's solution, I thought the best way to fix this problem was to, when the form is loaded, store all...