Search results

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 :)

Try this link

I had a similiar problem once and i think I found the solution in parentwindow somewhere. Check vbforums.com I think thats where I found the answer before. If you get desperate I'll dig out my old project files.

I fail to see why you would want to change your database structure in this manner. I wouldn't delete the table objects, instead I would delete all data from the tables. DoCmd.RunSQL "DELETE * FROM table1;" Then use DoCmd.TranferText or TransferDatabase to the bring new data back in. If you...

Just Curious, why not use the FileSystemObject instead?

I created a database for a school. In order to reduce database bloat I backup the backend db's every term and wipe all the tables clean. Now the situation has arose that I need to give the users access to data over multiple years. I could do this a couple of ways, and I am looking for your...