Recent content by StarGrabber

I've re-built your query (but without the where-condition) and it runs - at least with the test data I've inserted. If you want me to go further, I would need your database with some sample data.

@boblarson: With... Set cnn As New ADODB.Connection..."you can end up with errors" if that connection corresponds to the one referenced by "CurrentProject.Connection" or "CurrentProject.AccessConnection". This one can be used for local or linked tables only. What do you do, if there are none...

Glad to help.

If you add [tblFieldWorks]! and remove the quotation marks... RechargeTo: IIf(IsNull([tblFieldWorks]![RechargeToWhoID]),"N/A",DLookUp("[ToWho]","tblChargeable",[ID]=[tblFieldWorks]![RechargeToWhoID])) ...the error is gone, but the result of the query isn't correct. Try this: RechargeTo...

You are welcome! Good luck with your now less "simple" but obviously working training database.

You bet you can! If an error message appears when adding records to the subform, please have a look to the "default value" property of the textbox "txtEmplID". Maybe you have to replace "[Formulare]!..." by "[Forms]!..."

Hi Denis, if you want the tenants which are due within the next 7 days, you should put it this way: <Now()+7 or <Date()+7 The way you put it, the query shows you those which are due the week after next.

Hi kannon8833, I think you should use a m:n (many to many) relationship between the tables. To achieve this, a third, the linking table is necessary (see file attached). And here are some links: http://www.databaseanswers.org/ http://www.databasedev.co.uk/ http://allenbrowne.com/tips.html

Hi btb9877, welcome to the forum. I tried to run your code. Without success, as expected. But I got several other error numbers than 91. Error # 91 is thrown when an object variable (e.g. a recordset, a control, a class module, etc.) isn't initialized. Your code cannot run because you are...

Hi curtinch, I've tested the code and it runs perfectly. Error # 3265 arises when you address a recordset field, that doesn't exist! So either ... .Fields(255) = varSplit(255)or .Fields(18) = varSplit(273)is wrong. Check the number of table fields again. If you really have 273...

Before I can answer your questions of post # 15, I need you to answer my questions of # 14. Unfortunately you didn't. But I would have needed that information to go ahead. I've attached a file which provides you the line number. And that's what you've asked for originally ("Back to the issue at...

I see, I see. Now I'm starting to understand the context in which your database acts. But I would like to have more information. The procedures in your company are as follows (please correct me if I'm wrong): 1. Orders are sent out. For those sent through UPS you receive - in certain intervals...

I have taken a look at the file you've attached. There were some surprises: 1. The UPS file has column headers. I was mistaken, thinking the headers you've posted were for illustration only. 2. The file import (or "upload", following the steps you described in post # 3) does not work...

And here is the second attempt. This time with search functionality. Please note, I've used an ActiveX listview control with a customized font. That is why two additional VBA references have to be set: Microsoft Windows Common Controls 6.0 (SP6) (File MSCOMCTL.OCX) and Microsoft Forms 2.0...

You're welcome. It would be nice of you to let me know about your experiences in daily use, that is, if it meets your requirements.