Search results

thanks for your reply, i have started very briefly to put this together, but am a little lost at how i am going to display each section within the table.... for example in section 1 i have the following Question : it is split into a number of sections the Actual question 1)...

my company currently use a measurement system designed in access, by someone who has now left the company. i have been tasked with rewriting it, and believe me it needs it. however i was thinking of trying something a little different, but with my limited knowledge dunno how big a task it is...

i need to construct a database to store info for the appraisal system which is going to start at our company in the near future... but am not too sure how to go about this looking at the form i have attached. i think that i should have a table full of the employee's details and also a table of...

I need an example of a DFD level 0 and 1 for A HELPDESK can anybody help please. Cheers Andy

could someone please check my tables to see if they are to 3NF (Really don't get that) and also offer me some advice on how i should link them up via the relationships, again the one to one, one to many thing just confuses me. here is my picture of my tables and my database is attached...

i have now modified the layout of the tables and removed some of the one's not needed ( I think) see attached how should i link the helpdesk table to the workstation table, and also not sure how to link the other tables....many to many etc

once again, thanks for the input... do you think i should keep a seperate table for things such as: priority (High, Medium, Low) Type (Hardware, Software, Network, Password,etc) Location (Main Office, Lab etc) etc.. These contain just one field.... then link them via a relationship or...

great!!!!!!! thanks, this is the kind of feedback that i was hoping for..... please keep your suggestions coming. 1. i have got a technicians table, not sure why i left it off my, picture. it only contains one field though Technician Assigned. 2. Unfortunatley yes i do have a Yes and No...

ok thanks for your help, i have now gathered from various sources a number of tables, that i think i might need to create my helpdesk, some may disagree and i would love to hear suggestions. i have attached a list of all my tables, i am just not to sure how i would link them together via the...

hi can someone please have a look at the following code and tell me whats wrong i get a message saying "Block if without end if" Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) If Me.Line_LME <= 0.85 Then Me.Line_LME.ForeColor = vbRed Me.Line_LME.FontBold = True Else...

Need to build a helpdesk- Advice I have been tasked with designing an IT helpdesk database, but to be honest i am not sure what sort of things are usually included in this type of project. Any ideas please... my company has around 400 computers 8 technicians - can repair machines 1 help...

Can i condition format the contents of a text box, depending on the value. for example, if the value of text box 1 is less than 85% i need the font to change to red and Bold i have looked through the search, but didnt really find the right answer. cheers Andy

here is a sample of my database,

thanks but it doesn't seem to put 100 in the cell, instead it gives me various figures.

null, i think, there is nothing in the cell

how can i write the following Combi LME: ([CombiLME2_Crosstab]![PlannedTime]-[CombiLME2_Crosstab]![Combi])/[CombiLME2_Crosstab]![PlannedTime] so that if the value of [CombiLME2_Crosstab]![Combi] is zero then it will place 100% in the cell, it currently leaves it blank, where there is no...

I have just reread through my post and not sure it makes too much sense, i also tried my link and it doesn't seem to work.....great start. i have now added a picture and a smaller database to show what i am trying to do. i need help to try and get a query using the attached database that will...

i need to generate a query, that is as follows Planned Time - Combi - Dolly Tray - Handle - Imaje - Misc - Palletiser - Straw - Tray Divided by Planned Time I have been trying to sort this all morning but cant sem to work it out. there are a few things to consider. The part of the above...

I have set up a number of queries that are run dependant on data entered into various forms, this sets the criteria for the query. I am looking to compile a number of graphs in a report using the 4 queries that i have. however these all run off of different forms. What i want to do is create a...

this is my very first offer of some help, since joining the forum....and yet i aint sure it's what your after but i use this site a bit. Click Here Hopefully this is helpfull Andy