Search results

Thanks for your reply RuralGuy. Thats want I would like to happen, but I will have to get my boss to approve this as I think he was hoping that I could implement it without the use of forms for some reason :rolleyes: Eventhough it would be the wrong way to set it up is there a way to do it in...

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...

Maybe that didn't sound right. It works better than how I orginally thought it would work when I was just starting to design the database. Once again thanks for your help.:)

That worked raskew and gemma. Thanks for your help. It works better than I could have hoped for.

I managed to get the query to work by typing in the criteria such as Between #01/04/2005# And #01/03/2006# But because I need it to select the values from the form I used the following code. But it seems to produce the wrong results. Between [Forms]![frmSelect_Dates]![txtStart] And...

Currently the data in the tables only goes by month and year but there is no record that is specific to a day. I have got the query to display the date in the format "DD/MM/YY" but how when I put criteria in I still get values that are not within the specified range. How can I solve this?

When I check the show option it returns an error message but the error does not appear when it is not checked. Is there any way I can show the values so that I can be sure it worked correctly?

When I enter the new column details do I place =datevalue in the field name of the column also what should I select for the total e.g. Group by. Thanks

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...

Thanks for the help, that done the trick.

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

The queries link quite a few tables one of which contains approx 12,000,000 records.

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.

Sorry to bother you again. But I am still working with this database. I was wondering if there was any way to create a macro that when a command button is pressed it brings the user to the hyperlink window and automatically displays the folder which contains the scanned documents. :rolleyes:

OOOOOOpppppppppss!!! Sorry, I think I was convinced that it was something else at that point. :D

The import solved the problem, the database size has been reduced and works alot quicker. I just have to now change the forms to use a hyperlink instead of the OLe object. Thanks for all your help and advice :D If I have any other problems I know who to ask. :cool: