General

more or less than 0 or blank
Hi I have a column where I have a numbers more than 0, numbers less than 0, 0's and blanks. I would like to put in the formula in the query to calculate those numbers, but only for items more or less than 0, for those that are 0 or blanks I need to put 0 in the formula. I tried <>0, but it doesn't catch blanks... 7 Apr 2010 19:11

maximum number of indexes per SQL table that Access (jet) can deal with?
why is there a maximum number of indexes per SQL table that Access (jet) can deal with? is it really the count of indexes + statistics? I've seen plenty of documentation that states that typically DSS systems have twice as much index space as data space.. So I don't think that it's a case of 'over-indexing' I... 7 Apr 2010 18:03

Datasheet view on a form
Hi, On a form with cmd buttons and a subform that presents data in a datasheet view. When I open the form how do I make the cursor (or pointer) appear on the first record in the first column. Prensently I have to click on just any field for it to appear. And then how can I place the cursor on a specific... 7 Apr 2010 16:54

Exporting Access Report to Excel
The report I am transfering has 9 columns of numbers. In some of the columns the numbers are 3 ceros (000) or 003, etc. when I transfer the report to excel, the numbers are changed from 000 to just 0. How can I prevent excel from changing the 000 to only one 0 or the 003 to 3? ... 8 Apr 2010 11:05

Using TransferSpreadsheet Macro to import a single sheet from exce
I have an excel workbook with multiple sheets of data. I am trying to use a TransferSpreadsheet Macro to import 2 individual sheets to seperate tables in access. (I have a seperate Macro for each sheet) What is the correct "format" to identify the individual sheet in the Path? As an example the file path is:... 7 Apr 2010 19:11

IIF(AND) statement
Hi I have a number of things I need to test in the query. I need to use IIF statement with AND (for example in Excel you can do it),. Example I need this IIf (and(cat="HS",cat2="JTK",cat3="NT"),"1","2") how to do it in access? -- Greatly appreciated Eva ... 7 Apr 2010 18:03

Restore database from backup
I made a backup of my database and had to open it to recover changes that had been lost. How do I restore my backup to my original database? The Save & Save As commands only seem to save database objects to my open database. ... 7 Apr 2010 15:47

If check box changes
Access 2003 On my subform I have 3 checkboxes format Yes\No BBAll - control source BBAll default Yes BB1 - control source BB1 default No BB2 - control source BB2 default No and 2 textboxes TextBB1 - control source =DLookUp("[BB1]","[t000Facts]","[UnitID] =" & [UnitNo]) TextBB2 - control source =DLookUp("[BB... 7 Apr 2010 15:47

Problem exporting data to Excel using Access VBA
My code works fine on PCs using Windows XP. This problem only occurs on a Windows 7 PC. It worked OK when I first started using my Windows 7 PC, for a while it worked spasmodically – I could get it to work again by doing a compact and repair on the mdb and rebooting. Now it hasgotten to the place where it does... 7 Apr 2010 12:23

field Null but not Null
Don't really know how to explain this, but here goes. Have a table with fields [BLOCK], [NUMBER], and [ALPHA]. [ALPHA] can be null. These are concantenated together to form Acct# (block & "-" & number & alpha). Example, 9-152 is different account from 9-152G. I append block billing charges to a temp table for... 7 Apr 2010 19:11