Search results

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.

HI I am Looking for some help here... 1- I have a table that has a Postal code field. 2- a Query getting data from the table to a form. 3- a textbox in the form that the Onclick event is set to run the query based on the value I enter in an input box triggerd by the on click event code below...

:o HI I am Looking for some help here... 1- I have a table that has a Postal code field. 2- a Query getting data from the table to a form. 3- a textbox in the form that the Onclick event is set to run the query based on the value I enter in an input box triggerd by the on click event code...

:D Did you consider DAP in a secured location on the cpmpany's web site? this will make your life alot easier.

20 to 40 users no problem Hello there I have an access 2000 DB wihich is handeling 20 to 40 users on daily basis flawlesly using the same techniques that hartman just mentioned.. and it workes great. fe be is an essential and if you can distribute some mde to users that are not in your network...

Hi to delete the form 1- you have to check the date every time DB opens..say on a splash form 2-create a control(check box) and make it as small as possible almost invisible. 3- write an if statement ie. if date() >= 01/01/2005 then docmd.deleteobject "......". 4- then set focus on your new...