Search results

Thanks IMO!!! By the Way! Thankyou for your help IMO. It was the most helpful reply i've ever had on these forums!

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 made the text box plenty big enough for the amount of text. There seems to be a limit to the amount of characters even though I have made specifications a memo.

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 tried it and i get the same message.

i tried putting in the message box like u suggested. It gave me the correct value from the subchoose subform on the frmchoose table that I wanted. It then opened the product list form at the correct record but still came up with the same message. Any other ideas??

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

After the error notice I also get this information. The form name 'Form1' is misspelled or refers to a form that doesn't exist. If the invalid form name is in a macro, an Action Failed dialog box will display the macro name and the macro's arguments after you click OK. Open the macro window...

Any other ideas Anyone know an easier way of fixing this. I'd rather not have to move everything to a new database.

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

I want to create a union between two tables but one of the fields I want to include is a memo. An error comes up saying I cant use this type of field in this query. What can I do about it?

Sorted I have sorted the problem! After hours of trying different things with the code it turned out that it wasnt working properly because I had a blank record in my part codes table. Unbelievable but atleast its sorted. Anyone explain why this stopped it from working properly? Thanks...

Jon K! Can you try typing a completely different code like qqq and see what happens!

Thanks for going to all that trouble! I'll try making a new form and using the same code and I'll let you know how i get on!!