Search results

That gave me a compile error right after pasted it in. I had also tried several iterations of - If Len(DLookup("[Part Manufacturer]", "[accupi_export_sheet]" & "")) = 0 Then But all those did was not open the message box. I can get it to either never open the box or open it all the time.

Good afternoon. I have this if statement in VBA - If (Not IsNull(DLookup("[Part Manufacturer]", "[export_sheet]"))) Then If (MsgBox("Delete PN's w/o manufacturer names?", 4) = 6) Then DoCmd.RunSQL "DELETE FROM export_sheet WHERE [Part Manufacturer] IS NULL", -1 End If...

I know there are options already selected by default. I am assuming those values are stored somewhere in the registry. IDK if I could create a new registry entry that would add what I need to that default list.

I was hoping for something like a registry hack.

Good afternoon. When creating a module I always have to go in and manually select the Microsoft Office 16.0 Object Library so the code will run without errors. I have to do this every time in every database. Is there a way to select it so it is automatically selected in all databases I open on...

I am sorry, that was not clear in my OP. The program that I upload the ZIP folder to will not accept a folder larger than 300mb.

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.