Search results

I want field for two purpose 1 ) when it is new record it should be filled up with VBA and once it saved and when I opening same record it should show me existing ID which was created when I had created the record initially using function.

what if it is new record and from combobox I am selecting existing value and I want to populate same field with existing record ID

Hello I have one field called digitalID which is i am generating using Max function in VBA when New record is being created and i set that field to plain text to implement is that now I am saving the record so it got saved with 64 as it was the latest record or insertion point where I can...

Hi thanks for your reply now my query is that I want to generate the ID number from the above function code it is working fine but that works for me for new record is there in case of existing record how to implement changes control source changes to the field of query which retrives records of...

Hello I have one field who creates ID ( autonumber field ) which has datasource to the query field autonumber in the table as well. When we create new record it creates new id for example '45' , and we went away with form and decided not to save when we come to next time and create new...

I am trying to refer combox values in expression builder it gives me ID value instead of actual value it is holding , Can you please tell me what is wrong here ?

Thanks Minty, I would like to create a computed field which would do calculaton based on above two field what kind of field I have to create ? May be like this Field1 - field 2 result of this would be displayed in one of the field.

Hello How to create a number field on form which would accept only numberic value ? Thanks

In my query, I have parameter from specific form, and that query is binded to a report, now I want to use same report but with different form as input then what is specified in report bound query.. how still I can use same report with different form input.. or I can copy those query anf report...

I am not sure if I understood your reply correctly.

Hello I am opening one query based on button click event. Now query takes parameters and first and last date and customer code so I have it on form. Now I have also All option on my form which should display all records from query in datasheet view despite of the criteria given in form and in...

hello I would like to print current set of record which is display in form but want to use existing report which in turns uses query which is taking form input for query filtering. Now how do I can take same report reference keeping in mind i may have different parameters this time as I have...

Hello Can anybody help me what precaution has to be taken if application is multiuser application ? Thanks DDK

I did not get you what is meaning of search form here ? do you mean date input form ? if so in that case query will take input from date input form ?

I dont want to open query I want to open report, the query is associated with report which takes date as input criteria.

My question is that earlier in crietria was like below. [Enter Date MM/DD/YYYY] : now customer now wants date picker instead of just input box, so i created form with date picker and put in the query criteria as below. [Forms]![FrmDateInput].[txtdateDlvrmmreport] this query is associated with...

Yes I am clicking on run query directly to make form open, am I doing something wrong ?

I am putting in query criteria : [Forms]![FrmDateInput].[txtdateDlvrmmreport] instead of opening that form it inputs input box as attached image..

Rather I would have said it should be input box because it is coming from query criteria.. I need to have date picker instead. As that is handy to choose date , so I think in query criteria I can not put such thing, do I have to create form modal window with date picker field, please help here...

this is in query criteria, how we can format there ? you mean to say create a contron on form and format it ?