Search results

Damn it is not working...... What I have done was just getting the values into a combo box. Can you kindly tell me how you would extract the valuies from Table 1 into Table2. sample is attached.

Thanks for your responces I come to the solution. :)

How should I get the values from the new Table for 1 2 and 3

Hi friends, I am having a table with column A which has either values 1, 2 or 3 now in column B it should show me for 1 True for 2 false and for 3 in process. I am trying to solve it in a way that automatically if either 1, 2 or 3 is entered in the column A the corresponding is shown...

Hi Friends, I am trying to create and delete relationship between two tables and to enforce referential integrity between the two tables. The tables are in a 1 to many relationship. I am not able to create and delete the relationships. I would like to have suggestions from your side. Thanks...

HI friends, I want to ask you a question regarding my current problem. I have a table with mother and child records. The child records in the subsheet have a column Engine. Now my question, is it possible in Ms access to get only those mother records where in the child record the Engine is...

I have just two fields as mentioned in the table. i.e. DB-Key and Type Truly speaking I have no more information to share because there are no more information to share :D

I want to add all records into table A.

HI Friends; I am working on a problem for the last two day and till now I have no solution. I have a table with a field DB-Key and it comes more than once in a table and another fields TYPE. Now what I am trying to do is to go through each DB-KEY and when for a DB-Key the TYpe is 6 or 7 then...

Hi friends, I am trying to create a Chart with my data in MS excel using a Button but somehow I am not able to create it. I am creating the Chart but I am not able to create different series in the chart thats why my diagram is not giving me the required results.. I am attaching MS Excel file...

Hello friends, First of all I am not an expert in creating MS Access reports.I am to create a report for comparison for a table. On the left side of table I have description of parts along with quantity, date and country and on right side other parts with different prefix as well with quantity...

Can you tell me how to do this as I have tried in your direction as well but was not able to solve it.

Hi all, I am little bit confused how to solve my problem at the moment. I have spent a couple of days on it but came never close to solution. I have a table A which contains the order list of husband and table B which contains the order list of wife and I have a table C which contains the...

Hello Friends, I have a query which search the matches of two table (Tale A has ~ 4000 record and Table B ~ 60000 reords). Now when I first run the query after creating it, it is executed within 2 seconds but after half hour or so the query takes two much time and hangs. My assumption is that...

Sorry that I am not understanding that well or I am not able to describe my problem that well. I just want to click a button which should run a query and show me in my case records from GBR. I have done that before without knowing that my code first opens the whole query and then apply the...

Hi friends, How can I show the status of a query. i.e when I click a button and a query runs then on a form the status is shown like "Please wait query is running ".

I am filtering using a form, not in a form. I am calling a query as stated in my code. For a query that does not take much time to run you dont even recognise that first query is opened and then the filter is set, but for a query which shows a lot of data, it takes too much time and it looks...

Hello friends, I have a problem with my vba code by applying the applyfilter property, my code which is listed below first open the query qithout using filter and then reopen the query to applyfilter. Is there anyway I can do it in one step? Private Sub Befehl38_Click() On Error GoTo...

thanks for your help. really appreciate that

I am using your code and I have no control over the different masks,unfortunately.:(