Search results

Gina, I am attaching the mapping table that I am currently using now. This should give you a much better idea. I am sorry for all the mess but since the data is confidential it is difficult for me. So basically the table has 8 levels and 8 sub levels. So each smaller level adds up to the value...

Gina, I have set up some tables but the way I have them up might not be helpful if I want to insert datasheets. That is why what I have sent is a raw datasheet that I used to set up the initial MS Access tables. I am sure that my current table set up would not be helpful in that case. Thanks!

Hi I have uploaded the file here for your reference. The table consists of some 3,000 rows. The main accounts are 74 in number and then each is made up of a few sub accounts. Then each sub account is made up of sub sub accounts. On the table attached we can differentiate between the account...

Also would you a know of a way in ms acess where if we can get our results in an unsorted manner? So we know that ms access by default returns the sorted results in a table. Now I want a view of a particular type where the results are unsorted. My querry has the fields in an unsorted way but...

I understand that the form is an object and not a table. So basically you are saying that I should have the results of the form to be saved as a table first and then may be have the macro export the table in excel? Is that what you mean?

Thanks! Also is it possible to create a macro that can basically ouput the results of a form in ms excel? How can I get the macro to do the same? So I know about the "OutputTo" functionality but the issue is that if I use that then only the layout of the form gets exported in excel not the...

Hi Gina, I am trying to send that excel sheet over to you, but I am not sure how I can post it here. Should I send the same as a private message or so? Please guide me on how to send the file over to you. Thanks!

Thanks Gina, I really appreciate the help. Since the exact data is a little confidential, I can send you the dummy table which I am trying to create in ms access. Would that work?

Hi Gina, Yes the sub datasheets might cause slowness but that is the layout that I have been asked to re create. I am sure this can be done in excel but I have been asked to do the same in ms access so I am not sure I have an option here... Could you think of a way I can lay down the...

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 Gina, The database is to store the values of the balance sheet of a company on a daily basis. I am not sure what you mean by ignoring the plus signs, since the plus signs basically mean we have a sub datasheet within an account or so. Does this make it a little more clear for you...

Hi, I am having a little trouble in making the tables conceptually similar to the Northwind where in we have sub datasheets. So my master table is like one huge table with 300 main accounts. Each of this main account is made of 15 sub accounts which add up to this main account value. Each of...

Thanks! Also is there anyway in MS Access to not to sort data alphabetically? So basically I am trying to create a view in MS access which is of course not alphabetical so I was wondering if I can create the same table in MS Access? Thanks

Hey, I got that part...also I have modified the where clause of the query to add more "OR" criterion...so my querry now looks like the following: iQuerySelect = " SELECT HD_GL_ACCT_BALANCE.DATE,HD_GL_ACCT_BALANCE.GL_ACCOUNT_NO AS Account_Number, MAP_BALC_DESC.BAL_DESC AS Description...

I think that works at least in terms of its compiling now. But its asking to input a value for BALCFA in an input box. Would you know why that might be the case? Thanks!

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

Thank you for the input. I also wanted to confirm how to make a one to many relationship in access. So if anyone is aware of the north wind database tables and the relationship between those, you can see it is a one to many relationship. I tried doing that by using the relationshings and...

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

Thanks for that input. I got that idea and I too feel that this might be a better way to do the same. But I have been asked to do it the way I described above. Hence I was wondering if anyone has ever come across any such idea before, kindly provide some insight. It would be a tremendous help...

Hmm, so each sub account falls under exactly one big account. Does that help?