Search results for query: *

I would like to change the view of a form from regular Form View to the Datasheet view with a command button within the form. How do I do this?

Wow. How simple was that? It works now. One stinking line of code out of place, and the whole thing goes buggy. Thanks a bunch!

I have traced through the code, and it doesn't give me errors, but it seems to "pass over" the lines of code that involve the recordsetclone function. I'm not very VBA savvy, so I didn't know if that was the norm or not. If you guys have time, I have another question that's driving me nuts at...

First, to PHV: The event runs on load and on timer interval (10000, or ten seconds). To Alec: I don't get any errors when the code runs as is. It just doesn't do as I expect. Form doesn't restore, and caption doesn't change from "No Mail" to "New Mail!" like it says it should.

I'll pass that code example on to my VB guy. Thanks for the assistance.

We're using Access 2k, and want to send faxes to multiple contacts with WinFax Pro 10. So far, the only way we can make it work is by using Word 2000 to merge a query data set, then sending the merge from word to winfax. Trying to send to Winfax from Access report was awful. Winfax would...

Are you running Samba on your linux box? We have a linux server that runs a script through the samba server everytime someone logs on. I don't know how to set it up, but that may be an avenue to explore.

We had a similar error using a linux samba server with windows clients. It was a folder permissions issue for us. You may want to check the database record lock settings to make sure the first user isn't locking the database excusively. Hope you figure it out soon - I know how frustrating it...

Well - we just re-structured the way that we're doing it. We're making an append query first in order to get the StartDate and EndDate fields into a table. Below is my query in SQL view, with the fields in question in red: SELECT tblCustomers.CustStatus, tblGenerators.Generator...

When I try that, I get an Error 13: Type mismatch.

We've created a mail merge document that uses an Access 2k query datasource. The query has two input fields that the user must specify once the query is run (StartDate and EndDate). These date fields are not query criteria, and are not table related data - just fields that the user must...

Below is a bit of code from the basMail module from the Access Cookbook, 2nd Ed (example 10-04, I think). I'm using Access 2k, and I can't get it to work right. I'm opening frmReceiveMail with and AutoExec macro at startup of my database. The form is not re-opening from minimized when new...

Is there a way to make Word 2000 see an Access query data source from an already open Access database and query? I want to call the merge document and datasource from a form without the merge document trying to reopen the database and get the datasource on it's own. Any guidance would be...

I tried that, but the report sent to Winfax would always show only the first contact name, no matter what contact the fax was being sent to! So we got the SDKsend sample module from the WinFax Pro 10.0 install cd and made our own faxing module. Thanks for the input!!!

I downloaded a faxing database from www.weascend.com (called FAX2k.mdb) for Access 2000. The module is very useful, but I can't get it to do what I need so far. I've built a query that returns several contacts. I need to send a fax to each of these contacts, with the report being a cover page...

Thanks. I made two queries (one append, and one delete) and called them sequentially from a form with a command button. The form has unbound fields which are used in query criteria expressions to append and delete only specified records. Thanks for the input.

actually, I'm not doing this from a form. I will if I have to. Just appending one recordset from one table to another based on criteria on an indexed field, then needing to delete the datasource recordset after the append is complete.

I'm trying to make a query that will append data from one table to an identical table, then delete the data from the source table. Is there a way to do this without making two separate queries (one append, and one delete)? This may be a routine task, and I'm just appending/deleting one record...