Search results

You need to set a reference to the Microsoft Outlook object Library. Or you could use late binding instead of early binding.

Yes it can be done but I would link the tables into one db as the previous poster mentioned.

I would put it through some testing and go from there.

can you use a blank string for the DSN parameter?

No he doesn't want the DSN but it the only way he can get it to work. I will tinker with my iSeries connection later today. I am pretty sure I have connected with out the DSN before.

The ODBC errors are vague. I always just tweak the connection string until it works. I connect to iSeries all the time.

Tje below should work if you fill in the detail ODBC;Driver={iSeries Access ODBC Driver};System=my_system_name;Uid=myUsername;Pwd=myPassword;

Why do you need the data in an Array? What are you going to do with the Array? If you explain we can help you out.

Copy and paste the below function into a module and call it from your query. The function will create a comma delimeted string of the given Product ID. I have not tested it becuase I dont have a copy of the db. Also I would add some error handling. Public Function ListCom(ProductID As Long) As...

Check out the below link http://www.connectionstrings.com/?carrier=as400

No but you could write one to do so.

Which line of code is giving the error?

Make a variable of a date/time data type and use the below. variable=Date()-1

try running your SQL statement with Docmd.RunSQL SQL

The error you mention is caused due to a relationship between two tables in your db. You are trying to add a child record with no parent record. To stop the error you need to choose not to enforce Referential Integrity on the join. But it seems to me there may be a flaw in you db design if you...

Reports have an On Print Event. You can set the Cancel variable to true to cancel the print job.

Change values to Select in your SQL Statement.

If the values are pulled from a table just add a record to the table. Insert Into [TableName] (Fields....) Select "Values".....

Check out the below link http://answers.yahoo.com/question/index?qid=20080131235720AAEY1TX

Also I would take out the RoomID from the Device table and create another table to associate a Device to a room. This table would contain the RoomID and DeviceID.