Search results for query: *

Hello, I have been tasked with reviewing a whole host of databases. There are about 70 databases which i need to review. I need to analyise all aspects of these databases. This includes all the field names in each table as well as the field names a description of the format and attributes of...

Hello, This has got me stumped. I have been asked to amend a database very simple chance i just have to add a single field to a couple of tables and forms. But i have noticed that i am unable to use the database window while i have a form open. I am finding this rather strange. It is something...

Hello, I am trying to write a macro that will check to see if a text file is less than 7 days old. If it is to open the file. The name of the file is fixed and is created though an automated query on a database. The file output is a pipe (|) delimited text file. The file is called. Cluster.txt...

Hello, I am trying to create a macro that will copy a different macro in workbook1 to a named sheet in another workbook. e.g Workbook 1 Contains Sheet1 Contains MacroA Workbook2 Contains Sheet1 I need to write a macro that will copy Workbook 1 Sheet1 MacroA and place it in...

Hello, I have added a button on to a toolbar in excel through the use of a macro. I would like to remove just this one button from the curtom toolbar. I have used the following code to create the button on the toolbar and the second sub is to remove the button when clicked. Sub...

Hello, I have added a button on to a toolbar in excel through the use of a macro. I would like to remove just this one button from the curtom toolbar. I have used the following code to create the button on the toolbar and the second sub is to remove the button when clicked. Sub...

Hi all, I have code that will run through all the open spreadsheets and make a check on them. When a sheet Fails i want the code to pause while the operator has change to close, save & close the spreadsheet or to make amendments. I would like to resume the code from where it paused through the...

Hello, I would have searched on this but the search is not on at the moment. I need a way to return the number of open worksheets in MS Excel. A user will open any number of workbooks and i just need to this number to perform a loop to unprotect each of the spreadsheets open. Thank you

Hello, I am trying to find the name of the 1st sheet in an Excel workbook. Currently i am opening several excel spreadsheet and need to be able to id the 1st sheet of each one and for it to select that sheet. e.g Sheet 1 in a default new spreadsheet. Thank you

Hello, I have been tasked to produce a pipe delimited file to update a database. Currently the information is received in excel format and the database will only accept pipe delimited. Since several people work with comma and pipe delimited files i would rather not have to keep changing the...

Hello, I have got a form with 2 Combo boxes. ComboA gives a company name. ComboB gives the account number. Each company can have more than 1 different account number. Upon selecting a company the list of account numbers associated with that company is displayed. The Company and Account No are...

Hello, I am looking in to developing a booking database. I would like to look at some allready designed databases to look at how they were developed and packaged. I would like to build a database capable of being used on the web to book a rental home. I would like to be able to calculate the...

Hello, I have a database with a table called date. In there is every date from now until 2007. I have another table called booking which i will populate with data. Reference numbers, Start Date, and and End Date. After which i will click a button to search the records and for each date in the...

Hi all, I have got 2 tables in Access both require to be linked by date. In the dataTable the date is in the format dd/mm/yy hh:mm:ss format. The dateTable uses a date in the format of dd/mm/yy and nothing else is stored on this. The dataTable i have no control of it is an automated file sent...

Hello, I am trying to get a database to start up in a manner that all users of the database will have the locking set to the same settings. I would have done this with the security wizard but they do not want the database secured. The users have quite a large lack in confidence using the MS...

Hello, I have an Access 2k database running on a windows NT operating system. On a fairly frequently cycle this database stops all users from entering any new data to the database. This also stops the main table from being viewed and all design changes. I have checked the record locking options...

Hello, I have a large database on a network server with approximately 20 people accessing it. The database was developed on a Windows NT Operating system in Access 97. Until now the database has worked fine. Recently we had a new starter for which a new PC was purchased. This PC is connected...

Hello, I havev written a query for a database. The query is to look at records created today. The design of the table is such that when a record is completed that the date and time is recorded in a field called "date raised". In my query i am trying to find only the records created...

Hello, I am using an Access 97. There is a form within the database whic is based upon a query which just gathers together data from 2 different tables which are linked via an Id number field. When a new record is created a message appears saying "You are at the end of the recordset&quot...

Hello, I am working on several databases and as such do not need them to go throught their startup sequence when opening. I would like to be able to go straight in to the database to and see nothing but the Database window to start with. I believe that there is a /command that i can use...