Results 1 to 7 of 7
  1. #1
    doctor1010 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Nov 2017
    Posts
    3

    need help in a program that was built in access


    in my work theres a access program that they use with datebase here it is:
    Click image for larger version. 

Name:	example.jpg 
Views:	23 
Size:	92.0 KB 
ID:	31332
    now we want to change the amount of space or letters/numbers we put in the orange line and we tried to change it with the database file but it didnt change a thing probably beacuse they spreated the program from the database

    how i change the exe/proogram to add more lines to write?

    thank you very much for the help
    Last edited by doctor1010; 11-20-2017 at 05:19 AM.

  2. #2
    ssanfu is offline Master of Nothing
    Windows 7 32bit Access 2010 32bit
    Join Date
    Sep 2010
    Location
    Anchorage, Alaska, USA
    Posts
    9,664
    In the back end (BE) database, find the table the form is based on.
    Open the table in design view, find the field and, if it is a text field, increase the field size.

    Best I can suggest without having the dB.

    I'm guessing this could be Hebrew, and I only speak two languages - English and Bad English.

  3. #3
    doctor1010 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Nov 2017
    Posts
    3
    Quote Originally Posted by ssanfu View Post
    In the back end (BE) database, find the table the form is based on.
    Open the table in design view, find the field and, if it is a text field, increase the field size.

    Best I can suggest without having the dB.

    I'm guessing this could be Hebrew, and I only speak two languages - English and Bad English.
    thank you for quick replay we tried that but it changed nothing sadly its worried its only working on database but when we try to increase the field size it dosent change a thing in the maximum numbers/letters we can write in it

    the program is in hebrew yes you right but the data base and access are in english

    what we can do more to change it?

  4. #4
    Bob Fitz's Avatar
    Bob Fitz is offline Access Developer
    Windows 7 32bit Access 2013
    Join Date
    May 2011
    Location
    Essex UK
    Posts
    3,530
    Have you tried opening the form in design mode and checking for any setting of the controls Format property
    If this helped, please click the star at the bottom left of this posting and add to my reputation . Many thanks.
    Bob Fitzpatrick

  5. #5
    doctor1010 is offline Novice
    Windows 7 32bit Access 2007
    Join Date
    Nov 2017
    Posts
    3
    Quote Originally Posted by Bob Fitz View Post
    Have you tried opening the form in design mode and checking for any setting of the controls Format property
    tried to open the database in design mode checking the lines and changing filed size didnt change a thing we was thinking it might be wrong file but changing the database worked so we know its the right one.
    what else can we do ?
    theres no such a progreem to enter the exe file and change the filed size? or it must be the database file and it should work on it?

    beacuse i know the guy who made the program spreate database from it

  6. #6
    orange's Avatar
    orange is offline Moderator
    Windows 10 Access 2010 32bit
    Join Date
    Sep 2009
    Location
    Ottawa, Ontario, Canada; West Palm Beach FL
    Posts
    16,716
    For clarity, is your FE database accdb and NOT accde?

    We really need to see:
    -the record source of the Form
    -the control involved(properties)
    -the table/field involved in supplying values

    There is no exe file involved.

    Are you working with a copy of your database (FE and BE)? You should be!
    You should not be modifying your operational database until you understand the issue.

  7. #7
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    As others have suggested, check the following:
    1. Check first the table where that field from the form is kept and see if the length of the field is what is limiting the data and if so, increase it. You can go design mode on form and then look at data tab to see if it is a table or a query.
    2. Check the field itself(design mode of form). Check the properties for that field(Validation rule?, is there code in the control source)?
    3. Check the Events on the form and that field, maybe in the AfterUpdate of the field it is checking length and truncating. Maybe in the Beforeupdate of the form, it is doing same thing.

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

Similar Threads

  1. Replies: 7
    Last Post: 07-03-2017, 12:59 PM
  2. built in functions in access 2010
    By Jean S in forum Access
    Replies: 5
    Last Post: 12-05-2012, 11:22 PM
  3. one to one annomly or built in feature of access?
    By bbrazeau in forum Programming
    Replies: 4
    Last Post: 01-10-2012, 03:06 PM
  4. Program a 30-day trial into my Access Program?
    By genghiscomm in forum Programming
    Replies: 1
    Last Post: 05-26-2011, 02:14 PM
  5. Replies: 26
    Last Post: 09-27-2010, 09:48 PM

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