Search results for query: *

we are using the service cases to handle service requests. my issue is that if you open a new service request and when you select an account it should limit the list to the associated contacts. Correct?

Just did a SBServer2003 migration. mail is not working very well though. I seem to have a problem with port 25 staying open. At various times of the day mail gets delayed by hours. just a simple hotmail test, which goes through normally very fast, sometimes never gets delivered. I ran a GRC...

First off, I have no clue about ACT, I have been programming in access for several years now I support the computer sytems for a small office, 6 users They all sync to a main act database the office manager told me that her reports are different from the other users reports. (ex: more...

Why am I getting "Label Not Defined"??? I've been staring at this for an hour!!! help please Private Sub LNEW_Click() On Error GoTo Err_LNEW_Click Dim intaswer As VbMsgBoxResult DoCmd.DoMenuItem acFormBar, acRecordsMenu, acSaveRecord, ...

I'm currently using access as a front end and as a back end. My problem is that access doesnt have any functionality to calculate time for example: 2:20 +2:50 =4:70 not 5:10 like its suppose to be. I have gotten around that using VBA but, it has become quite a hassle...

ok, let me start off by giving a little decription of my database. Im trying someting a little different then the switchboard approach. I have one form with with various buttons at the top to act as a switchboard. Each one making a subform visible and the others not visible. I have hidden the...

I have a mainform with several subforms. only one subform is visible depending on there selection. what I am trying to do is use the activeX Banner control to give instructions on how to use each subform. If this is what I think it is, it should scroll across like the banner control in...

I have a query I'm building and I need to point the query to the first row of a table for values. here is what I currently have but apparently I'm missing something. >=[Table Repair Dates]![from Date] and <=[table repair dates]![to Date] Help, Ryan

I have a statement report that I'm trying to get the sum of the TOTAL column WHERE the COMPDATE is between DATE()-30 and date-60. I have tried the expression below but all I get is ERROR. =Sum([DUE]*([COMPDATE] Between 0 And 30)*-1) I have also tried to do it with the DSUM function and get the...

Hello, Please tell me this is possible. I have a mainform named &quot;FRMCLIENTS&quot;, With a subform called &quot;FRMLABS&quot;. The subform is a Tabular form with multiple entries per client. The subform has a field &quot;LabNum&quot; which is link with one to many relationship with the...

Hello, Please tell me this is possible. I have a mainform named &quot;FRMCLIENTS&quot;, With a subform called &quot;FRMLABS&quot;. The subform is a Tabular form with multiple entries per client. The subform has a field &quot;LabNum&quot; which is link with one to many relationship with the...

Hello Again, I have a invoice form with 2 subforms on it.one subform is for material and one for labor. I have a textbox(SUM) and(SUM) on each subform that totals the &quot;totals&quot; fields. On my main form I have 2 UNBOUND textboxes that equal the subforms values. This is what I have as the...

Hello Again, I have a invoice form with 2 subforms on it.one subform is for material and one for labor. I have a textbox(SUM) and(SUM) on each subform that totals the &quot;totals&quot; fields. On my main form I have 2 UNBOUND textboxes that equal the subforms values. This is what I have as the...

ALL, I have 2 colums in a workbook, one named taxrate and the other is tax. I am trying to get the total of the tax column WHERE the taxrate = 7% any Ideas. TAXRATE TOTAL 7% 198.00 6% 444.00 7% 123.00 6% 433.55 6% 343.54 ---------------- total...

hello, I have a client form and each client goes into a lab(LAB#) I 'm trying to filter the form based on a combo box(combo60) the combo box is on the client form and contains all of the lab#'s. Help!!and Thanks

Hell again, this code is attached to a combo box on my form. the code works fine but (there is always a but) it requerys my entire form which changes the recordset. Any ideas on how to make it either just requery the combo box, not requery the combo box till the entire record is saved or bring...

I have a client database that has around 1000 records.the Backend is on a network share for about 7 people to access. I also have 4 or 5 guys that are going to be validating all of the information from trhe field.All they have is dialup. which cannot be done using the front end back end senario...

hello again, I have a Clients form and on this form I have a button that opens up another form. Which is a request form( data entry). What I need is for the fields from the first form to populate to the second, so the request has all the client information already entered. thanks Again!!! Ryan

I have probably 9 or 10 fields that cannot be left blank on an order entry screen. I was wondering what is the best way to do this. I know you can do this with the before update event. Is there a better way? I'm using Access 97. Thanks again. Ryan

could someone help me with this statement, I am new to this and learning. I keep getting a &quot; function call on left hand side of statement must return avariant or an object&quot; Thanks ahead of time. Again!!! Private Sub Form_BeforeUpdate(Cancel As Integer) If Not IsNull(CALLNUM.Value)...