I've got an Access 2000 ADP with an SQL 7 backend.
My problem is this..
When moving from a record in one form to another record in a different form it opens the other from but doesn’t always go to the specific record.
It works fine about 25% of the time and when run through the debugger it...
Hi,
I have an Access ADP linked to an SQL 7 backend that is causeing me a problem in one particular form.
Occasionally when a user selects a value from a combo box, that in turn runs the code below, it generates a write conflict.
The exact message is
This record has been changed by another...
Don't forget to Split your database into a Back and Front End if you do want to redistribute the forms as an MDE.
Before you create your database as an MDE file go to the Tools menu and either in Add Ins or Database utilities there will be a Database Splitter. The initial screen is quite...
Sorry Brian but there are no Events triggered when entering data directly into a table.
You could write an Update Query to say filter for all records that are "Complete" and CompletedDate IS NULL and Update CompletedDate =Date().
It's quick and it's simple and the query can be run...
Sorry, with out looking at your system it's going to be difficult to say what is wrong. However there are a few things you can check, sorry if you've already done this.
Can you ensure that the CompletedDate field has been set up as a Date/Time data type.
Also I once had an error in a database...
I've a beast of a problem here. I want to be able to scan an image directly from an Access form but then scan and save the image with a predetermine name (it will get that from the same Access form) without further user intervetion!
All I can figure out at present is to get the scan application...
Hi Brian,
This is quite straight forward as long as you have based a form on those tables.
In Design view of the form select the Status field and call up its properties (right click the field). In the poperties select the Events tab at the top and within that list find an event called...
Hi,
I have a problem in that I want to be able to specify the path of an image, stored in a text box and by clicking a button I want the correct application to open up and display the image.
So far I've used
dim myFilePath as string
myFilePath=txtFilePath
Shell "Path of Application...
Hi,
To prevent anyone else getting access to your database whilst you're in it you can open it exclusivly. To do this when you go to the open dialog box you can choose Exclusivly (check box in Access 97 and on the Open drop down in Access 2000). If you want to access it via a shortcut onthe...
Hi,
I'm using Access 2000 and I'm having problems using the DoCmd.SendObject method.
All I want to to is use a HTML template.
The Message, To and subject fields are all defined in the code but there is no attachment. I'm using Outlook 2000 to send the message.
According to the help file I...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.