Search results for query: *

Do any of you remember the formula to convert a date to its corresponding number wherein that number starts at 1/1/1900 (maybe it's 12/31/1899) with 1 and increases by 1 each day until whatever date you use as the maximum? For example 12/31/1901 would be 830? (or there abouts...I still need a...

I don't think it's necessary. I've already written the query and already getting the needed data. I'm going to figure out a .bat file to import the data. See http://www.microsoft.com/technet/scriptcenter/resources/qanda/feb07/hey0206.mspx

I looked at the 'get data directly from PS' link you sent which solidified my dilemma - we are not given access to Oracle, therefore, can't set up an ODBC connection to grab the data. With Crystal I do the same thing: I write one or more queries and bring those into Crystal as if they are my...

CaptainD, You're the best. Thanks for the code AND the prefix tip. Like I said, I'm a Crystal Developer and don't know VB...OBVIOUSSSSLLLyyy. Our PS database is hosted by our parent company out-of-state and I don't think they will give us direct access to dumping data directly from PS to...

Hi CaptainD - Thanks for all of your information. The form displays the contact phone as a text box. I've called both the text box and the field on the form the same 'ContactMainForm.' I have two or three subforms on the main form for notes and order/shipping information. I have no code in...

sorry - meant to use count. shared numberVar prodCorr; if V_BAR_SR.BAR_TYPE = "Production Correction" then prodCorr := (count(V_BAR_SR.BAR_TYPE)/count(V_BAR_SR.BAR_ID)) * 100

Try this: if V_BAR_SR.BAR_TYPE = "Production Correction" then (V_BAR_SR.BAR_TYPE/V_BAR_SR.BAR_ID) * 100 If you want to use this value more than once, yes, declare a variable as shared, then the statement. Like this: shared numberVar prodCorr; if V_BAR_SR.BAR_TYPE = "Production Correction"...

Thanks, CaptainD- We've got phone software that, when the call comes in, it's dumped into a variable called remoteNumber. My VB code checks the number against what I have in my access database, and if it exists, my form pops up (6000 records) with the correct customer data of that caller. The...

All I need to do is declare a variable that returns the contents of a field on my Access form. For example's sake, my variable name is myVar, the database is MyDB, the form is MyForm, and the control is MyControl. Thanks

Let me back up. We have new phone software. Call comes in, searches the Access Forms for a match of that number, then pops up that form. The call taht comes in is WVrCall.RemoteNumber. Right now if it finds the match it pops up the right form. If it doesn't it pops up a blank form. That's...

Hi ProgramError - the field will never be null because WVrCall.RemoteNumber is the var that holds the phone number coming in. This starts the whole process. Thanks, though.

Thanks, youngManRiver - just back from lunch and it looks like it will work. I'm trying now. Alexandra

I'm using the where clause in the openForm method to find the phone number associated with my form. It all works fine. If the phone number is not found, a blank form comes up which is fine, but I'd like to also to have a msg box appear saying, "No contact found." I don't know how to search the...