Results 1 to 4 of 4
  1. #1
    Korei Khan is offline Novice
    Windows 8 Access 2013
    Join Date
    Oct 2015
    Posts
    10

    Paramter & Form Problems

    EDIT:



    Sigh, the form issue was fixed just found out that you can't edit a query that is connected to a form. Else, the form won't work anymore and you must delete the form, then re-create.

    Unfortunately, I for some reason can't link my database to the post. Basically my problem is as follows. Referencing the below image you will notice that I have square brackets around areas of the if conditionals. These are not within the table but made up fields similar to.... full name: [Table_First_Name] & [Table_Last_Name]. Thus, since I reference made-up fields such as full name I draw up a parameter query. I don't want a parameter query if I write something such as IF( [full name]="my name", "I am legend", "you are not legend")

    Click image for larger version. 

Name:	Capture.PNG 
Views:	9 
Size:	2.3 KB 
ID:	22487

    Any ideas?
    Last edited by Korei Khan; 10-24-2015 at 01:29 AM. Reason: Cause I can

  2. #2
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    I cannot download from that site (blocked) and home internet too weak/slow. If you can attach to post, I can download from that.

    I don't use dynamic parameterized query objects.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    Korei Khan is offline Novice
    Windows 8 Access 2013
    Join Date
    Oct 2015
    Posts
    10
    Never mind just realized that I could create a table off from the query and refer to this.

  4. #4
    June7's Avatar
    June7 is offline VIP
    Windows 7 64bit Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,815
    Actually, should be able to edit a query used by form. I do it all the time. I don't understand why you have to make a table to accomplish what you want. But then, don't fully understand what the issue is.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Dynamic Date Paramter Change?
    By aellistechsupport in forum Queries
    Replies: 27
    Last Post: 08-27-2015, 01:21 PM
  2. Replies: 3
    Last Post: 03-05-2015, 04:15 PM
  3. Replies: 3
    Last Post: 10-22-2014, 02:38 AM
  4. Two Sub-Form Problems
    By Keeper in forum Forms
    Replies: 11
    Last Post: 08-27-2012, 04:40 PM
  5. Replies: 1
    Last Post: 11-07-2010, 11:04 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums