Search results

Yes, in a table if I change it to "double" and then 4 decimal places - nothing happens if I change to "long interger" and then 4 decimal places - i get 1 digit (no decimal places)

I think I did what you suggested, instead of giving me 4 decimal places, it gave me none ('0') ???

Hi there, I am not sure the best way to do this, I have a field with values that look like: 1.69553366385509 or 0.0061705541157596 I want these values to look like: 1.6955 or 0.0062 (4 decimal places [rounded up if possible]) Thanks for your help with this Sue

I would like to separate values in one field into mutiple fields. All values are separated by a space and the number of values vary. An example: 0300194 0300092 0300091 0300090 Can anybody help me with the code need to split my field up? Thanks

I am using a data entry program and when I enter records on a certain form, I get the following error message when I enter data in to an Access 2000 database: ************ Microsoft JET Database Engine error '80004005' Cannot open any more tables. /m3cat/metd_edit.asp, line 1911...

Thanks for helping me, I really appreciate it :) Now I get the error: "data type mismatch in criteria expresion" The field I am wanting to split is a text field Thanks again

Thanks for you help! Sorry, I don't know enough about code to modify the above code so it works correctly... I get the following error: "the expression you entered has a function containing the wrong number of arguements" ?

Thanks for your help, No the split is not always after 6 characters, so I need it be split at the comma

I would like to split the following data in 2 (split at the comma). The field this data is contained in is a text field. (2FBSRY, 01-JAN-1995) Thanks for all your help. :)

Can you change the location of a design master database? For example, I created a replicate database (master) on my hard drive. Now I want to put in on a server, but when I copy it over, it become a replica. Am I stuck?

Hi I need advice on how to create form(s) for the attached relationships. I had no problem creating a form (with subforms) for a series of 4 tables one-to-many relationships (tbl_replicate, tbl_tcpbsdata_lm, tbl_tcpbssiteply_lm, tbl_tcpbssite_lm). But incorportating tbl_activty_site and...

Thanks for your help! I will give that I try

I need some advice on the best way to do this. I have created a single database (3 tables - Access 2000) with a simple data entry form. What I need to do: There are going to be about 5 people that need to enter data into this database. A database will need to sit on their desktop so they can...

Thanks for you help

Hi, I want to make it mandatory for the records in my "Date" field to be entered as follows: 20030923 I am not sure how to create the input mask to achieve this - can anybody give me a hand? Thanks!!

OK thanks guys, I understand

Thanks to you both for your help I will give both of you're suggestions a try

Thanks for your help guys, either of your replies will do me just fine

Can I make is so all values entered into a text field are formatted to be upper case letters? I want all text values in a field to be captial letters, I just don't know whether this is something you can specify in Access. Thanks for your help

Thanks Rich Yes, you are right 1) sites with x and y 2) sites with x only 3) sites with y only is correct