Search results

  1. H

    Help please for a novice.

    Ok, im not the best Visual Studio developer in the world. So if you can spare a few moments to help that would be great. Im using Visual Studio 10 beta at the moment, along with Visual Studio 2005. My project has a form that connects to records stored in an Access database...that all works...
  2. H

    Some Help please - Rolling back changes / cancelling

    Hi, I hope someone can help point me in the right direction. I have a form that has numerous bound lookup controls on it. If on a new record and i type in data that is not verified in a lookup combo box i get an error that states this....fine thats how i want it as u can only select data that...
  3. H

    Any help would be appreciated docmd.findrecord

    The following code sits behind an actions form. Public Sub Command23_Click() On Error GoTo Err_Command23_Click Dim stDocName As String Dim stLinkCriteria As String asset = DLookup("[asset_name]", "[events]", "[event_id] =" & event_id.Value) action_desc.Value = action_desc.Value & " " &...
  4. H

    Running events on other forms.

    Hey, I hope one of you wizards out there can help. I have a main form and subform with a one to many relationship. Some main records contain no subform records and others can contain 20+. My goal is when the main form changes record i want the subform to always go to a new record...
  5. H

    Combo Box data / refreshing depending on another combo box selection

    Any help would be great. I have 20+ tables in a database all linked in some way or another. What i would like some help and advice on concerns just 3. Asset Table Customer Table Contact table Asset table links to the customer table via a customer_id key in both tables. Meaning the Asset...
  6. H

    Dlookup help please.

    I have produced a dlookup to grab the telephone number of a contact on a form and it returns the folloing error; run time error '3075': syntax error (missing operator) in query expression ...... Heres the code; lookup = DLookup("[contact_tele]", "[contacts]", "[contact_name] = " & user) I...
  7. H

    Public Variables

    Need a little help as i am a novice. Using 1 form to select an option, depending on that option a string variable is populated with a path. (this bit works fine) as follows. I have declared as.... public reportpath as string Button click code; Private Sub cmdrunrep_Click() 'On Error GoTo...
  8. H

    A little help if possible please.

    Im using Crytal Reports X1 Developer Edition SP4. MS Access (Office 2003). I have been using crystal reports for about 11 years in its various versions on SQL DB's. I am realtively new to Access although im picking it up quite well from having a good understanding of how it all fits together...
Top Bottom