Search results for query: *

I have an Microsoft Access update query that I run each month with no real issues. We download data from our mainframe (we are a bank) to excel. The excel worksheets are then used as linked tables to update parts of the access database. The only problem is when something becomes blank...

I have several MEMO fields in my access database that are being truncated at 255 characters in Crystal reports. These are very long fields with data typed by users. We use them as reports to managment to show progress in problem loan resolution. Field Explorer shows them as Memo fields. Can...

I need a form to always open with a certain filter applied rather than the last filter applied. I wrote the filter in advanced filter/sort and saved it as a query. I have tried two methods to define the query as my filter. I used the Form Property Sheet and tried the <Advanced Filter/sort>...

I am trying to conditionally format an entire row in Excel 2007. This used to be easy in 2003, but I cannot make it work in 2007. I am trying to change the color of an entire row based on the value of a cell in that row. My formatting formula looks like this: Formula: =C6:C44="city name”...

I have a long running database that failed this month on my delete query. I get error 2950 when I run it from within the macro. But I have the file and the network location trusted and all macros are trusted. When I step through the macro and when I run the delete query alone, I get "could not...

I have a long running database that failed this month on my delete query. I get error 2950 when I run it from within the macro. But I have the file and the network location trusted and all macros are trusted. When I step through the macro and when I run the delete query alone, I get "could not...

I have a SQL expression that is not returning anything like what I expect. The database contains loan data. Some loans are in relationships and others are single loans. I am trying to get totals of the relationships and select records based on the SQL expression. My expression is supposed...

I have an Access database that tracks all loans secured by marketable securities. I have a five fields in the client table that are look up fields that refer to the stocks table. Access created multiple shadow copies of the stocks database in relationships. I set the joins to outer joins with...