Search results

Hi, I appreciate this may be a silly question, but I'm tying myself in knots and can't believe something I'm trying to do is turning out to be so difficult. I have a main/sub form set up where the sub form is set to show a datasheet view of associate records. I have a combo box that looks up a...

Thank you this worked perfectly :)

I have a main/sub form set up and linked with Link Master Fields : InvoiceID Link Child Fields : InvoiceID The forms link beautifully and behave just as I would expect. I have added a command button to the main part of the form using the Design/Button wizard and chose Record Navigation>Go To...

Hi, I've been working on and off on Access for years, yet seem to completely forget all I've learned in the interim ! I'm working on an Invoice tracker where the user can save different lines of information associated to one invoice. So one InvoiceID may have several rows of information for...

Hi, I have a fairly simple query to weed out all the records in our database that are missing vital pieces of infomation : SELECT Contacts.Name, Contacts.Address1, Contacts.Address2, Contacts.Town, Contacts.County, Contacts.Country, Contacts.PostCode, Contacts.Telephone, Contacts.Code FROM...

Before I get started I would like some feedback if there is an easy way of creating some charts (I have a history of over-complicating things :D ) I have some survey results that I need to create some charts from and am getting in a muddle. I have one large table that contains all the survey...

:p ...well that seems like the most logical solution and a whole lot less grief than what I came up with. I seem to have a knack for over complicating matters. I am very grateful for your assistance and patience ;) :D

Thank you for the time you have taken to look over this for me. I see now where the issue has arisen, however I've left with a quandry... the survey I need to produce is huge and doesn't fit on a single page, I thought that by splitting it into subforms it would solve my problem. But I guess...

When in design view, highlight the control you wish to centre and then use the align left/centre/right buttons on the formatting toolbar. I hope this helps

Hi, I tried removing the InterviewNumber (primary key) field from all the tabbed subforms however it's still creating a new record everytime I switch to a different subform. I have no other VBA code or anything complicated... I have no idea why it's doing this ? I've attached my current...

I have used an autonumber to link all the subforms and masterform together. I included this field on all subforms, although I have disabled it and made it non-tabbable ... do you think this has anything to do with it ?

Not sure if this is related to this issue, but every time I tab through my controls using this code it sets a new record for each form as soon as I enter the first control. I have no other VBA code, however I have the interview number (autonumber) field on each sheet - although it's not enabled...

Thank you. You're a star ! I've been getting my brain in a knot on that one, always seems so simple when explained !

Setting focus and linking to tabbed subforms Hi, I'm chasing my tail with an Access problem, and can't get my head around solutions I have found on the net. I dabbled in Access quite a bit, about 5 years ago, I've never touched the VBA side, macros or used the OnEvents. I have a database set...

Not sure I matched up my fields correctly : =DAvg("Mgn/Pax","tbl_7day_tracker","Code = 'B' AND Departure Date = " & [Departure Date]) where Mgn/pax = the price to average Tbl_7day_tracker = the table with all the info Code = B, F or LP Departure Date = the date grouped by I tried the formula...

I've seen that there is a Top5 query function, but dammit, I just can't get it to work the way I want :rolleyes: I have a list of prices that I have sorted in a report to show the average, minimum and maximum. I'd like to put a sub report in that shows the lowest 5 prices and the highest 5...

I'm looking to do a report based on average prices. So far I have: Month .... Average Price .... Min Price .... Max Price I'd like to add three more totals using an "if" function, hmmm let me explain. "B" Average .... "F" Average ... "LP" Average (Where B,F and LP are in one column called...