Search results

I would like to replicate a bank statement. One column for in and one for out and another for balance (and a column for the date of transaction). However (like bank statements) I only want to show the balance for the last transaction of a particular date. Also I only want to show the date for...

Thanks for getting back to me. as you can see Bat17 gave me some guidance in using the function. I had tried it in the immediate window with errors that I had reported. I still don't fully understand how something is stored as an array and how it is handled?

Thanks Modest Firstly for presenting my code correctly! Secondly for pointing out my error I know there are countless threads on the forum re difference between bang and dot but I always thought you're always OK with bang , and dot sometimes works but I see I am wrong! I thought bang emphasizes...

Thanks Chris & Modest but both of your solutions are not working! I enclose a cut down demo. All is OK except for that line I mentioned. If I use the alternative line, its fine! Dim rst2 As DAO.Recordset Dim txtView As String txtView = ProfileGetItem("vars", "View_name", "none"...

Jon! so why when I reference it does it reurn type-declaration character does not match declared data type? I am using:- rst(DonationValue) Chris! Nope sorry just get the same -item not found in this collection

In a DAO recordset, I want to refer to a field without using its name directly (for various reasons!), rather using a (string) variable which has previously been set. How can I get this to work? (where rst is recordset etc) rst!Amount 'works fine because that is the fieldname but dim...

Thanks! I was planning on getting information from another file

I have one db with various forms. I would like to have different forms open at startup depending on external criteria. In short can I run any code before any form is opened which would look like this dim Startup as string startup= source......... docmd.openform startup Should I put this code in...

sorry for delay Yes it worked very well. However had to exclude the automatic numbering ID. Thanks again

Sounds good! will try & report back. Thanks

Over 40 views and not one reply?

I need to run a loop which will duplicate an existing record in a table but change just one field using data supplied. I am not fluent in ADO ,I have seen the addnew method but as far as I know one has to specify all the fields and heir values. How can I say copy the records but change fieldx to...

Thanks for that and yes I tried it and it works. What I was trying to do was what to use the fuction 'subTestDayOfMonthDates' brought there which claims to print out to the immediate window. I guess I don't really understand what an array really is. I thought it would be a string of dates...

Sorry there is a misunderstanding. I meant the last date in the month. e.g. 30, 31 or 28. So if a user specified they wanted a transaction on the 29th of each month, it would know that on feb it should do it on the 28th. Also you did not respond to the point that I want a list of specific date...

Thats good thanks but I wanted one step further namely that it would only give you a certain day of the month e.g 15th. Moreover it was clever enough to calculate the last day ofeach month and to tackle situations where the day didn't exist that month e.g 30th for Feb Did you look at that code I...

I refer to the code in the code repository under this heading Return list of dates with same day of month I have tried for hours to make this work but I keep on getting a type mismatch (13) error. It is really exactly what I'm desperately looking for so I'd appreciate if anyone who has tried...

Yes thats excellent thanks You didn't answer re the compare database bit though thanks again

Yes that helps alot thanks Why did you use compare database and how can I use this in one subroutine only? Also could I make a public function out of this? Thanks

I have a string which can contain an arithmetic operator e.g amount*exrate. I want to be able to search the string for any of the operators i.e +,-,*,/. Is there any way I can use the instr function for this i.e instr(string,"+" or "-" or "*" or "/") rather than nest a few if functions Also...

My db records payments made out of various accounts. I would like to be able to provide the user with an interface that would allow him to enter a begin & end date and specify an interval- monthly,anually etc and the code would whip thru that period and insert a record for each month/ year. Has...