Search results

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

Hi again Bob I've played with it a bit, but now i have a new problem Once the master/child relationship is set up, it only displays records on the subform with a Qty on tblOrderdetails. So a new order displays no records whatsoever. If i remove the master/child then it displays the correct...

thanks bob - i think you're right - master/child hasn't even been set - i'll have another look into it. cheers!

I've checked into it - the After Update isn't firing twice -i think i've traced the problem back to the form. which is based on the query so txtQTY on the form is bound to tblOrderdetails.Qty as soon as I enter a value it creates a record on tblOrderDetails with no OrderID and then...

I've got my db for generating basic invoices, however the initial design was extremely rushed and consequently it's extremely inefficient. Basically, when a new order is created; a query inserts a record for EVERY product in tblProducts to tblOrderDetails and the form just updates the quantity...

Thanks a lot! it's definitely got me on the right track.