Search results

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

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

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

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

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

Hi All I'm trying to finally bridge the gap (or chasm rather) and start learning how to do SQL commands in VBA. What i'm trying to do is a simple invoice system where my Form selects the products from tblProducts and then creates a record in tblOrderDetails with Product AutoID from the current...

Hi everyone I've been looking around trying to find a solution - I basically need to be able to use the mousewheel to scroll within a textbox - there seems to be 101 solutions to disable mousewheel! My DB currently generates a flyer with a list of products - there is a rich textbox which...

Hi folks I'm trying to do a bit of cleanup on my db at the moment and i'm running into a problem with a combo box on my form. the main elements are the form - frmNavigation the combo box in question - cmbDistributionOrder and the button - btnNewOrder What i'm trying to do is create a simple...

Howdy I have a new piece of filter code that's working great on reports and on forms, however it's not working correctly with split form view. The code works fine if you double click the textbox on the form, but not if you click the same field in the split view. Private Sub...

g'day I'm having some trouble with filtering a report I'd like to automate it so that doubleclicking on the current record filters out all the other ones. I've tried a few things but they don't seem to be working correctly Private Sub StockCode_DblClick(Cancel As Integer) Me.Filter =...

I have a query that removes multiple records from my table, mostly for when we recieve stock for existing products in the database i'm using the code below to identify the records and i have another query which removes these records. SELECT product, ReportID, StocktakeAutoID, StockEnv...

Hello Does anyone know if it's at all possible to program the mousewheel to run a query in a textbox ie - i would like to update the quantity of stock +/- 1 by scrolling up or down within the textbox i'm thinking along the lines of Private Sub StockEnv_MouseWheel() DoCmd.OpenQuery...

I have a database with a primary feature of sorting/categorising products based on the input text into a totally insane but explicit order on reports. The reports are sorting and grouping as required - what I'm trying to do now is essentially copy the exact same multi-tiered grouping and...

Hey everyone! Hopefully this a simple problem I have a working form with a few subforms that I navigate through. I have my stock record on the main form and quantity details on the subform Basically I want to hard code the + / - keys on the Numpad to go forward/back a record regardless what...

I have a form with stock report information and a child/subform of a linked table - tblStocktake the subform is just a standard datasheet view with Master/child linked by ReportID I have buttons which copy data from a previous report to a new report. What i'm trying to do is have those...

I'm having a wee bit of confusion with what I assume is something really basic. I have tblInvoices which contains StockNumber & ReportID I then have an append query which appends StockNumber & ReportID to tblStocktake The problem is that sometimes there are multiple duplicates if the...