Search results

Simply speaking, I have a development FE. . . a production BE. . . and the production only means that the BE tables are optimized table designs full of data for reporting, and the reports are run out of a reporting FE. . . The BE data population is handled by another FE database, which links to...

Let me rephrase: I have a front end on my laptop, and a backend on an external ESATA drive. I have many tables attached from the ext ESATA drive, which holds the production tables prior to loading to SQL SERVER If I create a new development table in my front end database, with 15 fields and 1...

Everytime I close, open, modify, etc, you get my drift, either a linked table or an in database table, Access validation takes minutes before I can continue. What can I do to reduce this time or process? thanks sportsguy

I have linked an excel spreadsheet within access, and a particular field is formatted as data. If one of the column cells is MT, (empty), then the view returns #num error. Question is how to trap that error to convert to a date or null, or something else? thanks in advance. . . sportsguy

I have an append query from an SQL Server db to a local table, three fields, one key field in each, and 20,000 records takes about 30 minutes, with the database alternating between not responding and running every 5 seconds. . . . . my XP machine would have this done in less than 1 minute my...

Answer is: Option Compare Database Option Explicit Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Dim ctlBox As Control ' Change color to Grey for all prices which equal Zero For Each ctlBox In Me.Detail.Controls If ctlBox.ControlType = acTextBox Then If...

I am trying to color all controls which have a value of 0 as grey, to be less obvious to the observant's eye, and the remaining controls with the values greater than ZERO as black. . . ctlDetail.Value = 0 doesn't work, what am i missing?? Private Sub Detail_Format(Cancel As Integer...

I am having the same problem with Access 2007 and windows 7 x64. With the task manager open, i see that the database is reading the table records into memory, and while access is performing that function, or so it appears, access shows Not responding. I am staring at this right at this moment...

I have been using access for over twenty years, and I am stumped at this one. I have a query with a table, with several FK fields, and a total, two where clauses, and a sum >=25000 run the query, all is fine I link a FK to an attribute1 description table with key field, equal join run the...

Function vbAnd(expr1 As Boolean, expr2 As Boolean) As Boolean If expr1 = True And expr2 = True Then vbAnd = vbTrue Else vbAnd = vbFalse End If End Function Function vbAnd3(expr1 As Boolean, expr2 As Boolean, expr3 As Boolean) As Boolean If expr1 = True And expr2 = True And expr3 =...

I guess it would look like this: Function vbAnd(expr1 As Boolean, expr2 As Boolean) As Boolean If expr1 = True And expr2 = True Then vbAnd = True Else vbAnd = False End If End Function sportsguy

greetings everyone from new england where we will get the second significant snow storm since oct 31 last year. I want to write a vbAND function for access which works like the AND(condition1, condition2) in excel. But before I start, does anyone know of one already written? the query...

when a very large append query gets an error, where is the data prior to being populated in the destination table? all the databases are the original size in explorer, and I am just curious. thanks sportsguy

While repairing and compacting on close, I get this error message more so recently. I am wondering if its corruption, or disk issues or anyone have any ideas? thanks in advance sportsguy

Queries result in Not Responding, Access databases which were populated by XP were copies onto a shared drive for Windows 7 64 and Access 2010 for testing, and Access 2010 queries seem to blow up , access goes to not responding state. What am i missing? thanks sportsguy

I figured it out, though its kind of different than the example given. the IN(query) selects the customer account numbers, based upon the top 30 ranking of the netdiscounts, without a join. Maybe beause I don't read query language in bullet form that I can't properly interpret the solution...

Here is a picture of the query, attached I want the top 50 ASC order NetDiscounts by CUSTOMERDISCOUNTS.strDistricts NetDiscounts are negative sales My SQL criteria is: In (Select Top 50 [NetDiscounts] from CUSTOMERDISCOUNTS Where [strDistrict]=[CUSTOMERDISCOUNTS].[strDistrict] Order by...

I have 140 sales locations in 10 regions and 3 operations. I am printing net discounts by each location's customers, in descending order of most discounts. I want to stop at 50 for each location, as some locations have 10, others have 500. . . I have a running sum of 1 in the detail, so when...

I get the overflow error with no zeros in the data for the std dev any suggestions?

i found the answer: the enumeration is not accurate, Instead of acSpreadsheetTypeExcel12, i used 10 and all works fine. . there is an undocumented feature with the Access07 enumeration! sportsguy