Search results

This may be helpful: http://databaseanswers.org/data_models/visits_to_church_food_pantry/index.htm There are commercially available applications for this. just a few examples: Desktop: https://www.pantrysoft.com/ Web Based: http://www.foodbankmanager.com/

Ah ... the errors are coming from Classic ASP page(s). Is the database still int he older JET4 (.mdb) format? When as the last time you backed up the database then ran a compact/repair? I would suggest doing that is yu have not tried it. It is alway good to do a backup first since yu are...

What is the frontend created with? Mu guess would be not Access since you are detting on ODBC error. If an Access front end, What version of Acess are you running? Are you linking the tables using the ODBC Driver not directly?

Steve, I find that having the Database Engine Enforce Referential Integrity to be very important. As MarkK pointed out, this is set when you define the relationship.

I totally agree. Why do something that is guaranteed to be a never ending source of issues and a support headaches.nightmare. Ask yourself: Does this really make the application better for the end users? Do the end users really care? If the answer to either is NO then you probably should...

Is the database set to use Tabbed documents? You will find the setting in Acess Options > Current Database

Are you asking about comparing the database design? Like tabel names, field names, etc? If yes, have you looked a the built-in database documenter? Also check oot: http://www.fmsinc.com/microsoftaccess/bestpractices.html http://www.accessmvp.com/Strive4Peace/Analyzer.htm

John, I'll throw in my 2 cents. It is based on my experience since 1985 developing 100+ Accounting system, websites using ASP-ASP.NET/PHP/JAVA, etc and training programmer who are switching to OOP. Very little of your current Access knowledge will translate well to ASP.NET and MVC and OOP...

The way I do it is either write the data to a text file (.txt or .ini) or to an Access table. Then the other application can read it data. Curious, Why do you need Access VBA to create the folder? Did you now that Outlook VBA code can read and write to an Access database?

TIP: F4 is the shortcut toggle open/close of the combo box's drop down list. TIP2: Use the "On Enter" event to automatically drop down the menu using the this: Me.ComboBoxControlName.Dropdown

Using static's suggestion of loading the image list into a listbox would allow you to bind an image control to the listbox. The user could click on am item in the listbox to show it. The reason I suggested a table was it give you more flexibility. The table can be used as the rowsource for the...

The built-in Access Image control require the exat path to a single image. It is not able to display multiple images. Which is why yu can use a wildcard. What I do in may my applications is use VBA code to read the file names from the directory. I add them to a temp/work tbale that has a field...

Aaron, You're welcome. Glad we could assist.

I have not looked at your database in your attachment. I did look at the image. It has what is called Harvey Balls for the symbols. There is a free font for Harvey Balls. Get it here: http://www.ambor.com/public/hb/harveyballs.html I uses it for the numbers 0 (empty circled) to 4 (all four...

I agree with plog about the flights and that it is not properly normalized. A flight is a single ticket with a single flight number. You want only one record per flight (flight number/ticket). It may take several flights (flight numbers/tickets) to get to your destination. If you have multiple...

I agree with plog that this can all be done with just queries (SQL). TIP: When you are in the query designer, you can add a (saved) select query and use it just like you would a table! You can even use the Unmatched query wizard to create this by selecting a table and the saved query...

That is not what I was recommending. My bad. You are probably not familiar with Microsoft SQL Server. I am suggesting that you add an additional field that is the timestamp. Not as a replacement of the autonumber field. It would be in addition to the autonumber field. You would have...

IMHO, you are not using the autonumber data type properly. To keep the order items cam in add a "TimeStamp" field of datatype data/time with a default value of Now(). .

You definitely need to compact often. If compacting is causing an issue then that usually indicates there is a flaw or bug in your design. I think you "bug" is that in your append query includes the autonumber field from your first table. If the table you are appending to already has an...

Change then to INT to be compatible with Access.