• VBA to print to specific printer with print button

    In Access 2007 how do I use VBA code in my print button to print to a "specific printer" for my report.

    RPJ5 pointsBadges:
  • Microsoft Access 2007: Using an IF statement

    I want compare a field in one record to the same field but in the next record. For example I have this IIF statement: IIf(([MAILADDRESS]=[MAILADDRESS]),True,False) This will compare the MAILADDRESS in the same record but I want to compare that same field but in the following record. How do i do...

    Servent15 pointsBadges:
  • Excel to Access conversion

    When I import data from MS Excel v2003 into MS ACCESS v97, some of the data converts (numbers) converts to scientific form (4268411 converts to 4.26841e+006) even though I specify that the column format is text. How can I stop this from happening?

    QAMAN15 pointsBadges:
  • Migrating data from Microsoft Access to SQL Server 2000

    I want to transfer data from access to sql table and vice versa through windows service. so, plz help me.

    VBNET5 pointsBadges:
  • SQL Server 2005 or 2008?

    I am a database user going back many years and have used several different platforms from the high-end (NCR's Teradata) down to MS Access. I work for a Marketing Service Provider and we do alot of Marketing Database building with associated reporting and analysis and also use SAS for statistical...

    Habana5 pointsBadges:
  • Combo box question when developing a SQL database in Visual Basic 6

    I am developing a SQL database using Visual Basic 6 with ADO and Microsoft Access, but in it, I have a combo box with two options - yes and no. I want the combo box, after yes or no is selected, to open another form where a user can enter other details. How would I do this?

    SQL Server Ask the Experts2,585 pointsBadges:
  • Navigation Pane

    In Access 2003, my database window showed me all my database objects. Now I have a navigation pane that I have to scroll through to locate things. Is there any way to display all the objects in my database at once?

    Medved5 pointsBadges:
  • User security based on table in database

    I am using Access 2003. I have a small (2 table) database. One table contains unit rework information. The second table contains User information(ID, FirstName, LastName, Security level). I built a form with a place for 3 users to 'sign off' - one for operators, one for supervisors & one for QA....

    Rbrown3805985 pointsBadges:
  • Complex Database Issue

    I'll try to be brief: I have excel files that are downloaded via ftp to a folder where I have my DB. each of the excel files is "roughly" the same headers, I want to import all of these files, filter out all but 3 columns and then filter out certain rows in each table (at minimum, 25 tables) can...

    Mreed725 pointsBadges:
  • Microsoft Access menus

    How do you setup menus using MS Access?

    Danljonessr10 pointsBadges:
  • Using Dlookup to populate form fields

    I have a simple database with one table(Issue log). What I want is a form that allows for creating a new "issue" within the table or updating the status of an existing issue. I want the form (Issue log) that will update an issues' status to auto-populate based on which issue number you enter....

    Dave4015 pointsBadges:
  • How to import Microsoft Access to SQL Server 2005

    hi, while i am importing database MS-Access to sql server 2005 its could not importing its Showing like this: The operation could not be completed. Additional information: -> Not a valid password.(Microsoft JET Database Engine) What to do? can you give the solution. Thanks, Deepa

    Deepatss5 pointsBadges:
  • Amending a Product Price without altering existing orders in Microsoft Access

    Platform; Windows XP Microsoft Office - Access 2000 Adapting the example database that was supplied with Access - Northwind Sample Database. I adapted the above sample database back in 2003 to my own database but have now hit a snag and i am unable to rememberor or find the solution. Currently, If...

    Skipy10 pointsBadges:
  • Converting SQL data to Microsoft Access through coding in VB.NET

    I have tables in SQL and i want to port them to MS access through coding in VB.NET

    Kiti15 pointsBadges:
  • E-mail Notification

    Can Access 2007 notifiy me by e-mail when someone has added or made a change to my data file?

    Mightymrs5 pointsBadges:
  • Beginner – How to move a table

    I have one database, called Mask List. It contains two lists, Mask List and VIP Visits, which are unrelated and unlinked. I'd like to move VIP Visits out as a separate table I can call up and use without having to go into the Mask List database. I have created a link directly to VIP Visits on my...

    JustTrying5 pointsBadges:
  • Export report into seperate Word docs

    Hi, I have created a Crystal report that runs from an Access Database. The report shows details of different projects. There are around 300 projects in total, and when I am exporting these at the moment, all the details are being produced in one report. However, I want to be able to export the...

    Hunty835 pointsBadges:
  • How to use Access object library in my Windows application

    dear friends , how to use docmd.opencurrentdatabse command to open an access application database please advise

    Ashabalu5 pointsBadges:
  • Hotel database (Rooms availability) using Access 2007

    Hi there... I'm working on hotel database (Access 2007) I have a table named Rooms There are 3 fields in it Room ID, Room type, availavility how can I make Access shows the vacant rooms which are not related to any guest?

    Black0ice5 pointsBadges:
  • Microsoft Access QueryDef problem with numeric column anme

    I have a form that creates a query on the fly. It works great, but has a problem with columns that have numeric names. The table is not mine so I can not change the columns. When I run the query the column name appears in the column. I tried to find anything wrong in the query and could not. IF I...

    Davisdo5 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