Search results

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...

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...

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...

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

Hello all I have a report that uses a week number in the query to select the records for the week. My week is always Sunday through Saturday ( seven days ) I have a function that up to now has always worked well until this year. What I need is to have week one with any day of the week falling...

Hi all I have been trying to use one form for many different reports. The basic form "year selection criteria" is used on all of them. I want to change the caption and some labels for each different report. I have opened the form on the open event of the report changed the caption and some...

Hello All, I have a printing problem with a report that has a sub report in the footer. The sub report always starts on a new page leaving a large white space in the footer of the main report. It is functional but looks hellish. In the main report I have a list of items in the detail with both...

Hello All, I have a report that by making the detail section visible or not changes it from a summary to a detail. I have an option group with two buttons summary value 1 and detail value 2 In the report detail On Format property I have the following code...

I have a main form with several with four subforms. On the main form I have a bound text box [ShiftTotal] I have on each subform a unbound text box that sums a field [ExtTaxIn]. I am working with just one subform till I can get it to work correctly. The code I am using on the after update event...

Hello I have a Main form with several sub forms on it the tables behind each form are related tables. The user enters data on the main form with the exception of one bound control then moves on to enter data on the sub forms On exiting the record or the main form I want to take data from several...

Hello all I have a query based on a table which has a date field. the field both in the table and the query have the time also in the date value so when I try to query on a date I get nothing if I copy the date and time from the field I will get the result for that record if I just use the date...

I have a form with several command buttons to run reports. When I open the form I used the docmd.maximize and when I use the button to run the report it runs but when I close the report it returns to the form which is now sized not maximized. I want to have the form as it was before I opened the...

Hi I have a main form with a table as its recordset. I have four subforms with queries as there recordsets all quering the same table but four different groups of data. they are linked to the main form with child master relationship. This all works well in regards to data entry and saving to the...

Hello all I have a main form with a tab control with three pages. On the first page I have three subforms each one has table linked to the main form. What I am trying to do is update one field in this table which I have the tab stop set to this field only. When I tab down the table on this...

I have two tables linked together ( shift main & shift detail ) I want to import values from an array into the detail table maintaining the relationships with the shift main. I filled the array from a seperate table and want to insert them into the shift detail table. Thanks in advance Bob

Hi new here and a novice to access 2003 looking to build a database to look after out local Legion bar