Search results for query: *

I'll look into it. Thanks for the tip!!

I guess that would be possible, but very admin intensive. Say I decide to make changes to a form and I have 15 users, I have to do that 15 times???? Hmmm... there must be a better way. As for the difference between dynamically and programatically... in my head, that would mean either in the...

I have me a predicament!! I have a search form working very niceley that queries one of my tables and returns results based on 5 fields in a subform. Here's my problem... The subform data is based on the query "Search". In the "OnClick" procedure of the search button, some basic SQL is run...

Thanks for the idea, Leslie. I'll play around with it and see what happens... :)

Thanks for the reply Leslie. Not sure what you meant by "Calculated Field". None of those fields are necessarily calculated. And, yes, it is a comma, hence "Text Field". I guess this could almost be called an Array, or maybe a recordset. Not enough knowledge... hence, this post :)

I have found a few solutions that look like they will "Almost" work, but nothing that will actually solve it... so, here goes. I am trying to take a query result like this: OrderDetailID ProductName Qty 1 LeatherBag 2 2 PlasticBag 1 3...

Anyone know how to recover or bypass the tapeware login password? We've lost the username (it's probably "Admin") and the password. Thanks!!

Well, not sure if you're still struggling with this, but I have found a nice little work-around that works great!! Create a query on your table(s). In the query, create a field like this. Count: 1 When you look at your query, you'll see the field in the results with a value of 1 for each...

Thank you Rick. This is what worked. Dim intCt As Integer intCt = DCount("[CastingDetailCode]", "CastingDetail", "[ModCode] = '" & Me.Combo17.Column(0) & "' AND [CastingDetailCode] = " & Me.CastingDetailCode & "") If intCt > 0 Then MsgBox...

Hi Rick I am getting an error with your code. &quot;Run-time error '2465' Application-defined or object-defined error. My linking field is ModCode. I want to show all ModCodes where ModCode AND CastingDetailCode are unique. In other words, if Dcount(ModCode AND CastingDetailCode) is <> 0...

I have a table that has two fields combined to form a Key field. I want to use the Dcount function to customize a msgbox when the user enters a value that already exists for that record in the subform. This is what I have so far... Dim intCt As Integer intCt = DCount(&quot;[ModCode]&quot...

Thanks for the help, Bill but I just can't get it to work. I have tried so many different variables. The Dcount function is still specific to the whole table, and not just the current records in the sub form. Somehow, I need to make the intCt = DCount &quot;[ModCode]&quot...

I have a table that has two fields combined to form a Key field. I want to use the Dcount function to customize a msgbox when the user enters a value that already exists for that record in the subform. However, the Dcount function needs to hold true for both fields, not one OR the other...

You can create a sub form and have it as an independant form without having it imbedded in the main form, but have the same advantages of a subform

here is what I found on another post... RickSpr (MIS) Jun 12, 2003 The TreeView control was included with the Developer Edition of Access 97, as well as with Visual Basic Professional, Developer Studio, and other products. If you are still licensed to have any of those products on your...

I have a sub form that is dependant on data in the main form. I want a message box to pop up if the user tries closing the main form before the sub form is closed. Any help... much appreciated! [thumbsup2]

Toonce98 You can do everything through Exchange - POP3 and SMTP. My reasoning behind keeping everything on the server, is it focuses the load to one point. That way you don't have bandwidth issues with multiple users emailing large files from their workstations. As far as Outlook goes, when...

Toonce98... Thanks for the info. I'll check it out. As far as Internal mail goes, it should be instantaneous. Are you using Outlook for your clients? If so, it is native to Exchange, and should integrate seamlessly. If you are using Outlook, make sure that Exchange is added as an account...

Hi Folks Still no joy... I'm still waiting 15 minutes to receive my mail!!! What a total pain in the ass! Whoever solves this one will get a galaxy of stars from me! :-D

Please help!! I recently had to do an XP repair on my OS and took the liberty of installing Windows XP SP1. I am having a problem connecting to SQL server with my Access Data Projects. When I create the connection and test it, it tests fine, however, it opens up as disconnected. There are no...