Search results

Perfect, thanks :)

Greeting i have a main form with a subform the subform value has "ID" value with a relationship with the the main form now if i delete a record from the main Form, the records in my subform will have no value to relate to i do have a Delete Button in my main form , so what i want is, when...

Thanks Pat for the reply what code should i use (eg: hidden botton) to fore to query thanks again

Greeting, - i have a form, that has a List Box coming from a table ,, This list box when you click on it, it shows that field in the main form - and i have a front end and a backend to this database, - When i add a new entry in my main form, it shows in the List Box just fine, but when i...

thanks guys ghudson: i tried your suggestions, but it didn't work in my subform, i forgot to mention, that i my subform has a subform maybe that is why its not working ?? so my question will be.. what can i do for a subform inside a subform ?? thanks again

forgot to mention, that the form opens fine after the error message, and when i hit the date desired to be put in the field , it gives the same message again,

Private Sub tblDateCreated_DblClick(Cancel As Integer) DoCmd.OpenForm "frmCalendar", , , , , acDialog, Me.Name & ";tblDateCreated" End Sub where "frmCalendar" is the calander , and the"tblDateCreated" is the date field this code works if the form opens as a form, but not as a subform i'm not...

Greeting i'm kind of a rookie with access : ) i'm using the attached popup calander in my form and subform ,,, it works perfect in my form but when using in the subform, i get an error saying "the specified form can't be found" if i open the subform as a form it works so my question, is do...

Hi , i would like to show the Tap contorl from the bottom example: instead of the taps be on top of the form i would like the taps be at the bottom any help ? thanks in advance

Perfect works great, Now i have very very minor problem, the date now is showing in this format 1/2/2004 in the report, now i would like to change the it to 1 Feb 2004 , Note, that i DID change the input Mast in the FrmDate ,, i looked in the unbound properties but there is no option for Input...

Here is my scenario: I have a form called "Date Range" which has 2 unbound feilds , i use this as a popup Form throught my database when i want to print my report, so i could filter specific date, this part works just fine, On one of my reports, "end of year report" i want to show the date...

Greeting , I have a report that pulls out a Memo field from a table If the text in the that memo feold is too big, the report doesn't show all, it cuts it out accourding the text box size, Is there anyway , i could have the report to automatically grow accourding to the text , ?? Thanks in...

Thanks TB, I have more then one table in my report, do i still use the code you provided, and add the others table, eg: SELECT TOP 1 BloodPressureID, TodayDate, BloodPressure, feildTable1, ,,,more feilds FROM tblBloodPressure , tblTables1, tblTable2 ORDER BY BloodPressureID DESC; ...

Greeting, I have a subform of a main form, that records "bloodPressure" of a patient, the table that the subform uses has 3 feilds, "BloodPressureID", "TodayDate" and "BloodPressure" , Now when i print a report, i have only one field for the "bloodPressure" where i want to show only the last...

Works great, Thanks,

Greeting all i have a report showing an invoice, on the last line of the invoice i have the total, its showing "balance Due" and the amount $ beside it. Now what i want to do is, if the balance comes up with a (-) value, i want to change the "balance Due" message to " Balance" so...