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 Rhinorhino 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: *

  1. Loktar

    Help with IIF Statement please.

    You could try something like this: Dim strAddress As String strAddress = IIf(IsNull([addrnum]), vbNullString, [addrnum]) & _ IIf(IsNull([street]), vbNullString, " " & [street]) and then keep going for the rest of your variables. strAddress = vbNullString is basically the same...
  2. Loktar

    Record selection in subform not working

    Well this looks like a new record for consecutive replies in one of my own threads, but I've figured it out thanks to the help you gave me. Here's what I ended up with: Private Sub cmdRemove_Click() On Error GoTo Err_cmdRemove_Click Dim strSQL As String Dim curRecord As Long...
  3. Loktar

    Record selection in subform not working

    Now I feel slightly stupid :-P The reason that it "worked" when it was trying to go to record 1 was because of the if statement I had that only ran if it was not equal to 1. I had needed that for part of a test I was running on it earlier and forgot to delete it afterwards. Anyway, thanks...
  4. Loktar

    Record selection in subform not working

    Hey Roy, I saw that code of yours in another thread, but I didn't understand how it could findfirst when the record that would store lPK has been deleted. How would it ever find a match? Maybe I don't understand what PK means exactly. I just tried assigning the curRecord before the delete, but...
  5. Loktar

    Record selection in subform not working

    I know this issue has been brought up here, and many times at that. However, I've read all the posts I could find on it and still can't solve my problem. I have a subform built off a query, and when a user clicks the "remove" button next to a record, the record is deleted from the underlying...
  6. Loktar

    Can programming be separated from software design?

    My jaw dropped when I read this... I thought this only happened in fairy tales and myths. As I'm fairly new to 'real-world' programming projects having just graduated from college, I'm not that experienced with the different methodologies of software development, although I have learned enough...
  7. Loktar

    Some help with images

    Also, keep in mind that there is probably going to be a balance between speed and ease of use/design/updating, etc. Making the images dynamically load with links would be the easiest way to do it, in my opinion. Having all the images load and selecting which ones to view might be faster, but it...
  8. Loktar

    MS Conspiracy theory

    Personally, I think it's a bunch of little gnomes running around inside my computer with tiny magnets rearranging my hard drive while I'm at home sleeping... but hey, it could be a sign of the times ;-) I agree that it is _extremely_ frustrating, and that MS products seem to do it a bit more...
  9. Loktar

    Refresh Screen?

    I know that there is a way to set a timer event in forms, but there might be a way to refresh the form every time it recordsource is updated. The code you will want to use is Me.Requery or Me.Refresh Which one you use depends on how you've built your forms. The easiest way is to try both...
  10. Loktar

    Print on a form

    If you're looking to draw a line on a form, in the toolbox there is a line tool. Not sure what the name of it is, but its icon looks like a diagonal line. Click this and draw a line however you see fit on your form.
  11. Loktar

    Formatting Twice problem

    I would look it up in the Access help. My guess is that either the variable FormatCount holds the value of what iteration of formatting the report is currently on, or you can pass a value telling it how many times to format. I don't have access to... Access right now or I would look it up and...
  12. Loktar

    DONT PRINT BLANK REPORT

    One thing I've done in the past is in the On Load event of your report, have it check if any records have been returned, and if not, close the report before it can fully open. Here's code I've used. I think this was for a form, but I'm sure the same applies to reports. If Me.CurrentRecord = 0...
  13. Loktar

    Image color limitation on report preview?

    Here's a question for you all... On one of my reports I generate a thumbnail list of items in our inventory. The images are linked .bmp files, and they display correctly, except that they appear to be in 256 color mode only. Is there anyway to get access to display them in their 16 million...
  14. Loktar

    Check box for user input

    Oh, I only use them as check boxes, not for typing in. I turn all the editing options off and use them as if they were buttons/check boxes. Being able to enter data and double click would confuse my poor users too much ;-)
  15. Loktar

    Check box for user input

    I ended up using text boxes in place of check boxes before on my continuous forms, and that's what I did on this one too. I've never had to use double click tho; single click always worked fine for me :-)
  16. Loktar

    Check box for user input

    I was hoping that I didn't have to do it this way...oh well. Thanks for the input tho, now I can stop banging my head into a wall :-)
  17. Loktar

    Check box for user input

    Hello everyone, I have a fairly simple question that's been baffling me since I started using Access. I have a continuous form and I want to place a check box along with each record. I don't want this value bound to anything, instead I want to use it for user input. The user checks the box next...
  18. Loktar

    Insert email address from textbox into "To:" field in Outlook

    See if this code can help you. It works great for me. Note that you will have to include the reference to Microsoft Outlook 9.0 Object Library. This is using Access 2000. Public Sub SendEmail() Dim oLapp As Outlook.Application Dim oItem As Outlook.MailItem Set oLapp =...
  19. Loktar

    Read Outlook address book ???

    If anyone knows how to do this, I would like to know as well. Outlook doesn't seem to like having an email sent to it from Access without an email address in the To field, and using a dummy entry seems to confuse users quite a bit :-)
  20. Loktar

    Creating a search tool in an Access Page

    That I'm not sure about. My guess is that it would work in a similar way, but I don't have any personal experience with doing Access on the web. Hopefully someone else will come around who can answer that for you. :-)

Part and Inventory Search

Back
Top