Search results

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...

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...

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...

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!!

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

What I am working with: I have 3 tables: Table 1: Contains data about a specific geographic location Table 2: Contains Type "x" data found at a site recorded in table 1 Table 3: Contains Type "y" data found at a site recorded in table 1 At the moment table 1 and table 2 are joined in...

I did a search through the forum on this topic, but still need an answer. How can I put "PUBID" in front of all my record values. Also, "0" in front of records. Thanks!

I would like to create a Union query My table relationship: tbl_FW_Main PubID (Primary KEY - unique code - text) Title (text) Department (text) Date_Published (text) Publisher (text) Report_Location (text) Authors (text) Tbl_Waterbody...

I will try my best to describe my table relationship: tbl_FW_Main ID (autonumber) PubID (Primary KEY) Title Department Date_Published Publisher Report_Location Authors Tbl_Waterbody ID (autonumber) PubID (foreign key) WaterbodyName Watershedcode AliasName etc Tbl_Species ID (autonumber)...

can someone tell be how I can place a "0" in front of all records in a text field ('lon'). I tried to update to: Right$([lon],Len([lon])+"0") in an update query - i didn't get an error but it did not add a "0" to the beginning of the records. any ideas - thanks sue

Hi all, My database seems to have changed size (and the data it contains has not really been changed). I converted from Access 97 to 2000 and it went from 6.07 mb to 372mb Any ideas on what happened and how I can change it? Thanks, Sue

How to update number field in "many" table from autonumber field in "one" table I solve this problem a long time ago - I can't remember how I did it though! For example Table 1 Main ID (autonumber) field1 field2 field3 Table 2 MainID HabitatID Table 3 Habitat ID field4 field5 field6...

I have never had this problem before... I am trying to import an excel spreadsheet..... I get the error message "error trying to import file " ". the file was not imported. it doesn't give me any more detail than that (ie: import errors table) i tried to import just one of the fields from...

Aftter a bit of fiddling - the following extracted the "time" values from my field: Time: TimeValue([Start date])

Hi all, I know how to extract date values, but does anybody know how to extract time values? (have already searched for the answer on these forums) For example: The records in date/time field look like: 1/4/89 1:45:00 PM I want to create 2 fields, one for the date, and one for the time...

What I want to do: Where records in "field a" are the same - i want to make records in "field b" the same. Also - I want the records in "field b" to be the same as the first record were "field a" starts to be the same. Maybe I'll just show you what I want: An example, How it is now...