Search results

Hello all, I'm experiencing a lack of knowledge on my side again... I've borrowed a piece of code from http://access.mvps.org/access/datetime/date0012.htm. ' ********* Code Start ************** ' ' Modified from code in ' "Visual Basic Language Developer's Handbook" ' by Ken Getz and Mike...

Delete data from Table based on Select Query - Could not delete from specified table I'm trying to delete all duplicates from a master table with autonumber field as primary key. Based on other information found via the big Google machine, I've build a query that groups by on all fields in the...

Thanks, that solved it!

Apologies for the late reply, but I hadn't at the time you posted your answer, which was exactly what I didn't had due to lack of knowledge :banghead: Thanks for the reply!

Good morning all, I am trying to use an multi-select listbox to generate a report for the selected forwarding agents only. I'm copying the code from http://www.baldyweb.com/multiselect.htm, changed this part of the code as the values are text in the table where the report is created from...

Good morning all, Let me start with informing you that I'm completely new to VBA programming. I've got some Access experience, and want to move on in this. I'm trying to import data in to Access from a CSV file with a semicolon as a seperator. I've been able to do this with the following...

Never mind, I've got it. Just was a very hard typing-mistake in the DCount:rolleyes: Now changed the DCount to: and it works fine :D

Hi all, here I am with a new challange :D I've got a report, called Fleetlist. On this report, a list of trucks is given, based upon a selection on a form. At the bottom of the report, there is a textbox which shows how much trucks are on the fleetlist. This all works fine. The trucks have...

To quote one of my favorite teachers: I'm not in the office right now, but will try it when I'm there. Thanks for the idea.

Ok. The last problem to overcome before I can go live with my database within the company :D I've got a report called Invoice. On this report, I've got a sub-report, called InvoiceRules. A user selects a invoice-number on a form, and presses a print-button. The sub-report is printed on the...

Thanks, I've just wanted to post that I've solved the issue :D Where I went wrong was a typing-mistake (is this correct English? I'm from the Netherlands) Now, with the AfterUpdate set to this: It works. What I had, was a textbox bound to =[Combo12].Column(1). Because it was bound to that...

No problem. Didn't know that a Access-Noob could assist someone on this forum :D I mean, I don't even know of the existing of the nz-function :rolleyes:

If the textbox is on the same form as the combobox, just =[ComboName].Column(1) should do the trick, where 1 is the number of column you want to appear in the textbox. Note that column count in Access starts at 0.

Ok, here I am with a new problem :D I've got a combobox with which the user can select a product. This combobox is based upon the table Products.On selection of a product, a textbox is populated with the price of the product, made possible with the control source =[Product].Column(1). This...

I found out what the problem was :D By accident, I set the record-source field to InvoiceRules Query, instead of InvoiceRules Table :rolleyes: Now it works fine again

That is set to yes. Here is a print-screen of the settings of the subform: http://img252.imageshack.us/img252/8932/formsettingsyf6.png

Ok, I've got a problem that most-likely is a matter of putting something somewhere on a wrong setting, but I can't find it :mad: I've got a form, with a subform in it. In this subform, the products that are ordered are given in. This used to work, after entering one product, a new line...

And also that problem is solved, just a phone-call to the fleetmanager to complete the missing data in the fleetlist :D Thanks all for helping me out!

You're a God to me :p My collegue was already laughing at me that it would never work, so now I can laugh at him :D ----------------------------- But now the next problem occurs. When there is no data for one of the criteria, (whether I've selected the criteria or leave it blank), the query...

At the moment I've all the criteria on different lines, like this: http://img383.imageshack.us/my.php?image=queryfleetlistgk4.png I've tried putting all the six criteria on one line, but than the results are always blank. Therefore, I'm guessing that I can't use more than 2 criteria together.