• Updating Combobox after new data added

    Using access 2003, I have a form (frmJobSheet) which contains a combobox (cboContacts) containing all the contacts in a talbe (tblContacts). If a name is entered in cboContacts which doesn't exist in tblContacts, I want to open another form (frmContacts) which the user would then enter the new...

    SteIT15 pointsBadges:
  • MS-Access

    Hi all, I'll try to describe the problem in a simple way: I once created an Access DB with everything necessary, e.g. mdb, mdw and then put them all in a shared network file something ununderstandable happened: a colleague, whom I granted ONLY read-access, click on the DB he could write in the...

    PIEGR10 pointsBadges:
  • Query showing vbCRLF in string data

    Can someone provide SQL code that would generate a table showing any instance where a vbCRLF character can be found anywhere in my table? IOW, I'm trying to list records where the user input 2 or more lines of data in a simple text field. E.g., "John Q. vbCRLFSmith" as opposed to just "John Q....

    Sandisk25 pointsBadges:
  • How to use an form field in a SQL from a combobox

    I build an Ms-access application. In a form i selet project information based on project-nr. In that form I want to select in a combox records that are based on the project selected in the form. I think somethink like [forms]![<formname>]![<fieldname>] but it doesn't work. what is the...

    Haro5 pointsBadges:
  • Create a report with only results with specific entry in field

    Very simple question - sorry. How do I create a report where only the entries where a field has a specific answer. Such as only the results whose tick box is ticked, or who's "category" field is a certain category?

    Sleepybird5 pointsBadges:
  • Access 2003, calculating dates

    I have a database and I need the following to calculate based off a date field. My problem is that regardless if the date entered in that field is the beginning, middle, or end of month, I need another field that will produce a due date, which has to be the end of that month, which could be 6...

    Helen123415 pointsBadges:
  • Access 2003 using VBA

    I am trying really hard to produce these tables. But when it came to populating the information into them, it was throwing up errors. Ive managed to sort most of them out, but this one for WeeklyUnitStaffRota table is annoying me. Can anyone have a look at the tables and see where I could have gone...

    Loopymoo265 pointsBadges:
  • Resizing fields to see content in Microsoft Access 2003

    In Access, to expand a field to view the field's contents what can you press?

    Giabarbie1810 pointsBadges:
  • Access 2003 using IIf statement on a form

    I am building a database to help my daughter with keeping a record of pupil progress. I have a form in which I have a field for 'current grade' and a field for 'target grade'. I also have a field 'progress' in which I am using an 'IIf statement' to compare the two fields (to show either 'under...

    Malcplant35 pointsBadges:
  • access 03 sending emails

    I created a new database. with a data access page. when the person or persons are entering a new log i would like for access to send a e-mail to notify me of a new entry. I built a module to grab the fields i need to be sent. I just can't get it to work. Please help

    Bent4lf5 pointsBadges:
  • Resizing Microsoft Access 2003 properties form

    I recently installed MS Access 2003 SP3 on a new machine under Windows XP SP3. I find that I cannot resize the properties window when doing form design. The problem also applies to popup forms that I create. If I take the .mdb file to another machine, it works just fien. I have tried uninstalling...

    JNewmarch5 pointsBadges:
  • Update database when combo box value is changed

    Hello, I am wondering how to update all the text fields, other combo boxes, and memo's when values are change in a combo box in MS Access 2003. For example, I have a form that when values are change of a combo box that has dates for every quarter. I want the values that I have set for the other...

    ProgrammingGal30 pointsBadges:
  • Temporary recordset in MS Access VBA

    Hi, I am using MS Access 2003 as a front end to 2 Oracle databases. I am trying to retrieve a recordset from a database through ADO/DAO, display that recordset in a Form for users to make changes, and then write the records that have been changed to a different database (i.e. I don't need to make...

    Darryn765 pointsBadges:
  • Access 2003 Form fields Sync

    Hello, I am turning to you as a last resort :/ Here is the case, thought it looked simple to me at first... : I have a field which needs to be updated according to another field in a form according to the date in a table: Table contains [KEY, field1, field2] and the form uses to updated a different...

    Arielnavon15 pointsBadges:
  • Changing field format in Access 2003

    We have an Access data base that includes date of birth in the format mm/dd/yyyy. For reasons I don't need to go into now, we have to change all of them to a different format - yyyymmdd. Is there a way of doing this without changing every individual record? This would save us hours of work. Thanks

    Britinga425 pointsBadges:
  • Vertical text in MS Access 2003 report

    I'm trying to create report headings that are perpendicular to the data fields. I have lots of fields with numbers and the headings fit on the page if they print at a 90 angle -- on a slant would be nice too. When I make a label (or text box) and change the properties to 'Vertical = yes' the words...

    Carey5 pointsBadges:
  • Linked Server Question

    I am trying to link an existing Access 2003 password protected database to a newly installed SQL Server 2005 Express database engine. I am using the ‘Add Linked Server Access MDB’ template in Management Studio to create the linked server. The linked server is created without error, however when...

    AN5gel675 pointsBadges:
  • MS Access 2003 write in SQL query to convert string to numeric

    How do I write in SQL code in MS Access 2003 to create a query that converts a string into a numeric? Thanks

    SacramentoSil25 pointsBadges:
  • Problem with Microsoft Access 2003 write permissions

    users have read and write permission to certain forms in the database but after loggin, they could not enter any data to the form,please could help,i checked users&groups account,users&group permission everything seem to be okay but still.is there something i over looked or have not done yet.

    Nahleykema5 pointsBadges:
  • Look at query results & pass a value to form in ACCESS 2003

    I need to be able to look at the results of a query & based on the values in one field (?) on a subform/table enter a Pass/Fail value to the main table. Here is a basic breakdown of what I have: t_Main: table defining dimensional layout requirements. There can be multiple parts of the same part...

    Rbrown3805985 pointsBadges:

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following