Search results

I was wondering if this was possible or not. Can I write a function like the one below, which will accept a value and return many values? I would like to set various columns from one score. If I have something like “Expr1: returnArray(42)” in the query, can the function return the 3 values and...

Hi, I am exporting a table to word and I have come across a problem. My code opens a template, creates a table with the correct number of rows and columns at a certain position, and then adds data to it. At this point, everything is fine. But, here is where the problem sticks its ugly head...

I am writing a function to look in a table and return 2 values. I want to know how to modify the function below to return a string array rather than a string? Dim cat cat = Array(2) cat = CheckInspection("tblFailure", 5) Debug.Print "Val1: " & cat(0) Debug.Print "Val2: " & cat(1) Public...

Hi, I have encountered a problem and was wondering if anyone has come across one similar. I have a query running a function called GetYesNoScore (See below) with various parameters. It is a function to see if a field is a “1” and if so, count up the weighting. So, if I run...

How to I get the screen to show the top of the form? Solid lines and xs show what is shown on the screen. This is used for bigger resolutions. I am modifying the layout of the forms depending on the screen resolution. Also what is the highest resolution anyone has seen an access database...

Hi, This is the problem that I am having and if anyone could give me advice, it would be a great help. I keep getting the “Write conflict: This record has been changed by another user since…. Blah blah.”. Under one tab, the user is answering questions. The answers are stored and a result is...

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...

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...

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...