Recent content by vacant

Of course it helps if you have the index files in the directory as well as the dbf files d'oh!

Hello again As I said, I'm having the above problem on an XP SP2 machine. I have a directory of dbf files Im trying to link in Access 2003 SP3 (Msjet40.dll v4.0.8618.0) In admin tools I created the new odbc data source, choosing: Microsoft Foxpro VFP Driver (*.dbf) Database type: Free Table...

Thanks for looking at this I just suggested that he simply copy the shortcut rather than seemingly trying to _create_ one as he seemed to be doing above, and rather unsurprisingly it worked In his defence he is quite brilliant at manipulating our archaic MUMPS database, it's just all...

Hello, wasn't really sure where to post this... I've recently secured an Access database and now it's down to the IT boss to distribute a new shortcut to the users' desktops, which he intends to do by modifying a line in the login script Previously the script worked because the database wasn't...

Which execute statement is it failing on? (there are two in your code) Think you need to put at least a couple more spaces in; "DELETE FROM " and "INSERT INTO " Use the debug.print line as SkipVought says, then run the code. This will print the constructed SQL string to the Immediate Window...

I'm learning more by the minute! Thanks again

Replace? that's a new one to me, thanks for that my solution would have been: CurrentProject.Connection.Execute "INSERT INTO tblName (RequestNumber,[description]) Values (" & .Fields("RequestNumber").Value & ", " & [COLOR=red]""""[/color red] & .Fields("Description").Value &...

It looks like your query is designed to only return one record. If this is the case, couldn't you use DLookup or rs.FindFirst instead? Doesn't answer your question but, hey, if it works

Because the check query doesn't work, probably something to do with date formats. Try replacing the last line with: "WHERE [Duty Status].[Status Date]=Date()" That would bring in some consistency, since when you append you use Date()

Agree your append query should be as PHV writes Your initial query seems a bit over the top as well, you don't need the Personnel table in there. You just need to look for an instance of today's date in the Duty Status table and append if there's no instance of it Something like this ought to...

Thanks for listening cpjust - don't worry about it, I've since discovered this just isn't going to work with 8.0, so I really need to get hold of an earlier version. Thanks lionelhill, if I can find that I'll be back with your star.

Hello all I'm using some Neural Network software that requires I have Visual C++ version 6.0 or 7.0 installed. As I don't have these, or any version at all for that matter, I downloaded Express, but when I browse the NN software to the location of the executable it doesn't recognise it. So I...

Many thanks for the follow up, mr/mrs macropod. I've made a note of your amended code It actually was a set of mail merge templates that I needed the above for - not documents as I mistakenly described them - so there won't be a problem with the resulting invoices showing the wrong date if...

BLIMEY! I'd never have got that Thanks to you both, and a big pink star to macropod for the fantastic link {QUOTE{SET Delay = 1}{SET m"{=MOD({DATE \@ MM},12)+1}/0"}{SET y{={DATE \@ yyyy}+INT((Delay+{DATE \@ M}-1)/12)}}{m \@ MMMM}160{y}} is what did it for me

Hello tekkies I've just had a user ask me if, each time they open a particular batch of documents, they can display the month and year of the following month. I said "Sure, anything's possible!", but on getting back to my desk quickly realised I haven't got a clue how to do it I took a wild...