Hendra- Note that there's no parameter for the Maximize command. When you Maximize, it applies to every normal form or report open in the workspace. The only...
Thank You John,...your explanation really help me... About Open Dialog, ...is there any effect to application or to computer if we open a form in dialog mode...
Hendra- No. But the user won't be able to click anywhere else but the dialog form (within Access). John Viescas, author Microsoft Office Access 2010 Inside...
Hi All,... How can we open our application in Full Screen on Computer?(Not the same with DoCmd.Maximize), i mean really full screen on computer without menu ...
John, upon further research I believe the answer is yes. I will adjust the code and give it a try. Is this the place I should also put the code to prevent the...
Hendra- I think it's possible to run Access minimized and open popup forms that would have to be custom sized to fit the entire screen. It might involve...
Bill- Yes, you would use your error trap to test the Err value for duplicate value and handle accordingly. John Viescas, author Microsoft Office Access 2010...
Thanx John... No,..i got an order to make information display to public/guess/visitor in an office (like flight schedules in airport), it will use a big screen...
John, Well I have moved from one error to another. I think that is progress. I am now getting Error 3067, Query input must contain at least one Table. I...
Bill, The lightening seems to have let up on this side of town. This is one of the main reasons while us veterans typically create a strSQL to store the SQL...
Hendra- Make your form PopUp = Yes and design it's size to more or less fill the screen of the machine on which you will be running. Set AutoCenter to Yes,...
Duane, Now the Immediate window is active. That is nice. Thank you for the tip. I was reading up on the things you can do in the Immediate window. It now shows...
Bill- Once you get strSQL in the IW, you can copy and paste it into the SQL View of a new query. Switch to Design View to find any anomalies. John Viescas,...
Viewing the SQL statement in the debug/immediate window might be enough to determine the issue with your syntax. If not, copy the statement to your clipboard,...
Hi, I would appreciate any assistance with a report that is based on input from the user. For example, I would like the user to be able to select any or all...
Toukey- If these are three separate reports, use code triggered either by After Update of the selection or a command button to look at the choice and open the ...
Toukey- What's the difference between the reports? A filter? John Viescas, author Microsoft Office Access 2010 Inside Out Microsoft Office Access 2007 Inside...
Toukey- You guess? You didn't tell me what's the difference. What do you want to see when Insurer or Claim Status or Type Of Claim is selected? John Viescas,...
ok John. Let me see how best I can explain this. The report comprises of the following fields: date of loss, insured name, type of loss, comments, claim...
Toukey- OK, the light goes on! Yes, you want a dynamic filter. For a simple single selection (not multiple insurers or multiple claim statuses), you need...
Duane/John An exercise in Frustration. I have learned some great tricks but it still is very frustrating. I believe I found the missing spaces. I followed the...
Duane, Even though I am still currently struggling with the first SQL statement I have another question for down the road. My plan is to eventually run three...
If I have multiple action queries to run in on section of code, I will create a separate strSQL for each like: Dim strSQLAppNew as String, strSQLUpdExisting as...
