Search results for query: *

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

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

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

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

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.

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

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

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

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

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

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

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

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

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

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

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

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

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

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