Search results

Yes thanks Pat we do. I was thinking of them but wondered if there was a sort of standard for this sort of thing. Anyway thanks a lot.

I have been working on some financial projection software for distribution to our organisations licensees. A question has been raised as to how we have verified it's accuracy. Does anybody have any suggestions as to where I could go to have an independant audit of the software. This would really...

Any chance of some help with this question please?

Code attached Here is the code. The portion that is causing the problem is the ClientNo field which is appearing as a number. The relevant fields in the two tables are formatted as text. I think Mresann is on the right track as well but I don't know how I would include Cstr in the SQL. Thanks...

I have some code that creates a dynamic "Append To" query. The problem is that when the code is run it creates the query but generates a Data Type Mismatch error. I have tracked this down to a [clientnumber] field which is formatted as text in both the main database and the one the Append to...

That could be it. No wonder I was bogged down. Thanks so much again. I'll give it a try.

After some very helpful assistance from this forum, I have set up the following code to create an "append To" query in a situation where the Db may be installed on a variety of servers. The Dlookup component finds the server path on a table called Links and that information is inserted into the...

Hey Wayne glad to see you back on deck. I have attached a copy of the code that I have now set up. All works fine down to the line "Set qdf etc etc". I just don't understand what I am doing at this point. Am I creating a new query name in the text string? If so I am getting an error message...

I cannot access any information on help re tabledefs and I cannot work out what Wayne intends with the line of code Set qdf = CurrentDb.TableDefs("SomeReusableQuery") What do I need to do to make this line of code function? :confused:

OK syntax now fixed. Just one last question (I hope!) What do you intend doing with the part of the code that says "set qdf = CurrentDb.TableDefs ("SomeReusableQuery") I'm not sure what I need to supply here. Thanks

I'm starting to feel like the Parser! OK Thanks again I'll use that info to try to fix it.

Back again I have used a portion of the code Wayne supplied to try and get the syntax correct. But there appears to be an error from the SELECT line down. I keep getting a compile error stating that "Expected: line number or label or statement or end of statement". I have tried various changes...

Hey Wayne thanks for the trouble you have gone to. Don't know what I would do without this forum it's a lifesaver. I'll give the code a whirl and see how it goes.

Thanks Wayne and Pat for your help. Pat this question relates to a reply you gave me to a problem I was having with setting up a database to work on a variety of servers. You told me how to set up a paths table and to use a DLookup function to deal with the variety in server names. However, I...

The following is an SQL statement I have created in a query and copied into VBA. I have tried to follow the syntax shown in the Access Help but I keep getting syntax errors. Can anyone please tell me what I am doing wrong? DoCmd.RunSQL "INSERT INTO Customers ( Advisor, ClientID, C1surname...

Pats suggestion works well for all the coded links but I can't work out how to insert the DLookup into links that are contained in file name fields such as the "Append to" query dialogue box or the picture field of an Image Frames property sheet. I have tried to modify the underlying SQL...

Thanks for the reply Pat. Just back from leave so I will work with your suggestion now. Cheers

I have developed a db (A2K) which will be distibuted through our companies franchising system to various licensees. These licensees generally operate in a single PC environment but occasionally they will be based on a server network. The single user is fine but I am stumped by the server...

I am adding a marketing function to my database and am having trouble with the mail merge function. I have created a query that joins my Client table with a marketing documents table. I filter my database by using a criteria form. The resultant group of clients are then merged to the letter (a...

Hi Neil Your info in this article was very useful and I can now produce my pedigree charts for my own breeding program. What I can't workout is how I would use the DB to produce a chart of the progeny for any particular animal. Have you tackled this problem with your DB? Thanks peter