Search results

:banghead::banghead::banghead:

forgot to upload the database

Thanks for your reply, 1. TBL_Updates isn't really part of your data, so it shouldn't be in your relationships. I’ve removed the relationship for this table 2. You shouldn't have tables with only 1 real field in them (ID fields are not real fields of data). That means all your 'sys_' tables...

Hi, I have made a few changes from last time. could someone verify this is a logical and stable database and the relationships are correct. I have split the Asset table to just fields that will not change and introduced TBL_AssetInfo. My thoughts are that the assetinfo will be updated by a...

try this as an example

Re: Database Theory/Design Hi The reason for the last updated by and UpdatedDate was so when i queried it would show the latest data. How would i populate the UpdateTable Field to get the table name??

Thanks, i have added that in, My next concern is dealing with Dates within Access and the best method/approach. One of my previos databases had a habit of randomly changing dates stored from dd/mm/yyyy to mm/dd/yyyy. What is the best way of handling these? Thanks Rob

Would you advise an TBL_Users as this field seems to be in all the tables?

Thank you for your reply I think i have actioned point 1 correctly. I have remaned the MainData to AssetData as that is what the table holds i have deleted Enginner, Renamed the inspector to personnell and added a field for selecting engineer/inspector type, I am slightly confused around...

Hi, Sorry for the delay in replying I have remade the database after following the above advice. i have attached my efforts so far. The purpose for the database for 3rd graders- I have been asked to design an program/database that takes raw data, processes it, updates to MainTable. When a...

would someone be willin to assist in the basic set up as i'm getting confused?

I think that maybe what is missing, I've only used access as data storage before now so trying to build this is a challenge. TBL_Booking MaintenanceTaskID TBL_EngineerID TBL_InspectorID TBL_AccessID DateBooked BookedBy UpdateDate InspectorStatus AccessStatus EngineerStatus ??

Thanks for your reply MarkK, the relational field would be MaintenceTaskNumber. the maintenanceTaskNumber is basically the order number. the flow process is as follows which may help Email with Attachment Upload Attachment to DB Macro/Queries check if record exists or creates new record...

Hi I have been asked to design and build a database to track maintenance and i have a few questions: Scenario: There are multiple things that need to be tracked/recorded. TBL_Maintenance -MaintenanceTaskNumber -WorkCity -WorkSite -DueDate -DescriptionOfTask -ActionRequired -AccessStatus...

Hi I have a table call ed Archive. i need a query that would produce the following results Must be within one query. I'm after a distinct list of names To look within the field Hashtag to find if there is text "#LEFT" If there is i need the first Calendar date it appears against their name...

Sorry i was having a real bad day yesterday I have tried to construct the formula to extract the hashtag but it is failing Hashtag: Mid([test2]![Details],"#")+1-InStrRev([test2]![Details]," ")-InStr([test2]![Details],"#")-1 The string in the field can be absolutly anything but will...

I have 2 tables called MakeTable1 and DBO_TBL_Activity Im trying to update MakeTable1 with the values from TBL_Activity when both activity.StartDate and maketable1.Dates match but also acticity.IDStaff and Maketable1.ID Match Below is the SQL i have so far UPDATE [MakeTable1].[Detailsa]...

=IF(ISNUMBER(SEARCH("Training",[@Details])),"#TRNG",IF(ISNUMBER(SEARCH("Leave",[@Details])),"#HOLS",IF(ISNUMBER(SEARCH("holiday",[@Details])),"#HOLS",IF([@Details]="","#Free",IFERROR(TRIM(LEFT(SUBSTITUTE(REPLACE([@Details],1,FIND("#",[@Details])-1,"")," ",REPT("...

Thanks for the suggestion buti dont have a clue on how to turn this into a function? Can anyone assist with that or another suggestion?

Hi I built this and it works in excel but i have no idea on how to get it to work in an access query...