Search results

G'day all, long time... Hope everyone's well! I've got this spreadsheet with four tabs on it. Three of them have querytables looking at an Access DB and all is well. But... I want to change some of the criteria in a couple of the queries to reflect what's in a particular cell on the...

Hi all, how's it going? Got an annoying one.... (aren't they all) I've got a routine that looks like this: Public Function Max_Salesorg(ParamArray flds() As Variant) As Double Dim i As Byte, MaxOrg As String, MaxVal As Double MaxOrg = flds(1).Name MaxVal = flds(1) For i = LBound(flds) + 1 To...

Afternoon campers, I have a head scratcher..... This union query is a bit strange:SELECT [Full Sales History CY-0 AEM].Month, "AEM" as Region, "CY-0" as Period, [Full Sales History CY-0 AEM].SalesOrg, [Full Sales History CY-0 AEM].Material, [Full Sales History CY-0 AEM].[NS(F)], [Full Sales...

Afternoon all.... Happy Friday! I've got a series of text boxes on a subform whose control sources are update using VBa, depending upon what the user has selected in some combo boxes on the main form. The control source runs along the lines of =avg(iif([Tagged]=True,[fieldname],Null)) but it...

Afternoon all, hope you're well! I've got an odd one here. I have a form that has a variety of subforms, within which lie some calculated controls for totalling up sales etc. When I open this form, it seems to get stuck in some sort of calculation loop, with the contents of all the subforms...

Morning all! Long winded and annoying one - get yourself a coffee.... :) I've got a table with SQL statements in it. I've got a recordset going to cycle through the records and append querydefs. It works OK on the shorter queries, but some of the statements are really long and it seems as...

Afternoon everyone! Wondered if you could help me out on this rather simple one... What I need to do is add a string to the tag property of certain textboxes in certain forms in my DB. How do I say "for each form in currentdb.forms"? Here's what I've got so far:Sub ReTag_Controls() Dim Frm As...

Happy Friday to one and all! So, using Access 2007, I've finished version one of the DB I've been writing. It's ready to send out so I made an MDE of it - which doesn't work with 2003. I've done some googling and found out the 2007 MDEs don't work with 2003 'by design', which is bonkers, but...

Afternoon all!! Hoping you can point me in the right direction here.... So - I've got this bit of code. It's supposed to read the paths of folders and subfolders into an array, which I'm then going to cycle through with another Dir command to find MDBs and compact them. The process is: Call...

Morning all, I wondered if nayone else had experienced this - I'm using Access 2007 at the moment. I'm getting huge delays when doing the following (in the order of 30 seconds - 1 min): Switching between form/design/pivotchart view Switching between property sheet and field list in design view...

Afternoon all! Hope the weekend was fun.... So - I've just written a nice little module to relink some tables in a front end, depending on where the user has decided to install the application. In the module, before I append the new tabledef, I've got a string specifying the connect string -...

Morning campers! Hope the sun is shining where you are... So - I've done a bit of googling and it seems this isn't possible, but there are some clever types on here so I thought I'd see what we could come up with. I'm trying to get a subform to show a list of products down the left side, and...

Hi all - I've been trying to help stu_c out with his company car database. Basically all it has to do is take two dates and consult the hire table to see what cars aren't on hire between those two dates, and populate the list box with the appropriate car reg numbers. There's a query to find out...

Bonjour mes amis! Another odd one... but then they all are... So - I've got a make table query, based on a few crosstabs. The data type for the Value in the crosstabs is set to "Fixed", and when I run one of the crosstabs by itself it works fine. However when I run the make table, the table...

Morning campers! I've got a bit of VBA that exports the recordset of the form it's called from to Excel. It works fine, but there are a few calculated controls that sum up the data on the form, which I'd also like to export. Any ideas? Thanks!

Hi all - I'm almost certainly being an idiot, but it's been a long week.... I've got 12 fields that I need to take an average from. How do I do this in one field in a query? I get the feeling I'm going to be slapping my forehead and saying "D'oh" in a loud voice in the middle of the office...

So then, yet another odd one - I've got this form, image attached. As you can see there are a number of check boxes to the left, these are used to 'tag' a particular record for including in reports etc. The text boxes at the top are supposed to sum up the sales figures for those records that...

Afternoon all - I've had a couple of stabs at this and can't quite figure it out... I'm trying to write a public sub that will export the contents of the subform it's called from to an Excel file. The subforms are in continuous view, and each record has a 'tagged' check box. I want to export...

Bonjour all, hope you're having a fun day.... An idea popped into my head, and I wondered if it was doable - is it possible to make a form expand into sublevels when in form view? I've seen it before in a table's datasheet view, but can it be done in form view? What I'm trying to do is this...

Greetings all! Another odd one... So - I've got this make table query. It's supposed to cobble together two other tables from two other databases, one being about 400MB and the other about 700MB. It has about 30 columns. Strangely, I can view it in datasheet view no problems - it seems to...