Nick Cooper
Last Activity: Jun 9 '13, 09:01 PM
Joined: Jul 16 '10
Location: Home
-
Thanks for your help Seth. I think I'll stick with the first solution. -
Thanks Seth, Yes I have now done that and it's certainly an improvement, but somehow it seems neater if the user is taken initially to the top of the numerically then alphabetically sorted list of records. Some of them will not be too conversant with the use of datasheets. Also, I use the form caption to describe what action is needed and it would be good if the blank record waiting to be completed was immediately below it. No big deal but if...Leave a comment:
-
Open datasheet with new record line at top
I have a form in datasheet (Edit) view that is many records longer than the page height. The usual reason for the user to open this form will be to enter a new record, rather than amend an existing one. It would be neater and require less keystrokes if I can make the new record entry line appear at the top of the datasheet to avoid them having to (find and) click on the 'enter new record' control and then be taken to the bottom of the datasheet.... -
I went with ZMBD's first thought which works fine. I set up a query that excluded the record 'Private Customer' then used a form driven by that query to provide the front end for the operator to enter new account details into the Accounts Table. Obviously that form doesn't include a record for the Account named 'Private Customer'. The Bookings Form for which the Accounts Table provides a look up list of Account holders it still refers back to the...Leave a comment:
-
Thanks for that (collective) advice. Also my apologies to ZMBD for attributing his 'thoughts' to Seth. It is all useful and I must now set about testing and implementing accordingly.Leave a comment:
-
I think the solution lies with Seth's second thought but have yet to test it. Just to explain the problem in more detail - one of the fields in a Bookings form is 'Account Holder' whose data comes from the table of Account Holders (and their addresses, bank details etc) as a drop-down list. One of the Account Holders is named 'Private Customer' presence of which is tested for in order to bypass the actions associated with invoicing etc. It is therefore...Leave a comment:
-
Making a single record in a table read-only
On issue of an Access 2007 database in runtime mode I need to include in one of its tables a particular record that will be read-only for the life of the database whilst all other records in that table can be added, edited or deleted by the user. Is there a method in Access to do this(?) or maybe I have to use VBA to enter the data every time the table is opened, but this seems messy. -
Thanks. Your VBA solution typing in "me.datasheet.B ackColor = RGB(X,Y,Z)" on opening the form worked fine!Leave a comment:
-
Thanks guys. This database has quite a few Forms. Some are converted from Queries primarily to make them programmable, but also to be able to make them intuitively recognisable (or so I thought). I wondered if this might be achievable using the BackColor property in VBA on Form loading, but your replies imply not. Thanks anyway.Leave a comment:
-
Changing Form back color in Datasheet view - Access 2007
I have some Forms that were created from Queries and are presented in Datasheet view. I can change the back colour in design mode but when I save changes and open the Forms they revert to the old grey color again. Is there some VBA code I can use to set the colour every time a form is opened? I've had no success so far. -
Time differences meant I didn't get to see the later messages until I'd incorporated Seth's initial solution which was simple to implement and is just the job, although the ensuing advice about the general principles on warnings, over-use etc is taken on board. There is no other means of deleting a record on this database other than this button so I think it's watertight.
Thanks to all for the good advice.Leave a comment:
-
Nick Cooper started a topic Deleting Records in Form View: stay on record selected prior to deletionin AccessDeleting Records in Form View: stay on record selected prior to deletion
With all Access databases I have used, when I select to delete a record in Form view, the next record becomes the background for the message asking if I really want to delete a record. That makes it difficult to confirm that I really did select the record I wanted to get rid of. Can I make it stay on the record selected, prior to deletion? -
Hi Z, As a postscript to the above, in the absence of the ability to use wild-cards in directory strings, I have found a solution that does not need to use the ShellExecute command and is therefore resilient to the Mac/Parallels problem, but also handles older Adobe versions as well as future updates.
There are three variables along the path to the executable:
'Program Files' with or without the subscript (x86)
'Acrobat' or 'Reader'...Leave a comment:
-
Sorry Z, I didn't make myself clear. My last question didn't relate to the Mac/Parallels problem. The code I just sent works fine on MS or Mac/Parallels computers and using it gets me round the previously discussed compatibility issue. It's just that I need to make strProg resilient to changes in the Adobe version number in the 3rd directory.
However, from what you've said, it seems this can't be done by using a 'wild card' in the stricg...Leave a comment:
-
Maybe there is another way I can get round this problem. The reason for the above code was to ensure that a PDF could be created without having to bother about the Adobe version number being updated. Originally I used the following code, but it was messy as it would require the user to update the path every time the version changed:
...Code:Private Sub Form_DblClick(Cancel As Integer) Dim strProg As String Dim strFile As String
Leave a comment:
-
Well I guess that makes two of us! Post #123 in your link seems to offer a solution which I might try, but you can't really distribute a database along with some complicated instructions to make it work properly on some machines. It looks like I will have to reduce the functionality to ensure compatibility across the board. Shame.
Thanks for your guidance!
NickLeave a comment:
-
Thanks for that and no probs about the delay. Yes, PDFs do open from Windows Explorer, but not when accessed via the ShellExecute command from within Access. Sadly that is still the case when I replace the 0 by a 3 in the 6th line of code, as suggested. I confess to not being an expert on the coding, having pasted it in from a previous interchange with 'Bytes', but it has worked flawlessly for 2 years now, on a number of XP and Windows7 OS computers....Leave a comment:
-
The Mac is running Access 2007 and it is using Version 7 of the Parallels Desktop OS.
NickLeave a comment:
-
Problems running an Access dbase on Parallel Desktop for Mac
Hello, I have developed and tested an Access database that I now wish to distribute. It works well on all computers tested, including an Apple Mac running Parallels Desktop, but with one exception. When using the Mac, on the command to open an existing PDF it fails to deliver, with no error message. The VBA I am using to do this is as follows:
...Code:Private Sub Form_DblClick(Cancel As Integer) On Error GoTo 10 Dim
-
How do I deploy the Package Solution Wizard
I now have my Access 2007 database ready for distribution and have downloaded the appropriate AccessDeveloper Extensions.exe and AccessRuntime.e xe files, however I cannot get the Package Solution Wizard to run. It seems that AccessDeveloper Extensions is installed as when I double-click the .exe file it asks if I want to repair or re-install it, but I am not able to get it to run and take me to the Wizard.
No activity results to display
Leave a comment: