Search results

1-First of all...you have to determine the size (number of fields) and already did with the wizard.. so.. remember the first column takes the index 0 then 1 etc...ok 2-to fill a textbox from a combobox, you should use the .Column(Index) property.. example: Private Sub Combo1_AfterUpdate()...

1- I suggest you check your query to be the datasource of that subform then write the controls "combo boxes" names as "Forms![FormName]![ControlName] in the criteria section under each of the fields as Or statment.. and open the form, it will be showing no data until you fill in on or tow of...

GooD morning, yes it's very clear you need to send a filter of your data from the form along with the report name in the DoCmd.OpenReport command... As I see in your Pic: To show all records.. sipmly...and for example report name is "StdRept" DoCmd.OpenReport "StdRept", acPreview But to open...

Forms.frmContributionReceipts.SentLetters = strDoc IF THIS IS AN EXTERNAL i mean different and you pass values from a variable in public code or another form it's preferred to use this ".form" adding it before the control' s name... Forms.frmContributionReceipts.Form.SentLetters = strDoc

maybe the query is not updatable or... the .Value property is used to display the current stat of the Checkbox not change it. so you need first to check if you used the Yes/No field to "True/False" not leav it as Yes/No ... then check your query...

is this like,,, questions and answer option,,?? you mean:choose question1 for example, checks automaticly the check boxes associated with it...?? or what?

an idea,,, Add a field to the Authority table call it 'Selected" and its Yes/No in the after update event of the combo ... make an update SQL to set the selected field to yes where the authory is the combo choosen.. now re fill the combo box with an SQL select statement such that it excludes the...

For hiding a column in a datasheet form try this link,,, http://www.access-programmers.co.uk/forums/showthread.php?t=176979&highlight=hide+column that's what i understnd you are tryin to do..

yes a little,,, but my question was... if you d the calcilating of the (Fours) at one time.. i mean if you wan the result to display the sums of these (fours) groups at one time or the first, then the second or that you select... coz if at one time, you need to reconstruct the tables into 1-...

here is the question: do u sum the groups of four records all at one time or only group by gtoup! that's what i didn't get! sorry!

but Dcount() can be helpful if we have a table or query stored as a view.. not just a selection of unknown count records and non-name query... this lead me to do so: creat a form that takes its RecordSource from the SQL statement of the query talking about.. use the...

you are wellcme! glad to help

in the first place you should use a variable that stores the count of the records that match the date criteria, b4 even being apended, but how! use the forms ...as you usng macros to run simultaneous queries, use a line of one macro to open a form with and pass the count to it then use the same...

You mean the CrossTab query

You sould use the same Year() Function for the query field not only in the criteria, coz eles you will be requesting years to match full dates... So: in the Where Condition it should be: Where Year([MYQryfield] = Year([MyFormField]) regards...

the insert into SQL as I tried shoud be fisrt tested in an append query with the parameters you have,, execute it,, if it's ok, open the SQL view of the query.. copy the code and past it as string in your command.. other cases why it fails, you may misplaced a qoute "" or a single qoute ' ...

Ok.. Can you change all that for me and contribute to the solution of this no-problem...do it it's ok as you see it very mysterious thing to handle the codes and controls in this way! Do what you see better and thanks alot... THAT WAS my fault in the first place coz I lead some of you to the...

the noertwind sample "specially 2003" will help you very much.. go to the employees form.. open the code and see how you can add/change the photo by browsing the folder,, you can alter the code in the module to handle the files type you want,,, me,,, i use chooseFile() i used it for storing the...

sory, i thoughtputting the link would let you readcarfuly how the code should b writen and what the sysnax should be... any way thank for larson & scootburg for their contribution

i think you need to do this by the activeX or the advanced tool box