Search results for query: *

Simple problem except I can't work out how to do it. I've a date field on a form. The subform data is linked to that date. I want the user to be able to change the date but only explicitly by clicking a button, being prompted to enter a date, then entering that date. The button should then...

The same form is used for entering records, viewing records, editing records and deleting records. The user is also able to select various subsets of records by double-clicking on query names in a listbox. I want to stop "ghost" records being created. At the moment if there is an empty...

I've done a search for this in the forum but can't find the exact answer. All I want the piece of code to do is to tell me if the query returned records. I've included my code below. At the moment it runs fine if there are records to return however it produces the following error if there are no...

I've got a query that is used as the data source for a form. However if the query returns nothing the form is completely blank - i.e. no controls appear at all. How do I ensure that the query returns at least one record, even if that record just has something in a calculated field (e.g. the...

I've been going to hell and back with this one. I've got a form that I'm using for data entry. Users enter data and then press a "Log Case" button to enter their userID and a timestamp. It is not essential that all cases be logged straight away but it is essential that a user be prompted to log...

I've got a table that I want to get information from. Within the table there are five fields that need to be queried. However, the user should be able to disregard a parameter if they don't care about that field. It is a simple database that I'm setting up for someone to hold some very basic...

Hello. Is there a way to allow the user to leave all boxes unchecked in an option group?

This problem involves three databases: DB1 = data only. This db contains 7 tables and nothing else. DB2 = anything except data. This db uses linked tables (linked to DB1) and contains queries, reports, forms and code and is used for entering and viewing data. DB3 = similar to DB2 except it is...

I had thought that this would be a simple thing to do but I can't find the answer to it anywhere. I'm working on a form that has 10 or so fields. After data has been entered the user presses a button to log that data. There is code behind the button that checks the data entered for completeness...

Hi. I've made a copy of an Access 2.0 database and converted it to Access 97. A particular report now refuses to run - the offending lines are the following... ReDim Preserve li_PAmount(li_POS) As Double ReDim Preserve li_AAmount(li_POS) As Double ...and further down... li_PAmount(li_POS) =...

Hello. I am developing a database that will be used again and again on a yearly basis for the same purpose, however a fresh database will be required every time. As I see it there are two ways to go. 1) Make a copy of the existing db (which can then be archived) and then delete all data in the...

Is this possible? I've got a report whose source is a master query based on a number of subqueries. If any of these queries returns an empty recordset the master query also returns an empty recordset. In cases like this I'd like the subquery to instead be forced to return the value...

Hi. I've searched the forums for an answer to this but I couldn't find one. I've got a subform that displays continuous forms depending on the content of a text box in the main form. To my mind it is so simple that there is not much that could go wrong with it. However, one of my colleagues...

Hi. I'm having a problem with a date/time field. For some reason it is reversing the dates when they are entered, for example if you enter the date 24/04/2002, it stores it as 02/04/2024. I simply cannot work out why this is happening. Fixing it isn't a problem per se as I can just create...