Search results for query: *

Sure. Send it to smegle69@hotmail.com. I was doing some research into the GetChunk method or possibly circumventing the query using a recordset(???). Any help is appreciated. Thanks in advance.

I managed to get by all the obstacles save one. The data is still truncated at any more than 255 characters. There are some helpful suggestions in thread701-371366. However how to implement these is for now elusive.

Beginner Alert!!! When I try using the Memo datatype as a parameter in my append query it tells me I "need to remove the DISTINCT keyword, memo field or OLE object when selecting unique values" or something to that effect. I changed the query to unique records, Top Values to 1 to...

I see it makes perfect sense. The (tblTrackingInfo.Date)= ([tblTrackingInfo]![Date] was the problem all along. Thanks for the insight, saved a lot of head banging!!! The alternate solution worked great but are the "#" signs just markers?? Thanks again.

I'm sorry, I tried inserting the "#" signs but to no avail. I am getting an invalid syntax error. I am using office XP or office 2000 as the application is supposed to be cross platform. I was wondering if this will make a difference?? PS Thanks for the fast response.

I've been trying to get this date range qury to work for some time now. SELECT tblTrackingInfo.Date FROM tblTrackingInfo WHERE (((tblTrackingInfo.Date)=IIf(nz([Forms]![frmSearch]![txtFromDate].[Value],"")="",[tblTrackingInfo]![Date],([tblTrackingInfo]![Date] In (SELECT...

We are currently using a Cisco 2600 router with a sixteen port analog modem bank. The machine worked for a year at one location with not one problem. It was moved to a new location and immediately started to give trouble. Some ports would go off hook when dialed to, but just not answer...