Hi there,
I will appreciate if someone help me with the following.
I have three nested forms that is Form3 is withing Form2 that is within Form1 (in reality = 1 Form and 2 subforms cascaded).
I want to select a value from Combo1, that will further brings the values in Form2, and then further...
Hey guys,
Here is the issue. I am receiving emails (work related) in the same format (where the information is in the body of the Outlook email). Basically the emails contain some financial data that the team needs to manually enter in Access database.
The great question is - is there a way to...
Hey guys,
Here is my dilemma: I need to produce some metrics showing when a record has changed its state.
So I have a table, called tblRule. For each Rule, the user would populate a filed “CurrState” from a combo-box on a form. Now, I have to find a way to track somehow when a specific Rule...
I am heaving hard time finding some info on the following. I am receiving daily about 10 spreadsheets with different formats (different header names); only 10-20 percent of the content is the same across all the spreadsheets. The output is that i need to convert all of these formats into a...
Does Access 2007 have any Workflow tool capabilities?
Hello and Happy New Year!
I will greatly appreciate if anyone can let me know if Access2007 has some cababilities of worflow tool? I work on a project, and would like to use at this point Access to aggregate data for some control metrics...
Folks,
Here is the issue I have been struggling with. I have a table, which contains orders by individuals. Then I need to group those orders by certain criteria (let’s say by product type); I used a select query and grouped them by. However from that query, after i grouped them by, I want to be...
Hello folks,
Many thanks for all help i have received in this wonderful forum. I have experienced a very strange situation. When I converted my database from Access 2003 to 2007, for some reason i don's see all table relationships anymore. Now I am trying to restore by manually relinking them...
Hi there,
I have a quiery that runs behind a command button and exports data to Excel; however i want the format to be csv. Is it doable? Any ideas or code suggestions are appreciated.
Best,
Atol
I am trying to understand what’s next after a database is created (meaning it is functioning, but not ready for multi-user environment and not secured yet). By reading various postings and some articles, it seems these are the key steps I need to follow in order to have a database ready to go...
Hi,
I have a pop-up form on which there is a command buton linked to an "update query". Everytime the button is clicked, it makes a record to the table. I want to prevent from someone accidentally clicking twice (or more times) and making more than one record. I was thinking of finding a way to...
Hello,
I realize that storing a calculated filed is against the golden rule (at least in most cases), but here is a situation I believe I will need to do that.
I have a complex query that calculates and keeps history of projected interest payments; I also have a table where I keep track of...
Hi,
Here is my dilemma and I have been scratching my head for quite some time.
I have two forms (related to two tables in one-to-many relationship). The forms are linked as form and subform and they work just fine.
However considering the fact that the subform is basically a data-entry form...
Hello,
I have a quiery with about 4 to 5 fileds (columns). I would like to export the data to an Excel format (which have about 100+ colimns). The data will fill in just a 4 - 5 columns in Excel (and the rest Excel columns are not changing and no data is feeding to). The question is - can this...
Hello,
I have been searching the forum for this scenario but could not find similar case, which is as follows:
I have a Search Form with many Text and Combo boxes, linked to search criteria in a query. There is also a sub-form showing the search results.
I am trying to replace one of the combo...
Hello,
I know it has been said a lot on this topic but I could not find exactly this situation in my search.
I have a query, which pulls results from many tables. Based on that same query, I have a form with three cascading combos and a list box. The list box however should show results based...
Hello folks,
This is probably no brainer for most of you, but I got stuck.
Basically I have created a few queries (some of them just show a number, let's say "total number of active clients, etc). I have a few queries producing similar results; I want to show all those results on one form; so...
Hello,
I originally put this under "Query" category, but was not sure where actually it belongs... so I aploogize for posting this second time.
I need a little bit of guidance with the following.
Here is the scenario: two (or many) investors invest in bonds; usually the typical transactions...
Hello Folks,
I am trying to find a way to calculate a weighted-average interest payment in Access.
Here is an example:
You have a savings account with changing balance, the balance basically changes every time when you add some cash or withdraw cash. In Excel it would look like this
Balance...
Hello,
I am trying to use 2 vlookup functions in the same cell (which is fine), but one of the datasource cells is a date; when I run the vlookup, the date gets changed to a number. Is there a way to fix that? I want to see the date, but at the same time I do not want to change the date format...
Hello,
With all honesty, this forum is a Treasure! I see so much valuable suggestions here. Thanks to everyone.
I am a bit new to Access, but wholeheartedly, I enjoy doing Access-related projects. I guess I took a bigger bit this time, and got myself on the spot….I mean I am challenged. With...