Search results

You'll have to explain to me what is 'Drip' when batched together with 'Bought_$ and Sold_$. I've perused your latest db but can't do anything useful with it at the moment.

Yep, that works and the next time I get to modify my app I will probably incorporate that.

I had a quick look at one of my apps. The following function is called from a startup routine and obviously before the startup form is called. Sub CheckForUpdate() If k_YOUR_VERSION < gIntLatestVersion Then MsgBox "An updated version is now available, press any key to upgrade"...

Which code part are you after? The batch/script file or code within the frontend? As The DB guy says, search this forum, you will get a ton of info regarding this. I'll check later my code snippets, can't at the moment.

There are many threads in AWF regarding this issue. What I do is check for the existence of an updated frontend at the time of opening the frontend. If there is a new version, then run a batch/script file and the very next line exit out of the frontend (as you say, the frontend must be...

In your query, order by ID, then by Created Date, both in ascending order. In the Query Design window, under the field name you will see a 'sort' reference (haven't got access open at the the moment), enter ASC in that field from the dropdown values available. If the above is not what you're...

In your query, only retrieve the email address. Do not start with "Select * FROM ....."

I assume your Toggle Buttons are contained within an Option Group (frame). If that is the case then: Me.YourFrameName.Value = 2 or 3 or whatever

Did you check the form, "sat_Investments_Purchases_SalesF" that is a copy of your form, prefixed with "sat_". The ''Net Share Cost' and 'Net Share Quantity' (or Avg Price, can't recall at the moment) are already displayed on your main browser form, they were calculated, that is what I...

I always find double quoting very difficult on the eyes and so easy to stuff it up, missing quotes or too many quotes. To make life easier, why not write a little function where your string to be quoted is passed in and the output is a correctly quoted string. I use the following, hope you find...

In your recordset only select unique email addresses. Select Distinct tblName.EmailField from tblName; More here:

Create an Update Query as follows: UPDATE Investments01_tbl_SubForm SET Investments01_tbl_SubForm.Advice_Previous = [Investments01_tbl_SubForm].[Advice] WHERE (((Investments01_tbl_SubForm.Symbol_Stock)=[Forms]![Investments_StockBrowse_WebLinks_F]![Symbol_Stock])); I named it qry_UpdateAdvice...

Try this: Private Sub Replicator_Click() Me.WebDate_Previous = Me.WebDate End Sub

I'm not sure how much headway we can make here. It seems like you are struggling with the underlying table structure (my three queries, case in point). By headway, I mean to continue with form design and implementation based on current table design. To address the table design that will...

Do not store the attachments within the database, that is, the tables. Yes, I know you can, but don't. In your tables create a field (text field) that corresponds to the file location of your attachment. This is the approach I have taken with one of my apps and it works a treat. Issues you...

I didn't realise that this issue is such an issue. I can only speak on behalf of the industry I work in (Australia) but surely Flexi-time is not unique to Australia. The industry I work in, if extra hours are to be worked, a supervisor authorises the hours, asking the question, do you want...

I always find double quoting very difficult on the eyes and so easy to stuff it up, missing quotes or too many quotes. To make life easier, why not write a little function where your string to be quoted is passed in and the output is a correctly quoted string. I use the following, hope you...

Ok, I think, maybe you are over-complicating things a tad. Regardless of how many forms may open the same child form (form 3), there is a master form, that opened any of the calling forms, that is always open. Why not refer back to the master form for your PK/FK references and disregard the...

Dim Number as long Number = Val(SomeStringNumber)

When opening Form 3 from any of the other forms, is Form 3 opened in Modal fashion, that is, no other form can be accessed until Form 3 is closed? Also, on Form 3, what data is required from the calling form(s) for Form 3 to accomplish it's purpose?