Search results

My problem is that data checking can get complicated and every time a new rule is needed I have to add another If statement in the vba module and re-issue the program so I'm trying to see a way of storing the If statements in a table so that I can edit/delete existing rules and add new ones...

Hi All. I have three unbound controls on a form. If all 3 have content I want to enable a Save button but if any one of them does not then I want to disable the button. I've put vba in the afterupdate of each of them and tried Len(), Nz(), IsNull() and = "". It works fine once all three have...

Hi all, It's been a while. I’m trying to avoid Make Table queries. The result needed is a where records that match are grouped and totalled along with a list of the Refs (item references) for those records that are the same specification. This is a simplified version, in reality it is, as...

Hi, I have two combos with a cost price in Column(2) where the underlying table has a field called fldCost (Number, Single, Auto). After selecting from both combos, cboF1 has 3.11 in column2 and cboF2 has 10 in column2. (eg: £3.11 and £10.00). I'm trying to add the value from both combos in an...

Hi All, Stephen's mousehook works fine, as with all that he did, but I want to disable the mousewheel in the main form while allowing it in the subform. I've searched and tried eveything but no solution yet and the main form is crashing Access big time. Is it possible? Or can I set up the Main...

While putting prices into Sub2, Sub1 gets updated with the total but the Sub1 footer total doesn't update. Can I remotely force a save of Sub1 so that the footer totals get updated as well? Me.Parent!Sub1.Requery works but leaves the focus with the first record in Sub1...

Hi, I'm sending emails ok when Outlook is loaded on the machine but failing when it is not. I've searched everywhere and am getting answers about how to resolve it. The thing is, I'm not good enough to try to get to grips with discovering whatever email the machine may have and I'm happy to...

When I select from a Product combo, the ProductID is stored in the OrderDetails table. The Product combo excludes where Product.Discontinued = True. In time old Products become discontinued. Now when I view an old order, the combo is blank because its RowSource excludes discontinued products...

Hi all, I do try to resolve my own problems but this one is a mystery to me as I'm sure that similar has been fine in the past. I am trying to open a sub set of table "PriceList" which has 900 records and includes the fields ListID(Lng) and Valid(Y/N) but it's not going well... Dim DB As...

I'm able to write a payroll application but I don't have a clue where to start investigating the needs for filing electronic tax returns to Her Majesty's Revenue & Customs via their "Government Gateway". They do provide guidance documents but I'm not getting anywhere with them. Any tips about...

I am using DLookUp as the Control Source of a "PayWeek" unbound control and I can see that this fails because of Access defaulting to mm/dd/yyyy but I can't find a way to fix it. I have searched the forum and found lots from Bob, George, Mile-O and others so thanks to all but although I have...

Problem with a 2000 .mde in Access2007 Thanks for reading this. I am developing in Access2000 but the .mde has to run on a Access 2007 machine and there's some weird stuff happening so I am beginning to hate 2007 before I have had a chance to get to know it. In my subform I have three fields...

I have frmMain with frmSub which performs complex calcs and recommendations when values in the sub are changed. This works fine in the AfterUpdate event of all the relevant fields but I have a separate frmGlobal so that the user can make the same change to all of the records in the subform...

Solved: why does my mdb bloat? SOLVED - I Think!!!. Hi all, This is not about temporary tables or images etc. because there are none so I think it is about what Access is doing (or not doing) behind the scenes. I constantly Compact and Repair and I always work with a fresh copy when I make...

I have a parent frmMain with a subform called frmMainSub. On frmMain there are 10 hidden tick boxes that indicate if an option is required. The tick boxes are completed via a separate form called frmOptions which is opened by a button on frmMain. When I open frmOptions, tick a few and close...

Hi all. Great forum and a few of you guys stand out. I am just a lowly idiot who puts in tons of hours and definitely does it the hard and/or wrong way. I've searched and searched but I cant see a 'correct' way to go about this so heres my problem. Its to do with a Quotations/Orders...

When I use the following to bring up the print dialogue, the report prints and the report closes but then everything hangs. The system line says “Formatting page: press Ctrl-Break to stop” which is useless anyway because all you can do is crash Access. Does anyone have any bright ideas, I need...