Search results

I am trying to save files to users desktop, or even their Documents folder but several people have OneDrive enabled and are syncing either one or both of them which changes their path completely. Any code I run, whether it is Python or VBA, while it doesn't seem to explicitly fail, doesn't work...

I am revisiting a backend I made about 2 years ago at this point and trying to making improvements as I know a lot more than I did then and the old design isn't playing well with converting to a Python based front end. I have attached a picture of it. This is the backend for an application that...

Been awhile everyone! I just wanted to drop by and say that my current endeavors have really made me appreciate how nice Access is. I have been solely working in Python now for quite some time building an application suite for my work and I must say, I never realized how hard UI design really...

Hello again! I am working on a Python application and have a query interacting with an Access 2016 backend that I can't seem to get right. For reference, here is the function in its entirety: def query_order_data(self, pm_id): if not self.connection_manager.conn...

Not sure which sub-form to post in, so general it is! I am connecting to a small (only 3 table) access database (2016, .accdb) using an ODBC driver from Python. I am trying to run an parameterized query and am getting an error when I try. From what I have been able to find, it is saying that...

I am trying to prevent changes to specific controls when a record is not new to prevent accidental editing and to have more control over when an edit occurs. Is there a way to check on a form if the record is new and if not, locked and disable a series of controls along with changing their...

I cant determine how to do the table structure for handling cycling counting. Do I need an audit table? Or is one table with before/after quantities enough? Do I need to lock tables while the DB is in "cycle count mode" to prevent records from changing? I can see so many different possible...

I managed to finally snag the new Northwind and I was really surprised when I opened the relationship window to see a huge spiderweb. I always thought that you shouldn't be able to trace your way from point A to point B via multiple paths as that would mean a possible circular problem (excluding...

I need a little assistance in coming up with a formula to split a string apart based on length. This is part of a module to export a recordset to an Excel file template for import into my companies system. If IsNull("Description") then 'do nothing' Else If Len("Description") > 60 then...

I have a friend who is also learning VBA and Access (more Excel than Access, but still) who asked me last night what datatype is best to use and surprisingly I didn't really know the answer. All I know is Long can go out to like 2 billion but doesn't do decimals, double I am not sure on its...

This is a best practice question. Should there be a module that, when someone just closes the DB via say the X in the top corner, to handle all the forms closing and unloading? I have a couple users that love to just close the DB when they are done rather then backing out of it and closing it...

I have not done a query quite like this before so could use a little help. I know the field names I am about to show are awful but I have no control over them so don't beat me up too badly. Goal: Find all [Sales Register #] where [Extened Price] (yes that is spelled wrong, I know) matches...

I'm sure this can be done but is likely complicated to fully get what would be nice to have. I have a cells filled with a list of material and quantity. Example: (4)-QO130L200PG, (4)-QO250, (4)-QO240, (16)-QO120, (24)-QO120PAFGF, (4)-QO200TR, (1)-QOM2100MVH, (12)-QO120PCAFI, (24)-QO115PCAFI...

I know that you should not attach meaning to an auto-number field as its only role is to be unique but would it go against common practices to use it as a sort of "job number"? What I mean is when say a project in the database is created, you would use the auto-number to say that it is project...

I am getting this expression error in the query editor when connecting to a PDF with a table I am trying to link to. let Source = Pdf.Tables(File.Contents("C:\Users\tmyers\Desktop\Commodity Price Files\Copper.pdf"), [Implementation="1.3"]), SplitEachColumns = List.Transform(...

My searching is only turning up convertor tools or ways to do it from Excel and not Access but even what I found there wasn't quite what I am after. I am trying to replicate what Acrobat does when you do Save As and choose .xlsx as the file format. It takes the PDF and converts it to a single...

I am creating an Excel file from a query built within the module and need to update a field ("MFR") after the file is created so it changes the manufacturers name to the matching code within our sales system it is being import into. I have a table that I store all my manufacturers in and it...

I have an interesting issue that I can figure out why it is happening. In my table tblFixture I have the field UnitCost which is set to the data type Currency, yet when I import data in, this is rounded to the nearest whole number and I thought this datatype would only round to the nearest...

In a query for my report, I am testing if a field contains a certain string, then if so, override the value to "Approved". I have tried several different variations, but it never seems to flag true. Mfr: IIf(InStr(1,[OverrideType],"Over",1)>0,"Approved",[Manufacturer]) I have also tried: Mfr...

I am hoping someone with a keener eye can tell me where I need to put the IIF(ISERROR()) in these two expressions to suppress the errors from appearing on the form. The form in question is a continuous form and the last row displays these errors (no record). Does it effect anything? No. Is it...