Recent content by pwbrown

So you wouldn't create a login details table? It would hold the login details for every type of user.

Damn computer crashed just as I was about to submit my reply message, can't remember what I wrote now. Anyway I'm designing the database now and I don't start creating a database until I have a good design for it. I don't even touch Access until I have a design ready to implement. I have...

A. I haven't had to make a database this complicated before so I'm not sure how to go about doing instances? Workers will first put in an application and a specific application will be chosen for each job. B + 1. I don't think they will be linked to a job. Just a place where people can...

Ok I get you now. I guess it's the same for job app link because you can't apply for a job if there isn't a job. I updated the new design and added a message table. Now a few questions I hope you could answer: 1. Would I only need one table for a messaging system? I guess I would and it could...

You see that's what I originally had but I didn't want lots of blank fields in a table. A client can leave feedback on a worker and vice versa but the feedback is different. One is a rating system and a message and the other just a message. Admin won't have most the data the other users have...

Hello, I’m looking for some advice on designing my database for an app I’m creating. Every time I do a design it looks wrong and I keep thinking there is a better way to go about it. I can’t tell you what the actual app is going to do but it’s similar to a user being able to post a job and...

Unfortunately I deleted the test program I created because I thought you weren't coming back after not responding. Anyway maybe someone else can help because I'm unsure on how to pass the past box used through. May need another function and use count in a query.

Solty did you get this issue sorted?

Lol, then you didn't do the serial function correct! I'm not sure how to do it myself, I'll have a quick look. p.s. when I say create a serial function, I'm talking about creating a module specific to your problem! Edit: Ok, created a function which works although I had to cheat to find the...

I tried it but it only halfed worked for me, maybe someone else can help you. Access is a pain for charts / graphs. It only wrote the name of three months on the graph although all were included. Also all the points were bunched together and hard to read!

Yes? You said you did the function to create the serial?

If you did that your done?

Ok if you must do it this way, I would create a function to create a serial number and use the function in a make table query to add a new column for the serial.

That's why I don't get it, why not only have one product per row? Then you can have a column for quantity?

I don't get why you would be doing this. Surely every row should have one autonumber (primary key) then you can have another column for quantity. For example: Autonum Product Quantity 1 Product 1 2 2 Product 2 1