Search results

Tried opening the database on several other machines and it still does not work tried access 97/ 2000!!

I tried to create a new database and import the data but I receive the same error message about the unrecognised format?

I am attempting to open a database created in Access 97. The database was working fine yesterday however when I have come to open it today I am receiving an error message that reads incorrect format file is not an MS Access file. Windows has associated the *.mdb file with the file but will not...

I have been working on my database recently and there have been no issues. However, today, I have logged into the database ad have attempted to import a file into a table, a process I do every weekend, and I get the error message 'Cant Access. Database or object may be read only'. I havce...

Cheers. As you replied to this another colleague provided the same information. This resolved the problem with the database. Many thanks for the reply.

Urgent Help!!! Corrupt database Hi guys. I was recently working on my database, performing a delete query on some data within a table. When running the query an error occured and my machine froze. I went into the task list to see what was active and MS Access was listed as not responding. I...

I have created a combo box that contains a list of customer numbers. Upon clicking ont ehcustomer number I owuld like the other data such as the customer forename, surname, etc, to populate the corresponding text boxes? I cannot seem to do this though on my form any ideas? Thanks

I have created a query in access that appends data to a table. Once the data has been imported into the access table a pivot table is created based on the data contained within the table. However upon displaying the results in the pivot table the total of the values (that is the actual values...

Does anyone know how to create a simple login form using a range of textboxes and forms. It does not have to be anything fancy just a form that allows the user to enter their username and click on a button that directs them to a particulat form? I keep getting errors! Its late and I cant think! Help

Thanks rich that worked great!

I have used the first piece of code you provided me with and that worked well. However, is there anywy of preventing the formopencoomand was cancelled from appearing on the screen, and also is there anyway I can prevent the form from opening and instead just display and error message? What I...

I have created the table tbUserName as requested by the error message. I have created three columns Username, Password, and group. I have populated the fields but I still receive the same error messages, any ideas? Thanks for your help

Can you not use the security wizard on your database to create a simple login window? I have tried using the wizard but keep getting an error upon adding users. The error reads cannot setfocus on table tblUserName? Any ideas

Thanks for that Bill. Say I was to have two types of user 'student' and 'admin' and wanted both to log in then initiate the code you provided how do I go about doing this? Many thanks

Is there any way in which you can create two accounts on your database one for user one for admin, hiding certain buttons, or locking the buttons if you are not an admin user?

I have developed a form with several buttons that contain underlying queries to query data in a table called tbl_Book. One of the queries searches the table for an authors name if it finds the data associated with the authors name it returns the result in a form created for that particular...

If I had a table with a column named keyword. An for each row within the table in the column keyword I had more than one word such as computer networks, tcp ip, ETC. How would I construct a query to find a match on any of the data and not just the first item in the column?

If I wanted to place a validation rule on a table for ISBN with the typical format being 0-12-11111-9 how would I go about setting this rule in my table design? Thanks

When building the WHERE condition in the SQL do I place the condition on the underlying query or do I base it on the field in the report? The query underneath currently prompts the user for an input. I want ot change this so I can specify it for the user. Thanks

Does anyone know how I can write a macro that runs a report, that is based on an underlying query, that usually requires an input, but instead of prompting the user I wasnt to automate it for different values. The report is Reports!repAVR4!Pubcode - where pubcode is the value I want to change on...