Search results

When you copy and paste from a website, you can get strange characters. I don't see any way of preventing that.

Use the "Find Unmatched Query Wizard". Look at the results and you will see how to create your own unmatched queries.

I need to use the asterisk, because I don't know in advance what fields will be present. I want to avoid editing this query every year.

Still have the same problem even with "clean" statement.

The problem remains after re-creating the query.

I am working in the graphic interface where things are clearer.

I have a keyed external SQL server table called dbo_HISTORY that contains a summary of sales data. It has the fields: INV_NUMBER, LINE_NO, MONTH, YEAR, CUSTOMER_ID, SALESMAN, SEGMENT, NET_SALES, KEY (and other fields not relevant to the question). (Segment refers to individual markets that a...

Thank you, first option worked well.

I have an Access native table which contains information cut & pasted from a website. When that happens, sometimes you get spaces that can be easily trimmed. Other times I get weird things like this. Image from screen Cutting and pasting the rows Query1 Query1 Query1 Query1 Invoice Number...

Is there a simple way of replacing multiple spaces from the middle of string with a single space? This works Ship To Name: Replace(Replace(Replace(Replace([SHIP TO Name]," "," ")," "," ")," "," ")," "," ") Is there a cleaner solution?

Thank you. I will give this a try.

I need to run a crosstab query directly in SQL Server (the query is being executed through a website). In Access this is easy enough TRANSFORM Sum(dbo_HISTORY.NET_SALES) AS SumOfNET_SALES SELECT dbo_HISTORY.CUSTOMER_NAME FROM dbo_HISTORY GROUP BY dbo_HISTORY.CUSTOMER_NAME PIVOT...

I am the VP of MIS for a manufacturing firm. I would strongly suggest you get an ERP designed for a manufacturing company rather than try to recreate it piecemeal in Access. (We use Visual Manufacturing from Infor). You need do a lot more than track the parts that are used to make a product...

I discovered that it a good idea to prohibit nulls explicitly in SQL server, as well as setting a default of 0.

Thank you for your help. I will make sure that the fields in SQL Server do not have nulls and default to false. If I am using yes/no in Access field or bit field in SQL Server it is because I don't want null to be an option. If I want to null to be an option, I follow the practice of my ERP and...

I will do that and check again.

I recently added a bit field to an SQL Server table I link to in Access. After doing that, whenever I attempt to edit a record in the Access linked table (even for a different field), I receive the error "This record has been changed by another user since you starting edit it ...". If I create a...

I deal with the network access error frequently. It is can be caused by physical problems with the network. It is usually harmless (for me) but lost connections can cause corruption. Make sure you have a good connection before trying anything. Other than compact & repair, you can try importing...

You might want to try a different approach and use queries rather than VBA code. Each query can be tested separately and then the name of the query (or the code of the query) could be saved in a table. It is easy to make a mistake when you are writing code.

If you just need to know which houses have no dogs, you don't need to count. You can just used an unmatched query (left join selecting for null on the right table).