Search results

Okay here is a sample of the form and related tables. Edit: Before I started this project I didn't know a lot about Access/VBA so please ignore the poor commenting/naming/sloppy code etc etc :(( Regards,

Yeah I understand. I have gone over the code and the settings I just cannot seem to find anything. The boxes are not set to locked and there is no code that sets them to locked. I am at a miss with it.

Check the post out on the thread I made: Use VBA to do that and then a me.requery to update it with the on current event. (or when ever you want it to update). Don't use the control source of the text box for dcount.

I have a form with text boxes (I'm great I know) However they are often locking up (cannot get focus and type in them), it seems if i click on some other text boxes then click back in the locked up one it lets me in... not sure what the issue is. Any idea what it could be? It does not happen...

Your paying? ;)

I figured it out: Date() - WeekDay(Date()) + 1 Thanks,

Can anyone help me find the date the Monday of the current would be? I can find the date using.... well date(), but then how would I find the date of monday from this week? Many thanks for any responses Regards,

Don't worry, I am still a beginner myself however this site has been a great help. Glad I could give a little back. Now I am sure there is a method to set the value of combo box to an item in the list, but im not sure of it. You could try though: Combobox1.value = "*" Combobox2.value = "*"...

That worked a treat! Thank you very much. (a lot faster than using the control source also even when it did work :)

Hehe, I posted this topic about an hour ago when the forum was playing up (timing out and going slow) Maybe this caused a glitch in the Matrix!! anyway I will retype it: I just wanted to know, as lots of friendly experts post on here, if anybody knew of any good tutorials on graphic design...

The query should be pointed to the form control and should not prompt the user for information. If it does then the criteria is not set correctly, double check for a simple spelling mistake. Just to double check, when I said =[Forms]![FormName]![ControlName] you have to replace the FormName...

One way I would go about this is... Changing the record source of the form to be based on a query which has the same fields as the table. In the query under each field that need to be filtered change the criteria to point to the combo box on the form, ie: =[Forms]![FormName]![ControlName]...

Hello, I am having the same problem. Please see my thread for the specifics: http://www.access-programmers.co.uk/forums/showthread.php?t=178917 Now when I use the exact same database at home I do not have the issue. I feel it must be an issue with the version of Access I have at work. As a...

Hello, I have a series of text boxes on a form with the expressions like this: =DCount("[UID]","[qTesting]","[Test Subject]='Numeracy' And [Test Level]='Entry Level' and [Passed]=Yes") So the role of the text box is to, check the query for Numeracy tests at Entry Level that have been passed...

It should be xxxx.requery

Hello I have a report based on a Query. I want the criteria be based on two text/combo boxes that allow the user to select the month and year. So the if the user selected January and 2009 I want the query to show entries for that month only. Any tips? Many thanks!

Adding a record to a table (updated) Okay here is the issue: I have 3 tables linked as shown in attachment rel1. Now I have a form to add a new test, the form is linked to a query which has both the test table and client table. The learner can enter details on the test using the form. There...

Hello, Okay scratch that, I going to explain it differently below. Kind Regards,

Got it, thanks!!!

Okay I solved this, what I did: I created 3 queries with all the fields on the sub form. Each having the correct criteria on the test score field: >0.74, <0.75 etc then on the after_update event on the option frame I switched the recordsource between the queries and then requeried, works...