Search results for query: *

If you are doing your math on the report I would move these calculations to your queries to see if that would improve the reports output. Another item that can slow down a report is with code behind the report, if you can move that to your queries you will increase throughput.

Perhaps I am missing something here but rather than use Trim(), why wouldnt you use RTrim() instead?

Personally I dont think you can make a broad assuption that you need to move from Access because you have more than 15 users. Yes, lets face it, anytime you upgrade your network, for the most part anyway, you are going to improve the throughput of your database. 10mbps to 100mbps is a factor...

When the remote makes the call (I am assuming that PC initializing the call is set up as the Modem Remote), and provided the other is set up as the Modem Host, what happens when the call comes in to the Host modem, does the system try to answer? Do you hear the connection noise at all?

If I understand (and I am really confused), a real simple solution would be to add a subform to your searching form, the subform would call up the same table as the main form but only allow for adding new records. In other words you would not be setting them up as Parent and Child, you would be...

Perhap you can also try the Shellwait routine with xcopy, it suspends Access until the process completes itself and then passes control back to Access. You can copy the code from Dev Ashish's website and give it a try it might solve your problem. http://www.mvps.org/access/api/api0004.htm...

Written by Terrry Kraft and found on Dev Ashish's web site I store this routine in all my projects when I am going to shell to programs while in Access, this will cause Access to suspend itself until you are done with any application or DOS batchfile. For exeample, I had to write a routine that...

Another approach would be to use Chr$(34) The ascii equivilent to the quotation mark DLookUp("[Description]","tblSubAssyListing","[JobNo] = " & [Forms]![frmReportsListing]![Combo8] & " AND SubAssy = " & Chr$(34)& [Forms]![frmReportsListing]![Combo22] &...

You don't even have to go as far as using a variable. If rs("InAssy_Yes") then ..... .... end if Bruce Gregory

I failed to notice your openreport statement and just duplicated it for my example, the following would be the correct syntax for the example. Private Sub command4_click() Dim Crit, Docname as String Crit = "JobNo = " & Me.Combo8.Value Crit = Crit & " AND SubAssy = '" &...

I'll stand down, I wasn't trying to compete with anyone, just trying to pass a thought to the originator.

Try this one, perhaps place it in a global module. Function Table_isThere(Tbl2Find as String) As Integer 'see if 'Tbl2Find' exists 'returns True if there, False if not Dim MyDB As Database, I As Integer Set MyDB = CurrentDB For I = 0 To MyDB.TableDefs.Count - 1 If...

Wouldn't it be easier just to include your recordset in the Row Source Property of the combo box as the result of a query or temporary table resulting from your recordset? Bruce Gregory

Wouldn't this get you the same result? Private Sub command4_click() Dim Crit as String Crit = "JobNo = " & Me.Combo8.Value Crit = Crit & " AND SubAssy = '" & Me.Combo22.Value & "' " OpenReport "rptManufactured Parts List", ,Crit end sub Bruce Gregory

One line that has to go is Set rscheck = rs("InAssy_Yes") You have dimensioned rscheck as Boolean and now you are trying to 'Set' it to a recordset? This confuses me. Bruce Gregory

If the second user can't get into the database at all then the first user has opened the database 'Exclusively'

It would be helpful if I knew what you mean by 'online', if you just mean logged into a network then the simplest way would be to write some code checking for the existance of a file on the file server, if the file is there you are online and if not you are not. Create a button on a form called...

Put the function in a global module and you can call it from anywhere, for example if you have a field you want to display the 3 character month name and you have a field on the form named [Plan Del Date]that has the date to check you could do the following. In the 'Control Source' of the month...

I am not sure if I understand your question but you could create a small function to give you the three letter month. It is not so elegant but works on any date string. Function monthofyear (date2check as Date) as string Dim Months as String, MoNum as Integer Months =...

Perhaps your join is set up to include only those rows where the joined fields of both tables are equal, you should maybe change the join properties to include all the records from one table and only those records from the second table where the join fields are equal.