Search results

I am not sure how I need to do this so I am posting in General. I need to upload images into a web based UI. They are loaded using a ZIP folder. The UI limits the folder size to 300mb. I have a data set that consists of an distinct ID, a distinct image part number, and the image file size in...

That did it! You guys are awesome. This makes my day much easier.

@theDBguy I found one that I use that does not have anything anyone would worry about.

I really do not have any experience with FoxPro but when I open the database there is a bar at the bottom. In the lower left hand corner it gives me what record I am in / total record count just like Access. To the right of that it says "SHARED" so I believe the file is not set to Exclusive.

If someone has the program open that uses the DBF tables I get a pop up that says I do not have permission to access them. If I am accessing any data from one of the DBF tables and someone goes into the program they get all kinds of error notifications from within the program.

I thought I would be able to just insert them into a table like with an Excel file or an Access table. I can add the table to the database using DoCmd.TransferDatabase. I think I might use that to create a temp table, insert into another table and then delete the temp table. I was hoping for...

I currently have the DBF files as linked tables. This is causing a couple of issues. I am not the only person that uses the software that uses the DBF tables. I can either get locked out/or lock someone out. The DBF files have numerical values stored as text. It would make my life much easier...

I had thought about that but I did not know if there was a way to make the last two provisional in the way the format is written.

Thanks for posting that, I am using it to format some data I have. I do have a question though. I have some data that is like this: 1234567890 123456789012 I am using Format([FieldName], "!@@@-@@@-@@-@@-@@") I get: 123-456-78-90- 123-456-78-90-12 Is there a way to modify the format so it...

I do not think my company would like that.

I imported a DBF into Access as a local table. I am trying to update the data using this: INSERT INTO local_table_name SELECT * FROM [DBF_file_name.DBF] IN '\\ServerName\FolderName' I am getting an error : "The Microsoft Access database engine cannot open or write to the file...

I thought NOT IN would only drop what matched the criteria. A null would not match so it would not be drop.

I needed to filter some data in a query so I added a field titled "ProductDescription" that has the following data in it: Turbocharger Turbocharger Mount Supercharger And some empty cells I used NOT IN ("Turbocharger Mount") and it brought back data where the cell contained Turbocharger and...

That would be the same thing I used. I tried creating a MoveTo folder where the SendTo is and added some locations but it did not work.

I have some code that sets a file location as strPath. I am trying to use it to append some data from a table in another database to a local table in the db I am working in. I have used: DoCmd.RunSQL "INSERT INTO BrakeTypeWorking SELECT * FROM BrakeType IN strPath" which gives me a Run-time...

I did the registry edit found all over Google. When I right click I now have a "Move To Folder..." option. When I click on it a window opens and I can pick the location. I do not want the pop up window. I want a location option menu just like with Send To. I Googled it and could not find how...

Good evening. I am exporting some text out of Access and I wanted to setup a specification that would do it as UTF-8 with BOM. In the Code Page drop down there is Unicode (UTF-8) but no selection for UTF-8 with BOM. Is there a way to set these files up to export as UTF-8 with BOM?

That did it! You are awesome. I will name my first child after you!

Yes, you can ignore that.

OK so if the cell is empty then completely ignore it. Do nothing. No formatting needed. If the cell is not blank and is missing the period then I want to turn it red.