Search results

  1. N

    Workgroup

    Hi, I am currently working in Access 2010, and one of the users in my team is using an Access 2003 DB in 2010, this is all fine. However, some questions were asked about the MDW file, so i've been taking a look. I have joined the workgroup, which i am not a member of, now i cant use access...
  2. N

    ADO Execute

    Hi, I have written a tool in Excel VBA that compares an old copy of a database, to the new copy. Any static tables are removed and added from the old. So in the new i use connNEW.Execute "drop table x" and then in the old i use a SQL insert into so connOLD.Execute "Select x.* into db2 ..."...
  3. N

    Subquery frustration

    Hi Firstly a bit of background into the madness of my table. I had a sharepoint site linked to an access database for reporting. This SP site created workflows and tracked statuses, however for just over a day our SP server got full, so the new list items for tracking couldnt be created. As...
  4. N

    Adding controls to form and saving

    Hi, I am trying to open a form in design mode and add controls, this i have done. I am doing this all in a class, and am having trouble saving the modified form. I have tried using the following, both produce errors DoCmd.Save acForm, "tmpQueryDes" DoCmd.Close acForm, "tmpQueryDes"...
  5. N

    Event Sinking

    Hi, I am trying to sink the events of 42 command buttons on one form. I have created the class clsCustomCommandButton Option Compare Database Private WithEvents mCommandButton As CommandButton Public Property Set CommandButon(ByVal oCommandButton As CommandButton) Set mCommandButton =...
  6. N

    Textbox jumps to top

    HiI have a text box, bound to a memo, in a sub form, in my main form. However, when the user gets to the bottom of the text contained, to add further details, the textbox scrolls up to the top, when the first key is pressed.Is there a way to stop this?Thanks.
  7. N

    Show results not using join??

    Hi I have 2 tables, one tbl_Application contains details of applications, tbl_A_Numbers contains details of account numbers for that application. I want to run a query which puts all the records from tbl_A_Numbers into one column, rather than the conventional link. So, i have APplication 1...
  8. N

    Form Events

    I have created an event within a form in access, but can not find where it is to handle it. Can anyone advise?
  9. N

    Event Sink

    Hi, I am trying to create an event sink, to handle the on_enter event on my form, for each of the (approx 20) text boxes on the form, to have a common event. I have looked at a few examples, but can not get them to work. Can anyone advise. Many thanks.
  10. N

    Query Xtab type output

    HI I have a need to create a report, which i will simplify for the purposes of this. I have an orders table, which has 2 fields, cust_ID and Product_ID, both are numbers. I have a products table, which has 3 fields, Product_ID autonumber PK, Product_Name text and Licence Yes/No. The idea...
  11. N

    HTML Email in 2007

    Hi, I have recently (today) switched to Office 2007 from Office 2003. I my access DB there is a module which sends an HTML email, using the following code With objMailItem .BodyFormat = olFormatHTML .To = EMAIL@EMAIL.com .HTMLBody = "<HTML>" & strBody & "</HTML>" .Display End...
  12. N

    user control properties

    Hi, I have added a property to my usercontrol, called NumberOfChildRecords. This property appears when i add the control and view its properties manually. However, i am adding this control by code, and this does not allow me to add this property. ctlParent = New TreeViewv2.TreeView_Parent...
  13. N

    Custom COntrol

    Hi, I am exploring creating custom controls, and am having a little bit of trouble. I have read various articles on the web about authoring the controls, and how to use them. I have created a control, 3 text boxes and one button, on clicking the button, each text box, gets populated, 1 in 1...
  14. N

    PDF Distiller

    Hi, I have inherited a database that uses PDF Distiller to produce PDF's, i have the code, but cant find the files that are needed in order to set it as a reference in my code. Can anyone assist? Thanks
  15. N

    Custom Control Created in .NET

    I have written a custom control in vb.net. I have built it up in a test project (to test) and compiled as an EXE. The EXE file works exactly as planned, but i would like to use the custom text box i created in Access, when i try and register the DLL as a reference in Access, it says "cant add a...
  16. N

    Using Custom VB.NET Control in Access

    I have written a custom control in vb.net. I have built it up in a test project (to test) and compiled as an EXE. The EXE file works exactly as planned, but i would like to use the custom text box i created in Access, when i try and register the DLL as a reference in Access, it says "cant add...
  17. N

    Triggers

    Hi, I am planning to audit certail tables in my DB using triggers. I am new to triggers, and have got all the documentation about creating etc, but still have one question. I wish to audit, Insert, Delete and Update. Do i create a trigger for all 3 on each table, or can i create one...
  18. N

    code execution after form is displayed

    Hi, I have created a splash screen for my database, and want to run some code once the splash has been displayed. The code, simply checks for the users registration on the database, and if they are not, points them in the right direction. If they are, the main menu opens, if not a warning...
  19. N

    ListView

    Hi, I have recently used a image combo box and a tree view control in Access, and thought that my next task would follow a combination of these two, in putting images in a list box. Reading on the internet pointed me in the direction of listviews. I have the following code, on_load in my...
  20. N

    Citrix stopped vba

    Hi I have built a project in Excel VBA using the references from the normal place. However, last weekend certain users moved on to Citrix, and now the project cant compile. Do i need to force my references to be local, or Citrix dependant on whether they are a Citrix user? If so, how do i...
Back
Top Bottom