Search results

Thanks for the input. Both databases are not used by to many people at once. For now they will have to live with it.

I do not see that option in access 97.

I am compacting a database everytime it is opened with the following code: DBEngine.CompactDatabase str2Print_TDI_Path & "NewTDI_be.mdb", strTempPath Kill str2Print_TDI_Path & "NewTDI_be.mdb" Name str2Print_TDI_Path & "NewTDI_be1.mdb" As str2Print_TDI_Path & "NewTDI_be.mdb" The problem I ran...

Is there a way to put a functioning button on a report. Have a rpt that is at times more than one page and I want to duplex print at that time. They also want to preview the report prior to printing and do not want to minimize the report to click the duplex button. Any ideas?

I have purchased an new laptop with Office Professional XP. I cannot get the font color to change in access. Palette comes up, I can click on a color but it does not change? I have went into setup and added all of the options to access not loaded originally. I can change the font color in...

Pop-Up Problem Thank you, thank you Rich! I knew I was having a brain cramp. Thanks for the relief.

Still having Trouble Because these are both pop-up I cannot seem to get Docmd.minimize to work. Both forms still seem to have focus when the report appears in preview. I have tried to use a macro on the open event of the report and get errors. I have tried to use Forms!frmXXXXX.minimize on...

I have two pop-up forms that I want to minimize when a report is previewed. Now the two forms stay in front of the report that is being previewed. Anybody have any ideas?

Dim strOrigSSN As String Dim strNewSSN As String strOrigSSN = "123-45-6789" strNewSSN = "*******" & Right(strOrigSSN, 4) The new SSN should look like this: *******6789 I put the * in a string and using the & attached infront of the Right statement. I think this should work.

Check out the Right function in Access help. this allows you to return a certain number of values from the right side. Should help

Is it possible to edit a power point slide within Access? They want the ability to change the name of a company on a power point slide using criteria from a query, then print the slide. They want to do this from a button on and Access form. Who thinks up this stuff?

Finally!!!! I had the Allow Edits property set to No. Always need to go back to the basics. I was trying to not allow any changes to the data entered once entered. This works ok if the form is bound to a table but not if it is unbound. Thanks again for all of the help. This a great web site...

One more question. I am using Access 97. Are you on that or higher version?

I already have done just that. They both acted the same way. I also have another cbo box on the same form and it also acts the same way. I do thank you for the imput. I will keep working on the problem. If I find the solution I will post it. Happy New Year

The enabled property is set to Yes and the Locked property is set to No. Strange to me too. I am working on a work around but someone would think it was programed by Walt Disney it's pretty Micky Mouse!!!! Might work though

I placed your code suggestion in the load event of the form that contains the combo box. i.e Me.cboFunctionCode.RowSource = "Select Code, Function " & _ "From tblfunctions Order by Code" Me.cboFunctionCode.Requery It does populate the combo box but will not let you select a record within the...

I have an unbound entry form not populated by any query or table, that users enter date, function, number, time and user initials. The function is a combo box with a list of 97 different functions to choose from. The time function can have a user entered time value or I have created code that...

Create Macro that uses the output to function and save as rtf. Place macro in the click event of the button or doCmd in the event procedure of the clickevent on the button. This might work.

Try a db.update or db.refresh this might help.

I finally created a Create Table function. When I defined the fields I inserted a variable within the field name to update the information I needed. Might help someone else. Thanks for the input.