Search results

This property is set as you say...

Still greyed out!! Any ideas? Thanks a lot!

Hi, It is greyed out! I have tried changing a few of the settings, but it's still greyed out. Please could you help, Roly

Hi, I have setup this database with two tabs on it, but when it opens, it does not open properly, as per the attached screenshots. I have tried a number of properties , which haven't worked. Is there a way top sort this out, with code if not a property? Thanks for your help, Roly

Hi, You can't do that - it's very dangerous because you could knacker your data. It's also unnecessary data to have data duplicated and makes the database larger and slower. You should just run queries that take the data from both tables - it's much safer and quicker to run. All the best, Roly

Hi, The database has been protected by whoever wrote it - its quite standard practice. You need to ask the person who wrote it - there is probably a password aswell. All the best, Roly

Hi, Is there a function in Access similar to the SUMIF function in Excel. I would prefer this not using VBA, but if there isn't VBA will be fine. Thanks very much, Roly

Hi, Is there a way on Access that when a total is calculated using an expression on a form that it could update the table itself with that total? Thanks for any help! Roly

Hi, I am having problems with a DLOOKUP expression in an update query. I have set up a lookup table (imported from Excel and another table set up myself because of this error) with a date field and a week number field and I am trying to return the week number into another table for the date in...

Hi Michael, You can save the ODBC password in Access when you link the tables. On the Link Tables window there is an option to save the password in the bottom left hand corner. This is good because it only allow access to the tables that have been checked. If somebody tries to link other...

Hi, I have created a database that monitors containers that are being hired. When a container is hired some details are entered and remains the same until we receive an invoice to state that the hire has stopped. Subsequently, the database is updated and an invoice sent. The container is...

Excellent - thanks for that (very simple wasn't it!!). All the best, Roly

Hi, I have a problem with a table that has number formats setup as usual - #,##0.00;(#,##0.00) and formatted to 2dp. However when inputting say 1.58 into the table it will round to 2.00 and does not show any decimals except as .00. When I remove the number formatting and set the decimal...

Hi, In Access 2003 when you rename a table any queries that the table is in will be renamed aswell, which is usually very useful. However, is there a way to turn this property off, because I am trying to run over a hundred of the same query that use different tables? In Access 2000 I renamed...

Module / VBA Question Hi Mames, Have you tried a parameters box in the query, or does this spoil other parts of the database? I can't help you with VBA coz I have only jsut started and am rubbish!!! Good luck, Roly

I have the same problem Hi Dutch Wolf, Have you managed to get an answer at all? If I do, I will let you know. All the best, Roly

Hi, I have setup a new database that accesses an ODBC database which requires a username and password. Because the database is for basic level users, we do not want them to know the password. The database can be programmed to use the password in the background, but having very very basic...