Search results

I want the full description text box to pickup the value from cboPress. I don't want the user to have to click on it though. I have tried using the selected property but couldn't quite get it to work. How can i achieve my aim? I have attached my example

Nothing is being updated What is wrong with this code?: SQLstring = "UPDATE [Product List] SET [Full Description] =" & [Forms]![frmChoose]![subChoose].[Form].Controls![FD] & "WHERE [Part Number] =" & [Forms]![frmChoose]![subChoose].[Form].Controls![PN] & ";"

I have created a button on one of the forms in my database that works perfectly on my computer under my admin login. It also works perfectly on my computer under other users logins. But if I try on any other computer on the network even with my admin login it doesn't work. Each computer has...

I want to restore my secure databse from yesterdays back up tape. Can I simply overwrite the mdb file with yesterdays keeping the same name. Will the secured mdw file still be able to open it. Or do I have to replace other files too.

I've just accidentally deleted records from a table in my database because I didn'r realise the tables were linked. How can I restore this data. Aaaaaargh

I have a field in my table which is a memo type field. However it only holds 255 characters. Why is this? It may have been a text field before I changed it to a memo I cant quite remember. Would this have anything to do with it?

Does anyone know of any web sites where you can download good looking form templates??

I have a secured database in which I am the administrator and I have all necessary permissions. But when I try to link to tables in this database from another secure database it says I don't have the necessary permissions. How can this be??

I have a secure database which is currently used by 5 computers on the network. A new computer has just been added to the network but I cant seem to get into the database from it. The User Name and login part comes up but when I enter the new users details it doesnt recognise them and doesn't...

I have a continuous form. If a records urgent field is ticked true then I want that record to be displayed in red text. I want to keep the continuous form. How can I do this??

My Query: PARAMETERS [Forms]![CurrentList]![ListID] Text ( 255 ); SELECT Join.*, Join.ListID FROM [Join] WHERE (((Join.ListID)=[Forms]![CurrentList]![ListID])); I then want to make T a recordset based on this query in my code: Dim d As Database Dim T As Recordset Set d = CurrentDb() Set T =...

Each time a user enters a new record I want to automatically generate the next consecutive number. I want the format to be - T-0001.......T-9999. What is the best way of doing this?

I have created a database in access 2002. Some people in the office who want to use the database have acces 97. How can I allow for 97 and 2002 users to use the same database??

I'm the following function in the control source of a textbox on my report: =DLookUp("Specs","tblAssys","ListID = [Forms]![CurrentList]![ListID]") I am trying to display Specs from table tblAssys where tblAssys. listID = the value of ListID text box on the CurrentList form. I'm getting an...

i ahve a form based on the following query: SELECT DISTINCTROW tblassys.Specs, Join.* FROM [Join], tblassys WHERE (((tblassys.ListID)=Join.ListID)) And (((Join.ListID)=Forms!CurrentList!ListID)); Specs is a memo. The text box for displaying Specs on the report has can grow and shrink set to...

I have a text box on my from for displaying specifications in the report footer. Example of Specs: THRO' BORE:- 4.250" WORKING PRESSURE:- 5,000 PSI TEST PRESSURE:- 10,000 PSI SERVICE:- H2S & STD UPPER CONN:-6-1/2" OTIS FEMALE QUICK UNION LOWER CONN:- 6-1/2" OTIS MALE & COLLAR QUICK UNION...

I'm trying to import a form from one of my databases into another. I am the administrator and I have given my self all permisions but when I try to import anything it tells me I don't have the necessary permisions. Whats that all about?

I've just added the following code behind a button. The code works but a message box appears saying "This action requires an object name argument" Forms![Product List1].Visible = True Forms![Product List1].Requery Forms![Product List1]![PartNumber].SetFocus...

My database keeps coming up with module not found and when I click the help button I get the following information: Modules aren't loaded from a code reference — they must be part of the project. This error has the following cause and solution: The requested module doesn't exist in the...

I have copied forms and tables from one database to another. The problem is that in the new database the same line of code isn't working as it was in the old database. The code is: Dim d As Database The new database doesn't recognise the Database class. Database doesn't appear in the class...