Recent content by Smashie

Thanks. The 'business user' will have lots of memo fields though. My suggestion at this stage is to double key unfortunately. She wants ALL the information on a form and not as tick boxes or in a quantitative way. So unless there is a better solution I intend to store data in the database where...

Hi, I have a user who wants a form to have loads of qualitative data on it. Looking at her requirements it would mean at least 50 memo fields. To do this on a form and then save the data would quickly create a huge database. My initial thought was to export the form to MS Word and use some VBA...

(1) Has anyone any comments on using MSDE rather than Jet (good or bad)? (e.g. can one create a non PK index via the GUI with MSDE?) (2) Does anybody know of any good documentation for using MSDE that is aimed at people who have only ever used Jet with Access and NOT used SQL Server. (3) Thanks!

I want to access an Access database via the web. Are there any people out there with experience of doing this? I am intending to use ASP (/VB Script) to access the database and use something like Dream Weaver to do the basic pages. I am not a networky sort of person and have heard horror stories...

In Access 2000 at least, using the hyperlink to go BACK to Access from Excel / Word does NOT open another version of Access. If it does in Access97 then maybe that's 1 reason to upgrade (although Access2K has a lot of other problems as I have discovered!)

Hyperlinks are easy. I am using Office 2000 so this reply relates to the use thereof. In Access insert a field of type "Hyperlink" and use code to populate the link to something like: hyper = "c:\my documents\excel\excelfile.xls" Then in the excel file from the INSERT menu...

I have tried ShrinkerStretcher - that's what you get at the Softseek site. I didn't like it. I was writing my own but that is on hold (it's quite hard really!). Try the above - we have also been looking at a resizer written by Ken Getz (subject to copywrite) but have not made our minds up on...

Access 2000 comes with Active Data Pages. I wouldn't use them personally as they are crap. Getting the data onto your homepage can be done with ASP (Active Server Pages). If you use Access 2000 and use the ADO object model rather than (or as well as) DAO then using ASP is 'fairly' simple. You...

The "command not available" message only appears if you didn't fully install Access 2000. A partial install will not install "ACWZMAIN.sbm_Entry".

Access 2000 seems a Microsoft rush job to me. The new features aren't that impressive - i.e the Internet integration is frankly poor. I feel that Microsoft should have waited a while and then released a new version of Access that TRULY allowed greater web development. I have come across quite a...

Access developer edition permits the insertion of custom help files - not sure if they are available in the retail version.

You could do it in code like this: Private Sub Command4_Click() Dim yy As String Dim dd As String Dim mm As String yy = Mid(dt, 3, 2) mm = Mid(dt, 5, 2) dd = Mid(dt, 7, 2) dateform = mm & "/" & dd & "/" & yy End Sub Apply the above conversion to the...

I'll ask Phooey to reply to this as he knows the answer

Here is the code...<br>============================================================<br>Private Sub Attempt_Logon_Click()<br><br>Dim cnnUser As ADODB.Connection<br>Dim rstUser As New ADODB.Recordset<br>Dim StrFind As String<br>Dim fltMainMenu As String<br><br>Set cnnUser =...

DougP<br><br>Thanks for your interest. I hope you can help.<br><br>I am using the.seek method of the ADO.recordset object.<br>To do so I (1) Create a connection object (to the current project), (2) Create a new recordset. (3) Open the recordset using the connection created in step 1.<br><br>I...