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

    Haha, excellent, learn something new every day. Yes that resolves the issue. Also, Is there a programmatical version of 'Ctrl Z' Regards Simon
  3. 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...
  4. 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 & " " &...
  5. H

    Running events on other forms.

    Works like a dream, thanks for helping.
  6. H

    Running events on other forms.

    Yes the child form is in form view showing one record at a time, the action form (child) is merely a recording form of all actions possible throughout the life cycle of the event (main form), ie adding a note, Update, closure, re-open etc for an audit trail of all actions taken against the event...
  7. H

    Running events on other forms.

    The child form is embedded into the main form and stays open permenantly with the main form until the main form is closed and both are then closed. No code runs at closure. Yes, i am using bound controls on both forms, and dlookups. I am looking for a little guidance on how to update the...
  8. H

    Running events on other forms.

    Thanks for the reply, but the Child form does only show records that are related to it, the PK / FK relationships are fine, thats not the issue. I want however, when scrolling through the main form records, the sub form and only the sub form to go to a new record automatically, but it has to...
  9. 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...
  10. H

    Combo Box data / refreshing depending on another combo box selection

    Haha, no i wasn't. Thanks, sometimes i need a poke with the stupid stick! All sorted. Regards Simon
  11. 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...
  12. H

    Dlookup help please.

    Many thanks that solved the issue. A little typo though, heres how it looks; lookup = DLookup("[contact_tele]", "[contacts]", "[contact_name] = " & "'" & user & "'")
  13. 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...
  14. 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...
  15. H

    Scheduling Crystal reports through VB

    Heres another angle; Use Crystal Delivery, its excellent and free!!! http://homepages.udayton.edu/~groffkep/ I use it at work, i have a dedicated machine and it schedules a huge amount of reports at different times, handles parameters and can export to a directory of your choosing on a report...
  16. H

    Unique Count Except for...

    Add a formula and use VB syntax. If [record] = "a" then formula = 1 place that formula on the details section right click it and choose summary / sum and move that to the header or footer where u want it. Thats a total sum of "A" then. Sum and count will return the same value as its the sum of...
  17. H

    Please Help ME

    This sounds a little like NTFS permissions on the location of where the database is held not the DB (I presume its access). Just Make sure its not the security on the folder, if so add or get someone to add you giving you the relative folder access on the security tab of the folders properties...
  18. 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