Search results

Hi all, Just want to confirm what I am thinking is correct. I've ran an Append Query to select certain fields from the old DB to add it into the preformatted table in the new DB. This preformatted table is based on the table from the old DB but it has slightly different fields. The Append...

True. I was wondering if VBA could access WinAPI functions but that would be too complex and not necessary. However, reading your reply I have another question. Let's say I have a procedure called "CalculateMe". This procedure in turn calls 10 sub procedures like CalcArea, CalcWeight...

Can anyone please have a look at my SQL statement below? It looks correct to me but I get the error " Too few parameters - expected 1"... strSql18 = "INSERT INTO [tblSetTime] ( FKVersionID, txtMachineID,txtEB, txtBE, txtB, txtE, txtF) " & _ "SELECT " & lngID & " As...

Hi all, I've managed to get my hands on some code examples for progress bars but they all rely on a preset countdown value. For example the value of 60000 will show a progress bar that takes around a minute to countdown. I am wondering if there is a way to invoke system based values. I am...

I've started my career as an Access programmer and slowly moved into database and network programming (with some website programming thrown in). The demand in the UK is certainly there especially for smaller companies with growing demands. An Access DB is quick and relatively easy to build and...

Hi, I have a form with a tab control which itself contains 5 tabs. First two tabs are populated with some textboxes but the last 3 contains a subform. When I click on the last 3 tabs the screen will automatically scroll down seemingly to recentre on the subform. This obscures the tabs so I...

Hi all, I am trying to duplicate records in my form. I find the built in "Duplicate Record" macro in 2010 very easy and useful but MS Access keeps crashing when I try to use it presumebly because of some of my controls' After Update events are triggering Null values... Does the Macro...

Well it seems like I've cheated Access long enough :) Everything was working fine until I close and reopened to DB. Now the form crashes 1-2 seconds after it loads. I've removed all code/macros so I think the only thing to suspect is that I've exceeded the number of controls. I am trying to...

Hit the nail on the head there mate :)

@VillaRestal : Thanks for your support :) Indeed most of the controls on my forms are unbound so most textboxes actually displays results of calculations. I would've used a single form featuring datasheet view but the client wants a really specific layout which can't be done with Access...

Now I am really worried... I've used your code and it reports exactly the same numbers as mine! This is my code : Dim Temp As Double Temp = Forms("frmEstimate").Controls.Count MsgBox "No of Controls:" & Temp & ""

Cheers ;) Tabbed Controls count as a Subform too? I've read somewhere by using subform you actually "gain" another 754 control limit... This is interesting as I have most of my textboxes in my tab control. Does creating a new page in a tab control make a difference or you need a brand new tab...

I know the question will be asked ;) 80% of the controls are listboxes or unbound textboxes. The table the form is based on only has 15 fields. The rest are result of calculations based on these values. For example user enters sheet dimensions (2 bound textboxes, width and length) I have 3...

No problems mate :) Thanks for the quick reply anyways!

Yeah, I've found that it let me add more controls now after I compact and repair (MS Access 2010). I guess to get an accurate description of exactly how many controls I have now I would have to follow your instructions... edit: Wow...this is really strange now. I've created a new DB, imported...

Maximum number of controls in a form Hi all, I edited my original question as I've done some more reading and also experienced strange new issues so I hope someone more experienced could offer some advice. Scenario : I was happily working away in my form one evening and while in the middle of...

Did some digging and I've found out due to certain legal issues you can't edit linked Excel spreadsheets in Access anymore :(

I need to create a spreadsheet data entry form which contains certain formatted cells like what you can do in Excel. For example record 5 of column 1 value would be record 2 - record 1 of column 1. In excel you just click on the cell and enter something like " =A2-A2" but you can't do that in...

Hi, I can duplicate a form with a single tiered subform but if my subform have their own subforms I am having issues finding a way to do this. I am using Allen Brownes example but I wonder if anyone can advise? Below is a picture of my table relationship : Uploaded with ImageShack.us

Well..after more experienment I have got most of it working. I can copy over the machines (tier 1) but I can't find out how to also copy over all the subforms related to machines (tier 2). Here's my code to copy over all the machines. Can anyone tell me how to copy and appened the other...