Search results for query: *

Greetings! I have an Access 2000 database which I have split to keep my back-end separate from the front end. Today, somehow, it has been set to read-only and I think this is what is causing some of my queries/macros (especially those that run delete and append queries) to not work any more...

We have come up with Flash/ASP code that allows us to make a selection from a drop down menu in Flash, display the selection in a text box in Flash and when a button is pushed on the Flash page, it sends the data to ASP, writes it into a variable which we can query for and then displays the...

Greetings! I am working with a Flash developer (I build ASP pages). Together, we need to send requests from a flash page to an ASP page that houses scripts which query a database based on a selection made on the flash page. We have been able to build a test page which can send the results of...

Greetings! I am working with a Flash developer (I build ASP pages). Together, we need to send requests from a flash page to an ASP page that houses scripts which query a database based on a selection made on the flash page. We have been able to build a test page which can send the results of...

Hello! Can anyone recommend a good web site/tutorial that illustrates how to use Flash to access data within an ASP recordset (if it can even be done)? I have googled the subject and have come up short and could really use some assistance. Thanks, GC

Greetings! I have an onClick script written within an ASP page that, when the link is clicked, pops up a calendar so the user can select a specific date. There is a start date and an end date that the user can select and these variables are passed to a sql query to pull class events from the...

OK. I'm sure someone has seen this error message before and knows what to do about it. If so, I would sincerely appreciate your help before I pull the rest of my hair out! Here is the error message I am receiving: Provider error '80020005' Type mismatch...

Hello, I am building a calendar listing using ASP and VBScript. The calendar contains a field that list a description of an event, which could be more than 255 characters long (Access 2000 database...set as a Memo datatype). I only want to show the first 275 characters of the event...

Greetings! I am building an application where users can log in to view a directory and manage their own user information. The user's information is added to the database via a web form which is not password protected (client request). They can select their own username and password in this...

Greetings! I have a form that keeps track of when a user pays/renews their dues. If their dues are current, their login access is(remains) active. If their dues are not current, then is it possible to have a script kick off, check whether the user's dues are current and, if not, set their...

Greetings! I am trying to create a dynamic list of radio buttons from a table in my database. I want the table to have however many rows necessary, but be three table cells across. I think I have something close to working, just that it is not really working. I am getting the same record...

Greetings! I have been using MS Access to design and build databases for use in several dynamic web sites. They are small sites that do not get an overabundance of hits a month and Access seems to suit them fairly well. I feel that I understand how databases work and how they should be...

Greetings! I am using an ASP page w/ VBScript to query a database for certain records. Once I find the records, I would like to output, or export, the result set to either a .csv file that can be opened in Excel or directly to an Excel sheet. Is there a simple script or method that someone...

I am trying to set a validation rule for my Year field so that it will only accept years that are greater than or equal to 2004 (ex. >=2004). My field is set as a number, yet when I enter >=2004 in my validation rule, it does not seem to work. Can anyone please help? Thanks...G

OK...this may be a very easy question...that I just can't seem to figure out. In my code below, I am displaying sales information based on a date range. When the page is first displayed, a simple form asking for a start date and an end date is displayed. If the user does not fill one or both...

I have a MySQL database which has several tables. In some of the tables, the primary key is an autonumber. I need to convert this db to an Access db and maintain the ID for the table as that ID is related to other tables. Is there a way to convert MySQL to Access and still maintain the...

HELP! I created two reports - one to pull # of leads submitted between two dates and another to pull # leads sold between two dates. Both were working yesterday...yet later that night (after not making any changes to the code or db), both stopped working and kept throwing the following error...

HELP! I created two reports - one to pull # of leads submitted between two dates and another to pull # leads sold between two dates. Both were working yesterday...yet later that night (after not making any changes to the code or db), both stopped working and kept throwing the following error...

Hello! I have a SELECT query that is used to search business names in a database. In some cases, it works...in others, it doesn't. Here is what I mean: It works if there is no special characters such as ' , & . etc. BUT...if someone enters a business name of (for example) Dewey, Cheetam &...

I have a form where I am collecting a user's email address as part of the form. When submitted, an email will be sent to the user containing all of the information the user entered into the form based on the email address they entered. I am looking to use a regular expression to make sure they...