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?

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

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

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

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

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

I need some help from you guys. I got the following SQL which I would like to run with vba but it gives an error (errror 13 type mismatch). The SQL does work when I use it in a query but not in vba:banghead:. Dim SQLobsoleteperc As String SQLobsoleteperc = "SELECT...

Dim SourceSubFrmParts As String SourceSubFrmParts = subfrmEmptyParts.SourceObject I would like to extract a part of the string which is assigned to SourceSubFrmParts and replace it with something else. The first six letters, which always will be 'subfrm', which in all cases have to be...

Two things I would like to do with this vba code: Update a value from one table and save the ID as DeleteID Use the DeleteID in the where clause of a delete query I got the following code but it doesnt work as intended. Could someone please help me with this: Dim myDb As...

Hi, I got two questions: 1. I have written a vba code which should append data to a table called; 'tblActionsTaken". The data is given by the user. access works with 2 of the 3 fields. The third field (or first in de vba code) gives an error. The value is selected in a combobox containing a...

Hello again, I would like to make a DLookup that check 2 criteria in two different columns in the same table. The reason to use a DLookup is that I would like to check if two parts already have been linked together. The user therefore selects two values in to different comboboxes (lstLinkPart...

I would like to show all linked components (once) in a query. With inner joins (option 2 when double clicking on a relationship line), it shows all linked components but with duplicates. When selecting option 1 (only include rows where the joined field from both tables are equal) I only get 1...

I was wondering how to calculate all records that have not yet been linked to other records. For example: I have 1 Product, which is linked with multiple components which is subsequently linked to subcomponents. All these types can be linked to Alternate Parts. In order to reduce redundant...

Hi, I hope I post this in the correct section of the forum, forgive me if not. I would like to ask for some advice because I'm don't know how to implement a functionality into my access database. The related tables required for this functionality can be found as an attachment. When the...

I am new to writing vba code and am currently trying to open a form with a couple of criteria that are typed into several boxes. When all given criteria are larger than 0, it should search for those items. I chose deliberately to put it in a openfrm function to try it out. If IsNull(Naamtabel)...