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

    Accesstables5 pointsBadges:
  • Passing a form to subroutine in Access 2003 (VBA)

    I have a function that recieves references to 2 forms and 2 controls. The sub looks like this Public Sub Not_In_List_Starting_Handler(vNewData as string,Not_in_list_form As Form, List_control As Control, Lookup_Form As Form, Lookup_Control As Control) when I try to call it from the form I get all...

    Nainey5 pointsBadges:
  • 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 From and To...

    Vadle35 pointsBadges:
  • Create “if then” formula in Access 2003

    Hello, I'm new with access. I have a table with article numbers in one column. and intro and outro dates in 6 columns. the intro and outro dates come from 3 tables, so that's why the 6 columns (2 columns per table) However, I would like to combine the six columns into 2 columns, one for intro and...

    Jos197215 pointsBadges:
  • Cumulative totals in Access 2003

    I need to be able to calculate cumulative totals on groups of data in a query. Specifically I have a list of repair order numbers with associated part numbers required, dates the order was placed and the amount of the part needed for the repair. I need to be able to calculate a running cumulative...

    Acmaintainer20 pointsBadges:
  • Access 2003 report printing

    We've been using Access 2003 for a while and are now changing over to 2007. At the same time, I am creating a new report to replace a report we've used in a database successfully for several years. I open the new report, and it looks perfect on screen, then I print it using the printer icon. The...

    tlsanders11,340 pointsBadges:
  • User Accounts in Access 2003

    I set up successfully user accounts and passwords in MS Access 2003 on my computer. when I transfer the file to another computer the login form no longer comes.

    Muwambo5 pointsBadges:
  • 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 strFormName As...

    Pubfin15 pointsBadges:
  • Access 2003 IIF Function?

    I have a form and a subform relating to vehicles. The subform has starting mileage, ending mileage and the purpose of the vehicle's use, one of which is oil change. I would like a text box on the main form to show the next oil change mileage which should be 4500 miles from the ending mileage of the...

    Hld111025 pointsBadges:
  • How to count data in Access 2003 stored database

    hello to all, will u please help me on how to count data in stored data in database, I am using ms access and vb6. Thank you

    Tlosom55 pointsBadges:
  • How to concat SQL Server 2005 data with line feed

    I am attempting to update a column in SQL Server 2005 by concatenating data from two other columns and include a line feed between the two and have the second line begin with a /. The data will be viewed through an MS Access 2003 database with a linked table using an ODBC connection. The script I...

    TLMercer45 pointsBadges:
  • How do you change user password for a separate Access database than you are working in?

    I've built a database (Production) with user level security on it.  I also have built a smaller database (Login) so I don't have to use Access' login.  I'm trying to figure out if there is a way to change the user password in the Production database FROM the Login database.  I've been working...

    McNitro255 pointsBadges:
  • Dir() Function doesn’t find .pdf files in Access 2003

    I've used the Dir() function with VBA several times for different file formats, but for some reason it's not working on .pdf files. Am I missing something?

    McNitro255 pointsBadges:
  • Converting from Access 2003 to Access 2007

    hi, everyone i have 3 desktop with Access: one have Access 2003 two of them have Acess 2007 so i divide my Access database in two parts on of them have tables an other a form queries, etc. My problem is, is possible link tables for these three desktop's. because of that diference i convert for two...

    BUG68235 pointsBadges:
  • How can I email a query output from Access 2003?

    I have a query that runs form a table, the table have data for multiple customers, I give the query the customer numbers, it gives me the customer statement, I then copy and past the statement to excel and email it to the cutometer. I need to automate process if access allows me to do so

    MahmoudAly5 pointsBadges:
  • updating, deleting in access with asp.net using Visual basic

    hi, i m using  asp.net 2005 usin vb. i m having gridcontrol with the back end of msaccess.  i know to retrive the data from databse by using tis code, Dim msaccessconnect, query, databasecommunication, readdatabase         msaccessconnect = New...

    Priyadharsini5 pointsBadges:
  • Combining Access 2003 Queries for Dates Criteria

    I have a MainInfo table and 3 different Log tables (PleadingsLog, LitigationLog and DiscoveryLog) that are linked to the MainInfo table by an IDnumber. Each of the log tables contains a date field and a notes field. I am trying to find a way to query all records from the MainInfo table that show a...

    GCIB15 pointsBadges:
  • Exclusive access to Access 2003 database

    I have a database located on a server. I have it set to where user clicks the icon and it will open to a main menu. I have one user that when they click the icon and the database opens, they get the message "You do not have exlucive access to this database at this time." It pops up 4 to 6 times...

    Ryker5 pointsBadges:
  • reformatting a multi-tab spreadsheet and access 2003

    Hi,    I have an instance where I have an Excl 2003 spreadsheet and need to reformat it into a single record format using the data from each of the tabs but I also need to put additional data into the new record. Here is another twist I want to be able to trigger this from my access 2003...

    Cwv19495 pointsBadges:
  • How to pick a source for a subform in Access 2003?

    I have 3 different DB-s, I am working with. I have no problem linking the data in. The user is in DB-a. My problem is I need the little bit of tricky code to check my DB-A's plainid the DB the user is in. To check the DB-A's planid against DB-B' plainid then use the data to fill a sub-form. If...

    Techexpressinc10 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