Search results

Hi - I have local tables that needs to be updated based from another file. To update the data of the local table I usually do this strSQL = "Insert Into tbl_holidays Select * From [MS Access;DATABASE=" & pathofanotheraccessdatabase & ";pwd=" & thePwd & "].[tbl_holidays]" CurrentDb.execute...

Thank you CJ_London - The users only way to add data to the backend is thru the front end using the ADO connection I stated above or this code [MS Access;DATABASE=" & Thepath and name of the database here & ";pwd=" & PasswordHere & "].[tablename] Its really hard to set up MS Access for...

Thank you The_Doc_man... I checked the permissions and it shows that they have full control/access. With almost 100 users its possible that they're saving at the same time. Would access be able to handle saving of a record lets say 15-30 at the same time? I have already research on MS...

If I use this: strSQL = "Insert Into Table1 Select * From [MS Access;DATABASE=" & Thepath and name of the database here & ";pwd=" & PasswordHere & "].[Table1] Where ID = 1" db.Execute strSQL, dbFailOnError Would executing this code open your backend to openexclusive? Thank you Hudas

Thank you Ranman256.... I have a tool with a accde front end and accdb backend that is being used by almost 120 users but Since yesterday it already happened twice that they could not connect to backend and the error is could not find;file already in use. That's why Im asking it both...

Good day, I'm not even sure if I have the correct term for my post TITLE but I will try to explain it further. 1. When I am trying to copy a record in a table and insert it into a new table(another database) what I usually do is this: Dim db as database Dim strSQL as string Set db = currentdb...

My Sincere apologies TJPoorman... Yes it does exactly what I want. Thank you so much for everyones help.

Thank you! Thank you! TjPoorman.... If I add 1 hour to 04:57:36 PM and surely the result is greater than intdayEnd , would it be possible to add the remaining minutes to the next day¿ Example Add 1 hour to 10/13/2016 04:57:36 PM, since 5:00:00 PM is the dayEnd so the result should be...

Thank you jDraw, the link you shared is the same with the my NewBusinessDay Function taking into consideration the Holiday, and Weekend. My problem is more related on adding an hour(integer) but it should be added during business hours only which is 8:00 AM to 5:00 PM only. So the result should...

So I'm trying to create a function that will give me what I need but I'm stuck. So far this is what I have. I tried searching google as well as this forums but I don't see a solution near to what I needed. This code will get the start date and time considering the Holidays, Weekends, and Time...

Hi Good Day, I need to add hours to a given date and time but the condition is it needs to skip the weekends ,holidays and, non working hours. Example: Shift Start: 08:00 AM Shift End: 5:00 PM Add 3 hours to 10/7/2016 3:30:00 PM The result should be 10/10/2016 9:30:00 AM...

Thank you The Doc Man. Indeed I was able to find the solution when I search for "Exclude non-working hours". Here it is http://www.access-programmers.co.uk/forums/showthread.php?t=159163&highlight=Exclude+non-working+hours Thank you!

Solved:Calculate Time Elapsed but exclude Non-Working Hours Good Day! I have a start date and time (06/16/2016 12:52:01 AM) and an end date and time (06/23/2016 12:52:01 PM), I need to calculate the time elapsed between this two but it should only include the working hours which is from 8:00...

Thank you jdraw! It seems to me that using ADO recordset as a recordsource requires more work than I imagined and based on your suggested link I have encoutered several items I'm not sure of how and when to use. I'm going to go back with my original plan that is update the table in my front end...

Hello MarkK, Thank you for taking the time to read through my post and aswering it. I tried the reference you gave me but the result on my subform are all #Name? and it seems its for MS Access 2013 and for later versions only. Im using MS Access 2010. Any more ideas?

I have a table linked to a backend database that is the recordsource of a subform. The problem is latency issue because of multiple users. I want to use ADO to update the record in the subform instead of linking it. I just want to get your opinion which is the best option... I have think of two...

Hi - First off, I know how to connect a front end to a back end using linked table. I was reading about connection string .I just want to get some insights. If I have a subform in my front end how do I get the data from the backend. because in a regular subform what I would normally do is...

Hello - I tried my best to make the above idea work but I wasn't good enough. Searching online brought me to a site that provided solution on hiding the Access Title Bar. I was hoping could this be modified to hide the access window border? Option Compare Database ' ************* ' Code Start...

Hi - Is there a way to hide the border of the MS access window? I just want to hide the border nothing more. Thank you Hudas

Hi , I have the below SQL statement... In table2 there is another field called timestamp1... Is it possible to have the timestamp1 included in the below statement so that I will have a record of time the moment the records were inserted in table2? There is no timestamp1 field in table1...