Recent content by Ryon

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...

Not too mention that if you have already purchased 2 SBS your kinda scewed, because you cannot demote a small business server to a member server. It will shut itself off every 60 minute due to the fact that you are not in compliance with the EULA. Ryan

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...

that did it. thanks for you help. Have a star Ryan

It looks like its in the error handling, this is a label being used as a button. I have 4 that work fine and 6 that give me the error. On Error GoTo Err_LNEW_Click

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, ...

yes, thats exactly what Im doing. I was just wondering if using sql as a backend would give me any help in doing so. thanks for your help

yes it does work when your creating a query and a new field, say total:sum([time]+[time2] my problem is when you try and total the query using sum function for example time time2 4:55 4:15 3:25 3:15 SUM SUM

yes short time, but it doesnt calculate. It should, but it doesn't. Im using access, not SQL. Are you saying that SQL will calculate it correctly? Even in a access SQL query when you add 2 times together that have short time property value, it sums it to a number format that comes out like...

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...

on the new data command button add combosearch.value = "" Ryan

WOW, Rick you are the man. The solution you gave for the subforms using the source object control is just what i'm looking for. this will cleanup my code dramatically. The reason I'm trying to do it this way is, I have built a couple of databases already using the common switchboard control...

pete, Could you go into more detail regarding how you work subforms. I'm intriged. I have one form with 6 of 7 subforms. I have somewhat of a switchboard on the form header which when you select an option 1 form is visible and 6 are not. I do not know if this is the best way to do this... I...

BTW, have some stars Ryan