Search results

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.

Thanks missinglinq. That did the trick.

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

Thank you stopher for the solution and thanks missinglinq for elaborating. I'm still struggling with the combobox to react as a parameter criteria though. The combobox will only autocomplete a result if the first characters which are typed match. Is it possible to autocomplete when starting to...

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

The problem is that my main table (REP_01_2009) is filled with a txt-file every month. This txt-file is a download from SAP. I don't see how normalisation is even possible as there is only one table. From what I can make up out of your reply the problem of the wizard error probably lies in the...

I've read up on the subject. I can conclude that a DB needs to be normalized by placing relationships between tables. To support this conclusion I adapted the DB so it will only make use of one table. Hence there are no relationships to create. When consulting the wizard to create a form using...

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

Thanks both Brianwarnock and boblarson. Your help was much appreciated.

Hi Brian, I tried using your expression but I keep running into a syntax error (operand without an operator). I presume this has something to do with our difference in regional settings (we use semicolon instead of comma). As a result I created the following expression: CountOfNVR...

I've rearranged the attachments so that the JPEGs are directly visible. Hopefully this will result in more people looking at the problem.

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

Gustav, I can't believe I did not check out the advanced button on the bottom left hand. Thanks for pointing this out!

Gustav, From the looks of it you managed to add the parts I was getting an error for. Where can I find this import spec you speak of? Thanks for your time and help so far!

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 taken a look at that database but it's not what I'm looking for. Thanks for your reply tho.

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