Recent content by Loktar

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...

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...

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...

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...

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...

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...

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...

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...

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...

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.

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...

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...

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...

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 ;-)

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 :-)