Search results for query: *

Sorry i had to be out for awhile due to surgery now im back at my project looking for help again.

i created the tables like you instructed but now how do i create a relationship between them how do i get the tables to be normalized. https://files.engineering.com/getfile.aspx?folder=018d1d39-7034-4888-b449-c4ae8e248253&file=14DAYFALLOFFREPORT.accdb

can you show me please i have been racking my head for weeks for a solution.

im still trying to work that out this is not mine it was just handed to me from the department manager

i was going to put that in in a bit it just long process of me putting all the data in i have the data in an excel sheet . https://files.engineering.com/getfile.aspx?folder=9f2bef29-8441-4bfd-be74-371ddd81776e&file=Copy_of_14_Day_Follow_Up_Fall_Off_Log_MASTER2.xlsm

ok i got it to work but i need to add some conditional formating based on labtest result I need to put this on the text boxes on the calendar for the test done for listeria in a given location. i have created a query for the test restults which is. SELECT [14DayFollow-upFallOffT].Location...

I would like to thank everyone for their help and assistance [gorgeous]

Thank You

i keep getting an error i have been going through the code i am stumped

im trying to download the file here but keep getting a error.

dtpYear is a list box that list the years the user select the year yes i stepped into the code and it steal doesnot add the labels for the name i can send you my database if you like.https://files.engineering.com/getfile.aspx?folder=f12f5480-ffeb-4d30-8e06-3a1c425814c5&file=calendar_example.accdb

This what i get still not sure what the issue is

i think it has an issue with FillMonthLabels sub routine because it wont add the labels to the form

thread702-1705763 i need to put test result in a database but have no idea where to start. I though t of using this as a example but i get stuck. https://files.engineering.com/getfile.aspx?folder=b6c43650-27fa-48c7-a771-8db7ad7e8144&file=14_Day_Follow_Up_Fall_Off_Log_MASTER2.xlsm

I have a form that i for from old post that MapJ wrote but having a hard time getting the code to work. my form looks like the attachment . i have the following code that i am trying to input the dates depending on a year that is selected but i get an error. Run time error 424 Object required. I...

The formula on my sheet that historian addin creates is =wwWideHistory3("LEWC2012INSQL", Sheet1!$A$17:$A$27,"Row7",AFStartBinding,AFEndBinding,254,0,0,0,0,3,0,"",3,"",-1,0,"","NoFilter",20480)

Jeannie, Just like in Access, pressing the F11 key will take you right to the VBA interface we all know and love! It looks and works just the same as it does in Access… the only real difference is that building user forms is very clunky compared to Access. Alternatively, you can go to the...

I didnt get it from somewhere i got from facebook group but i beleive there an easier way Since its not working

Do you have this Addin installed in your Excel? Ans: Yes i have the add in installed. Then you have a function in your VBA that actually calculates the difference of two Date/Time values. HOWEVER, you also seem to have if History function, that was missing some quotes in on argument, that I...

The formula works when i copy and paste it in the call but i do not know the VBA to write so the user can just click on the button to retrieve the results.