Search results

Hi, Is it possible to create a hyperlink within a part of a field formatted as long text? If so, how is this done? See attachment for a print screen. P.S. I know there is data type "Hyperlink" available but this is not an option.

Hi, I have written a function which sets the checkbox for all records in tbl_Questions to true. Function frm_1_Passage_Q1_Ja() Dim strSQL As String strSQL = "UPDATE tbl_Questions " _ & "SET tbl_Questions.Answer = True" _ CurrentDb.Execute strSQL, dbFailOnError End Function I however only...

Hi, I have a form with a datasheet view. When I want to filter on a field I get a checklist of all the available values. When there is however already another field filtered there is no checklist visible. See the attached print screen for a visual overview. Any idea on why this is happening?

Hi, I have a table with two fields. Both fields have a validation rule and text. As a result both fields need to be filled in the form before a next record can be added. When using a macro based button to go to the next record a pop-up appears with the validation text if a certain field is not...

Hi, I have a table (Quarter) which acts as a source for another table. When I create a query based on the latter in the Datasheet view the entries of the second column of table Quarter are shown. The PivotTable field however displays the primary key. Where do I need to make the change to only...

Hi, I've made two queries. One in PivotChart and one in Datasheet view. Then I added both to a form. When one query in the form is filtered the other should filter as well. Currently they are not "synchronized". How can I make this happen? Thanks in advance for your reply. I've added a...

Hi, I have a lot of long IIf-statements in my database and apparently I just went overboard. When trying to add a criteria an error pops up: "Expression too complex in query expression". That's why I think it's time to convert some IIf-statements to a table logic. I'm however struggling to...

Hi, Pivot Tables have drilldown but Pivot Charts do not. I stumbled upon a macro (credits go to Craig Hatmaker) which however does exactly that but with some VBA coding. I'm however struggling to understand where the relationship between the macro and the two charts is placed. When I for...

Hi, I currently have a table which lists all of the numbers for a certain letter. I was wondering if it's possible to define a range for the letters? An Example.jpg is attached.

Hi, On every form where I make use of command buttons, one command button has a blue glow behind it. Is there a way to get rid of this? It kinda ruins the "slick" look I'm going for :cool: I've added a print-screen + here's the VBA code of the command button: Private Sub...

Hi, I have a combobox in frm_Supplier. Users can scroll and click suppliers which will change the values to match the supplier selected. If people start to type in the combobox though, sh*it starts to hit the fan. Apparently when entering after typing they change the values in tbl_Supplier...

Hi, I want to construct a form based on multiple queries. In this case the queries are: Automation Ratio - PGr B36 Automation Ratio - PGr B37 When creating the desired form by using a wizard, I receive an error (see attached jpg) that the chosen fields from the record sources can't be...

[SOLVED] Multiple counts in group query Hi, I am trying to add a second and third count field in the group query ("Automation Ratio - Potential Per Supplier" ) but it either results in: Attempt 1: Data type mismatch Attempt 2: Wrong count Can someone point out what I'm doing wrong here...

Hi, When I import a txt-file in a new table I get a bunch of import errors. I tried to work around this by importing the txt-file into an Excel sheet first. This reduces the number of errors but there remains a whole lot of them. Luckily these are restricted to just one field, namely Material...

I have a number of filters across the top (6 in total). I want to run any number of these filters and then only print the relevant records that pop-up after I pressed the search button. As you can see now I have searched for records that contain TSA. It shows 3 records from a total of 16. I...

When you add a new column you can select different data types such as text, memo, currency,... When I pick currency and typ in 12345 in the column and press tab it automatically puts the € sign behind 12345. What I want is the same technique but instead of € I want to have "ton" behind the...

I want to change the background color to a plain white color. So I used the coloring bucket to fill it in. The problem is that it does not have any effect. In the picture you can see that the greyish color with the white dots remain. This is some kind of standard template. Is there anyway I...

As you can see I have a form with a subform in it. What I want to achieve is that when I press add new record a blank record will popup in the subform without all the other records you currently see. An example of this is the picture under this. If I then fill in the new record row the record...

I'm making use of a value list to add firms in a column. Now I would like to try something out. Suppose there is another firm that isn'nt in the value list. I selected no for the Limit To List question. This makes it possible to type a firm in the firm column that is not in the list. I typed...