Search results

See, this is the issue I am encountering that maybe will not work. I have created the entire database on my PC which has nothing to do with the office that is going to use the DB. So in doing this everything reads my PC. If I don't split anything the entire DB works great on the one computer I...

I had them split and then not split, same results. I will try it again since changing registry.

I am doing all the registry edits on the FE workstation using an .accde file on the FE. I have no problems actually accessing the database on the server.

I have tried all of this with no progress. My database is on D drive of server 2019 and I have tried no mapped drive as most things I find say don't use mapped drives. Server is \\SERVER-PC. I tried using it mapped anyhow T:\TimeClock.accde but did not work. Is your database on the same PC where...

I added AllowSubfolders and Description but doesn't seem to help. Also Network Locations.

I knew about the registry edit so I already created Path: \\SERVER-PC\Time Clock\TimeClock.accde which is the exact path for the database. I did not add anymore than the path. Is the triple and double backward slashes needed throughout the path as you have in one of the examples.

I know that if even one computer had full blown Office I could put the database on the PC and it would create the correct path since all the PCs are connected through a domain but there should be a work around for just using Runtime. Everything works in the program as should. I just get that...

I designed a database on my computer, with help from this great forum, but I need to put it on a totally different system/location. The database will be on a server and it will be accessed from two workstations all using Access Runtime. There is no Office programs on any of the PCs. I have...

I think I have everything in the database that the client will need. I really appreciate everyone's help. Greatest forum ever. If not for you guys I would have pulled out the little hair I have left. If it is OK with everyone I have added the form in the photo that will be opened by using the...

Please keep us informed.

I hope everything is OK. I know how that can feel because I went into severe dehydration after cutting my grass in 97 degree NC weather and had to be rushed to the emergency room. I drank ice cold water trying to cool off which put my body into shock and made me sick as a dog. Never knew that...

Thanks Ken for the response on this but having issues with implementing how should work. Got an error that it didn't recognize TimeElapsed, had to add my table to EmployeeID but still getting syntax errors.

Yes, I try to use everything sent but my problem is still how to implement it. I tried what Ken posted but I keep getting, if I can remember, a #Name? error. I googled it and tried making some changes but didn't help. Got rid of the error but still no solution. As I said, all this is like...

BlueSpruce, I have been trying to use this as a guideline for creating a weekly total for each employee but haven't been successful. Do you have any ideas on this.

I literally don't know if I can narrow it down. I know I worked with info from June7 and Ken and I changed my calcs and some of my module via arnelgp and BlueSpruce. I was getting my form to give me rounded total hours such as 4:02 hours plus 4:12 hours equals 8 hours but no minutes. Then trying...

Wow! I want to thank all you guys for the help. I am so glad I found this forum. I actually incorporated, I think, some of what everyone contributed and finally got what I was trying to do to work. I can build custom computers, program and network them, design websites using HTML, CSS, Java and...

I tried to use post 11 but I'm just not sure I know how to use it.

OK, I have tried to figure all this out and have tried some of the solutions without success. Totally my fault. I am going to try and explain again what I need and may find you have already given me the answer at which point I may have to call it a day. EmployeeID_______EmployeeName________...

As I said prior, it has been years, 25, since I have messed with Access but I am a quick learner especially if I have worked with it before. This is my first project back and I have tried to work with all these great solutions, greatly appreciated I might add, but right now I am in the "Do I...

I hope this helps. As you can see in the query I am using this set of calcs to get my Minutes Worked and Hours Worked. MinutesWorked: DateDiff("n",[TimeIn],[TimeOut]) HoursWorked: Round([MinutesWorked]/60,2) WholeHoursWorked: Int([hoursworked]) MinutesLeft...