Recent content by Caddie

Hi - My work computer has just been migrated to a new network and as such path to my desktop has changed because may network login name has changed. That said, I have an access database on my desktop (dev environment) and now that the path has changed the link between my front end and the DB...

Fantastic idea...works perfect now. Thanks!

Hi - I have a report that has a subreport embeded in it. There is a work order field in the main report and in the sub report, so they are my master and child links. The main report list costs associated to work orders related to vender invoices, where as the subreport list costs...

Hi - How do I use Crystal XI to connect to a secure Access DB using the .mdw file? I know how to use access to connect to it obviously, but can't figure out how to do it with Crystal. Thanks!

Hi - Recently a user asked me to delete a record from our database (through the back end, the database is split and password protected) which I've done many times with no problems. However this time, the result is a record that has #DELETE written in each field of the record and I am not able...

Your example works well, assuming the user has to chose a state first. However, in my situation I the user can run the report only by 1 sector, or 1 city or 1 customer. Or they can chose 1 customer then chose a city that the customer has service in. The only way I can see this happening would...

Hi - I've created a form to manage the passing of paramaters onto a report. I've got three comboboxes on the form: Customer # Sector (Enterprise, Public or Carrier) Region (Cities) These comboboxes are tied to tables and then selections are then passed into the query as paramaters. Also...

Now we're talking! Private Sub Combo39_Enter() If Me.Status = "Verified" Then Dim pass As String pass = InputBox("Record locked, please enter password") If pass <> "Welcome2" Then MsgBox ("Invalid Password") Exit Sub Else Me.AllowEdits = True...

You are bang on! What was throwing me off is that when you enter the data for the sub-subform the little drop down box that normally pops up doesn't but you can still enter code. Now it looks like this: Private Sub Form_Current() Me.Service_Addresss_Details.Enabled = False If Me.Combo39 =...

Hi Guys - For the time being I'm not going to worry about allowing the users to "UNVERIFY" once it's been verified. So, this is what I've done do far: Private Sub Form_Current() If Me.Combo39 = "Verified" Then Me.AllowEdits = False Me.Service_Addresss_Details.Form.AllowEdits = False...

Ok, thanks for the tip.

Got it: Public Function Original_Term_Renewal(Renewal_Type As String, End_Date As Date, Term As Integer) Dim Multiplier As Integer Dim Offset As Integer Dim Expiry_Date_Temp As Date Multiplier = 0 Expiry_Date_Temp = End_Date While (DateDiff("d", Date, Expiry_Date_Temp) < 0) Multiplier =...

Okay, I did some "googling" and I think I understand what you mean by making my own function. You mean in VBA I create a new module? If so, how do I reference my database fields?

I presume you mean using VBA on the report side? I tried taht but couldn't figure out how to place the vba code onto the texbox on the report. Where do I enter it, on an event? If so which one?

Here is the purpose of the code. If a contract expires on Dec 31, 2008 and the original term was 1 yr and the renewal terms of the agreement are that the contract will auto renew for the same term as the original contract (in this case 1 year, but it could be 3 yrs or 6 months). So my report...