Search results

Hi Steve I usually come here when I am stuck or don't know quite where to start. I am in asset management as well. My project involves building a front end to our SQL data base that will use the barcode reader to identify the asset. The guys will then be able to select a variety of forms...

Hi Steve I am looking at doing what you sound to have suceeded in doing. Was wondering if you have yours fully operational and if you would consider posting a sample. We to are using the Motion Slates as well. Regards Sil

Hi All I have an Access database that currently acts as the front end to an oracle database. Most tables are linked. Most users are all wanting this front end as a web pages. What I would like to know is what would be the best way to web enable this front end. Also do you loose much...

I am attaching a sample in case someone else needs this help. May not be the best way to do it but it works. danson

Thanks Will try the select case statement - I did try code in the after update with no success. The text box datatype will have pre defined data in it eg 1, 2, 3 and I only want the corresponding textbox eg Data1 to be enabled. This is so the user only puts data in the entry field they are ment...

Hi All Looking for some quick help I have a form made from the data in a table and what I would like to do is if the data in one txt box = 1 than only the data1 text box would be available for edit, if the data in one txt box = 2 than only the data2 text box would be available for edit...

More help -please Keith G Can you tell me how to create an unbound text box and use the after update event to filter the form. What do you put in the after update event. I am very new to all this - need spoon feeding :) Thanks for the suggestion Danson

The form is in datasheet view from memory - will need to have a better look at it. It is just every time I or one of the others open it at work you just tend to scroll to the entry you want. After you do it you always think it would be great to just press a key and it take you to the start of...

I have a form that lists about 200 items with a few little bits of info to make sure it is the actual thing my users wish to select. Once they select the item and click on the details botton a form open with all the details of the item. What I was wondering was - is it possible when the first...

All comments greatfully recieved - am still plugging away - just thought someone may have an answer or a work arould that may put a different perspective on this Thanks

Recording to a table Who is logged on to Database, When they logged on and when they logged off. Gets tricky as I really would like the info to come from the mdw file(all users go through this for access) If someone can help would be great. Need my hand held for this as I have been attempting...

Search Help Hi All Using access 2000 I have a Contact table with around 600 entries that I would like to be able search by Surname then Given name. I would like to then click on the result to open the data entry form associated to the table. Any Ideas as to how I can manage this would be great...

Thanks -------------------------------------------------------------------------------- Hi Rick Thanks for prompt reply. I must be 2 old or really thick because I just dont get how to make this work. Pasted it into the textbox that is to store the age of the kid at the date of test 1...

Might Help In Excel I would look at Switching rows of cells to columns and columns to rows - reversing so your columns become the rows - type Switching rows of cells to columns in the excell help to get detailes on how to (copy your spreedsheet first so if this is not what you want you haven't...

More than a Date of Birth Hi All I am really getting frustrated trying to solve the following problem –I am also new to code. Have created an access data base that needs to calculate age from date of birth with years and months I used the following code in the Gereral Decs (a mate sent it to...