Search results

Can anyone tell me if the following is possible in a table or do I need to use a form. I have a check box in a table that when I check it I want it to automatically enter the current date. I also don't want to change the dates that have already been entered manually and that date should only...

Can anyone help me create a query to do the following: I have to fields in a table and want to create a thrid field depending on the values in the other two. What I need to do is select all the values from column2 and all the values from column1 when there is no coresponding value in column2...

I am currently working on a database which has links to two other databases both of which are password protected. The problem occurs when the main database needs to access data in the others as it prompts for their passwords to be entered. I was wondering if anyone knew a way to automate...

I have create a vb script that creates a new empty database when a command button is clicked. I have then created macros to populate the nwe database. Is there any way to set a password automatically for this database after the new tables have been generated, without the user having to set it...

I am trying to create a make table query that extracts information from another table based on its year and month. The problem I am having occurs when it comes to selecting data across multiple years ie. April 2005 - March 2006. The table that contains the data has two fields that are year and...

Can anyone please help me, I currently have a series of queries that are called by a macro, these create a number of tables. But when each query runs it provide a prompt stating what it is doing, my question is can these be stopped so that the queries run without a user being present. Thanks

I am having a problem with an access database that is connecting to a sql server. When trying to run any queries it is very slow. I think the problem might be caused by the ODBC link and I was wondering if there are any alternatives to using ODBC to connect access and sql.

Could anyone tell me if indexing a table in sql server will have an impact on performance of the access frontend that contains links to the sql server.

I am having problems trying to create a new table in an existing database I am working on in Access 2002. When I try to save the new table I receive an error message saying 'Invalid Argument'. I have checked if the database is locked but can't find anything to suggest that it is. Can anyone...

I am creating a database to log faults with a system. I have created a form which allows the user to enter the details of the fault. But I also want to be able to display information about the location of the fault on the same form when a selection is made in the combo box. For example I have...

I want to filter the information displayed on a form using the values I select in text or combo boxes. I want to filter the form using one or more of the following options. Call Ref - text box Location No - Combo box Area - combo box Status - combo box The combo boxes are taking their values...