cannot (1 Viewer)

Laega

New member
Local time
Today, 03:58
Joined
Apr 29, 2020
Messages
10
after compact/repair and put in zip file it still not fits to attached file here. can someone know how to convert or save as Access 2002-2003 database from Access 2013 database?
 

Attachments

  • cannot.PNG
    cannot.PNG
    9.7 KB · Views: 89

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 19:58
Joined
Oct 29, 2018
Messages
21,453
Hi. If you have any images in the db, try removing some or all of them out.
 

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 19:58
Joined
Aug 30, 2003
Messages
36,124
How big is the zip file? I think up to 5MB is allowed, which the process you described normally achieves. Converting to an earlier version wouldn't likely change anything.
 

Laega

New member
Local time
Today, 03:58
Joined
Apr 29, 2020
Messages
10
the zip file is 1380 kb. i will try remove all images in it try check if its ok
 

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 19:58
Joined
Aug 30, 2003
Messages
36,124
I would expect that to fit either way, as I'm fairly sure Jon said he allowed attachments up to 5MB. Does the site give you an error?
 

Laega

New member
Local time
Today, 03:58
Joined
Apr 29, 2020
Messages
10
oh..correct its work now. thanks pbaldy. yes i received error previously it. any way the problem is how to sum total there please see.
 

Attachments

  • zip file.zip
    1.3 MB · Views: 87

pbaldy

Wino Moderator
Staff member
Local time
Yesterday, 19:58
Joined
Aug 30, 2003
Messages
36,124
The zip appears to contain an rar file, which I don't have the software to unzip. I'm sure others do so I'll get out of the way.
 

Laega

New member
Local time
Today, 03:58
Joined
Apr 29, 2020
Messages
10
ok rar file is removed now. see attached thanks.
 

Attachments

  • no rar file.zip
    1.4 MB · Views: 86

The_Doc_Man

Immoderate Moderator
Staff member
Local time
Yesterday, 21:58
Joined
Feb 28, 2001
Messages
27,139
Now that we have your zip file, what is the problem you are trying to solve?

Try to be descriptive if possible. I would guess that English is not your first language, but do your best. What are you trying to do and what is happening (or not happening) that causes you to come here?
 

Laega

New member
Local time
Today, 03:58
Joined
Apr 29, 2020
Messages
10
Please see screen shot. Thanks.
 

Attachments

  • sum.PNG
    sum.PNG
    116.1 KB · Views: 82

MajP

You've got your good things, and you've got mine.
Local time
Yesterday, 22:58
Joined
May 21, 2018
Messages
8,525
I fixed it the best I could, but you have a lot of significant problems.
1. Table naming convention is poor. Do not use spaces in any names (table or field or any other object)
2. Table names should be representative of the items that are contained.
3. Table design is wrong. Do not repeat data in multiple tables.
4. Do not store calculated fields in a table
5. Use queries to bring in related data
6. Give controls real names not "Text5" but "txtBxItemID" or "cmboItemName"
7. Do calculations in queries.
 

Attachments

  • MajP_CashRegister.accdb
    2.4 MB · Views: 88

Laega

New member
Local time
Today, 03:58
Joined
Apr 29, 2020
Messages
10
I fixed it the best I could, but you have a lot of significant problems.
1. Table naming convention is poor. Do not use spaces in any names (table or field or any other object)
2. Table names should be representative of the items that are contained.
3. Table design is wrong. Do not repeat data in multiple tables.
4. Do not store calculated fields in a table
5. Use queries to bring in related data
6. Give controls real names not "Text5" but "txtBxItemID" or "cmboItemName"
7. Do calculations in queries.

Thank you very much for help and advice. I am so happy.
 

Users who are viewing this thread

Top Bottom