Search results

just use the example and modify it with 3 listboxes... the principle is the same for 3, 4, 20 listboxes... all you have to do is copy what is done in the example for 1 and make it 3... Kev

OK - this is a pretty involved process so rather then trying to explain in detail I whipped up a demo and posted it here: Multi-Select Listbox and In() Function Have a look at this and let me know if you need help implementing this in your app... HTH, Kev

glad you liked it... if you like the calendar demo check my demo for the treeview control in that same forum... lots of applications and uses for that one! :D HTH, Kev

Q1: Create a new query. Put your fields (field1, field2, Payment) in the query fields. Then in a query field that does not have anything added to it yet add this: [field1]+[field2]-[payments] in the "Field" field... then in the crteria for this field put >0... then base your report off if...

for multiple items in multi-select listboxes you have to use the In() function...

ChickeyD - You may not get a reply on this... this thread is over a year old!!! :eek: You can check the post dates on the left hand side of a post above the users name... HTH, Kev

Dim ctl As Control For Each ctl In Me If ctl.ControlType = acTextBox Then If rs!Status = "Busy" Then ctl.BackColor = vbRed Else ctl.BackColor = vbYellow End If End If Next Set ctl = Nothing

Oliver - Did you try the suggestion made by Mile/SJ McAbney? I wonder because he has given you the correct way to do this. You do not need the individual names of the textboxes as you are using the control object to go through all of the textbox on the form. Basically the code says that for...

With the DoD I'm surprised thats all (I think the expression arm & a leg would apply literally here) Kev

Good Point Ken/Doc Monkey - Do you have an IT section to your company? Are you the IT Section? I only ask because something like this application you are talking about is going to require some pretty heavy machinery - Your talking (potentially) a DB server running Oracle/SQL Server (I'd go SQL...

don't use a marco - they are awful - you need to use a recordset/array and loop through the records populating the set and firing emails. Search the forum for "email" as this has been covered alot! HTH, Kev

monkey - ReAn gave you some options but, personally, if your talking 80 users across the continent then your talking a web FE with a large RDBMS as the BE plain and simple... I would not touch this project with Access if you paid me... Go with ASP/ASP.NET and SQL Server/Oracle... This is...

Should have clarified - Charles you wont be modifying the original system.mdw you actually create a new .mdw and add users to that new .mdw. For with modify I actual meant, and should have said, that many people try to manipulate the original .mdw file and in the end usually try to solve the...

No Problem Charles - wasn't trying to yell at you - just wanted you to know that what you thought was "secure" was actually not... If your beginning to explore Access Level Security do two things first: 1 - make a backup of your database file. 2 - make a copy of the system.mdw file of which...

Greg - One thought - is your form slow to open because of a connection/network issue? If that is the case search this forum for "optimize", "database performance","db performance" as there are many posted tips to increase the speed with which your db operates. Second - progress bar demos are...

Mod - General Database Design practices dictate that you should always enforce business rules at the lowest possible level. The lowest possible level is that of data service i.e. tables and their relationships. This is a common practice and should not be ignored... Follow the Doc's advice...

if you have basic VB skills already I'd stick with VB (or make the move now to VB.NET)... IMHO your better off with VB/.NET but there are other variables to this question as well like learning curve, development time, development environment, deployment, etc... HTH, Kev

Charles - Open a new, blank db and save it to your desktop. Next, click File -- Get External Data -- Import. The open Dialog box will open - navigate to your shift bypass, protected .mde and select it. After you select it you will now see all of the objects contained in the db!!!!! (Note*...

sdebo2 - Your idea will work only if the application is left open all of the time (i.e. never shutdown and computer is never shut down) mohammad - What I assume your trying to do is set a control variable where even if the app is closed and reopened the last setting for the control will...

Charles - No, your db is in no way secure... Here's a scary/fun trick! Create a brand new, empty db. Go to File -- Import and navigate to your mde then import all of the tables and queries!!! Because its an mde you wont be able to get to the forms, marcos (no one but one person here really...