Help newbie sort out his DB

[fingersburnt]

Help newbie sort out his DB. still need help please

Hello all

Been looking at this forum for a few weeks and think it's great!!

Now for my first post

We have a DB at work (attached) and it was put together by a consultant would you believe. Anyway I have been given the task to fix this. It now work i.e. it records what I want. The only problem is that it's written with more macros than i've ever seen.

I want some advice on the DB to make it function better. It is used to record how long a member of staff spend on a piece of work, apologies for the interface.

1. The user must first input a date , start date and end date into a table. Now the start date will always be a Monday and the end date a Sunday. Is there anyway to automate that process? i.e if a user goes in on a Monday the prevous weeks date is there but if the user went in before it would not , get the idea.

Anyway, please rip it to shreads and give me some advice

Thanks

 

[mpb.vu2]

i couldn't even open the zip file!!

 

[Oldsoftboss]

i couldn't even open the zip file!!

Me either

 

[fingersburnt]

sorry, having trouble compressing DB to uploadable size.

try this

 

[carash77ash]

No that doesn't work either

Ash

 

[fingersburnt]

Think it's because it's large file well, 3 meg when not zipped.

You can d/l the file from here now

Database

 

[carash77ash]

OK downlowed ok.

Prob is it is password protected so still can't access it

Ash

 

[fingersburnt]

Sorry thought people would use the shift option to by-pass. Password is admin on all accounts.

Thanks for looking

 

[carash77ash]

before you try and fix the above prob you will need to tidy up the db.
forgive me i spent only a couple of minutes on it however there is a couple of things that need to be fixed.

Firstly i would convert all the macros to vb.

You also need to create relationships between the tables.

Run a performance check on DB and see if it suggest any other improvements.

Get the db optimised before you start fixing probs. You might find they are easier to fix if the db structure is better defined.

Hope this helps. Let me know how you go.

Ash

 

[fingersburnt]

Ash

Thanks for taking the time to look at it.

Converting the macros now, as I didn't know you could just convert them.

Can you help me with the tables of dates in my first post

Thanks again

Ian

 

[carash77ash]

will have a look.

on converting macros. Once converted you will need to go into each form that runs the macro and change the event from macro to the vb code that it has converted to.

Ash

 

[carash77ash]

you could create and expression for date field

iif([start date] = date() > 7,[start date], [start date] = dateadd ("d",7,[start date]))

this says if start date is greater than 7 days form today then do nothing else add 7 days to start date.

Is thiss what you where after.

Ash