Search results

Hi Beany, This should now work with the combo box's, Checks this is working and then get back to me with the Text18 issue. Garry

Click on the record selector of the subform and it will display that record in Text 20. Text 18 will show the count of the Records in the subform. Garry

Hi Beany, If you followed the suggestions I gave you at the beginning you would have it done by now...... Here is what you have asked for. Garry

What happens?

Amend the first part change it to "On Click" of the subform or the "On Click" event of each field in your subform instead of the "on Current"

Hi Beany, For the first part of your question. Delete the control source form TEXT20, and add this to the the "On Current" event procedure of you subform Forms![AssetMain]![Text20] = txtCountUser For the second part of your question, Put this into the Control Source of Text18...

My apologies, Me.Requery is the way to go, I must have been having a blonde moment. Garry

try me.refresh Garry

Hi TinTin, Just noticed that you are a Brumy Girl (Presume you’re a girl from your avatar) Where about in Birmingham are you from? I'm from Bromsgrove (not quite Brum but close) :) Anyway, where to start. Good question. Northwind DB that comes with Access is a good place to start. Open it up...

Bump. Ive got no answer for this one, Has anyone else got any experience with graphs who can help. Garry

Hi, For a test, what happens if you replace For intListRow = 0 To lboListCtl.ListCount - 1 with For intListRow = 0 To 10 just to see if it works then or still fails on No6 Garry

Hi Keith, One approach would be that after each entry into the subform of the players name do a "Dcount" of the subform. If this value is 4 then set the subform "allow addition" to No. Thus not allowing any more entries. Garry

Hi Tintin, Like most thing in life I find there are 2 ways to approach new thing. 1, jump straight in the deep end, learn by mistakes, trial and error etc etc Or 2, Plan what you want to do, research, research, research. It you want to go with approach no1, then start by making up tables...

Hi Donna, How are things? If you would like me to take a look, send your app across to me and i will see what i can do. Garry

Hi Jeff, When you say "the data is not refreshing the way it is supposed to be", what do you mean by this. Does it mean that you have to close the form displaying the info and then reopen it before it shows what you want? or The record being updated / changed does not show on other PCs until...

Hi Rene, I do believe that more can be learnt by battling your way through problems, learning by mistakes, trial and error etc etc However sometime it just needs a little example to view before the penny drops. I agree with you that if someone does the work for you then nothing is learnt. My...

Sorted!!!!! :)

Hi all, I need a little help with a wild card issue, Ive looked and looked and cant spot whats wrong. I have two forms "Requisitioner" & "Engineers", each form has a subform. These are basic search forms (unbound) that find related records in the subforms. The work is done in the query of the...

Ok, I think you missunderstood my reply to your post. Your report does not exist anywhere else other that inside your MS Access Application, unless you have saved it as a RTF file or something similar, but this would be a static report and would not show the latest info if any had changed...

Hi johnson34, In the "On Open" event property of the first form that opens when the Front End is opened, add code similar to this. DoCmd.OpenReport "Report Name", acViewNormal, "", "", acNormal The above code should print your report out. After that the Front end can be closed using...