Recent content by sam77755

in that case eric go for the builder.

1. How do I go about entering parameters through a form 2. how do I put in a drop down box that will list all of the values available for a field in the query? 1- there is 2 ways the first is coding it. and the second is to use the query builder to select the fields you are getting the...

1. How do I go about entering parameters through a form 2. how do I put in a drop down box that will list all of the values available for a field in the query? 1- there is 2 ways the first is coding it. and the second is to use the query builder to select the fields you are getting the...

1. How do I go about entering parameters through a form 2. how do I put in a drop down box that will list all of the values available for a field in the query? 1- there is 2 ways the first is coding it. and the second is to use the query builder to select the fields you are getting the...

Reem I think your problem starts with your design. table A should have MRN as primary key. table B should have AutoNumber (or the date if it is only done once) as a primary key then MRN as a foregin key. For data entry you should create a single form based on a query combining data from both...

I dont know your table structure but in this case you should have a BookingDateFrom, BookingDateTo field and a BookingTimeFrom, BookingTimeTo fields. then ask the query to select items that do not have a value similar to what you are requesting in those fields ( you can do this by comparing the...

Hi there I think basing your booking form on a select query that only select Items available at the requested time would be the answer to your question. I dont know your table structure but in this case you should have a BookingDateFrom, BookingDateTo field and a BookingTimeFrom, BookingTimeTo...

left() an Easier way is to create 2 new fields in your table (Building, RoomNumber) and use the left() fuction to split the original field and assign it's value to a variable then save it in the newly created field.

Worked Great thanks alot

thank you Ken will try this an let you know... cheers

it would be 1/15/2005

Forgot to mention that the first field size is always 9 charachters and the second is always a date format.

Hi I inherited a table where 2 fields are merged together into 1. currently the field looks like this: 115586010/20/2002 and I would like to split it into 2 fields I.E field1 1155860 field2 10/20/2002. I know this must be a commun questions but i searched all over for an answer but could...

hi there I cant explain it but can only think of 1 reason... some of your users maybe frantic clicking the button triggering this data entry you set in your table... i would suggest you tak to them and observe how they are using your application

PAT thank you very much.... IT WORKED.... I was missing the string quotes on the wild card.