Search results

Thank you . Looking at the easiest things can sometimes be the most difficult tasks.

Thanks for the prompt response here. I need to test for any records on this 2nd "For i" statement embedded within the 1st (not sure of that makes a difference or not, but I did read somewhere that there are limitations.) anyway, so I put that if statement in to check for any records, if so move...

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

Well, I did it. I upgraded. All in all I'm really please with Windows 10... except; Nvidia cards don't like Windows 10 (at the moment) with dual Monitor setups as on occasions, without warning, both monitors go to sleep and you can't do a thing about it... Reboot, and hope it don't happen again...

it's easy when you know how. ;) I've never had much use for MID up to now, but I think it'll come in rather handy going forward. As always , much appreciated.

Hi Plog. Thanks. I'll go have a look, and let you know.

Hi all. In order to hide some sensitive data, specifically around account numbers etc, I'm trying to replace the first half of the text within a textbox with asterisks. example; turning AG7465LFR721 into ******LFR721 In this instance Account numbers are various lengths (including...

By my own admission, I should check my spelling. Wayne, absolutely right, it was the pipe next to it, with an incorrectly spelt name. A new error experienced, and a new one never repeated. Many thanks for you help guys. Totally appreciated.

Hi Dave. Many thanks for your reply. I have an if statement checking if it's blank and I've tried using the Bang in place of the dot. renamed the control, and just about everyting else. I think I'll redo the form and see what happens. The same code runs perfectly in another database I'm...

Hi Guys... I've hit a wall in regards to the Error, Method or data member not found. yet when I wrote the code, intellisense saw it, I added it , and all was well. image attached. What I want to happen, is click a button , btnsplit in this instance, and pass some piped open args to another...

Isn't that the idea? Provide as much information as possible? isn't it better than little information (which I've seen many times?) I'll keep looking. but thanks.

Hi all. I know this has been covered many times, but I'm really at a stumbling block with an idea on the dreaded budgets vs actual. I'm after some guidance on how to possibly set up a table, where I can change the data in it (on a monthly basis) in order to compare a budget table against an...

Awesome. did the job! thanks JHB!

Hi all. I'm sure this has been covered before, and I've searched with no luck for my specific problem. I have 3 forms. form 1 is just to contain the other two, as it's a popup (and it's totally unbound to anything). form 2 to enter data, and Form 3 to show a summary of all data via a query...

Nailed it! Took a little time, but managed it in the end Basically, once the Main form has been counted I needed to then count the Related forms entries, and based the incrementing date on the number of entries on the related form... If anyone else needs this (which I doubt) then the code I...

Hi Paul. Yep Exactly that. I've already started on the code. What I thought was a relatively simple task is slightly more difficult, but I think I can do it. Well, at least.. I can give it a try! Thanks for your guidance... I shall let you know if I'm successful

Hi PB, thanks for your reply. I've been using this method, and only had a chance to get back to it now... It seems, I need to save the new ID as the primary key value to use as the foreign key for the related records.. so I've had to change the code to the following... Private Sub...

Thanks for the reply Cronk. It's happening in the second sql string StrSqlsub Dbengine(0)(0).execute strsqlsub dbfailonerror

Hi guys. Last week I submitted the thread ... http://www.access-programmers.co.uk/forums/showthread.php?t=277992 and from this I wanted to copy one table to another, incrementing the date by any given value. With a lot of help, the desired outcome was reached. After looking and not finding on...