Search results

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.

Good morning. I have a field that will contain bolt thread specifications. Some cells will be left empty. They need to be entered like this - M18-2.0. The person populating the data is entering M18-2. I need to write a formula to ignore the cell if it is blank but if it in not blank but does...

The guy screws so much stuff up every sheet the tables to compensate would be three times the size of the original form. I am going to add the notes on what has to be in the fields and just rejecting the forms if the data is not correct.

OK thanks. I put together a spreadsheet that one department needs to populate the fields. I then import the sheets into Access and manipulate the data to build load sheets for a program. The guy populating the data cannot keep the data formats consistent. I added notes to the field heading so...

Good morning. When I add a comment to a cell it puts a red triangle in the upper right corner of the cell to denote there is a comment there. Is there a way to change the location to the upper left corner?

The original data does not contain a dash so I took your code and modified it to: Val(Mid([FieldName],InStr([FieldName],"C")+1)) and it worked great. Thanks for your help!

I have some data in a table that is listed like this: NTC10RM NTC5RM TC10RM TC5RM I need them to be like this: NTC-10-RM NTC-5-RM TC-10-RM TC-5-RM For the NTC/TC part I used LEFT([FieldName], InStr([FieldName], "C")) & "-". For the RM part I know I could use some like RIGHT([FieldName],2)...

I know I can do this - F1 : "Test1" and it will put Test1 in the field. Is there a way to to something like F1: ("Test1", "Test2") so the query will produce two identical data sets but one will have Test1 and the other will have Test2?

That works. Thanks.

Here is some test data: f1 f2 test1 123,456 test2 789 test3 987;654;321 test4 test5 quick/brown/fox I do not think I would run into multiple separators in one data set but I would like to have a universal query set up where I can copy/paste data into a table like the above and...

I have a question on this. In ParseText module the code reads: Public Function ParseText(TextIn As String, X) As Variant On Error Resume Next Dim var As Variant var = Split(TextIn, ";", -1) ParseText = var(X) If ParseText = "" Then ParseText = "empty" End If End Function I want it to do...

vba_php, thanks for the link. My takeaway from reading that information is that Template File does not mean what I thought it meant and that it will not work for Excel. If I am wrong then please let me know.

I want to export data from a query into Excel. It is going to be the same data all the time. I want the data formatted a certain way every time. The ExportWithFormatting command has multiple fields. One is titled "Template File" so I created an Excel template. I have populated all the fields...

That worked. Thanks.

If I try to run it without the quotes I get the following error: Syntax error in query expression 'table1.id<>query2.id' Initially I tried brackets but they gave me an error also.