Search results

Correct, it is a school project. I hate the Access UI, so, may go ahead and do it in MySQL (I do know the theory, just the UI of Access is bad!) That's what I was talking about the calculations, I was going to calculate them on the end of the report / form, where needed (it will actually only...

According to the specification order sheet I've been given, each customer can only have one carpet per order (or at least, that's what it look's like, and what a Excel based system uses as a rule of thumb). I shall have a juggle with everything else, and see if I can build a form to enter all...

I seem to remember (but can't remember what it's called!) a way of converting alphabetical data, into numerical data. I can't remember what it's called, but I'll have a Google. Unless, you use each persons UID as their competitor number aswell?

Hi all, I've had a go at making a relational database with Access,with the table structure below, but, I seem to be missing something. In the following design, all of the primary keys in the tables lead to a 1-many relationship with their fields in other tables, with the 1 relationship being on...

I have followed this: http://www.access-programmers.co.uk/forums/showthread.php?t=108698&highlight=image to get images into a database / form. Now, we have the picture control in the report, and the path is sitting there in the table, but we need a way to link path to picture to picture frame...

That looks like half the solution. Two features that are kinda missing for us: The picture insert form must go in with other data-types (we can build that), but it must create a new record. Also, the picture must be printed as a picture in reports (we have to print off pictures for an id card)...

We are trying to create a database where by a user can insert a picture into the database, either as a link or in an actual file in the database. The user must then insert these with a browse button (like uploading online), kinda concept (must be easy). We looked into OLE objects, and...