Recent content by davemcdonaldireland

Does it used any linked tables? Dave Mc Donald www.mcdonaldit.com

Oh dear, putting my solution in SQL sounds impossible! Not to say it can't be done, of course. What about just retrieving the TimeIn and TimeOut fields from the recordset and then using my function? i.e: strQuery = "SELECT TimeIn, TimeOut FROM tblWhatever WHERE PatientId = " &...

Yep, Tool -> Database Utilities -> Make MDE File Be sure to keep your MDB file so you can make changes!! Dave Mc Donald www.mcdonaldit.com

For a full explanation of why Access rounds differently and a way around if, see my FAQ: The Round() function rounds 2.45 to 2.4 and is correct. Why? http://www.tek-tips.com/faqs.cfm?spid=705&sfid=3734 Dave Mc Donald www.mcdonaldit.com

DKORO, Here is a function that takes a number of minutes (- or +) and returns a formatted string like "H:MM" or "-H:MM": Public Function HoursAndMinutes(lngGivenMinutes As Long) As String Dim lngMinutes As Long Dim lngHours As Long lngHours =...

loneranger27, If you run any Access .mdb file, you will see a temporary file created alongside it called [filename].ldb, where [filename].mdb is your Access file. So don't worry about the .ldb file, that's normal. The fact that you copied your file from a CD is the key here. It's still marked...

Hi awinnn, First of all, as far as I can see from your code, if a user types in a non-existing username, you'll get an EOF when you call rst("Password"). A better scheme might be to say: If rst.EOF Then MsgBox "Unknown User Id." DoCmd.GoToControl "UserId&quot...

Cheers gazzippy, I just spent hours wrestling with this, had forgotten to put in the datatype in the .InputParameters string and was getting that generic OLE error. Pity we can't get a meaningful error from Access 2000 for ADO errors. They've fixed it in Access 2002. Let's all pay more monay and...

JAMNKEFRT, To fix your problem: For NAV desktop edition: Run from the Windows Task Scheduler (not the NAV scheduler): Navwnt.exe /L For NAV CE: See http://service1.symantec.com/SUPPORT/ent-security.nsf/3d2a1f71c5a003348525680f006426be/c937e09a6ad4e20688256a22002724bb?OpenDocument Did this...

polymath5, I saw this problem about 2 years ago when working in a small NT4 network. They were using the desktop edition of NAV. Here is an extract from Symantec's Knowledge Base: Scheduled scans for Norton AntiVirus 2000/2001 do not run when logged off Situation: You are using Norton...

Just Wondering, ON YOUR FORM PAGE: ------------------ You are missing something from your radio buttons - a value for each one! <input type=&quot;radio&quot; name=&quot;rdbutton&quot; value=&quot;1&quot;>Radio 1<br> <input type=&quot;radio&quot; name=&quot;rdbutton&quot...

Hi Mr. Binary! Try: 'Open the table: Response.Write &quot;<Table>&quot; While not caors.eof 'Write a row with two columns: Response.Write &quot;<tr><td>&quot; & (caoRs.Fields.item(&quot;Problem&quot;)) & &quot;</td><td>&quot; & (caors.Fields.item(&quot;problemdesc1&quot;))&...

If you need further help, post your code... Dave Mc Donald www.mcdonaldit.com

You could also use: If RS(&quot;Manufact_Name&quot;).ActualSize = 0 Then .... This will pick up NULLs and empty strings. Dave Mc Donald www.mcdonaldit.com

Hi Allen, If you want ASP to run on the laptops (not connected to the net), you will need IIS (or Personal Web Server on Win98) on the laptops. ASP pages won't execute by double-clicking in a directory. Also, an access database needs to be in a directory that can be written to (you know the...