Search results

Hi Experts, I tried the whole day to contruct a query that deliver me the sum of 3 months i.e the actual month + 2 months. The Table layout is Month1 Cost Item Year Moving Sum (should be Output) 01/08/2010 20 A 2010 55 01/09/2010...

Hi Experts, I am having the problem that when I try to save my snp file to pdf file, sometimes the pdf file generated is not the correct one. For example i have a customer A and I have generated pdf files for it and now I want to make pdf file of report for customer B, now when sometimes the...

HI experts, Is there a way to prevent the user to delete tables? Or ask user when he tries to delete a table whether he is sure about deletion of that specific object. Thanks in advance for your suggestions

Hi experts, Today morning I am asking myself the question how I could get unique items in a recordset. I have a parts table and for each part there should be approriate description available. Now for some parts there are no description available and as one part can come many times in this...

Option Compare Database Private Sub Combo3_AfterUpdate() Dim db As DAO.Database Dim rs As DAO.Recordset Dim vl As String Dim strsql As String Dim totalengines As Integer Dim usedengines As Integer Dim notusedengines As Integer Dim noinfos As Integer List6.RowSource = "" vl = Combo3.Value...

HI friends, I wonder whether it is possible to get variable name for a simple code like this i= 1 for i = 1 to 8 debug.print i next i I can get the values of i but if i have a complicated strcuture aqnd I at specific time i WANT TO KNOW WHICH VARIABLE IS DELERING ME A VALUE HOW CAN I...

Hello friends, I am trying to scan the fields of a table with the following code. This should normally give me the maximum length value for each field in the table. However max is not working in vba code as it normally works on table/query level. I therefore used DMAX but it is not working. Any...

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

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

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

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

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

I am comparing two fields in a query like [table1].[Prefix]=right([table2].[Prefix],3)) the prefix in table A look like AB123 or A123 or AC123 and in table2 like 1234. HOw can I the trim beginning if it is A,AB or AC? Any suggestions? Thanks for your answers.

Hi friends, I want to trim a string in a query but somehow I am not able to do it as I am not a ms access expert till now. How can I for example trim letter to etter? I want to trim the L character whenever it comes at the beginning? Thanks for your help.

Hi friends, I was working on a problem to get records that match in a table with the help of left function in my queries, now i want to get all records that dont match the criteria.How can I implement this in MS Access? I was using in my queries the logic (table1.[col1] = left(table2.[col1],4))