Search results

  1. C

    Security and Protecting my work

    I created a big database program for a company. I want to protect it so that if any changes need to be made they have to either pay more or contact me to do so, I want to make it so that what they use is the user end version that is not editable or changeable but they can of course still use...
  2. C

    Useing Refresh in Module

    I created a function and wanted to use Me.Refresh what would be the equivlant for a module?
  3. C

    shortcut for buttons?

    I use the same buttons in almost all of my forms none of them change is there a way of only having to write the code once and reference it on all of them so that if I change it! the all change here is the code that is looped Private Sub Previous_Record_Click() 'Button On Error GoTo...
  4. C

    Trbl with Filter

    The following code is used to open a form with specific criteria problem is that once the criteria is met and the form is open if I want to goto the next or previous record of that employee it wont let me how do I remove the second part of the filter once its used on open DoCmd.OpenForm...
  5. C

    duplacate output

    the following sql doesnt quite do what I am tryinh to achieve SELECT DISTINCT Employees.tblInitials, Inbound.tblDate_Review AS Inbound, Inbound.tblRRound, Outbound.tblDate_Review AS Outbound, Outbound.tblRRound, Critical_Criteria.tblDate_Review AS [Critical Criteria]...
  6. C

    not going to before update

    When I use the following code it does not run the before update Form_KeyPress Private Sub Form_KeyPress(KeyAscii As Integer) If KeyAscii = vbKeyEscape Then DoCmd.Close End If End Sub but when I have it run through this code CloseForm_Click Private Sub CloseForm_Click()...
  7. C

    clear filter on close

    I figured this would work but it does not Private Sub Form_Close() Me.Filter = "" End Sub as for some reason every so often the filter box contains data and screws up my form! and I have to go into edit and manually remove the filter and then its fine so how can I go about doing the above...
  8. C

    trbl with sending data

    OK I am having trbl with this code Private Sub ocxCalendar_Click() mystring = Me.OpenArgs myarray = Split(mystring) 'myarray(0) 'myarray(1) [Forms]!["myarray(1)"]![txtDate].Value = Me.ocxCalendar.Value DoCmd.Close End Sub keeps saying unable to find form myarray(1) even though when...
  9. C

    Looping Private Sub

    Is there a way of shortening this code Private Sub Command1_Click() Does something in here doesnt really matter dont have the code as its at work End Sub Private Sub Command2_Click() Does something in here doesnt really matter dont have the code as its at work End Sub Private Sub...
  10. C

    WHY! Mouse Scroll!

    Why is it in the year 2004!!!! Why cant Microsoft do anything right lol what I mean is why is it we have to install third party software to make the scroll wheel working in the Microsoft Visual Basic Editor Especially when it works great in the rest of the Office programs??? is there a reason...
  11. C

    Stopping Form from being opened

    I was wondering how do I stop a form from being opened in the database window so that it can only be opened from a button in other forms?
  12. C

    onLoad or onOpen???

    What is the difference? :confused:
  13. C

    Standard Naming Convention

    I was wondering if this is still the starndard naming convention http://www.mvps.org/access/general/gen0012.htm and if so then to what this is saying all table names should have a tbl infront of them! I am also aware of the reserved words list however if you follow the Standard naming...
  14. C

    trouble with escape key

    I created a action so that when I press the esc key it closes the form Private Sub Form_KeyPress(KeyAscii As Integer) If KeyAscii = vbKeyEscape Then DoCmd.Close End If End Sub however I have the following code in the form as well Sub Form_Unload(Cancel As Integer) On Error...
  15. C

    Creating Function

    If I am correct useing a function is to cut down on having to write the samething over and over again! right? anyhow if I am wrong please correct and put me on the right path to what is that does that ok below is some code that I am having trouble with so I have this code that works Private...
  16. C

    Changing Text Box into Combo Box

    Ok on to the new adventure attached is a db file that contains all the information what i need to do is change EnhStoreSellTxt and EnhStoreBuyTxt into combo boxes so that when the first 2 combo boxes are selected the EnhStoreSellTxt or EnhStoreBuyTxt shows all the stores at that price in the...
  17. C

    Multiple Criteria DMax?

    Is it possible to have more then one criteria in Dmax for example DMax("expr", "Table", "Criteria = 1" & "CriteriaA = 2") Mind you the & doesnt work so its definatly not the right Choice? :confused:
  18. C

    not going through the table

    I am having trouble with getting it to grab the data in the form I have the form connected to the enhancement table and I have the following code for the first dropdown there are 2 Combo Boxes the first one is Enhnamelist and the second is ENhLevelList I also have 2 txt fields named...
  19. C

    grabbing data from table dynamically

    Ok how do I get this code to grab data from a table or query based on criteria? Private Sub Level_AfterUpdate() Enhance = Me.Enhancelist Lvl = Me.Level If Me.Enhancelist <> "" Then Me.PriceTxt = Lvl Me.StoreTxt = Enhance End If End Sub so that instead of it saying <>...
  20. C

    Trouble setting up table structure

    I want to create a form that has 2 drop down boxs when choosing the selected drop downs then I would have 2 other boxes that would indicate say store and price! so in total I have 30 items 40 levels of the 30 items and these 30 items can be sold at 7 different stores for differnt values so the 2...
Back
Top Bottom