Search results for query: *

Brooks, Date is a reserved word in Access. I'd give it another name. Otherwise, you will have more trouble with it down the road. Wayne

Hello, I tend to drag a lot of Access DBs & other stuff onto the desktop. Sometimes, when I attempt to double-click on something to run it, about 20 things will highlight and start to run. This is not good! I know (think?) that there's a Windows setting that limits the double-click to only...

ouzojd, Thanks for the WHOHASIT tip. It is still available. The file was created by a process on the server and doesn't show up on the shared files list. Will convince the Server manager to give it a try. Thanks again! Wayne

On a Windows 2000 Server, there is a file opened. The file is located in "C:\Temp\SomeFile.txt" This file can't be deleted, renamed, etc. - because it is "in use". The app that created the file is probably running (which one) and if the server is rebooted, the file can probably be deleted...

Spider, You can traverse the Listbox and construct your own SQL statement. You can put the SQL in a QueryDef. You can probably search here for QueryDef and see some samples. Normally, people use Listboxes to construct the - "Where field IN (...)" clause of a QueryDef, but there is no reason...

Tom, You can use the NotInList event of the combobox to: DoCmd.RunSql "Insert Into Ships (ShipName) Values ('" & Me.cboShipName & "'") Me.cboShipName.Requery Wayne

Congratulations Bob, The traditional reason for splitting a db is to put the data (back-end) on the server and the forms/reports (front-end) on the clients machines. This way the overhead of transporting all of those forms/reports over the network is alleviated. An added benefit is that "most...

r, Did you lose an index? Wayne

laker, I've programatically made some triggers and procedures that must have had at least 75-100 "Or" clauses. No problem. Wayne

One, When you change the form's recordsource, it is changing one of the form's properties. The normal save actions on the form apply to your data only. I think you can do something like: DoCmd.Save acForm But, if use this technique in versions of Access > A97 then you will run into problems...

rj, The Replace function only takes strings as arguments. You will have to iterate through each of the fields and pass their values to the Replace function. Also, you will have to interate through each record in the table. Wayne

Maturi, Access is not a word-processor. You can store/display text with carriage returns in it. For bold text, you could do some tricks with VBA, or queries, but in the long run its probably not worth it. As for the Tabs, Access does not have a means of dealing with this (as far as I know)...

Paul: MsgBox("New Record Added - Number " & Me.CustomerID) Wayne

Hans, Make your form so that it is a traditional bound for and also has your two "unbound" controls: srchPerson and srchPostal. Make the default value for your controls "*" (with the quotes). Then base the form on a query, and obviously, doesn't reference your two...

Medic, Private Sub Form_Load()] Dim x as Integer Dim y as Integer x=Int((10-0+1)*Rnd+0) y=Int((10-0+1)*Rnd+0) firstnum.value=x secondnum.value=y End Sub Private Sub sumnum_LostFocus() If sumnum.value = (Me.firstnum + Me.secondnum) Then MsgBox ("Good job") Else MsgBox...

Lonnie, If there were a static number of candidates, it would be very simple to make a set of nested loops where each loop index ranges from 0 to 1 and is multiplied by the corresponding element. It would not matter if there were 5, 10 or whatever. It is just a more deeply nested loop. For...

alexisb, i = 0 Open &quot;myfile.txt&quot; For Output As #1 Do While i <> 3 i = i + 1 Print #1, i & &quot;,&quot;; Loop Print #1, &quot;&quot; Close #1 Wayne

mj, After you trimmed the local variable, you never &quot;updated&quot; the Excel cell. Wayne

DYM, With the db1.Execute, you don't need the recordset. You do need the Where clause, but the recordset isn't used. Wayne

Har, No, that is my mistake. It should be If Not IsNull(). Just a typo. Wayne