Recent content by theSizz

Try this! access button access options current database under picture property storage format, select preserve source image format. (your setting was probably on convert all picture data to bitmaps.... NOTE ! The FORM must be selected (not the form header) for the formatting to work...

Thanks SOS that worked. It's strange that the original line: Dim rs As Recordset ran fine in the .mdb version Thanks again for the help.

I've converted an .mdb to an .accdb and when I try to run the code listed below, I get a "Compile error method or data member not found" with this line of the code. Do rs.Edit So I went to references and tried to load the DAO 3.6 object library. I got a "Name conflicts with existing...

I have a bound object frame that is a control in a report. I have an entry form that contains the bound object frame control. The contents of the frame is 4 pages of text and images that have been copied from a Word document and pasted into the bound object frame on the form. When I print the...

I am trying to format the form header section of a form in access 2007. I select the form header section in design view, choose the auto format button from the arrange menu on the ribbon, and then click on the desired format. Seems pretty simple. However, I don't get the format that's shown in...

Does anybody know why the lookup code located in frmOrders in the text controls named txtFirst and txtLast don't work in the attached file? Here's my question from the previous message.

Hi Dave, I downloaded the Db you uploaded this morning. Thank you very much. Here’s the reason why I store calculated controls such as Balance Due in the DB. I have another form that searches the DB for all employees that owe a balance. If Balance due was a calculated balance and not included...

Hi softoldboss I’ve been working with the example file you uploaded. Thanks for the lessons. I’ve got a few questions that I hope you will have time to answer. In the form “frmOrders” OnCurrent event the code reads” Private Sub Form_Current() On Error GoTo Err_Form_Current Me.AllowEdits =...

thanks for the example oldsoftboss. I will review the db that you attached and try to implement the changes in the db I am working on. Once again thanks for your time and help.

Sorry, but I don't understand how normalizing the table would solve the edit issue.

I’m having a problem getting the AllowEdits property to work. Here is the issue. I have a form - frmOrders . The forms Form_Current event has the following line of code: AllowEdits = False This works fine and when the user tries to edit a field on the form he is unable to. However, if the...

Thanks Bob. This is what I ended up writing. Private Sub cmdDoSearch_Click() On Error GoTo Err_cmdDoSearch_Click Dim stDocName As String Select Case Me.PickReport Case 1 stDocName = "rptSignOff" Case 2 stDocName = "rptDeptList"...

I have the following 3 access objects frmSignOff , rptSignOff, and qrySignOff. The form FrmSignOff has 2 unbound text boxes and 1 unbound combo box that the user enters search criteria in to populate the query qrySignOff. I want to force the user to enter a control number in the text box...

I have a text box in a report, with it's control source property set to =[BegDt]. Upon loading the report a message box pops up and asks the user for the value of [begDt]. This occurs 3 more times for 3 other parameters. Now I want to change the design of the report so I decided to put these 4...

Thanks Bob, for pointing me in the right direction. I'll use those functions on a form in a calculated field. This will be better than trying to store the calculations in a table. Thanks for the help.