Search results

Thanks I had 2 small errors that I fixed and all is well now.

I have a database that I tried to make a ACCDE file with but I am getting an error about 2 many ID's. It was suggested that I make a debug module to run with the database to check it. Can anyone point me in the right direction as to how this would be done.

I did find the answer to my last question above regarding copying the structure only for the tables. Can anyone help me with the module that needs to be created for debugging. I really don't know where to start with that for debugging the entire database.

Thanks I will need to read up on modules. I am new to this and don't know how to make a debug module for the database.

1) I am trying to make an ACCDE file from my existing development database and I am getting and error message stating it can't do it. When I select help from the little menu that appears this is the message. This error is usually associated with compiling a large database into an MDE file...

I tried both suggestions with the same error on the 1st suggestion. The 2nd one which was from "vbaInet" gives me the following VB Script error. I brings up the debug and "Run Time Error 3061 to few parameters. Expected 1" For Each varItm In Me.List9.ItemsSelected strIn = strIn &...

I have a string in my code that keeps getting a code 13 error message when I run from my form. The form has a list box that displays and index field called testdetails_id which is an auto number field in testdetails_tbl. The 2nd field is called drawings which is part of drawings_tbl and is a...

No the field is an autonumber. The query that the listbox gets it info from is as follows. There are 3 tables linked in the query, drawings_tbl, Test_tbl, TestDetails_tbl. The list box works fine and allows me to filter the records for a Test and then select the drawings I want to remove from...

Thanks I added the code and changed the respective areas but I am getting and error 13 message with this part of the string. strIn = strIn & Me.List9!TestDetails_id & "," I am curious if it may have to do with the fact that there a multiple fields in List9 including TestDetails_id.

Try using this in your query under the criteria for the column you want to filter with your combo box. Like IIf(IsNull([Forms]![YourFormName]![combo5]),"*",[Forms]![YourFormName]![combo5]) Change the name of combo5 to the correct combo and the YourFormName to the correct form.

I have a form that I have create that has a list box set so that I can select drawing numbers from. I want to be able to delete those records from a table. I have the following code that I have placed in an event procedure On Click but it gives me this message when I try and run the code...

Figured out my mistake. In the select statement for the combo box it was trying to send the id field instead of the data field. Working good now.

I have a query that takes multiple arguments sent from a form. The following line show the number of these arguments. Like IIf(IsNull([Forms]![Weldstatus_frm]![combo10]),"*",[Forms]![Weldstatus_frm]![combo10]) "this selects the Project" Like...

Funny how when you get an answer to one question you find by working things a bit you get answers to many others. Your answer opened all kinds of new things for me. Again thanks.

Thank you this will be a big help.

I have a query that is made up of multiple tables. The data displays fine but I need to be able to create a form that will allow me to select only certain records from the query and then update another table with those records. Thanks in advance.

Hello all. New to the group.