Search results for query: *

Not Sure if this is possible, but i have a form with a list box on it. The record source for the list box is from a table. Is it possible to select one of the rows in my list box and then delete using a command button. When i say delete the record in the list box, i mean to delete the...

Merry Christmas All. Thanks for all your help over the past few months. I couldn't have done it without your help. Have a good one. Anthony

Hi all, I have a database with a query i have to export weekly. The query has 10 fields:- ULI Learn_ID Provi_id LSurname LForenam and so on. However when i export the query the ULI field is blank and then three days later i will receive a file which has the following fields:- ULI Learn_id...

Hi all, Was wondering, i have a report based on a query in which i enter parameter values which are dates, and if i open the report if there is no data, i can have a message that says there is no data in this report or report is null and then cancel opening it? Also is it possible to have my...

Does anyone know when Using Access 2000 - Why when using parameter values your are asked to key them in twice and how to stop it if possible? Thanks Anthony

Hi All, I have a form with a list box which the control source for the list box is a query. Is it possible to delete the selected row from the List box from clicking a command button. I have looked at the commands available but none of them seem to be able to do the task. Maybe it will need...

Hi all, Have asked this question before but have had a bit of trouble wording it, so bare with me please. I have a form with several fields on, Surname, Forename and Learn_id. When I enter a surname and forename the names are concatenated and placed into my Learn_id field. e.g. Anthony Webb...

Hi All, I have a field which currently combines the the first four letters of the surname and the first letter of the first name. However on certain names they include ' symbol. Is there any way when concatenating two fields to remove the '. Thanks in Advance all Anthony

Hi All, I was wondering if it possible to populating a combo box with the names of my queries? The user would then be able to select the query they want from the drop down. If it is possible would there be any way of automating it so if a new query was added it would automatically appear in...

Hi All, Am not sure if what i am after is possible, but here goes. I have a form with a command button which runs a query. In the table whichi is the data source for the query i have a field called ExportDate. I was wondering if it is possible that when i click my command button to run the...

Could anyone please tell me how to count the number of records in a group on my report and insert the total into the group footer? Thanks in advance Anthony

Hi All, I have a query and one of the fields is called DateOfExport. I was wondering if it is possible that when i run the query if it is possible to populate the field with the current date. Thanks in Advance Anthony

Hi all, When you open a database you can skip opening forms by holding down the shift key. Is there anyway to prevent this? Thanks in Advance Ant

Hi All, In Access 2000 when exporting a query it is possible to set up an Export Query Specification. Is there anyway to export this query specification to a *.txt file through the use of a Macro or code for use from a command button, or can anyone point to any helpfull articles that will be...

Hi all, Was wondering, is it possible to refuse entry to a record if it is already open on another machine. Don't want to use Lock Edited Records as i don't want anyone to be able to get in to the record in the first place. My Database is made up of forms without any subforms and navigated...

Hi All, I have a check box on my form which is bound to one of my tables. I was wondering if when i open a form, it is possible to automatically check the box? Thanks all Ant.

Hi All, Is it Possible to do Conditional Formatting on a Query. Thanks Ant

Hi All, I have a text box and on the After Update Event i have code which brings me up a message box if the text is entered in the wrong format. However after my message box has been displayed i would like the text in my text box to be deleted. How can i do this? Thanks in Advance All Anthony

Hi all, I have a Macro that displays a message box saying "PostCode in Incorrect Format" and i would like this to be displayed if someone puts in a Postcode that is not in the format: LLN NLL or LLNN NLL or 99999999 or 00000000 L = Letter N = Numeric Thanks for Any help Ant

Not sure if this is possible as i haven't heard of it being done before, but what i was wondering is, is it possible to run and then Export by using a command button? Thanks in Advance all Anthony