Search results

Hi, At this moment I've got a DCount problem. I used DCount for several forms and it works fine, but not with a new form. Problemsituation: I have a form that uses a query as a recordsource. You are able to fill in a unique number in a text box (txtAfleveringsbonnummer). I want to check for...

Thanks for your advice. I am really focused to put everything in tables but I know now that I only have to put data in the tables. I will keep that in mind! ;) Regards, JiTS

Hi, I want to save a calculation from a subform into a table. Problemsituation: I have a mainform with a subform in it. In the subform is a calculation with a result (400). This result will be showed in the text box (Verschil fust) in the main form, see attachment. To show the result I added...

Problem solved! Back again! My problem is solved... now my New Year Party can finally start! See you next year... ;)

Sum problem continues Hi, I read this topic and I have the same problem. I have a subform too (see attachment). Each row is a new record. I want to sum the column 'Gewicht' and the column 'Aantal' seperated from each other. After that I want to devide the total sum 'Gewicht' by total sum...

That's it! Thanks for your help, it works perfectly! ;) BTW... happy new year to everyone in the world of Access! See ya, JiTS :D

Hi, Problemsituation: I have a form with a combo box and a check box (see attachment). The combo box is able to show me productcodes such as 'VB0101' and 'VC0101'. If the check box is checked (true) and I click on the combo box, I only want to see the productscodes that begins with 'VB....'. If...

Hi.. I'm trying to make a from that includes an Order Number, this ordernumber is connected to a table field "OrderNumber". This "OrderNumber" field is an AutoNumber field. I would like it to be possible to begin the ordernummbers with 900 instead of 1. I already saw a similar topic, with the...

Hi, My next problemsituation: I have a form with a search button. When I search for something a new form pop-ups and I see the search results. It works perfectly. But I want to search again for something else so I add a button on the results form. If I click on that button the database will...

Thanks! That's what I needed... Greetz, JiTS ;)

Hi, I am busy with building a database and it's getting bigger and bigger. There are coming more forms, tables, query's etc. What is a efficient way to save these objects, under a structural name? For example: Tables: tblProducts Forms: frmMainMenu etc. Further ideas?!? :) Greetz, JiTS

Thank you for your answer Still I don't understand your explaination very well, because I use a Dutch version of Access.. Could u pls publish an example? Greetz, JiTS

Hi My problem is: I have a Form with different text boxes, those are related to fields in a table. One of those textboxes is the sum of the other two boxes. The result is saved into the Form, but NOT in the Table!!! What should I do? Pls help

Hi, Problemsituation: I've got 2 forms (main and sub). In the main form I created a button with the name "exit". I also created a button in the sub form with the same name, because the button uses the same function. After that an error came up about duplicate names. Question: Do I have to use...

Thnx! :) I've got the dutch version of Access... so I had to search a little to find it, but that's the answer for my question. Thanks for your help!

I guess that's not the answer for my question. I use a textbox to show the current date (function =Now()). If somebody uses my database and he cliks on the showing date (Friday 12 December 2003), I don't want that it will appears in 12-12-03. It have stay in Friday 12 December 2003... so that...

Display today's date correctly Hi, I am able to show today's date in a form with the function =Now(). If I am viewing the form I see the date correctly. For example: Friday 12 December 2003 But if I click on the date then it's changing to: 12-12-03 12:10:55 What to do to prevent this...