Search results

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.

I have a Main Form which is for Change Management (Engineering). I have a Subform for the Sign-off Signatures required for that Change. However, I also have a Form to add contacts so in any part of the Main Form you can select from a ComboBox individuals name. For instance, if they own the...

I'm not quite sure what you mean by "the next level". Can you please explain?

Hello all, I have a subform where I am trying to add select contact details from a table already built and assign those contacts to records in my main form. From when i select the contacts i want some of the other information to populate the other fields. Should I actually try to read the...

David, you know, as much as I hate to admit it and concede defeat, I'm going to just work on the basic autonumber generation; and therefore, acheive results like PC0001, TC0002, PC0003, WW0004, etc, etc. I would still be able to filter on the prefix and produce reports, etc. To answer your...

Hi DC, I didn't understand your last post. PLEASE HELP - I'M DEPERATE. Could you forward me a basic DB?