Recent content by mischa

Is there a possibility to check if a ODBC link has been installed on the computer, and also preferably to verify if the connection can be established? The ODBC link that has to be checked on availability has to comply to a the following (DSN) name: Like "*" & Name & "*"

Is there a way to check if a series of action queries can be run (without any error) before actually running the queries?

Do you have any suggestions on how I could build this code?

I made multiple pass through queries that receive their data via an ODBC link which is established. Currently the username and password is entered seperately in every query but I was wondering if it is possible (and how) to make both look for the values in a table (OR somewhere else if possible)...

Thanks for the reactions! The rowsource of the combobox is: "qryLinkProductComponent_Mapics" How can I put the combobox entries in an array? (The output is dynamic) The query shows the user part numbers that are related to a specific part. These are text values and for every part it could show...

I don't know how the values can be retrieved from the combobox (Your second guess).

I would like to let vba select all (one after the other) values in a combobox and run a query. The code has to be run using a Do While Loop for which I already made the condition. The reason I want to automate this is to allow the user to quickly add new links in the database. The combobox is...

Thank you very much jdraw and Paul :D !! The CLng did the job.

I have a problem with calculating the total qty of two fields. QtyMapics: Nz([MapicsQty];0) QtySubComp: Nz([SubComponentQty];0) TotalQty: [QtyMapics]+[QtySubComp] When I calculate the values of the fields it pastes the values after each other. For example: if you have the values 1 and 2 (which...

Just solved it by using the 0 and -1 in the IIF statement. Thanks:D!

Paul, I would like to thank you again for the quick response :D. Unfortunately Access doesn't give a damn about the True/False in the IIF and still shows the dutch language there :banghead::banghead::banghead:. I am going to hardcode it (because Access doesn't get it yet) with an additional...

Thank you Paul! That worked perfectly for that part of the code. I found that the part which should return the true or false returns it in Dutch. " & (Me.lstLastTImeBuy = "Yes") & " After debugging the following is generated: INSERT INTO tblActionsTaken (LastTimeBuy, ActionDate, ActionDetails)...

Yes, LastTimeBuy is a Yes/No boolean datatype field. The comparison is due to the fact that the combobox returns a Yes or No string. With the debug code I get the following in the immediate window. All values in the code are correct and all field names are correct. When I try to display it...

Sometime ago some of you helped me figuring out how I should insert and update some values in my db. At the end it functioned perfectly. Recently I deinstalled Access 2013 and installed 2007 because of the unavailibility of certain functions. I dont know if this caused my following issue but...

No that would be a to big of a hassle. I just used a criteria that filters all and used it in the update query. It now works perfectly. Thank you Namliam and Paul!