Search results

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.

I am using the following statement: INSERT INTO table1 SELECT * FROM query2 WHERE 'table1.ID'<>'query2.ID' There is already data in table1. I want to it to insert data to the table only where there already is not data listed using that ID The macro runs but it just inserts everything from...

OK I figured it out. When I went to pull samples of the data to put in a db to share here I found the data I needed was missing from one data set. This would explain why it was showing up in one query and not the other. It turned out my boss had updated a field in the table to equal "" where...

I edited my OP to add that both queries are joined on the EXACT same fields. If it was something as simple as there was a space (which I already thought of and checked) then the data would not match up in both queries.

I have two data sets - a master table and an application table. Both tables have multiple fields that differ but have six fields that are supposed to match each exactly. I wrote two queries: master vs application tables -> checks to see if there is anything in the master that is not in the...

To me the funny thing is that if you run that IF block with the MsgBox and you do not tell it to stop it will go on and do other things after the block. When it hits the submacro it just stops.

I thought it was fixed. If delete the MDL_MAST_2 table from the query it will run. I fixed it and replaced the zip folder.