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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.