Recent content by reptar

cheers, will look into that

Hi, i have two identical databases, located in two seperate countries. I would like to update one database with information from the other (and vice versa). Currently these databases are accessed on local area networks. Security is a big issue here. Is there a simple method of being able to...

Hi, i work for a company which uses a database within the office. At the moment there are roughly 10 users and i have set it up with a back end and front end. My question is that one of the staff members would like to use the database at home and away from the office. Is there some way of...

Is there a way i can set the date to display e.g. 16th April? I'm not sure if Access is capable of calculating "th" or "st" or "nd". Any thoughts would be greatly appreciated. Thankyou.

I have my main form which has a control source from a query containing fields from tbl_company. In addition, i have a subform in tabular view on the same main form which has a control source containing fields from tbl_contacts. Now, each individual company record has a tabular list of their...

I have a form which uses a control source from a query. tbl_contact contains all the customers details. Also, is a field named intialsID. This has a one-to-many relationship with tbl_initials. tbl_initials contains all the intials and names of the staffmembers. I have "Enforce Referential...

Hi, our company currently uses Access97 to contain all their information on clients. It is time to upgrade and i was wondering if there is anything that we should know before we upgrade to Access2007. Thanks,

Hi, i have a search form with unbound textfields which when filled out and form button is clicked, add to a string e.g. [first_name]='John' AND [last_name='Smith' etc. On a seperate form i have my qry_names as its control source. I would like to set this up so that when the 'search' button is...

Hi, i have a table "tbl_details" with fields "first_name" & "last_name". I have a query "qry_details" which contains the two fields. I would like to create a search form with first_name & last_name textfield entries that when the search button is clicked, "qry_details" comes up with the filtered...

cheers, thanks

I have 3 tables: tbl_company, tbl_contacts, tbl_events. tbl_company is the parent table to tbl_contacts with clientID as their one-to-many relationship. When tbl_company is on the first record, its clientID value = 1. I want to have a combobox in tbl_events which dynamically populates a list of...

Hi, i current have a splash form which opens up at loadup. The splash has a comboBox with a list of all the different employees who use the database. Once Joe Bloggs selects his name from the comboBox, he hits enter and the splash form hides itself and the main form (frm_main) opens up display...

Hi, i have a microsoft access 97 database listing 4000+ companies. The database is being used by up to 4 people. On the main form, listed companies have a previously inputted recontact date which once the date passes the current date is flagged and listed in a query. Along side the recontact...

G'day, i have a database with a whole lot of numerical data. I am able to extract 100 records based on a filter i have created in ASP. I am trying to somehow work out the median, and quartiles of this data and attach them to variables. Has anyone tried this or know of a better way of doing this...

I have a database located on my server. If am able to display the records of a table through ASP. What im trying to do is use ASP to query a table and filter it, then have some sort of file which can be generated to download with all the filtered data in it e.g. csv file Any ideas would be...