Recent content by flect

Perfect!! - Thanks ChrisO :p

Thanks Bob - the hyperlink method didn't work but the alternative works fine.

Hello World. I have a little piece of code that I'm trying to convert for use in a module so that it works on any control. It basically selects all text in a box/field onMouseUp, but I want it to work without having to specify which control all the time The basic code is...

Hello World! I am attempting a crosstab report for the first time and have had limited success. I have everything on the report unbound and labelled dynamically and it's half working. My Crosstab query displays the data correctly, and the Report when opened automatically ascertains the...

Hi everyone. i've got a seemingly simple function i'd like to perform with with a query but am unsure how to go about it. Essentially I want to concatenate results of a query into a single field - grouped by distinct value. eg - original table NAME VARIETY Apples Granny Smith Apples Golden...

I'm having a go at using VBA for excel, having used it a bit in Access. What I'm trying to do in this exercise is have the code scan column C, and if the cell is empty it needs to remember the value in column A, and then clear cells B & C for all instances of value A example (small sample) --...

Solved it myself :D =LEFT(A1,FIND(" by",A1))

Hi Guys I'm wondering if it's possible to split a string by a keyword in excel. eg. I have a list of products and companies and the strings are all variable length but contain a common keyword - ie "Shoes by John, Socks by Allison, Vacuum Cleaners by Frank" I don't think i can use...

Thanks Galaxiom!!! - Perfect solution!

I'm trying to set up my continuous form so that the default date for a new record is 1 week after the last one: so far my approach has been: Private Sub Form_Current() Dim strSql As String strSql = "SELECT TOP 1 DateAdd('d',7,[wagedate]) AS NewDate " & _ "FROM tblWagebook " & _ "WHERE...

Hi everyone! A while ago I found that you could program the pc speaker in your computer from access. Basically, you can program anything as long as you give it note frequency (in Hz) and note length (time in ms). This lead me to knock up a few blips and buzzes to give audible feedback from...

:::Update::: Success!!! I had to go back and rethink a few things. I had to create a new query for the form source object with a subquery for the quantity to display correctly. Unfortunately I was still having the same problem with the double records so I decided to disable the SQL...

wow! fantastic stuff! I too would be interested to know if you can send these appointments to other outlook recipients, or even just email addresses. great work though!!!

No, I hadn't tried either - but they work fantastically!!! Cheers! :D

Hello world I've just acquired a barcode scanner to use with my database I'm now at the point of programming the form Everything is working correctly except for one feature I need everything in my barcode textbox to be selected (or deleted) after it has been updated. It's basically so...