Search results

I have a query which runs perfectly, and has an average price calculation, total / units, where units are always greater than 0. As soon as I enter the criteria average price is greater than 12,000 and less than 200,000, the query gives me a divide by zero error. . Access 2007 running on...

I had to rebuild the query from scratch in the new database. . . works again. . . works now. . . though must be some sort of corruption. Have been meaning to productionize this database so that its fully button operated with all coding. . . partly done now. . . thanks sportsguy

INSERT INTO FINISHED_EROSION ( strDistrict, CommonName, strProject, System, prjDescription, Family, Product, CommonProduct, Promo, Project_Start_Date, Finished_Date, Project_End_Date, Finish_Period, Customer_Number, BillTo, SalesType, Scope, ExpandedVM, Face_Price, Total_Actual, Total_Original...

Copied the SQL text from the "corrupted" database and pasted into a new query in a new database with minimal code and the one form and one query other than this query. still get the same answer. . . 3125 - ' is not a valid name. Make sure that it does not include invalid characters or...

Error message is 3125 - 'apFINISHED_EROSION MTD' is not a valid name. Make sure that it does not include invalid characters or punctuation and that it is not too long. I have saved the query with different names, the query used to run, now it won't run no matter what way i try. . . Access...

depends upon the size and age of the company. I fill in with access where the oracle and SQL server programmers take forever, their queue is full, or I need this in a trend by month for 36 months, whereas the transactional programmers dump monthly transaction reports, and programming three...

What is the proper syntax to set the backcolor to #FAF3E8?? Private Sub GroupFooter7_Format(Cancel As Integer, FormatCount As Integer) If Me.ftrQuota = "Bookings" Then Me.Box30.BackColor = vbWhite Else Me.Box30.BackColor = vbYellow Me.Box30.BackColor = "#FAF3E8" End If End Sub...

hmmm. . . with everyone's desktop under a different user/logon name, or can access call the bat file file, and pass parameters somehow? I won't know where they will put the server backend locally. . . the issue is that mgmt doesn't want the users to have to click any type of security buttons...

When I release my small database application into corporate usage, the database will be creating a local back end, and has two server repositories which it will pull and push. Most will not have any folders marked as trusted, and certainly not if they put the database on a local server, and all...

The field format is set to Currency, Standard , 0 decimal places, the combo is set to Currency, Standard, 0 decimal places, the tables are set to Currency, Standard, 0 decimal places, the combo list drop down shows 2 decimal places, how do i get rid of the decimals? thanks sportsguy:confused:

I am using ADO to connect to an access 2007 database and retrieve data. I am repeating the process for different query extracts on different tabs. the VBA code is in a module and all other queries work. This query doesn't work due to syntax, and i have tried three ways, and none of them work...

ah, no. . . i fiddle with everything to learn. Disconnected my Boss during a departmental video conference, had to get IT to reconnect. I asked IT why isn't the connect directions in the operations book, IT said the book is too big. . . so they just pushed buttons like i was pushing buttons...

I restarted the COMPUTER, and that fixed the issue. Not sure what was unloaded, but all is ok at the moment. thanks sportsguy

editing forms and testing code. everything worked fine until i fooled around with the references. however, all the references are loaded. . .

new database, same inability to look at control properties. . . thanks for responding, today is not going well. . . sportsguy

Many, many times

I lost the ability to view and change form control properties. I don't know how or why this has occured. For the anal retentive, when I click on the ribbon Properties, nothing happens. Does anyone know what i need to do to get form controls' property box to show up? thanks idiot sportsguy

I have a database which was non ANSI92 compliant. I imported some linked ODBC tables and linked some ODBC server tables to my access 2007 database, and now the ANSI92 compliant box is checked and grayed out. Any query with LIKE "*" does not work. Is there any way to get that ANSI92 compliant...

doesn't matter why i want to delete so many records, they have to go. . putting it in a macro and setting warnings would be faster, i agree. However, wouldn't access get 50% of the cpu (1 of the cores) instead of just 1% every couple of seconds? i get 50% utilization on certain append...

I have an Access database delete query going against a linked table on the same pc, and I am trying to delete about 2 million rows, and when i look at windows task manager, access gets only about 1 - 2 % cpu time every couple of seconds. . . . i defragged my disk , but i only have 11g of 60 gs...