Search results

Thanks for the advice and answers

I tried to put the allowedit = true part before the combobox selection and after the selection the allowedit = false part, this does not seem te work either(!)...

db uploading a stripped version of my db is of course possible, but all is in dutch... (except the VB Language and parts of the expressions of course :D ) I appreciate your help, i will first look further in the db (have to make other forms/parts in the db first and then i will come back to...

i have tried several options (<=, <, between); but it still results in information between the given parameters. Is there maybe something i overlooked? 1) comboxes name_from and name_till 2) query is available where in the fieldname the condition as mentioned is written 3) the report has his...

Sorry....made a mistake in my example... if the last one (name_till) is Daaa then the result will be Caaa...... So in my opinion, it seems that >= and <= acts like > and < (?)

I have a query where the following expression is used on one field name (in a form selected by two comboboxes named "name_from" and "name_till" >=[Forms]![Selection]![NAME_FROM] And <=[Forms]![Selection]![NAME_TILL] Suppose there are five names: Aaaa Baaa Caaa Daaa Eaaa and i select in the...

i have a little problem, at least, i think it is little. Within my access db form i have made a combobox for searching a number. When selected the applicable information will be shown in the detail part of the form. I made a button in the detail section, to allow people to change the...

Thaniks Thanks for the answer. I have done the following: (BTW i use Access2000) 1) mainform in design mode 2) selecting sub form 3) right mouse click, to properties 4) set Default View ==> single form 5) Views allowed ==> Form Then save the main- and subform Opening the mainform in form...

Thanks Thanks for the answers.... The IIf statement didn't work too properly, got an error first time that expression was to complex, so i indeed had to make a case statement, this worked fine, but Making the other table was something i had thought of, but i thought actually that it was not...

Hellow :( Question..... i have a report in access on which grades of student are shown, like the following example: Lifescience 6 Brainstorming 7 learningdev. 9 communication 5 My goal is to, next to the grades, also to put the grades as words... Lifescience 6 six Brainstorming 7...

See title :) I have seen that in some sample db's rightclicking the mouse showed the menu with an option to check or uncheck the dataview option, unchecked the formview was applied, but when i 'just' import the subform, i cannot find somewhere the possibility to change from dataview to...

uhm...?!? Sorry..am not that good with access to know how to write a passthrough query..but i will look for it and try to use it. Thanks for your answer!

varWhere = varWhere & "Booked_Date" Like """ & Me.txtBooked_Date & " * "" And "" I think the quotes (") in red are too much :)

:confused: Can anyone help me with this? I do not think it is quite possible, but you never know :confused: I have made a form, with no startup parameters. The form is opened with restrictions (at startup, i have unchecked all the checkboxes so that in fact users cannot do anything, allright...

Jacky, I am quite new too, but can you explain to me where the 'cursor' went after you clicked [ok] upon the error? Usually access visualize in the code (red) what part of the code is wrong. In most cases a sample code need to be rearrange before another person can use it

This is kind of old, but still needed in some cases. How to convert a reports thats made in crystal 7.x to crystal 8.x: 1) open the report in crystal reports 8 2) Then go to database-->verify database 3) Search for your db connection 4) The report is being checked/verified with the database 5)...

Thanks, Ik will try directly (turning to other screen).... as expression: =IIF(AllowEdits;"Edit";"Read") works....thanks for your help :) But i have another problem, the word "Write" only seem to appear 'after' i have edited the form?!?! hmm....go figure....?

Thanks to another thread (cannot remember exactly where i found it) http://mvps.org/access/queries/qry0003.htm describes the answer to your question

Hi KenHigg, 1) on the properties of the Form, the on current i have made the property AllowEdits --> false; (not-edible) 2) i put a button on the form [edit form] with an OnClick event (message "change form", vbYes and vbNo)\ 2a) on vbYes the allowedit will be true 2b) on vbNo the allowedit...

Hi, I have an access form which is edible for users; there is an only-read mode and a edit-mode. I want to put a textbox in the header of the form which changes depending on the allowedit function (if allow edit is true then "edit-mode" and if allow edit is false then "read-only"). I tried...