Search results

  1. A

    Odd Behaviour of Int() in Function

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

    Two Similar SQL select queries. Why does one not work?

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

    Object Required Error Checking for Empty Recordset

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

    Good book to learn vba, sql and recordsets

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

    Function To Return Result of a Query

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

    Unbound combobox column as query criteria

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

    Do Calculation In Form Or Query

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

    Function, with Recordset, In Combo Box

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

    Set Form ForeColor OnLoad

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

    Formula Based on Record Number -Recordset Required?

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

    How To Incorporate Selling A Product Option

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

    Calculating Wieghted Average Cost

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

    Replicate a Split Form

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

    Best Way To Have One Form Referencing Multiple Queries

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

    Why are joins denoted left, right, inner, outer

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

    Show a group Item with 0 sum in totals query

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

    Expression Builder in Report Design

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

    Question Property Sheet: Link To Property Explanations.

    Hi Just wondering if anyone has a link to a site that explains, one by one, the purpose of each property on the property sheet? Thanks AJR
  19. A

    Form with Spreadsheetlike Performance

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

    Trouble with structuring Categories and Sub Categories

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