Search results

John - Unfortunitely Access does not allow you to update an ActiveX Progress bar with query processing as when the query is running provides no feedback (another stellar feature :mad: )... so the only way you can tell the progress is by looking at the status progress bar located at the lower...

Spikey - Jus so you know in Ken's example above the "2" is another way of saying "cancel"... the line could also be written like this: if MsgBox("Zijn alle verplichte velden ingevoerd?", vbOKCancel) = vbCancel Then .... HTH, Kev

you know you don't have to use an .adp to link to a server db right?!? just wanted to double check as this is a pretty common misconception - to use an mde or mdb link the tables in the FE to the tables in the BE... Also - in case your not familiar with .adp files BE CAREFULL as changes in the...

First - If your going to be saving this information then you need to create a new table with a many to one relationship with the primary table (one with the values for this list) and instead of a listbox use a subform... Adding multiple values to a single field is not normalized data structure...

Peter - A better way to do this (more effecient that is) would be to base the form on a query and in the Customer Number field in the query put this in the criteria section: = Forms!frmAddBill!CustomerNumber Then all you have to do is have the form open the other form which will open based on...

;) I'm sure I'll get struck down by some here but the thruth is that sometimes Access isn't the "one stop solution" many proclaim it to be... Furthermore - although I've only been developing apps in VB.NET for a short time now (and very much still a beginner in that medium) I have never had a...

see gHudsons post in this thread: http://www.access-programmers.co.uk/forums/showthread.php?t=66511&highlight=kick+users HTH, Kev

where is mission2java when I need him! I'm beginning to be a convert to his principle that Access is not a very good IDE... :mad: Good RAD tool yes... good long-term development environment...? Sorry Becca for the unfortunite happenings... now might be a good time to pick up a VB or VB.NET...

Becca - Unfortunitely I must say you have just been Baptized into the world of Access... Its pretty common for Access to give you the "An error has occured and Access is about to shut down" type message that doesn't allow you to save and simple leaves you high and dry. Your problem, although it...

Now that is funny! :p :D Thanks for making me chuckle at the end of a long day Doc... good points too! Kev

kdm - Use the Len() function... HTH, Kev

You could use an adp for the FE in and connect to a large RDBMS but I still wouldn't use access for 200 user ADP - use a VB/VB.NET/C/C++/C# FE for this... Some may differ on my suggestion here but unless you are extremely versed in Access (i.e. know its shortcomings and how to set it up to...

DO NOT USE ACCESS FOR THIS!!!! your going to have to use a larger RDBMS like SQL Server, Oracle, DB2, etc... HTH, Kev

The best way would probably involve using a Windows Scheduled Task to run the report.... Kev

fenhow - See the attached sample db I posted in a thread here HTH, Kev

This is happening because your storing your number fields as a text datatype so Access sees this two strings to concatenate together - not two numbers to add together. To resolve this either change the fields datatypes to numbers and use the same equation you were using or use the val function...

If you want to use it in more then one form then save the code in a module and reference the variables when you call the function from the different forms like : (example in Module) Public Sub EXAMPLE(strFormName as String) etc... . . . End Sub (example in Form) Private Sub Button_On_Click...

Alex - Not trying to move people away from this site (sorry Jon) but in the interest of helping others if you go to the UtterAccess Site (www.utteraccess.com) and search for "Diary" or "Access Diary" one of the members there has posted a complete Diary Application for free for others to...

Igor - The cause for this (I believe) is that when in preview mode Access will only open one report in preview at a time so, basically, the first opened previewed report breaks the loop as it waits for your input on what to do... sorry if this is what you wanted in the first place but you said...

Igor - I don't have time to put together a sample right now as I'm going into a meeting in about 5 minutes but I'll put something together for ya later if your still having trouble... Put an unbound field on your form and call it txtReportHidden. Make the field invisible. On the report...