Search results

It took me a while to create a similar database. For company reasons I cannot post the real database I use.. Here it is:

Hi guys, I made a form to search some values in a table and print them in a report. The form looks like this: When clicking the "show report" button a macro is executed. In this macro I have the following code: OpenReport --> Report name: main View: print preview Where condition...

Ahhhh that did the trick! ;) Thanks!

Hi, I got a question related to a database with a frontend and backend. It seems that every time I make a minor adjustment to the frontend its size increases. i.e. My frontend was about 2 MB. I made an extra report which I later removed. I quit access and look at my frontend database, the...

I'm not really familiar with IIf code in te query so I'm not sure how to use this... I tried to use the code as raskew described it but that gives me an error on the last line ( 2 = No).

Hi guys, I'm having an issue I hope can be resolved with a macro but I don't exactly know how to fix it. I have a table containing some fields with the following values: 1 2 3 When I open the report that gets it info from this table it prints me the values 1, 2 and 3. Now I want the report...

Hi, I'm having issues with a form (named 'search') I am trying to build. The form looks like this: the first OK button linkes to macro1 the second OK button linkes to macro2 What I want is to print a report of the name I enter. Both name1 and name2 have an OK button. I have 2 seperate...