Search results

Hi, I have a form with an unbound control on it. The record source of the control is a DLookup function, which works fine. When updating the table (on which the DLookup Function is based) through different form, my unbound control on the other form that uses the DLookup Function does not...

Hi...can you help? I have a multi-user MS Access97 database application. It is causing one of the users (and I have only once had the error message myself) the following error message: "There isn't enough free memory to update the display. Close unneeded programs and try again." This error...

Hello Liv Manto and Pat Hartman, I am trying both of your methods: Liv: I tried your revised SQL and now I get the error: "Syntax Error in Join Operation" ???????? Pat: I created the union SQL as per your sample and then created the cross tab query based on the union query. This works...

Hi Liv Manto, Thanks so much for writing this sql for me. I copied and pasted it into SQL Editor in Access 97 and when I switch to datasheet view, I get the error "Syntax Error in From Clause". When I click ok on that error message, the "SELECT" keyword in RED below is highlighted. Any...

I think I have come up with a workaround solution which does not require the creation of a very complex union query. Here is what I have done, and what seems to do the trick: 1. I created a table that contains all the fields required for the final result (Emp #, and years 1981 - 2003). I...

Hi, Does anyone know how to exclude the header information when copying a record from an Access table and pasting it into Excel. When I paste into Excel, it is also pasting the header information from Access which I do not want. I only want the data to be pasted. Thanks for the help in...

ByteMyzer, Restructuring the table is not something my boss wants me to do. I am stuck with writing this complex query. I've been working on it for a couple of days. If anyone knows how to write this query, I'd certainly appreciate some help. Thanks!

Hi ByteMyzer, Thank you for your suggestion. Unfortunately that will not be possible for me to do. This is a database that has been in use for many years, and thus has thousands of records in it. The boss does not want the tables changed. He just wants me to create a query that will get...

Hi All, I've tried using a union query, but it doesn't work, since the only common field among the three tables is the emp # field. The rest of the fields in the tables are different, but I need to display them all. The fields for the tables are as follows: Table 1: Emp #, 1981, 1982, 1983...

Hi Liv Manto, Thank you for your response. I tried doing a union SQL, but wasn't successful. I am not good at writing the SQL statements...better at using the design grid. Will a union query work if only the Emp # is the same, but all the other fields are different in the tables? I need to...

Hello Access Friends, I am having trouble writing a query. Here is what I am trying to accomplish: I have 3 tables: 1981-1990, 1991-2000, and 2001-2003 Each of these tables contains employee records with totals in each year. I am trying to write a single query that will pull the record for...

I just converted a piece of code from DAO to ADO and now updating the recordset does not work. I am getting the following error message: "Runtime Error 3251: Current Recordset does not support updating. This may be a limitation of the provider, or of the selected locktype." I simply have a...

It is an unbound text box.

Thanks for the comments, Mile-O-Phile! Now I understand! You've been a GREAT help!! BJS

I am displaying the result of a calculation in a textbox on a form. When doing the following math: 9999999999* 9999999999 = I get error: "Arithmetic Operation Resulted in Overflow" How can I handle this error and display the result: 99999999998000000001 Note: my numbers are dimensioned as...

Mile-O-Phile, YOU HAVE SAVED MY LIFE! THANK YOU SO MUCH!!!! your code works like a charm! I'm not sure I entirely understand what it is doing, but I have attempted to comment your code. Could you look at it and let me know if I have commented based on what it is actually doing? HERE IS...

I have a result of a calculation that displays in a text box on my form. I have dimensioned my numbers as double. The result of the calculation could look like this: Sample Answer 1 = 662.102106929135 Sample Answer 2 = 66210210.234 I want all my answers to display with 8 digits (excluding...

Pat, I reverted to dimensioning my variables as strings, due to another problem I had, which was trying to display 9.09. See my post "Trouble displaying 0" on 26 Feb 04. If I redim them as single, will I not have the same problem whereby the numbers containing "0" will not display properly?

Hello, I have a text box on a form that displays the result of a calculation. My numbers are strings, converted to double during the calculation. once converted to double, I cannot get my text box on the form to display the result using the format function. Dim strNum1 as string Dim strNum2...

The code I had was correct: 'dblNum2 = 9.09 + 9.09 dblNum2 = CDbl(dblNum1) + CDbl(dblNum2) I simply missed converting to double in a portion of my code. This works now. BUT.....now the problem is: After the result of the math is assigned to dblNum2, dblNum1 is set to 0. This causes a problem...