Search results

  1. R

    Importing/Exporting Database Information

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

    database updating

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

    Date Formatting

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

    multiple table search problem

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

    problem with blank fields

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

    going from Access97 to Access2007

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

    filtering help

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

    query filtering

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

    dynamically populating a combobox

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

    Table Relationship Help

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

    Login prompt to define a user in main form

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

    Working with Statistics

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

    Generate a downloadable file from database

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

    Hyperlink problem

    G'day everyone, i have source table which has a hyperlink textfield. I have this textfield in a form and its "Is Hyperlink" property set to "Yes". When i view the form with a URL in the textfield, i am unable to get a web browser to open with i click on the link. Any ideas as to how i might be...
  15. R

    VB Coding in form

    I have a quick question. I have a main form with a label and a button on it. When the button is pressed a secondary form pops up. The second form has a button on it also. I am trying to code the button on the second from so that when it is pressed the label changes its value on the first form...
  16. R

    Using two list boxs to use as query criteria

    Hello everyone, i am trying to get 2 listboxs (the first is for name, the second is for state). I need to be able to select a name from one listbox and a state from the other and have a query display after a button is clicked. At the moment i have found a section of code which runs under the...
  17. R

    Updating Records

    Im using Microsoft Access 2003 and have a form 'frm_contacts' linked to a source table 'tbl_contacts'. My frm_contacts form has a button which when pressed opens a popup form 'frm_hottarget' of some additional fields from the same source table. The frm_hottargets form contains the field 'State'...
  18. R

    Setting the position of a subform scrollbar

    Hi everyone, I have a 4 part survey database consisting of one source table : tbl_survey. I have created a main form with 4 subforms (each subform is a section from the survey table tbl_survey). I have placed 4 buttons in the main form, and each button when clicked reveals its subform, whilst...
  19. R

    Extracting range of records

    Was just wondering how i go about pulling out a range of records. I do not want to use my Primary Key autonumber value as some records have been deleted and selecting a range of 10 to 50 for example will not guarentee 40 records. Is there some way i can use an SQL command in the SQL View window...
Top Bottom