Search results

It is a database with projects executed world wide. The produced list is used for prequalifications. Projects can be searched within a timeperiode, turnover, type, area (14 piece) and activity. During the input process of a project three different activities (main and 2 sub) out of 50 can be...

Indeed, criteria are set by clicked buttons and the WHERE-part starts with the if statements. This works fine and fast so the bracketing is correct. The problem is that when I increase the number of clicked buttons the number of found records increases or decreases as expected, but suddenly...

I have a form with buttons and a list box. Pressing a number of buttons a SQL-string with a WHERE-string (based on the buttons pressed) is build and executed after pressing the search button. The the recordset complying the requested criteria (buttons) is displayed in the list box. After...

MS Access 2003. In de code van mijn database bouw ik een SQL regel op waarin een datum voorkomt, namelijk het filteren van rekeningen die tussen twee data zijn opgemaakt. De notatie van de velden is dd-mm-yyy. Als ik ga zoeken krijg ik niet het verwachte resultaat. De reden is dat in SQL het...

Using a cmd-button with the given code and function gives me an error on the .tbHidden which can not be found. Me.tbHidden.SetFocus Any idea?

I searched the internet and different forums, but could not find the solution for my problem. In Access 2003 I splitted the database and made a mde file of the frontend. When I copy the front and backend to another computer it cannot find the backend due to the original path is included. To...

I managed to do it with FormName.optBox = True as you said before closing the form and returning to the form (FormName) with the option bos (optBox). I used optBox and that includes the 2 options available whithin this box. By giving tha value True both options are not selected and that is what...

Thanks for your comments. I believe I managed to do what I wanted to do. I splitted the database (mbd-file) in a front and backend and compiled the frondend to a mde-file both with the standard menu functions in MS Access 2003. Before compilation of the frondend I added the code which I found on...

Using the MDE-menu function in MS Access it returns an error. MS Access is not able to make a MDE-file of my database. I prefer to make a runtime of my database, but surfing the internet I can not find a way to do this. Can you give me directions for this?

Leaving a form by selecting an option in an option box I enter an other form, but returning to the first form the option is still selected. I would like to deselct this option, but can not find the way to do that. Your help is appreciated.

Thanks RuralGuy! Format([Date], "dd-mm-yyy") did the trick.

Using MS Access I have the following SQL for a selection query: SELECT qryOfferteAfdruk.pkOfferte, qryOfferteAfdruk.Nummer, qryOfferteAfdruk.Datum, qryOfferteAfdruk.Bedrijfsnaam FROM qryOfferteAfdruk WHERE [qryOfferteAfdruk.Datum] Between #08-01-2008# And #12-01-2008# ORDER BY...

Thanks for your advice RoyVidar. That does the trick.

I must do something very stupid! I have a table with different VAT's. This table is used for a combobox on a form to select a VAT. What keeps puzzling me is that the selection in the combo always shows 2 decimal digits instead of one. What am I doing wrong here?

Thanks Bob! I'm very close now.

Bob can you advice how and where to update the chart. I've tried everything within my possibilities, but still the chart shows the original data set instead of the filtered dataset.

I tried to solve this problem with recalc due to the calculated fields, but it was not the result I'm looking for. Both requery and recalc do not change the chart nor the figures in the datasheet that opens when I click on this chart. If you can help me pls let me know. Thanks in advance.

Was going through all the possible post on this forum and fond your answer to another user to requery the chart. Did that and still the data is not updated. I attached the test. Thanks in advance!

Hallo Valter. Did you find a solution for your problem. I have a similar problem. If so, can you inform me. Thanks!

Bob, another question. When I present the data in a chart and then use the combobox to select a specific area this chart is not updated. Do I have to add another statement to do this?