Search results

You can make a master query that gets all the information for all the reports that you need. And in your code you do seperate queries that only get the data you need. Here is an example of what I mean from a program I am developing. I don't get info from a query but you can. Dim db...

What do you mean?

no prob

If they want the user to input data in the database through the web use ASP. Make sure there host is able to handle Access database and supply you with a DSN. Some web hosts allow asp but the database format they allow is SQL. If it does set up the website.

You could do it all in one query and set conditions on who to select. For example have a form with 2 textboxes and a check box. If they want 1 or 2 vendors get them to type in their ID or name and run a query in your code which just selects the records where the ID's match and the checkbox...

Sounds like a simple ordering system. Shouldn't be hard to do. I know A2K2 offers a template for order entry.

Wouldn't it be easier to make the format consistant over your entire program. It's a good programming practice *EDIT* Nevermind. It's early and my brain farted:)

By online I'm guessing you mean through a web browser and not an applicaiton. Just wirte up an asp file that looks similar to your form. Error checking is pretty much the same.

Then I'm stumped. Had that error awhile back and that is how I got rid of it. Sorry I couldn't help you out further.

It was in my mind to begin with just had to get it to work.

Try checking Microsoft DAO 3.6 Object Library

Reference are links to dll's In the code editor select Tools->References since it is an ole error make sure that there is a check beside the OLE Automation reference.

Mile I posted a new topic with disabling the shift key

Could be that a Reference has been unlinked. Make sure your references are what they are supposed to be.

Because this was brought up in my previous post here is the solution to disable the user from using the shift key to access the database window during startup. 1. Create a new module and past this code inside it: '---------------------------------------------------------------------' ' Module...

Actually just worked out a way around. In my startup options uncheck everything and select which form I want to start. This gets rid of the right clicking. Also I created 2 macros t display blank menus in replace of the Access menus. Thus not allowing the user to select Record->Remove Filter.

forgot one thing aswell. When the user maintenance screen is displayed therre are no passwords showing. They can change their password only if the password they enter in the old password field matches the one in the db will it allow it.

Thanx for the tip but since this system involves passwords when i am finished it it will be an mde file that doesn't show the database window and also the menu won't be shown. This should take out the ability to edit the filters. Let me know.

Thanx anyways guys. But they way I did was used the BuildCriteria Function to create a filter that matched with the id of the record and turned off athe AllowAdditions property. cheers

I have a user maintenance screen that displays all their information and allows them to change their passwords. How can I get it so they stay on there record only and not go into other records. What's happening now is that when they tab through all the fields it goes to the next record. How...