Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: kaiana
  • Content: Threads
  • Order by date
  1. kaiana

    Subform disappears Main form allowedits = false

    I have a main form with a tab control and several subforms. There has been many errors with accidentally hitting the space button when looking up data so I have set the main form to allowedits = false which also sets the subforms to not allow edits which is fine, except that, if the subform has...
  2. kaiana

    Combo Box add to list when list is not from table?

    Hi, I have a combobox that I input the list that was to be selected from (ie. list is not derived from another table). I am now needing for items to be added to that list by the user. I have seen plenty of threads that show how to do this when the data is pulled from another table but not for...
  3. kaiana

    Switchboard totally grey in form view

    Hi, I have been programming this db for months now and suddenly my switchboard is coming up totally grey in form view. It looks fine in design view. I have no idea what I have done to create this. Can anyone point me in the right direction. I don't want to have to recreate if possible and I...
  4. kaiana

    Code not seeing duplicates

    I am trying to get the code to return "Duplicate" if a duplicate is found, it is not working, I have separated the criteria and found that it is the date part that is the problem. Here is my code and it is returning "0" even though there are duplicates in the table. y =...
  5. kaiana

    SBS 2003 Exchange Recovery Mode

    I Have an sbs server running exchange using pop connectors. If I send a message via a client machine it errors saying exchange is in recovery mode. If I send via web mail it sends ok. In the event viewer it shows an application error reporting the exchange to be in recovery mode????? What is...
  6. kaiana

    Subform disappears

    I have a form that I have just added a subform to (using the wizard) and have not put any of my own code in as yet or changed any property settings. When I open the form in form view the subform fields do not show unless there is data in it. I have used subforms many many times and never had...
  7. kaiana

    Base recordset on a query

    Hi, I have some code to run for emailing multiple members. It works beautifully but it is based on a table. I want it to draw the data from a query rather than a table. Can I do that by calling the query or do I have to enter the sql statement? Any help would be greatly appreciated. Here...
  8. kaiana

    SendObject not working

    Hi, I have read all the threads on sendobject and can't find a problem. I am wanting to email a snapshot of a report and I am using this code in the onclick event of the cmd button: DoCmd.SendObject acSendReport, "Parents", "Snapshot Format", Email, , ...
  9. kaiana

    Setting a stationary (using code) when emailing from access

    Is there some way to programaticaly set a selected stationary within Outlook when sending an email from access? Any thoughts would be great Kind regards Jason
  10. kaiana

    Cursor placement in custom stationery

    I have created a stationery for Outlook Express and it works beautifully, however, we have now changed to Outlook and doesn't work so beautifully. The cursor comes up under the logo at the top of the email and thus when I type it moves the logo down or across the page. How do I set the cursor...
  11. kaiana

    Message box if fields are blank

    Hi All, I have been struggling with this one for a while and have tried several different options. Problem: I have a form that is on continuous form and I have fields that I want entered. If these fields are not entered on moving from that record, I want a message box coming up giving them...
  12. kaiana

    Form moving to first record on requery

    I have a button on my form that inserts a photo. However after the photo is selected it isn't updated on the form. I tried me.requery but that moves to the first record. me.refresh and me.repaint doesn't work. After clicking on the insert button and selecting photo if I just move to previous...
  13. kaiana

    Subform not sorting correctly

    I have a subform that is not linked to the main form as the all the main form has on it is an unbound text box and then the subform queries a table based on the date entered in the text box. Everything is working beautifully except that the subform is not sorting based on the criteria and can't...
  14. kaiana

    Don't want to have blank row showing in form

    I have a form that is opened from another form, it auto fills the first field from data in the form, however once it fills that field and sets the focus to the second field it also adds another blank row with the *. I don't want it to add that row unless "Add Training" button is...
  15. kaiana

    Autonumber not unique after insert query

    Hi, It has taken me some time but I have managed, (with the helpful suggestions from tek-tips), to get an insert query working well pulling data from old backend and appending to new backend. Then I find that the autonumber is disregarding the numbers that are in the field and starting at 1...
  16. kaiana

    Delete a registery key

    I have the w32_Datom_Worm Virus on a medium sized network. Removing this virus meens disconnecting every computer from the network booting in safe mode and deleting some reg entries manually. I want to create a small exe to automate the deletion of these entries. How in code do i Delete the...
  17. kaiana

    Default Value in Table based on two fields

    I am trying to set a default value in a table based on two other fields in the table. This table gets its records via an append query. It has a primary key "SupportNoteID" and I have a field ("SupportNoteNumber") that I want to fill with the default value of...
  18. kaiana

    Open form linking criteria to subform

    I have read thru some threads on this but to no avail. I have a database that is tracking Service calls Form 1 (ServiceManager) has a button on it to open form2 (Hardware) it currently opens this Hardware linking UserId on the mainform (listing HardwareID's in the first subform and showing...
  19. kaiana

    Field goes white

    The forms in my database have an image in the background and I have made some fields transparent and locked with an on click event. When it is clicked or has the focus the field goes white instead of staying transparent making it look quite ugly. How can I stop this from happening?
  20. kaiana

    Position Message boxes

    I have a database that I am programatically positioning forms in certain areas of the screen. However, when a message box comes up it comes up in the middle of the screen I want it to come up in the middle of the form that it actually relates to.

Part and Inventory Search

Back
Top