Recent content by scra

Thank you for the reply. I'll give those options a try.

I have a database in Access 2010 and would like to set permissions to allow other users to have the data tables as READ-ONLY and have no permissions to make changes to them but me as the author. I would allow users to link to the tables from my database and have those users open the linked...

Thanks!!!!

Hello. I have a flat file in Excel. There are missing values on each row when value changes. I need to copy those values to each row. I'm not sure if I'm making any sense, but here is an example. Current Output Ticket # Patient Date of Service 1712612 111111 9/15/2011 null null...

Thanks for the reply, but the conditional formatting does not work. I have colored the text box (green) and attached the conditional formatting to color red for No.

I have a report in Access where an option button is visible for each record. As of now, the option is shown in color black when the answer is true or yes. When No, the option button is not filled-in which is expected. However, I do want to change the color in Green when Yes or True and in...

It's me again! What is the correct code to have the form go to a blank form? Currently the form is loaded showing previous records into the form. Private Sub Command44_Click() Dim rs As DAO.Recordset Dim db As DAO.Database On Error GoTo ErrHandle Set db = CurrentDb() Set rs =...

Thanks so much who contributed to this post. You Rock!

I'm still getting a compile error on this... Me.FormFieldName.Value = rs!IssueAssignedNum + 1 Please help.

Max, I'm getting this compile error which hi-lights the IssueAssignedNum. Private Sub Form_Open(Cancel As Integer) Dim rs As DAO.Recordset Dim db As DAO.Database On Error GoTo ErrHandle Set db = CurrentDb() Set rs = db.OpenRecordset("Issues") rs.MoveFirst rs.MoveLast...

Thanks, Maze. Now, the other question is...where do I place the code you provided?

I have a command button name "New Issue" on a form. When I click on that command button, I get a clean form to enter new data. Within that form, there is a field named Issue Number. I would like to assign that field an automatic fill-in number (i.e. last issue number is 35..would like 36 to...

The form is bound to a table. There is a combo box to select a value then populates the other fields. The form itself is not meant to update any tables. I would like to see the form blank when it I open it.

I just want to see a blank form after it's been opened. Undirty it, I guess.

I had forgotten how to code it. Anyone???