Access 2003

How to combine 2 linked Excel tables in access 2003 with same field names, using query?

I have 3 employees working who have no access on their PC. they are performing their data entry in excel and I ahve linked all three tables to one access file as I have Access on my PC. I need to combine all 3 tables using query or some other method in access to create one master table. Here is the...

Migration from Paradox to MS Access or VB.Net/MS SQL

We have a department that has several applications running on Paradox 11.  They need assistance migrating their tables and application UI/code to another platform.  Any feedback or guidance would be appreciated. Software/Hardware used: Windows XP desktop, Windows Server 2007

Access 2003 default record locking

I'm working with a multi-user Access system. When I change the default record locking option via Tools/Options/Advanced and then save the database, the other users still have the original setting for record locking, i.e. the change I have made is not shown on their machines. Shouldn't the change I...

Access Subform Blank

Subform doesn't appear in either form view or design view. Can move database to another computer running Access 2003 and subform works perfectly linked to the same tables.

Showing a substiute value in a report if conditions are met - Access

In one of my tables, there is a date field which shows dates of an event happening (called "Issue Date"). This gets input through various measures. Input form or directly into the table or query. One of the reports I am trying to design is a report that will show all materials that have been...

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

How to show two query results in one Microsoft Access report

I have two queries saved, one shows the record that match a criteria and the othe query shows the record that do not match the criteria. ie. query1 in the feild lastname the criteria is "jones" in query2 in the feild lastname the criteria is Not"jones". What I want to have is a report that shows...

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

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

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

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?

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

Microsoft Access Date

Microsoft Access 2003 I have a Today button that uses the command.. Private Sub cmdtoday_Click() 'Sets the Date From and Date To text boxes 'to Today's Date Me!OSJPQFrom = Date Me!OSJPQTo = Date End Sub To put Today's date into my From and To Date fields. The problem is I have these...

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

DoCmd.OpenReport not working right with WHERE clause

I have looked all over and seen hundreds of questions about this command, but no answers. It seems like the most basic thing you can do with combo boxes, so I'm baffled that it doesn't work. Here is my VBA Code: Option Compare Database Private Sub cboFundNumbers_AfterUpdate() Const...

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?

Microsoft Access 2003 slow on Windows Server 2003 Enterprise

Recently one of our servers was upgraded from Windows Server 2003 Standard edition to Enterprise. We run a MsAccess2003 system on the Servewr, both backend as well as front end. Performance on the Enterprise system becomes visibly slow when process larger volumes of data at speed! Has anyone had...

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

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

Adding Serial Number to an already existing access document

Hi , I want to add a row of serial number for the existing records in MS access .Whenever I am trying to define a new row with type as "Auto Number" and save the same it automatically gets changed to Text type.Please suggest. Thanks, Ansh