Go Back   Access World Forums > Members List

 
plog is a jewel in the rough plog is a jewel in the rough plog is a jewel in the rough

plog plog is offline

AWF VIP

Visitor Messages

Showing Visitor Messages 1 to 5 of 5
  1. ka3pmw
    12-13-2015 08:20 AM
    ka3pmw
    It DIED!
    All of a sudden all of the drop down fields in the Look Up won't stay updated when I change them. Any ideas?
    I have tried making changes to the Roster table, where the data comes from and the form.
  2. Mahendra
    06-23-2015 12:18 PM
    Mahendra
    Dear Mr. Plog

    Could you kindly help me out to my request in the below thread

    http://www.access-programmers.co.uk/...d.php?t=278546

    To be genuine am an novice to MS Access and I work in another domain of database. The person who did it is in a long vacation and I have been assigned to this changes.

    I don't know how to build queries with calculated fields. Please assist me

    A demo of sample sheet with 3 examples with Start Date, End Date, Quarter, Month and Year fields would be more helpful.. please
  3. plog
    02-15-2013 06:24 AM
    plog
    If you have an existing query, you simply right click its name, select 'copy', then right click again on top of it and select 'Paste'. If that won't work, you can open the query in SQL design view (the one with nothing but code), copy all the code, create a new query, go into SQL design view on it and paste the code there.
  4. im4gltr
    02-14-2013 07:53 PM
    im4gltr
    Hi, Plog. Some how I found a post in the query thread where you answered on how to create a new query from an existing one. Now of course I can't find it again and I wanted to ask you about the 'copy and paste' option you detailed in your answer. You speak to 'copy the existing query and then paste it giving it a new name, open that new query......' but for the life of me I can't find where to paste it. I also get an error that Access can get the data off of the clipboard and the query is itty bitty---Just one criteria. Think you can help me? Thanking you in advance, IM4GLTR
  5. Ramshan
    10-11-2011 12:27 PM
    Ramshan
    Hey Plog help me if u could please. I have one problem in querying,
    Here it is,
    In my query form I have a field called County, its a combo box and it contain the several values like Adair, alfalfa etc. so the user will be selecting one of this value to perform query operations. But here comes the problem, in the table where these values are stored they are stored in the number format, for example Adair = 109, Alfalfa = 126 etc.
    So if I select Adair while performing query operation, it will go and check for the value "Adair" in County field and its throwing an error since the value is stored in number format. So I am struck with this. can you please help me on this. Thanks in advance.

Statistics

Total Posts
Visitor Messages
Total Thanks
General Information
  • Last Activity: Today 03:33 PM
  • Join Date: 05-11-2011
  • Referrals: 0



All times are GMT -8. The time now is 04:40 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Sponsored Links

How to advertise

Media Kit


Powered by vBulletin®
Copyright ©2000 - 2017, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World