Search results

need to clarify The main form has several sub forms in the interest of keeping it simple I am only dealing with one sub form for this as once i find the problem is for one i will do the rest when solved. Two forms a Main and a sub On the the same code on the current event of both main Form...

Hi All Thanks in advance I have a Main form on current event that checks a yes/no field and allows or disallows edits depending on the value. I have also subforms that do the same. When I go to another record the main form works fine but the subforms allow edits no matter what the yes/no field...

this works Me.FirstName = Left(FirstName, InStr(FirstName, Chr(32)) - 1) This does not Me.Surname = Right(Surname, InStr(Surname, Chr(32)) -1 So cant figure it out any idea's Thanks Bob Code -------------------------------------------------------------------------------------- Private Sub...

Hi all merry Christmas to you all I have a combobox on a main form called Employee it uses a table called tblEmployee Employee_ID auto number First name Text Last name Text Phone number Text Inactive yes/no On the form when you select a name it places in the field...

Hi All I went back to the drawing board to check what results I needed and found that the cash register dealer who told me that that the cash rounds up was not correct. I used a query to load the data into Exel and the tried all the different rounding options and found that rounding down is...

Thanks CJ_London for your response. I had to go back to check out my requirements and did a query to Exel and checked out the roundup function there and it did not produce the results I expected. I have code that takes $4.75 tax in and calculates the base price. Code...

Hell All I am looking for a function to roundup currency. Exel has this function but Access does not. Rounds a number up, away from 0 (zero). Syntax ROUNDUP(number,num_digits) Number is any real number that you want rounded up. Num_digits is the number of digits to which you want to...

Tried to put thanks in with a few details but could not enter anything other than name also want to mark thread as solved Thanks again Bob

Hi all Well I finally have got it all worked out with you guys ( Beetle and sneuberg ) I am still a novice but working on improving my skills I have uploaded a working model for other people to see so your efforts will help some one else.

Hi all here it is working and yes I did go back to previous posts for the solution. Just when you think you have it beat there always seem to have a twist when I open the form I get errors on the two text boxes that have the DLookup function in them and what I want is to display 0 until you...

hi all that part of the problem is solved thanks for all the help. My next challange is to have a text box that the user can supply the week ending date part of the DLookup function any idea's welcome. thanks bob

Hi jdraw, Beetle and sneuberg That part of the problem is solved with the txtbox set to currency I was not just getting it now it makes sense thanks all. Now I need to input the date from another txtbox when I open the form Thanks Bob

Hi the make table query sums and groups records based on the week. Each day is a record and the WkEnding field is the ending date for each entry so I want the sum of the weeks payins the WkEnding is the selection criteria so I want a dollar value for a series of dates Bob

Hi Steve, I have tried all formats no format result 1110.2 General Date result 1/14/1903 4:48:00 am Long Date result Wednesday January 14 1903 medium Date 14-Jan-1903 Short Date 1/14/1903 so that does not seem to make any difference BOB

Hi all Beetle picked up on the table name which was misspelled was tbDepositInformation and should be tblDepositInformation when i put this in the intermediate window it returns 1495.65 when I open the form now I get the date 1/14/1903 Where did that come from?? Bob Ps running access 2003...

Thanks sneuberg for your reply. I tried what you suggested in the immediate window but it just returned what i typed in minus the question mark so not sure what to do with that. i am still a novice so not very good on some of the technical stuff. I have a make table query that does sum and...

Hi All still :banghead: I have created a blank form ( Form1) placed a single text box on the form and tried all the variations suggested still receive error when opening form. not sure where to go from here. It seems a lot of people have this problem and no solutions Bob PS surely someone...

I have a form with a text box and have the control source set to the function listed below. Payin is currency and end is a date. I get the following error (#error or name ) . I have tried many different configurations to no avail any help would be appreciated. Thanks Bob...

Thanks it pointed me in the right direction and made me change my approach

Hi all I have a report with five subreports and each one has a total which is used in a calculation in the main report. When any of the subreports has no data I get an error on the main form. Thanks Bob