• Net Present Value

    In an Access Form, I want to be able to have five values in text boxes and use those five values along with another value in the form, the return rate, to produce the Net Present Value

    Mattylar125 pointsBadges:
  • Open Import window via code in MS Access

    Within a MS Access application, I would like to have the window that is opened when you select: File | Get External Data | Import via code.

    Rjwilcox45 pointsBadges:
  • Save Access 2007 format as 2000 format with VBA

    how can i save the curent database as a 2000 format with vba

    Dave b10 pointsBadges:
  • Split Databases – BE Structural Changes Version: 2007 (12.0)

    Can I make structural changes to the BE database without affecting the users? i.e. the relationships, proprieties Also, why do you have to put the FE on the users computer, can't you put their copy of the FE on the network, under a folder just for that user?

    Thuzinec10 pointsBadges:
  • Deletion of Macros when doing a repair & compact

    We are experiencing a problem of a number of macros being deleted after performing a repair & compact. Could this be a space problem or could it be a problem with how the environment is set up--what do you think could be the problem?

    SharieL10 pointsBadges:
  • access 07 help

    i have a database in accses o7 that i wont to share over a network and allow users to log in on any system so that they can update or view the database'forms'and reports..please help

    Joe26098615 pointsBadges:
  • Using shell execute from Visual Basic

    How can I use the function Shell Execute in Visual Basic Code. I am running MsAccess. I want to use the Shell execute command ro run sqlloader command which loads data into an Oracle table. Would benice to have an example of this. /Roland

    Rolandsk5 pointsBadges:
  • How to pass a Whereclause from a form to another form’s subform in Access 2000?

    In FormA, I have a start_date and end_date fields for users to select the date range. The start_date and end_date will pass to FormB.subform where the subform is a continous form to display the records after filtered by the date range. My question is: how can I pass the date range to the subform of...

    Wonder195 pointsBadges:
  • Flickering subform in Access

    Hi, I have a continuous subform that, upon opening the database, flickers constantly. This flickering can be stopped either by alt-tabbing away from Access and back again or by hitting F9. The main form has a button that changes the source object of the subframe to a different continuous subform,...

    Mickeymongoose1235 pointsBadges:
  • Access Report Page Setup Won’t Save

    I am running Access 2003 on Windows XP. In the page setup of a report, you can set custom page size and specific printer, etc. I have a PC that the page size will not save with the report. I have two other PC's that it works on. Has anyone had this problem and found a resolution? I should add that...

    Randym1,740 pointsBadges:
  • Microsoft Access Printing graphic hell

    Hi This is a weird one. I have a report that prints embedded Access graphics - from a table. When I originally designed it, each time I went to print - no graphics appeared - then almost overnight - they started to print and I've had no trouble since - until today... when I started adding more...

    Elgoober5 pointsBadges:
  • How to create an SSIS package for importing an Access table to SQL Server, running SPs and exporting data to Excel

    I need to create a SQL Server Integration Services (SSIS) package for importing an MS Access table into SQL Server, then running some stored procedures on this database and finally exporting the result to Excel. I am comfortable in writing queries and working in Management Studio but I don’t know...

    SQL Server Ask the Experts2,585 pointsBadges:
  • access data change history

    i wanna know if the data entry will change the entered value more than one time or if i can make history register for data update and change

    Rosealzubi115 pointsBadges:
  • Access Database, columns, calculatons

    Hello to everyone. I really need an answer to this question. anyone that can help, it is extremely appreciated. I have a database that has a number column, which relates to a text colum. the text colum has two differnt types of information in it. i need to add the number column, but only for...

    Mstweety10 pointsBadges:
  • MS Access-Query

    I am Using MS Access. I have a table that has price quotes from subcontractors. The fields are: SubID; TradeID; TradeValue (this is the Price Quote). I typically have 3 quotes for each TradeID. How do I query to get a result of the lowest price for each TradeID?

    FranktheMan15 pointsBadges:
  • Equivolent SQL Server function for Access DoCmd.TransferText

    I need to convert an Access app to SQL Server that has a DoCmd.Transfer command in it. Is there a qay to accomplish this in a stored procedure?

    Paul4815 pointsBadges:
  • Connect to Microsoft Access database

    I want to connect to an access database that is placed on an internet server. i use the following syntex when i want to connect localy. With DB .Provider= "Microsoft.Jet.OLEDB.4.0" .Properties("Data Source").Value= "C:\Data.mdb" .Open .CursorLocation = adUseServer End With Can't i just change the...

    Blink.j5 pointsBadges:
  • Microsoft Access – Find and Replace Issue

    In Microsoft Access 2007, the "Search Fields As Formatted" check box checked results in a serious performance hit when a Find is done on a linked Oracle table. Even though the Find is being done on an indexed field, and the Access link to that table is aware that the field is indexed, the Find...

    Santino35 pointsBadges:
  • How can i express the percent margin in a query for Microsoft Access?

    How can i express the percent margin in a query? I have a field PurchasePrice and a field Salesprice. the field Purchaseprice is the price at which we buy the products and the field salesprice is the field at which we sell the products.I tried to substract the salesprice to the pruchase price and...

    Peljo20 pointsBadges:
  • I am a student trying to convert a excel spreadsheet to a Access database.

    My questions: How do I convert data from an excel spreadsheet to a Access Database. How do I convert a access form to excel - Using the form as a front for data capturing. How do I link multiple users to a access database - making allowance for data to flow simultanously into the database.

    Joshua55 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