Search results

You are welcome Fruit, (whatever your name - look like Pakistani ;)) my pleasure your problem solved. Sorry for late reply, I was bit busy in home as I on my annual vacation to my homeland :) Best Regards,

Lot of update Insert and Select queries. the form itself have lot of IIF conditions on each field. i.e =IIf([Forms]![frmDiaryMultiView]![chTreatment],[Item1],[Client1]) the double click event has missing reference Id to a form DoCmd.OpenForm "frmNewAppointment", , , "OrderID = " &...

no problem Paul Eugin. its more important that someone got help. i am glad you gave answer.

ahhhhhh great you have sorted out. Paul Eugin gave you the answer ;p

It will display only the current record on Report, because each row will show its data on the Report. you need some effort to correct your Query for desire result, then call the calculated field on the report. suppose if you want to show more than a one field on a Report then: you can...

You can create a TextBox control and bound it to your Desired Query Field. OR just drag and drop the underlined Query/Table's Field to your Report. After that change the format of the required field to MMMM/YYYY.

creat!ve you have done already to find duplicate records using sub-query: Now you can Run it by clicking a Command Button click event: (powerful and flexible action) Docmd.OpenQuery"criteria 1" OR By Clicking a command button Click Macro action (default click method of command button by...

I am using Access since 1998. Great & Congrate Access to its 20th anniversary!!! Access V Love You!

Goto 1 goto 2 goto 3... if if if if if if...... the first time I see this code in my life... so I will go AFTER Update, After Update.... :D

Hi, which version of Access you are using? is it Access-2010? In Access-2010, the maximum 80000 (don't remember the exact number) rows can be copied & paste in one go. astonishing.

Ok! I have written the code on command button click event just for testing to get the desire result. The same can be used on open REPORT event with just minor changes. First of all understand the code: 'Declare Varialbles to get the open recordset Dim rs As DAO.Recordset ' declare Recordset...

Is your data is normalized properly? There should be separate table for subjects and all subjects should have their IDs which can be referred in Students records for grouping them together for each subject.

One better way is to use Select Case Statement. Where you can use Cases instead of so many IF statements. another way is to consider a command button click on a form which will fire a code for all the calculation. A function which will iterate through all the 18 Loss Ratio fields and will...

Welcome to AWF, Always post your queries in a right panel. for example in Introducing yourself you can introduce yourself, in Query you can post a question related to queries, Report for reporting. Tables for tables and so on. Can you explain your queries further more what data you want to...

Great you figure it out. corrupted records are always a headache in Access, I fought with them many times, they effect queries a lot, effecting report printing, effecting data processing and cause network problems.

Re: Try... lagbolt gave you good answer, in my post I use trim function on org_Name field not on facult field in a query... my miss understanding

Re: Try... lagbolt gave you perfect solution. In my post it will remove spaces from org_Name not from facult field as I call the trim function on org_Name field in a query.

Deleting Key ID Autonumber is not always a recommended idea, doing so will lead to BIG MESS of records integrity when ID is used as a Primary & Foreign Key constraint in related tables (Relationship with same IDs to other tables). If you do so you will regenerate all the IDs Autonumbers...

The following code produce exactly what you need; Private Sub Command2_Click() Dim rs As DAO.Recordset Dim db As DAO.Database Dim strSQL As String Dim conField As String Dim conField1 As String strSQL = "Select fruitName FROM fruit" Set db = CurrentDb Set rs = db.OpenRecordset(strSQL) Do...

Hmmmmmm, Its possible, you need some VBA coding which iterate through the record in the same field and concatenate each record to a string variable separated by comma ;) then call that variable on report unbound control.