Search results

i have a text box "textMemo" (data type = memo) on a form that is populated by "textMemo1" (data type = memo) =Forms!frmMenuReports!subfrmReportMemo!textMemo1 textMemo populates a text box (Tmemo) on a report =Forms!frmMenuReports!textMemo.column(2) when i open the report i get #Name in...

i get the same error i assume its a userlevel security issue i will just have em export the data using file - export thanks for trying merry christmas

thanks for you replies thanks to both of you for replying dont mean to be ignoring your replies i am in the middle of a war over here in iraq and we had a bad day yesterday i tried the code you provided but now i get Run-time error ‘3051’ It is already opened exclusively by another user, or...

the following code DoCmd.TransferSpreadsheet acExport, "qryMonthlyStatusReport_Active", "C:\AccessExport.Active.xls" produces the error Runtime error 13 Type Mismatch i am 2003 versions of access and excel please help thanks

no, the text box is enabled and not locked

i had tried that already as well same error thanks for the reply

What is the best way to have all controls in a subform empty when form opens? The form and subform are bound. The following: Private Sub Form_Open(Cancel As Integer) Me.textDate = Null End Sub Produced error - "cant assign a value to object" thanks in advance

Now i have another issue when tblReport!fldReportTypeID is null i get no records...i dont know what is causing fldReportTypeID to have null values is there a way to prevent that from happening? or code i can add so that all records are visible if tblReport!fldReportTypeID is null? thanks in advance

I got it! Solution below - Me.cboReportType.RowSource = "select fldReportTypeID, fldReportType from tblReportType where fldReportTypeID Not in (select fldReportTypeID from tblReport Where fldProjectID=" & Me.cboProject & ")"

I have the following code in the second combo box on a form Me.cboReportType.RowSource = "select fldReportTypeID,fldReportType, fldFrom, fldTo, fldDue from tblReportType Where fldReportTypeID Not in (select fldReportTypeID from tblReport) order by fldReportType" right now this code is...

many thanks to oldaf294 and RV and happy thanksgiving!

Hello all I need to get the difference between 2 date fields on a report All records have a startdate but not all have an end date, I need to place a IIF then (i think) in the control source of the text box on the report so that the difference in the two dates will be either: 1) between...

good eveinng everyone need some help updating a populated table tblOne fldA, fldB, fldC frmBlue record source tblOne (all fields) i need to open the form and search for a record in tblOne and change the data in say fldB from apples to oranges (tblFruit is a listing of all choices for fldB) i...

i have a db that works fine on computer it was created on all computers have office xp/windows xp 1. split db using the database utility - database splitter to create a front/back end 2. copied the front end to user computers and linked tables (back end is on db admin computer - not a...

i have a db that i took from work and brought home to work on when i try to preview a report i get a window saying that the network printer isnt available... the code on the command button to open and PREVEIW the report is below DoCmd.OpenReport stDocName, acPreview, , strWhere why is access...

the error went away but...now the value isnt being passed to the query

i get an error wrong number of arguments...

what do i add this statement so if a selection isnt made from a particular combo, the comob is ignored and the query uses only the values selected [forms]![frmOne]![cmbOne] something like this [forms]![frmOne]![cmbOne] or is null ? thanks

thanks roy i will try your suggestion

I get this error when i try to select a record from a combo box....error 3021 - Either BOF or EOF or record has been deleted.... Can anyone tell me what BOF and/or EOF is? i know the record has not been deleted. thanks pat