Search results

In the BeforeUpdate event of a form field, I'm holding open a messagebox (my own design) with DoEvents as I can't allow it to open in dialog mode. If Len(Me.ReminderTitle & vbNullString) > 0 Then strLinkCriteria = "[ReminderTitle] = " & "'" & Remtitl & "'" 'checks reminders...

Hi all. I'm trying to lookup a value from another query with dates running in ASC order from qryLookup TransDate Lookup Value ----------- --------------- 20/07/2018 … zz1 20/07/2018 … xz1 21/07/2018 ... xy1 21/07/2018 ... xy2 23/07/2018 ...

Now I know it sounds stupid... But Access is aggregating a row source I don't want it to... I have two columns of data in a query one for dates and one for a running balance, but the running balance is aggregated (and I'm getting very aggravated) The chart has no resemblance of the data I...

Hi all. I was thinking... I'm currently using Access to delete related records in the outlook calendar, relevant to data I no longer need to keep in both. I was wondering if I could also create something in outlook and use it to delete a record on delete of the calendar item. I do have a ID No...

Hi guys. A quick question... I know the title is confusing, and so is my problem. I'll try to explain as best as I can. I have a totals query called [qryActualSpend] where the dates criteria is Between [myformname]![txtstartdate] AND [MyFormName]![txtenddate] and the results are exactly as...

Hi guys. Thanks for taking the time to read... I have a currency field, and currently its set to automatically insert a decimal point by /10 if it's notnull. Most of the inputs to this field use pence and shortens the input method. Someone has asked me if it's possible to insert trailing...

Hi guys. I'm using the following code (with reference to MS Outlook object library) to delete a contact from OL. Function DELOUTLOOKCTCT() On Error GoTo Err_Ctrl Dim olAppl As Outlook.Application Dim objNamespace As Outlook.NameSpace Dim objFolder As Outlook.MAPIFolder Dim olCont As...

Hi all. Macro question relating to Actions Catalog and access to the macros contained within it. I've inherited a macro only (ugh) database, and as I prefer to use VBA I'm converting said macros. However, there are sub macros run within each macro to which I can't get access. As I look in...

Hi all. I've done a search for what I'm trying to achieve below, but there's nothing to give me an idea how I'd go about tackling this. Basically, I have a couple of clients who've asked to show all invoice activity on a daily basis, when I'm sending out monthly invoices. I can do the running...

Morning all. I have a Main form "frmREPORTS" and within it contains a sub form control "SFControl". I'm using a subform control so I can call its recordsource through VBA to view various continuous forms from within the same space, depending on what form the user selects. Here's the...

Hi all. o/ Bit of a difficult one to explain (I think). However... I have a theory on how I can get around this, but was wondering if anyone had any advice on a way that's easier. I have a very simple Union Query which lists all entries in a couple of tables for meeting room bookings...

Hi all. I've been racking my brain for this for the last couple of hours... A simple function to find the first day of this month when a form opens..i.e me.txtstartdate = dateserial(year(date),Month(date),1) Should work fine, and it does on another form that was written pre anniversary update...

Hi all. I'm using the following on a Click event to load a real time tooltip showing details where there is more than one entry on a related table... Dim strSQL As String Dim dbsmyaccounts As DAO.Database Dim rstSplits As DAO.Recordset If Me.Part <> "Split : Multiple Parts" Then Exit...

Hi all. Is it possible to have a combo box look in two different fields in a table, to return the same data based on PK? I'm only talking hypothetically as the systems we use for work incorporate this method and it makes for easier data entry, but I'm stumped as to how this would work, based on...

Hi all. Test rolling out a database on mobile devices (namely Surfaces'). To get that 'tablet' effect, Access is running on full screen. Anyway, one problem I've stumbled across Is... without a detachable keyboard, there's no way to get access to the keyboard button in the taskbar of windows...

An odd title. However, I have an issue and was wondering if any others have had a similar problem. When I'm running VBA not using a Break Point, to generate a random long number (based on date and number of entries) that needs to be inserted in a field in the table, using a loop statement, it...

I need some help with something I'm obviously doing wrong... I have several forms where the user can input supplier details (which use the same table) so I'm trying to use a public function to do this. However when I call the code, I get an "Argument Not Optional" message. The public sub...

I have a date field, that can be changed via "+/-" keys on the numeric key pad by increments of either plus or minus one day. Because data within the field physically wont change by typing a new value, is there any way of forcing the before update event to fire if it's changed? Am I right in...

Below is a (difficult for me) piece of code I'm using to write to a table using DAO, while referencing the main ID's of each record. All is OK and seems to work fine until I get to the highlighted line, and then when there are no more records, I get an error no more records. I put an if...

Hello all. I have a very simple CT query and it's been working fine.... TRANSFORM Sum(qryTRANSACTIONS_ALLPrevious.Amount) AS SumOfAmount SELECT qryTRANSACTIONS_ALLPrevious.Category, Sum(qryTRANSACTIONS_ALLPrevious.Amount) AS Total FROM qryTRANSACTIONS_ALLPrevious WHERE...