Search results

The backend is stored on a shared drive on a file server. I was not using OneDrive to distribute the FE, but some of my users use OneDrive to backup their computer and OneDrive alters/highjacks the file path to the desktop, documents and pictures which meant the path to their desktop was no...

I have been doing a bunch of research and I am going to give Flask a try for my first attempt. The results should definitely be interesting.

I have been learning Python over the last few months off and on. Its syntax doesn't differ that much from VBA, so it hasn't been too rough learning it. I was reading more on Flask last night and will likely try to use it first.

OneDrive is nice but it does create a headache when dealing with paths and figuring out where things went. I ended up getting this to work by making a batch file specifically for OneDrive users. Not the best workaround I am sure, but it worked lol.

I was thinking of trying to use...I think it was called Flask? For the webform development. A friend told me it was somewhat easily to learn, if I am remembering the correct one anyways. I have heard PHP mentioned a lot for this as well, but no nothing about it so will definitely be reading up...

Does anyone here happen to have some experience in this matter? I really want a project to learn more new skills and think converting one of my more simple Access apps to a web application hosted on our local intranet would be a good and fun challenge. Any reading material would also be greatly...

I just tried it again and it worked. I have no idea what I did wrong as I rebuilt the query in the same manner I did originally. Maybe I tried to insert the autonumber field the first time by accident and it just spazzed out. Either way, thank you for your help Minty!

I tried to both insert the my autonumber field and leave it out and I still received the error but I am reviewing it all again to see if I made a mistake.

Above is the error I am receiving when trying to insert new records based off an unmatched query. I believe this is due to having the Identity Specification set to "yes" on the table. This is the first time I have run into this and most of my searches have only returned how to fix this on the...

It is just a simple batch file that pulls the latest file from the server so people run the most current without me having to email it to them.

I think I got it. I wrapped the path in quotes and that seemed to let it do its thing.

I did try START "MSAccess.exe" %UserProfile%\OneDrive - Company Name\Desktop\ReelTime.accdb, but all that seems to do is open the onedrive folder and doesnt launch the application.

This is more or less how I initially tried to do it, and it works. The problem comes when people are using OneDrive and syncing their desktop as the path to the desktop changes.

It seems to only work in Powershell as cmd doesnt recognize it.

I am hoping someone could help me with this. I am trying to use a batch file to get the file path of a users desktop due to some people having OneDrive enabled and syncing their desktop. I found a way to get the path via [Environment]::GetFolderPath([Environment+SpecialFolder]::Desktop) but...

But what would you do in the event you are working with multiple recordsets and an error occurs before one has been set/opened? It would cause another error when trying to close a recordset that was not yet opened would it not? This is the primary thought that raised this question as to what...

I have a question that I wasn't able to find a nice clear answer to that I am hoping you professionals could shed some light on. When dealing with recordsets (DAO), when doing error handling if the event the module/process fails, should you apply .close and then set to Nothing? If so, why? If...

I can only do a round or two of something like Battlefield, otherwise the depression will become rage lol.

No, my intention was just to get feedback on a larger module that, for once, I wrote with nearly no help and see how bad/well I did. By the looks and sounds of it, I did not do a very good job.

Got it. That IF block was removed and is now just: MultiRS.Edit MultiRS("MultiComplete") = True MultiRS.Update But that field is from a previous iteration when the process was done one instance at a time, so it would flag it true to provide the person doing it a visual indicator that they...