Search results

Ok heres what I have now: So now when a candidate is assigned to a job a record is created in M_CandidatePostDetails. It has info specific to that particular candidate and job. The currentlyAssigned field is a boolean field so we know if they are currently employed or not. That way I can show...

Thanks for posting back Neileg. Its great being able to get other peoples view on it. I have just checked and there doesn't really seem to be any such thing as a standard pay for a post. It varies so much from site to site. Even within a site or project two people doing the same job can be paid...

Ok I've changed it a bit to represent the ideas of having candidates and posts a bit better. I think that the data I had in M_CandidateJobDetails belongs in the M_Candidates table It was supposed to be a sort of junction table between candidate and post but I think that that is unnecessary as...

It doesn't matter about deleting everything in your work table as its just a temporary table. -You import from the CSV file into temporary work table -clean it up as FoFa says -run an APPEND query to add new products to your main table where you store product info -run an UPDATE query to...

Thanks for that Neil, Maybe my table naming is not the best - the M_JobClassifaction table is the table that holds post information. There is a one-to-many relationship between the post and the candidate. Your suggestion about linking the pay info to the post rather than the individual sounds...

Thank you so much fo that DocMan. I'm just going to spend some time seeing how I can apply what you've said to my database. I the meantime here are the relationships as they are at the moment:

Hi, I would like to get your advice on my table setup and relationships for this payroll project. The company is an engineering company with Projects (or construction sites) around the world. The 'Candidates' are current or potential employees and contractors. There are three main pay...

Thanks so much for the detailed reply ByteMyzer. I would need to use the multi user version all right - as I mentioned there will be 7 tables of components altogether (spools, valves, instruments, cables etc.) Users will be importing much of the information from excel sheets as well as entering...

Ok, Bacically I have 2 different lists (well there will be 7 in total): tblValves ValveID KKS_no Description List - specifies thats its in the valves list TOP_Code tblSpools (pipe sections) SpoolID SpoolTagNo Description List - specifies thats its in the spools list TOP_Code The reason that I...

Thanks again Keith. Didn't realise there was a DCount function. That will come in useful. I just had another idea though. I could do a query to update the vendor table with the title from the main table where there is only one matching record. I think that that will be the faster than having...

Hi, I've realised that there is another issue with this. What I'm trying to do now is show the title from the main table if there is only one matching record in the vendor table. (The title in the main table tblDrawingRegister is the more official one and they can vary slightly). Otherwise...

Thanks for the reply KeithG. I did try using IIf but was definitely making it more complicated than necessary. Got it working in the end: DrawingTitle: IIf(IsNull([VDrawingTitle]=True),[DrawingName],[VDrawingTitle]) So if the vendor drawing title is null (i.e.) there is no corresponding vendor...

There are 3 main tables tblDrawingRegister - stores information about construction drawings tblDrawing Revisions - each drawing in tblDrawingRegister has one or more revision or version tblVendorDrawingList - this table has a list of drawings numbers that correspond to the drawings in...

Kieth if you just read the answers that were given to you already you will find an explanation of why you get those messages on your work PC but not your home PC. As Laurentech and I both suggeted you can go to Tools/Macro/Security and set it to low Obviously this the macro security is set to...

if you are only returning one field in your query you could use the DISTINCT keyword in sql e.g. SELECT DISTINCT fieldname FROM tablename Can you give more details on what you are trying to do?

Why do you need to access one database from another? If people need to use 2 or 3 databases maybe it would make sense to have all the forms/queries in one database. It doesn't matter where the tables are because you could have links to the necessary tables in the different databases. Otherwise...

I don't know the answer to your question but having set up security for a few databases and read alot about it on these forums I do know that you should not have anyone join your workgroup permenantly. You should use shortcuts. You should rejoin the original unaltered system.mdw and put a...

I think that Kieth is talking about the unsafe expression warnings etc when you open the database. Not anything to do with running any queries so I don't think turning warnings off in VB would make a difference. So as Laurentech suggeted you can go to Tools/Macro/Security and set it to low or...

The easiest way to do it is to secure it first using user level security and then split it. That way when you split it both the backend and front end will have the same security and you only have to do it once. Splitting it is quite easy. You just have your tables in one database (the backend)...

This site has a good tutorial about corruption: http://www.everythingaccess.com/tutorials.asp?ID=Access-Database-Corruption-Repair-Guide