Search results for query: *

Thanks Graham! I'll give that a go now... thanks for helping me out :) Cheers Dan.

Smudge, Very nice of you to let me know! Thankyou muchly :) Dan.

Hi LittleSmudge, I'll be anxiously awaiting your post! i've looked over the last 2 months worth of posts but couldn't seem to get the solution I've been looking for. Thanks in advance, Dan.

Hi everyone, I have sent out a copy of an Access DB frontend to a customer. Now the frontend gets the data from a linked table. However the customer wants the daily update of the DB (linked table) to be stored on a server. From my end, I don't know how to change the location manually. I've...

Hi everyone! I've got the following code in part of my form: If Not IsNull(Me("txtVal" & i)) Then strWhere = strWhere & strJoinType & Application.BuildCriteria( _ "[" & Me("cbxFld" & i) & "]", _ fld.Type, Me("txtVal" & i) &...

thanks to everyone who helped with this.. i have found the problem. If it's any use to you, I removed the criterion set in Flags (in the SQL query). This allowed all linked tables to be shown.

Hi Jeff, Thanks for your continuing help! Much appreciated... Still can't get that linked table to appear in that list box. I'm determined to get it going though! If you have any more ideas I'd love to hear them. Thanks. Dan.

Hi, thanks for all your replies. Ed2020, the row source for the listbox is SELECT MsysObjects.Name AS ObjectName, IIf([type]=6,&quot;Table&quot;,&quot;Query&quot;) AS ObjectType FROM MsysObjects WHERE (((Left$([Name],1))<>&quot;~&quot;) AND ((Left$([Name],4))<>&quot;Msys&quot;) AND...

yeah i've tried deleting the linked tables and then creating a new one a couple of times.. doesn't solve the problem. Maybe it has something to do with the data in the form not being local (i.e in the actual database itself).

Hi there, I was wondering if someone could help me with this problem. I have this linked table that for some reason does not appear in a listbox on a form. However if I import the table instead of linking it to the database, then the table appears in the listbox. Anyone have any ideas on this...