Search results

  1. K

    Joins??

    I have two tables...1.) Expense, 2.)Income How would I get a result set to give back everything in expense and everything in income. Seems easy, but I'm stumped. Thanks in advance, Kacy ________ Ford iosis
  2. K

    Sending a Shortcut

    When I try to zip a "shortcut" it goes ahead and zips the actual database. So when I send it and have them unzip it, it actually loads the database to their harddrive and not a shortcut to the network. ________ Body Science
  3. K

    Sending a Shortcut

    Is there a way to send an Access shortcut through Outlook that it won't be blocked? I tried renaming the extension, but that didn't work. Any other suggestions? Thanks in advance, Kacy ________ Harmed By Paxil
  4. K

    Screen Area Pixel Size

    I was wondering if there is any way to have the forms automatically adjust to individuals screen area pixel size. I noticed on some users pc they have to scorll all over the place to access different fields and buttons while others everything is all on the screen without having to scroll. Is...
  5. K

    MsgBoxes

    I would think this should be easy, but I'm having a diffiicult time and keep receiving an error. I want to display a message box with a label I have for the title. Dim strTitle as String strTitle = lblTaxes MsgBox (txtTaxes), vbOKOnly, strTitle lblTaxes is a my label that I want to...
  6. K

    combo box

    I guess it's harder to say thank you in more than 10 words....... Thanks! ________ Shaved Pussy Webcams
  7. K

    combo box

    Is there a way to get a combo box so users can't type input into it. I know I could use listboxes, but I have already got the combo boxes in my code. Thanks in advance, Kacy ________ Lovely Wendie99
  8. K

    Hide "Debug" Option

    Hide "Debug" Option Is there an option to turn off in the event that there is an error that the "Debug" option is not available to users? Thanks, Kacy ________ LovelyWendie
  9. K

    Code Error

    Thanks Wayne! Just curious what is the difference. Thanks again...got it working. Kacy ________ Nevada marijuana dispensary
  10. K

    Code Error

    I have the following code that when the control gets focus it displays a msgbox with all the information. However if there is nothing in the combo box I get an invalid use of a null. I put the "if cbotaxes = null then exit sub", but the code always skips over the "exit sub" Does anyone see...
  11. K

    Call Form_BeforeUpdate ??

    Is there anyway to call "Form_BeforeUpdate"? When I try it I get a "Argument not optional" error Thanks in advance. kacy ________ LovelyWendie
  12. K

    Skip Form_Before_Update

    All of my fields are bound EXCEPT my username field which I get from a module. So I was thinking that and insert statement was the only way to get the username into the record. I tried doing the DoCmd.RunCommand acCmdSaveRecord then doing an update statement so I could insert the username but...
  13. K

    Skip Form_Before_Update

    Is there away to skip Form_Before_Update? I have a command button (cmdOK) that I use when the user adds a record. My problem is the code runs to add for cmdOK when clicked and then it runs again following immediately. I'm wondering if I could put something in the cmdOK_Click that after it...
  14. K

    Don't Save unless "OK"

    Working....is this OK to do It seems like I've got it working with the code below. The only difference if that I put me.undo after the insert statement and I'm not getting the pop up message I explained in the previous post. I just wanted to check to see if this is ok to do or am I going to...
  15. K

    Don't Save unless "OK"

    Having Trouble The code below is what I'm trying to use. I have to do an Insert statement instead of the DoCmd.Save because I have an unbound text box that contains the userid. The code runs through, but I get a message....... "The record has been changed by another user since you started...
  16. K

    Don't Save unless "OK"

    Thank you! That exactly what I was looking for. ________ VIDEO REVIEWS
  17. K

    Don't Save unless "OK"

    Don't Save unless "OK" I have a form that I would like for the only way for a record to be updated is when "OK" is clicked. The reason for this is because the "OK" button runs an insert statement that includes the username from their Novell account. My problem is if someone changes...
  18. K

    listindex

    Thank you! ________ Zx14 vs hayabusa
  19. K

    listindex

    I'm trying to set my list box to a particular action. In my list box I have "Inquire", "Change", "Delete". I would like to set it to "Inquire" so I would assume like in VB it would be........ cboAction.listindex = 0 But I'm getting a "You've used the listindex property incorrectly" error...
  20. K

    Run SQL?

    Great! Thanks a lot. Learned something new today. kacy ________ VIPER
Back
Top Bottom