Hi
I am writing a financial database that tracks Stocks, Bonds and Cash in several currencies.
To do this I have a table with a record for each transaction that includes a field for [Quantity]. I have another table with [CurrentValue] for each asset. Both of these are number - Double - 4...
Hi.
I need to check if a recordset is empty. I did this once before, with much help from this forum, using the following SQL:
sqlstr = "SELECT [fxXRate] FROM tblFXRates " & _
"WHERE fxDate= #" & dtSetDate & "# AND fxCurrency ='" & strCur & "'"
Adapting this to my new, even...
Hi
I am soooooo close to getting this data entry form complete. The Database keeps track of transactions in bank accounts with differing currencies. The exchange rate between currencies is recorded in tblFXRates and I have to check, before adding a record to tblTransactions, using the data...
Hi
After a couple of years of struggling I am getting pretty comfortable with basic Tables, Reports, Forms and Queries. I could really use a book that explains using VBA, SQL and Recordsets in Access.
Any suggestions?
Many thanks, as always.
A/R
Hi
I'll try and explain this in a simplistic way as I tend to overcomplicate my questions. I think my problem will be revealed quite readily by the code.
I am trying to assign the result of a query to a variable so I can use it in a formula. From what I can gather this is possible by way of...
Hi
I know it is possible to use the bound column of a combobox control as criteria in a query, but can't figure out how to use an unbound column.
Is this possible, and if so, what is the syntax?
Thanks
A/R
Hi
General question.
If I want to populate a text box in a form, whose RecordSource is a query, with the result of a calculation.
For example:
Query Fields are [Quantity] and [Price] and I want the form to show [Quantity], [Price] and [TotalPrice].
Does it make any difference if I put an...
Hi
I apologize if I sound a little incoherent but I have scrambled my thought processes somewhat; working on this the last few hours.
The following is a simplification of what I am trying to accomplish but will stand to the question without over complicating it.
I do business from Canada...
Hi and thanks for taking the time
I am writing a new database and am setting up some templates. In order to make changing the color of elements in forms and reports easy I would like to define them when the form loads.
I have created a module to define the colors by using public variables...
Hi
I have been slowly plodding away at the process of learning Access and VBA.
I have come to the point that I think I will have learn how to use Recordsets and was wondering if someone could confirm this before I embark on the somewhat daunting (to me) task.
In order to arrive at the...
Hi
As usual I have to say thanks in advance for all the help I receive here. Without it I would be so much more confused than I am.
I have an interesting sort of problem that I will explain with an analogy...
Thanks in advance for even reading through this.
I am still quite new to Access but have managed to build a few
databases. I have used a bit of VBA, primarily to open and close
forms and reports. I am quite confused as to how to approach my
next task. I suspect I may have to take on...
Hi
This is a pretty bonehead question but I'm at the point where it needs to be asked. I could do this as a split form (I seem to loose control over the font size that way) but the real problem is that I just don't understand the workings of the Master and Child link on a form so now seems like...
Hi
Just getting the feel of Access but definitely not highly proficient. I'm also starting to learn VBA.
I have a form that I want to filter by different fields on different occasions. i.e., I might look at all records that have a review date of earlier than today on one occasion and I might...
Hi
Can't seem to find an explanation for why joins are denoted as left/right or Inner/Outer. If I know why it would probably help me remember which is which.
Thanks
AJR
Hi
Thanks for taking the time to check out my question
What I need to know is if I can somehow get a Totals Query to include a line when it returns a null value.
A very simplified explanation of the situation:
I have a database that generates a report showing different categories of Stock...
Hi
I am pretty new to Access but have been working on it quite intently for a couple of weeks. I have noticed that if you use the expression builder, in Report Design View, to insert a field from a query that is defined as the record source for the report (probably also from a table too but I...
Hi
Thanks for taking your time with my problem, even if you just read it and move on.
I'm pretty new to Databases and Access and am just finishing off my first real Database.
Sorry for using the S word. There are many reasons that this project should be done by a database, I'm finding one...
Hi
I am a Newb who has almost completed my first Database. I have just one problem to solve that seems to be far more complicated (and taken far more time) than it should. As it is very complicated to explain the problem in the actual database (I tried and no one answered) and because I am...