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

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

Thanks for all your help, I will hit the books. 2 more questions though before I get started. Can I use a custom logon window with access security? by setting up the front end with miltiple subforms am I going to get into any trouble with record locking, visible-not visible. compared to...

I just read the post again, if you are trying to hide all of the buttons on the FORM, then just set the form properties for control box to no. if you are trying to hide controls in the access window then you are on the right track: yes, its the same code, this removes all access built in...

there is also some code on this site that actually hides the access widow completely. making the forms appear by themselves with the desktop in the background. it will require some code in the on open and on exit event of every form but it would also solve your problem. if this intrests you...

you could also use sub-reports and link themto you main report

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