Search results for query: *

Hi All, I found this helpful website, so I hope it helps you as much as it helped me. http://www.kayodeok.btinternet.co.uk/favorites/kbofficeaccesshowto.htm It's a How-To on Access, Excel, Word, Outlook. It doesn't have the answer to everything, but it will answer a lot of the questions I've...

Hello, The people that are having trouble, are they running the app in an IE environment? DAPs only work in Internet Explorer. Also, make sure the download of the MS Web Components didn't fail.

Hi ericksoda, You need to be sure to specify a UNC path, not an absolute path. I had a bit of trouble understanding this, but as long as your folder is shared your connection string should look like this; \\webserver\sharedfolder$\db.mdb Be sure to include the $ at the end of the shared...

Hello, I too had a lot of trouble with a DAP application that I created. But I finally got it to work. First of all, DO NOT set Remote Provider to True. This only causes more problems. Secondly, you said that the app is on an Intranet, so did you add it to the Trusted Sites list in IE? Also...

Hi, Try saving the page as htm. Then in Access, create a Data Access Page. This will allow you to use html and it will write a lot of the code for you, though it's not very pretty. Iashia

Hi ericksoda, Well you need to install the Microsoft Office Web Components. To do this, you need to download the following http://www.microsoft.com/downloads/details.aspx?FamilyID=982B0359-0A86-4FB2-A7EE-5F3A499515DD&displaylang=EN After that, you need to make sure the pages are running on an...

Hi, Why don't you try using the disabled command instead of the visible command. That way the button is only enabled when you need it to be. Iashia

Hi, I've created a login form based on a Users table. My intention is for the user to type in their username/password and the VBA is supposed to loop through the table until that username/password record is reached. Once the username/password is verified, the app is supposed to Open an Approval...

Hi, I have an access application that uses data access pages(daps). I would like to insert a record programmatically. However, I can't seem to get my query working. I'm almost sure I'm using the correct Insert syntax, but instead of inserting a new record, it just updates the current record...

Hi. Before installing it on the user's pc, right-click on the database window, and choose startup. Here you can choose what form should be active on startup. You can also choose to hide the database window so that users can't get to the tables, reports, etc. I hope this helps.

I had this same problem. The solution is to use a UNC path when identifying the data source. It should look something like this: \\webroot\foldername$\dbname.mdb Also, be sure to make the folder shared, as this allows other users to access it.

No. Autonumber fields can only contain numbers. Access increments the number based on the maximum value on file. You need to create the field as Text, and program the incremental values behind the scenes.

I'm using the following script to insert records into a table in my MS Access db. I am using Data Access Pages for the front end. However, I keep getting the error: "Arguments are of the wrong type, are out of acceptable range, or are in conflict with one another." Does anyone know how to fix...

I have an MS Access db. I am using data access pages to allow users to create/update records. I have three diffeerent pages. My first page is fine. Everything works great. It's purpose is to define a project. I have a separate page for each department however, and these pages are based on...

I tried to use the way you gave me but it didn't work.

I have an MS Access application that contains 3 data access pages (DAPs). The purpose is for department heads to record and track projects and their activity. I would like to limit the pages so that each department head may view only the projects that are relevant to their department. Currently...

I have created some Data Access Pages (DAPs) that reside on an Intranet, and whenever I try to load the page from Internet Explorer, I receive the error - Internet client error: cannot connect to server. I have added the web server to the Trusted Sites under Tools --> Options. I have also...

I have added the script you indicated, but it still doesn't work! What I want to do is be able to filter the recordset based on the user logged in. I have set security on the database, and I am still able to view ALL records, not just the ones that are pertinent to my username/department. I have...

How can I limit the recordset based on selection criteria in a DAP?