Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  1. limpan

    Problem with stalled report

    I have a front end Access2000 application and sql server 7.0 back end. To create reports I query the sql database through OLEDB and insert the data from the result recordset into a temporary local table. Obviously this takes a while, especially when the query returns many records. The problem is...
  2. limpan

    List box rowsource = sql server table ?

    Hi! Does anybody know how I can use a table from a sql server back end database as rowsource for a list box in a Access2000 front end application? I do not want to use ODBC. I´d also like to know if there is a simple and fast way to populate a local table with data from the back end data base...
  3. limpan

    Problem w. recordesets from sql server

    I solved by dropping the odbc connection and using connectionstrings instead. /Linus
  4. limpan

    Problem w. recordesets from sql server

    I´m getting desperate, I need help with this issue. I have an access2000 front end with SQLServer 7.0 back end. My problem concerns the retrieval of recordsets from the sqlserver. I have a procedure which is supposed to check whether a certain record exists in a table. If the record exists that...
  5. limpan

    Problem w. tab controls

    Yes I did. I did exactly the same as I did on the other form, the only difference is that I have a tb control on this one.
  6. limpan

    Problem w. tab controls

    I have a five textboxes, one containing currency and three containing integers. The fifth one is supposed to have a calculated value based on the other four, like (price * no of units * discount1 * discount2). I´ve done exactly this in an ordinary form, and it worked perfectly without any...
  7. limpan

    How to send mail without client

    Hi Doug! I´m not really sure what you´re getting at here... It doesn´t look like you´ve responded to what I have written, or maybe you´ve just misunderstood what I´ve said. I understand the theory of MAPI and it is useful, but partly because SendObject crashes Access2000 and because I...
  8. limpan

    How to send mail without client

    For quite a while I´ve been looking for a way around the problem with the SendObject method of sending mail from Access2000. Since my users would have different mail clients, or no client at all, I needed a way to send the mail directly through the mail server. Finally I´ve found a solution. I...
  9. limpan

    Send mail from Access without SendObject and mailclient

    I need to pass a message directly to my SMTP server without going through a mailclient. This is because the application will be used by many different users using many different clients, or maybe no client. The .SendObject method tend to crash access2000, so I don´t want to use it. Is it...
  10. limpan

    Changing AutoNumber

    You could also use the database tool "compress and repair database" under the tools menu. This way your autonumber fields will restart from zero, if the table doesn´t contain any data that is. /Linus
  11. limpan

    Too Much Information?

    What kind of query have you built? Do you mind describing it? /Linus
  12. limpan

    values based on another table/form

    You can use the OpenArgs property. When you open a form you can specify an argument to be sent to the form to be opened. This argument can then be captured and used in the new form, maybe in a sql query if you like. Here´s an example: 'Call the new form DoCmd.OpenForm "frmAny", , , ...
  13. limpan

    canceling a Sendobject generates an error

    The same thing happens to me, only access goes down totally with no possibility to debug the code. Is it possible to have access send the mail through outlook express even though outlook is the default mail client? /Linus
  14. limpan

    How to email the current record using SendObject

    Hi DougP! I´m using this method to create an email to be sent. My problem is that I first created the procedure in access95. Now that I have upgraded to 2000 a strange thing happens. I set the edit parameter to true to be able to se the email. Now, everytime I close the email after reviewing it...
  15. limpan

    Problem with updating date field

    You´re right, it probably is a bit confusing, but you got the general idea right, I want completedDate to have today´s date. I only want to have the date though, and not the time. Can I use the Now() function in a way so that I only get the date? Linus
  16. limpan

    Not In ('list'...

    You could use recordsets. Loop through a recordset of the table and add the entries that doesn´t match your list value to a temporary table. Then you repeat this procedure for every entry in the list. This way you´ll get a table with the entries you want. There is probably an easier way, but...
  17. limpan

    Problem with updating date field

    This function below is meant to update a date field. Public Sub complete(id As Integer, completed As String) Dim dbs As DATABASE Set dbs = CurrentDb Dim completedDate As Date If completed = "Yes" Then completed = "No" dbs.Execute...
  18. limpan

    AutoNumber??

    You could create a table between the owner table and the car table, with owner ID and car ID. That way, every owner only exists once in the owner table, and every car only exists once in the car table. By not having a key in the connecting table, one owner can be connected to many cars, like...
  19. limpan

    Removing elements from a listbox

    Can anyone help me? I need to do a simple thing as removing an element from an unbound listbox. As far as I know .Remove or .RemoveItem doesn´t work in Access. Does anyone know what does work? Thanks, Linus

Part and Inventory Search

Back
Top