Search results

I need to have a user select a file for further operations using a normal dialog. I tried this code, but nothing happens, not even an error. Dim FileName As String Dim FD As FileDialog Set FD = Application.FileDialog(msoFileDialogFilePicker) FileName = FD.InitialFileName I have the Microsoft...

In order to compute commissions I need to read data from a spreadsheet provided by the customer. Unfortunately, the customer does not understand the first normal form and is not showing repeated data. Sid Harvey Sid Harvey Branch Sid Item 0004 BROOKLYN,NY (0004) NY SPE-EZ5E-CS...

I have query that is being used to generate the body of an e-mail. Sometimes, the result should be more than 256 characters. However, when the query is run, the value is truncated. Is there a way of having a query generate a result that is more than 256 characters?

Last night, I needed to rebuild my database by creating a new database and copying all objects into the new database. I am now receiving the "This record has been changed by another user since you starting editing it" error when I edit a specific table that is linked to SQL Server. 1. If I go...

I have a field that should only have numbers as characters, but it can have a leading zero, so I can't use a numeric field. Is there any way that I can prevent accidental entry of non-numbers in the field at the database level?

I recently changed an Access native table to a linked SQL Server table. When I ran a loop to edit individual records in the database (in a situation where I could not run a query), I started to get "Record is deleted" errors. After much searching I discovered, that sometimes the ODBC driver...

I need to create a constraint within SQL Server that enforces the rule NET_WEIGHT <= GROSS_WEIGHT. My problem is that the GROSS_WEIGHT field is in a different SQL server database. How would I create such a constraint? Is there a way I could create a view or some similar object within my database...

A customer wants me to e-mail a spreadsheet showing sales and columns for each month (even future months). Here is a simplified version of the query. TRANSFORM Sum(dbo_History.Net_Sales) AS SumOfNet_Sales SELECT dbo_History.CUSTOMER_NAME AS [Customer Name] FROM dbo_History WHERE...

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...

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?

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 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 recently got a new computer. When attempting to connect to a linked table in Access, I get the error ODBC--connection to <database> failed. It works fine on the old computer and the ODBC configuration is identical. When I test the ODBC connection from within ODBC Data Sources (32-bit)...

I have an application where each record has both text and an associated image. I would like to print both the text and image on top of each other in Access (in the context it should be legible). Is this possible in Access? I suppose that I could create 2 reports and run the page through the...

I have a business requirement that poses an interesting design question. My company makes dyes that detect leaks in fluid systems. All chemicals require an SDS (Safety Data Sheet) that specifies safety information about that chemical. The SDS is produced by specialized software, so I need to do...

I am suddenly getting values of #deleted in all fields in tables connected to 2 different SQL server databases, which have functioning for years. This affects most of the tables in the databases, regardless of the number of fields or records (I have 13 record, 2 field table that is affected) but...

A user is receiving the error message "Unable to update due to lock violations" when running a query that updates an Access native table with data from an SQL server table. When I run it from my computer, it works without any problems. We are running on the same network, using the same database...

I need to use a query to find when products with similar ID's are in the same inventory location. Has someone designed a clever function that measures similarity? My idea is to add up the ASCII values of each character in the ID field and consider them similar if the totals are close.

I generate e-mails automatically by using an SMTP object. This works fine from my own computer but when I use a virtual server I receive the message "A program is trying to send an e-mail message on your behalf.." which I then need to allow manually. Is there any way to get around this?