Search results

I think I know what it is... It's the space in the CHM files name C:\Documents and Settings\pwatson\My Documents\HelpFolder\Database Help.chm How silly of me. I've tried it on my PC, and while I never got the error message, I did get a blank MS help screen that froze. When I deleted the...

I'm using winCHM which is an authoring tool. It compiles it for me. Unless it's an errornous program it should be compiling it properly. I can access it as a help file and there's no errors within the CHM file when I view it. I'm thinking either I'm doing something wrong or I'm missing...

Hi, it's Access 2003 v11. It definitely uses chm. files.

Hello all Well, I've created a help file using an authoring tool to make chm. files. I've put the path name in the "Help file" property and I've put the Help ID there as well. When I press F1 in form view I get the message "Error starting ms Help". I've had a look for this error on the net...

Hey, thanks for the help Fernando. I tried it, the only problem was that because old records get archived, whatever ID I put might, at one point, might cause Access to filter nothing. I tried the RecordsetClone.findfirst, I was a little weary incase it was slower (I'm not really sure if it is)...

Hi I feel a little silly asking a question that is very simple. however, I can't find much documentation on the net etc. I know how to create a combo box filter with code but I don't know how to create a filter on form load to limit it to one record when the form opens. That's all i'm trying...

Thanks for the help Ruralguy

the call tree? Thans Ken That is actually quite helpful; streamlining business reports. The reason I asked about putting some procedures from a form module into a standard module is that, apparently, each time a form is loaded, the whole module is loaded into memory and any procedures that...

Hello I've heard that putting code from a forms module into a standard module can speed things up. My question is, how would I do this? I mean, could I put lots of forms code into a standard module? and would access still know that the code was for that form? I'm not really sure how to do...

Hi folks. I wonder if someone can help me with some code. I have an input form with my criteria text boxes. I set my criteria and I use the command button to preview my report. I'm actually using two sets of code courtesy of Bob larson and Martin Green. When I use one part of the code...

Thanks for replying to me Ucle Gizmo I personally thought it'd be the Calculation/expression that I was using and perhaps Access was running into some kind of confliction. I've left that calculation behind as it's not needed anymore. Ofcourse, the worry of having too much stuff in one form...

Hi there I have a question. Is there a point where a form can have too many controls (as well as tab controls with more forms) and Calculations (inc. VB code)?? I have one form that has several controls and calculations and when I tried to create a list box the form died on me as well as...

Hi I have two sets of tab controls on my main form. I want a page from one tab controls to be invisible while working on a form within the other tab control. This should effectivley hide the appropriate form. I've tried this but I didn't think it would work anyway. (Not really sure where to...

Hi there. I'm getting a really annoying dialog with the title "Error in Form_Current" and it says "resume without errors" and it's not going away when I click it. The form is a main form with multiple subforms and I'm in the process of trying to find the form_current event that might be...

I used the Int() function to strip the Fractions. Found it in the book 'Data Analysis' and had help with the syntax. Me.txtPerc = Int((DCount("*", "qryPercentage") / Me.txtTotal) * 100) & "%" Thanks again for taking the time to help.

I've tried to set Decimal Places to '0' alreay, that doesn't work. I'm not as experienced as a lot of members here and I always make sure I do as much research as I can. I've looked for articles on how to deal with the Format() in regards to striping the Decimals and can't find anything. I'll...

oops, sorry, I didn't explain that one at all. what I meant was, in the database the record with the highest year is 2009, anything after this will be added in time when the records are created. That's why I'm getting the 'Overflow' I'm sure of it now. So, I've just handled the error. I'm...

Thanks for the reply folks. The code I've shown is the only code, there is no Variables. I'm not really sure if and what was needed in regards to variables. PetehillJnr, I think it might be something to do with a 0 but not with the txtTotal. The query the code refers to, qryPercentage...

Wonder if someone can help me with this problem. I've got a form with text boxes to create a percentage out of records that have a numeric field. there are text boxes that allow the user to select a currency band i.e £0.00-£50,000.00 etc and then hit a command button which will show the...

Hi there I'm a bit confused with this. I have a database which I've split and I've put both the frontend and the backend onto the network drive. I'm pretty sure it's the case that the backend should be on the server and the copies of the frontend should be deployed to each of the computers...