Search results for query: *

I have a table with a composite primary key, name and date. This does not allow a double entry of a person with the same date. However, I would like to, when someone enters a duplicate date, not accept that date and give a message that they already have that date reserved. Any ideas on how to...

Is there a way to allow the user to use the navigation buttons, but not allow them to move beyond the last record? I have been trying to code it in VB but have not figured out a way to do this yet. Any help on this would be appreciated!!!

These answers are what I need. Thank you so much for the help!! [bigsmile]

Trying to decipher some code. Can anyone tell me what this might be doing? Format(lName.text, ">")

Thanks. The data is collected in variables by ASP first then stored to the database. So it appears I am on the right track then by using ASP to make the calculation. Thanks again!

I am working on a project using ASP to store data in a database. In this, the user will answer questions on a webpage and get a response depending on what they enter. There is a calculation needed i.e. case A multiply by x or Case B multiply by y, etc. Which would give better resonse time...

Could I also get a copy of that script. I am working on a similar application as the original post and need all of the info I can get. Thanks. Please send it to maximost@hotmail.com

We have a weekly schedule that currently is kept in an Outlook calendar. It must be constantly updated as people come and go from the rotation. I would like to create an application either with Visual Basic that would automatically pull from a database table to populate the calendar but am new...

Thanks, Omega36!! I have reviewed the db you made available and it is great!

I am trying to set up a VB function using a SQL select coalesce statement which I can then call to replace the autonumber in my Access database. Has anyone used this concept? If so, how did you set the function up? Thanks! ;-D

The query I need and the tables are as follows: Empl - Report - Shoe - Color - Size Name - Date - ShoeType - ColorType - Size My query needs to pull for each Employee a date multiple shoetypes, shoecolors, shoesizes. (This is just an illustration. The way my employer want the database set up...

I have a database set up with a Report table that three other tables are related (many to many relationships) to the same primary key of the first table. i.e. ReportID primary in first table and foreign in other three tables. The Report table is also related to an Employee Table. The three...

My question concerns two subforms on a main form. I am getting records that duplicate the record info on the first subform for each record entered on the second form. i.e., if an item is entered on the first subform and two items on the second subform, the records show the item on the first...

Thanks, Graham! I will see what I can do with this. Appreciate the quick reply. Want to simplify my coding and this will help.

I am also trying to figure out how to do a control array in Access. You said you can mimic them...please explain. Thanks!