Search results

I'm not completely sure how MS has this tied together, but as the 'owner' of the Access files, once I add the Trusted Locations, then all is good. In my case, I got admin rights for the day and ended up changing a Registry value so that I could use an environment variable in the path, thinking...

@Gasman : Yes, I read the article(s) on the bug, and discovered that I am running a Windows 11 (365) Beta build, ver. 2201 build 14827.20158. All the problems I am working on right now is involving the FE on my local machine. The lock file seems to prevent me from double clicking or pressing...

Hello, In the last week or so we've been experiencing a ton of errors, and now I am a little stuck in the mud. (And I'm hoping this is not because of an update MS recently put out that interferes with Access! which I read about earlier today.) I've been experimenting with copying, renaming...

Good question, Pat, I wish I could. The new DB has a slightly different table design and an import would not work. This is the system in use, going to be the old DB. The RequestDetails table currently stores the Part Number and Description. This is going to be the new DB. I have...

Hello all, I have been looking for a solution to this problem... Here is what I would like to do: I have a new DB (DB2), with slightly different design. I want to allow the users to look up materials in the old DB (DB1) and add that to a new order. However, DB2 uses two tables for the...

Part-time Dev, maintenance tech, parts manager, mechanic, DIYer... Full-time dad, husband and grandpa!

Have you finished this project? If not...I would use a normal button to open the visit form, pass the patient ID to that form in the open command. Delete the extra patient ID and visit fields on the investigation sub form. And calculate the age from the date of birth.

To this point, I was only interested in removing special characters from a copy and paste from the Web situation, when users enter data. (Problems arise when users search for some Item and cannot find it because of some special character). We are not concerned, much, I think, with foreign...

Thanks guys. Now to implement it for chosen table and field. One more question: What is the functional difference between Asc() and AscW()?

So the ASCII number for the copyright returns 174. A Google search says it's 169. According to this site: ASCII it is neither. And...going through some Unicode charts is VERY hard on the eyes! Over 150,000 characters! Edit: Perhaps there may be some legality involved with removing the...

Thanks Maj. Took out those funky ones. Edit: How about those pesky copy right symbols?

I am attempting to clean up the data, prepping for an import and removing special characters and accidental user keystrokes... I found this one record, where the user pasted text from a website three times. I got an error about the field being too small, as I was attempting to convert all...

After putting this code in the BeforeUpdate event... Gasman mentioned comparing the two main blocks of code. The first IF block does not call the Message Box, so you won't get a pop-up. And, as CJ pointed out, that extra "End" will stop your code from working properly. As for referencing...

And everything else from Europe! We have been waiting on a cushioned chair as part of our new furniture set...ordered back in March. I got a call in July that said everything was here so we scheduled delivery and tossed out the old furniture. Now we are missing our comfy recliner, who knows...

i remember the McD's one...she sued for something like 5M because the lid on the coffee didn't say "HOT". She did win. But who would put a cup of hot coffee that isn't sealed, between their legs while driving???

Pat, I'm not really looking for a new shiny object to use because it looks cool. I am exploring what options may or may not work well within the application. I'm reading through the content via your replies, links, and samples. If someone suggests a class is better for situation X, then I ask...

@MajP forgive me for reviving an old thread... What does 'cube' relate to in this situation? Are we talking cubic feet or a box of some kind? With my basic understanding so far...it sounds like this could be useful in determining how to optimize loading 53 foot trailers and pallets. I've...

@MajP I was just reading a thread from a couple of years ago on classes and you told the OP to check out some of your earlier posts. And seconds before you replied here I just hit the search button looking for your threads, LOL! :ROFLMAO: Thank you for clarification and I will have a look!

I have a module from Scott Prince that I've made some changes to, and requires a table in the BE and FE for version checking. I've also added the ability to check for an app module prefix (3 characters in my case) and the file path to the 'master production version' which will be copied to the...

Thanks, Cronk, for throwing a wrench into the mix, lol. I must ask, how would I implement a class object into Access? Let's take Inventory Management as an example. I have a room full of parts, most can be purchased from various vendors. I have a stocking location as well as stocking levels...