Search results for query: *

Hello all- I am currently experienceing the following bug in Access xp: http://allenbrowne.com/bug-05.html Conditional formatting If you apply conditional formatting to calculated controls, you may start an endless loop where the form recalculates continually and fails to display the results...

Is there any way to change the color of an indidual cell's text in the Datasheet view of a form? For example, one of my fields must be above 48.0. So, if the text entered was 50 - I want it to be green. If the text was 30, I want it to be read. Thanks in advance! Adam

I have the following records with 4 fields: test1, 1, 1 test1, 3, 4 test3, 1, 1 test4, 1, 2 test4, 1, 3 I would like to return: test1, 1, 1 test4, 1, 2 test4, 1, 3 test1, 3, 4 That is, I would like to get the non-distinct records ONLY non-distinct on only the first field. Note that on the...

Is there an event that tells when the record changed on a form? Changed either by a mouse scroll or by clicking on the built in Access arrows at the bottom. Thanks Adam

I have an access database that is linked with sql server through ODBC. All workds fine, I can add records manually by openeing the tables and typing in data. But when I try to run an append qry, it gives me a "Didn't add 1 record due to a key violation". well, I have tried about...

I have an array of LABELS. I also have a mouselistener and I need to know how to remember which label was clicked and change the background icon for it. any ideas???? Thanks Adam

I have an old access database that I recently migrated over to sql 2000. I still have all of my qry/forms in access, I just linked all of the tables. Whenever I try to run a delete qry, it tells me that it "Could not delete from specified tables". Has anyone ever had this error and...

I have a database that is split over a network an a network drive. All works fine. Super. The problem that i am having is that there is a severe lag time opening forms. Is there any way in access to speed this up, or is it soley a function of my network speed. It is in a university setting...

Is there anyway to limit the size of a field that is displayed in a subform that is diplaying datasheet view mode?? By limit the size, I mean that I am having trouble becuase I want to have a subform with 5 fields, but they are all default to be 1" long. They are all numbers, so I only...

How do I insert records into a table using an append query with one of the feilds of the table being populated with the contents of a form's text box? I am using a cmd button to run the query - IE, the user clicks on "Update" and the stuff that they typed into the textbox gets...

I am trying to import data from excell into access. I am importing a small amount of data from a lot of spreadsheets (more than 700). Unfortunately, what it does, is inserts in the following format: 166 full data records (the correct data too) 79 BLANK records 1 record with data 79 BLANK...

Hello. I am trying to import data from excell into access. I am importing a small amount of data from a lot of spreadsheets (more than 700). Unfortunately, what it does, is inserts in the following format: 166 full data records (the correct data too) 79 BLANK records 1 record with data 79...

I am trying to import data from excell into access. I am importing a small amount of data from a lot of spreadsheets (more than 700). Unfortunately, what it does, is inserts in the following format: 166 full data records (the correct data too) 79 BLANK records 1 record with data 79 BLANK...

Hi~ I am opening an instance of excel 2000 with access 2000 pulling some data into the database and closing Excel. The only problem is after I run my code, excel is still running in the background (I can see it in task manager but not in the task bar). PLEASE help me solve this major memory...

Hey, basically what I need to do is copy over some data (not much) from an excell sheet into a access table. does anyone have any idea how to do this?? Here is the code I am using: Dim objXL As Object Dim xlWB As Object Dim xlWS As Object 'some objects to refer to Excel Dim db As...

I am trying to set up a database over a network using Access for forms and SQL Server 2000 for the tables. The optimum situation would have my users logon to their machine access everything off of the server - Forms Tables Queries etc.. Is there anyway that I can store the Forms that I create...

I am trying to set up a database over a network using Access for forms and SQL Server 2000 for the tables. The optimum situation would have my users logon to their machine access everything off of the server - Forms Tables Queries etc.. Is there anyway that I can store the Forms that I create...

I am trying to set up a database over a network using Access for forms and SQL Server 2000 for the tables. The optimum situation would have my users logon to their machine access everything off of the server - Forms Tables Queries etc.. Is there anyway that I can store the Forms that I create...

Hey, I have a very simple problem that I can't seem to figure out (it has been a long day). I have a string that I want to convert into an array of strings of length 1 (Chars). Is there any easy way to do this? Or is there a hard way that I am just not thinking of. Thanks in advance. Adam

I have a tool that is automatically gennerating some SQL in access to output to a graphing report. The data is performance counters collected every 5 min however, the SQL that is gennerated (shown below) averages the values for every hour. I see the AVG keyword, but whenever I try to get rid...