Search results

I somewhat agree with BLeslie88 about your posting. However; I must say this; loosen up a little bit on the users BLeslie88. Everyone is new to this board at some time or another. LittleGlory: Take a look at this previous post…it may lend you in the right direction...

To limit the combo box to the list… Set “Limit to List” to yes on the data tab in the properties of your combo box… This will only allow a selection from the items in the list. Then on the event tab on the properties of the combo box add the following Event Procedure to “On Not in List”...

My first actions toward this problem would be the same as The_Doc_Man’s. The next thing I would consider is that the Database_be.mdb may be opened exclusively. If the database has been opened exclusively it will give the same error. Don

Here is a previous post dealing with this... http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=19577 Thanks to PeterD and raindrop3 I was able to get it to work... This post also includes info on preventing a particular report or reports from being in the list box...

The Runtime Version of MS Access is just that...it’s a replacement (so to speak) for MS Access. Once installed; MS Access Runtime will allow you to run both .mdb and .mde databases. As far as I know the Runtime Version is not associated to just the database you packaged it with. There may...

It's a start... I am not a graphically gifted individual however; I created this little graphic… It’s not extravagant or anything but it’s a start… With a bit of luck it will give others the jump start they need to present there own. Don :D

If I understand what you are wanting to do... You could place the following into the OnOpen Event of your form... DoCmd.GoToRecord , , acNewRec Hope this helps... Don

Cdogg, Take a Look at this post...It may lead you in the right direction... http://www.access-programmers.co.uk/ubb/Forum4/HTML/000749.html Don Edited because of format...I forgot to hit the return key...It was ugly... [This message has been edited by donbettis (edited 01-13-2002).]

Haytham... I am not sure why it's giving you a compile error...I typed the code in my first reply although I hadn't tested it at that time...I have used it in the past...I just cut and pasted the above code into an unbound field, changed the [YourField] part and, it worked fine on mine... I am...

Haytham, "Fornatian" is right setting the fields input mask to "00000000000" (Minus the ") should do the trick... Another way you could achieve this is... Place the following in your BeforeUpdate Event of the Field... ----Start Code---- dim lFieldLength lFieldLength = 11 if...

David R Thanks Man...It worked like a charm... I never once thought about using a Select Case Statement... I've used it before but, for whatever reason it never entered my mind... I guess I had a one of those uhm "blonde moments"! I am entitled to have these moments...I have blonde hair and...

What I am trying to do is this: If the DateDiff between Today’s Date and a date entered in the NextSchContact field is say <= -90 then I want to put a message in an unbound field called Message. If the DateDiff is <= -180 then I would like a different message to appear…I can make it work by...

I am not if I am understanding your Question right... However, the way I achieve something similar to this is: I create a query based on the table that contains my data…I add only the field that I want in my Combo...Let us say that item is FirstName...Then in the criteria field of FirstName I...

Glad I could help...

If I am understanding your question and I think I am... You can create an unbound textbox on your form... Then place the following code in the Control Source for the unbound field... =[CurrentRecord] & " of " & Count(*) I Hope This Helps... Don Edited because I Fat Fingered...

David R Thanks... I had to play with the code but I was able to get it to do what I needed...

I am not sure if this is the only way or if it's a good way however, I figured out that you can name your reports like ~Report1 and it will not show up in the listbox... When a report is assigned a name starting with "~". The above query skips those names. Kewl Beans Man... If this a real bad...

One last thing... This is more of a question to broaden my knowledge then is something that I need... Is there a way of preventing a particular report or reports from being in the list box? Thanks Don Life is Grand when you achieve...

raindrop3 Thank you...Putting the 'MyFunction MyListbox.value, Forms!MyFormName' as an Event Procedure worked great... Peter D Thank You for starting me in the right direction...Without your help raindrop3's suggestion would not have helped me complete this... I give a round of applause and...

Peter D Thanks for your reply...I have achieved getting the list of Reports...However I am having trouble with the "create a function" part. I am not sure what I am doing wrong but it keeps telling me the it can't find the macro "MyFunction MyListbox"... If it's not to much trouble could...