Search results

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!

Didn't think of that option:banghead:, but I can run it after my append query. I'll give it a try. Hope it works. This would not be possible because in my database I have an almost infinite amount of options which could stand before the 'to'. I used 'to spring' as an example but this is not...

I would like to know how I can achieve the following (and if it is achievable by only using queries or vba has to be used). I have an append query, one of the fields (lets call it 'A')it appends is a value. The value of A is 0 or -1. When A is -1 and B (which is a string) complies to a...

Changed DFirst to DLookup but I'm still getting the same error. After running the SQL only one row will be returned with a simple integer (between 0 and 100).

The SQL code works fine after deleting both "*" (which I didn't need anyways) I'm figuring out how I can run this SQL and use DFIRST to extract one value and show it in a textbox. I know RunSQL does not work because it is not an action query, which is why I used the DoCmd.OpenQuery statement...

Me and mornings.. Didn't see the post from blog at first :$ (Shame on me). Thank you very much Plog for the elaborate answer which I think resolved my issue:D.