Recent content by gunny3000

Dear members, my recently "robust" application was changed (Forms, Tables, Queries). Ever since I reconnected to the Live Back-end data, I have been experiencing some issues: 1. multiple requests for the password, and then, states not a valid password. On the re-attempt, the password is...

Simon, Just to let you know that the DB I have sent is not a "split" file. it is only when the DB is split. I have re-sent the same DB, but, it is split.

Hi Simon, I have a "Clean" version without too much incriminating data for me and my company. You advice and guidence is welcome.

Access not great then! I've hardley created anything too large or complicated. Without data my DB is only 1.2Mb. Is there really nothing I can do? what about the "Temp Tables"?

I have a very basic piece of VB code to view the Report of the current record: Private Sub Command270_Click() On Error GoTo Err_Command270_Click Dim stDocName As String stDocName = "rpt_Change_Management" DoCmd.OpenReport stDocName, acViewPreview, , "change_ref_id =...

Hi, I appreciate that there are other threads on this, but, they do not specifically cover my issue. I have also read about "Temp Tables", but, I didn't understand how to create a Temp Table, and therefore, I'm not sure how to use these. My Issue: I have a report that references a number...

I have read on many forum pages that Temp Tables cure some errors pertaining to common errors for split DB's (too many records open... or something like that). I have not yet split my DB, but, it would be better if I could. My DB is not large and I do not have many Queries (or Tables). I...

Hi all, I have developed my DB. I want to lock-down the DB to users, and, make the file exclusive to avoid duplication of records and other associated errors. I have gone into the 'Advanced' 'Access Options' and checked the 'Default open mode = Exclusive'. Alas, this does not work. I do...

SORTED!.... Thanks, you're all legends.

RG, I have to admit that I have never done this and don't know how... any pointers? (you're dealing with a novice by the way)

Hi, I don't have a lot of code, but, I have all the Form and Report standard Command Buttons that I created from the Wizard. They all work fine to be fair.

Is there a global setting in Access 2007 I should know about?

RG, Yes, the auto intellisense pop-up comes up with my selection as a choice. I also like to leave the uppercases off on purpose and watch them change when i press enter... John, Yes, the Command Button and CheckBox are on the same Form. this is a strange one!

thanks but I must mean 'checked'

Hi, I'm terrible now at VB... I think I've lost my marbles getting old! I have tried the following to "activate" a Check Box using a Button... Private Sub Command270_Click() Me.Print_Mark.Value = True End Sub I need help please.