Recent content by Treason

Well I answered my own question, The quickest method was transfer database: Here's my example: Sub ExportMSSQL(DBN As String) On Error Resume Next DoCmd.SetWarnings False 'Drop tables Dim Conn As New ADODB.Connection Set Conn = New ADODB.Connection Conn.Open "DSN=myDSN"...

=Dlookup("[Description]", "PNs and Desc", "[PN] = " & MyPNVar) The hard part would be getting MyPNVar equal to the right record. if the PN is already on your form then you could do: Dlookup("[Description]", "PNs and Desc", "[PN] = " & forms!myformname.PN)

Memo fields are truncated to 255 characters if you use group by. There is no workaround other than modifying your query.

I have a VBA script that opens a intra net web page and downloads data from it. The data is stored locally in Access tables. After the tables are filled, the script ftp's the database to the web. This script is set to run every night at midnight and has worked well for months now. I had to...

Yup thats it, thanks Ken...

I've been coding some ASP pages and I am starting to think a tag cloud would work great. Does anyone have any idea how these work? Are tags and clouds even relational?

Hey Curtis, Check the MS blog. Some Microsoft dude wants more information about your conflicts with other access versions. It could only benefits us all to give them the heads up.

It's so funny you say that last line. The main reason I want 2007 is to make my own ribbons... I'm so lame.

Maybe they pulled it off the shelf? I downloaded it when it was available, and I mirrored the file here It's in rar compression format.

Hey Daniel, I know what it's like. When I worked on the very same solution information was very scarce. I dug up my access db. One thing I am noticing is that I did not attempt to automate Internet Explorer, instead I used the webbrowser control. You are not gonna like this answer. I grabbed...

Good news jeff but i beat u to the punch, by a whole 2 minutes I might add :p

Access 2007 developers extensions and Access 2007 runtime are here: Blog Post Download ADE Download Runtime

I tried 2k7 and I like it... especially the reporting features. And the ribbon ain't so bad. When you talk about the other shortcomings, specifically which shortcomings do you mean?

I've heard this before but this time it may hold some truth.. Read more I am still using ODE97, and I think I am going "step up" to ADE2007. It only took me 10 years, lol Hope I am not dissappointed.

yea it works the same... as long as the other computer exists :)