Search results

Hi, Following is the macro I am currently using to import data from excel into a MS Access Database. What I want to add is a feature where in if a user enters the date in the wrong format, a message box appears saying "Date format Incoorect". Private Sub importFile() Dim inDate As String...

Hi, So I have a query which selects 74 account numbers, balance numbers for a date that I select in a form. I have embedded this query in a VB Code of the form and have also created a button which selects the date and runs the query. But because I want to view the result in a particular...

Hi, I have a main form like a main menu for the database as a form and I am trying to add a button in the same which can launch a pdf file stored at a location on my desktop. Firstly is it possible to do this in MS Access? Secondly, if yes, below is the code I am trying to work with...

Hi All, I have a VB Module that I use on a daily basis to upload a set of data containing 2599 rows and two columns (one for account number, other for balance value). I want to include a feature in the Module program where 1) I can check if on any day the number of rows become less or...

Hi, I am trying to create a macro to open an application called CRONOS. My question is that can we use the macro in MS Access to open any application stored on our computer? Also is it possible to write a macro which does the following: 1) Run Application CRONOS 2) Exports data table...

Hi, I am trying to run the following code in VB in MS Access to basically run a query and I am getting a syntax error saying "Syntax error (missing operator) in query expression 'HD_GL_ACCT_BALANCE.DATEFROM HD_GL_ACCT_BALANCE INNER JOIN MAP_BALC_DESC ON HD_GL_ACCT_BALANCE.GL_ACCOUNT_NO =...

Hi All, I am trying to create tables like they are in the northwind database. I already have the individual tables ready which have to be linked to one another like in the database. These table as of now have no relationships defined and are stand alone, though they do have common columns...

I want to basically create a table such that if i double click on one of the fields in the table, it opens up another table that constitutes that value? So lets say that particular field contains A which is A=B+C+D+E, so what I want to do is when I click on A, it should open up the table with...

Hi, I am trying to format the values in a column which is a result of an extremely long query. Now I know that I can set the format in the design view but if I try to view the query in design view, because of its length, I get a message saying that "the expression you entered exceeds the 1024...

Hi All, I have this huge table that I run queries off to get desired results. Now in that table of course there are some values and some nulls. So if I am trying to run a query which sums three of the rows with one null value, the result is a zero. Now I am looking for a query that can help...

Hi, I have a database for accounts and I have a particular format which is produced by a query giving me only 50 rows which are mainly sums of a few rows above it. What I want to do is to be able to click on a field or a record for any of that 50 row to be able to open up a table consisting of...

Hi, I am trying to create a filter to contain dates from a table and then trying to run a query on the same table to get corresponding date's values. But I am getting a run time error in the following piece of code: iQuery_From = "FROM HD_GL_ACCT_BALANCE INNER JOIN MAP_BALC_DESC ON...