Recent content by louiserome

Yes I can do it manually, but it's something that is done on a regular basis and is done automatically by queries and VB code. Is there someway that from the split database I can write some code that will export the table from the back end database (the original table) as opposed to the front end??

I currently have a multi user database that I have recently split. With the front end on the local drive and the back end on the network. For a particular process I need to export a table to another external database. My problem is that since I've split it it keeps exporting the table but it...

is there a way to preset the autonumber to have numbers that look like 0001, 0002, 0003 and to use up the zeros as they increase??

I have a multi-user secured database, which has been working perfectly for over a year. Until now! I had a problem when I compacted the database saying your 'Mysystempfile already exists' (or words to that effect). I read somewhere that I needed to export everything out into a blank database...

I have a date field on a form with the properties set to short date and the input mask as 00/00/00. I have set these properties in both the form and the table. My problem is that if you want to edit a date previously entered then it always brings up the time as well. I don't want the time to...

I have a report based on a crosstab query. I have worked out how to get zero's if a value is null, but I want to show the total of the rows on a report. How do I do this?

I have a main form and a subform which is set to continuous where the user selects something from a combo box. After I select something from the combo box I get the following message and I don't understand what it means: The LinkMasterFields property setting has produced this error: 'Member...

Is there any way that from displaying 2 columns of data in a combo box, both can be stored? Any help would be greatly appreciated

I am currently developing quite a large company database. I have read a few posts that indicate that it is better to keep a few regularly loaded forms open as apposed to closing them. What is the best way as I have developed mine to always close them as i have always been lead to believe that...

Private Sub lblgo_Click() Me.Refresh [Date_Created] = Now() [UserName] = CurrentUser() On Error GoTo EMail_Err Dim db As Database Dim rsMySet As Recordset Dim MyMail As Recordset Dim a As Integer Dim b Dim c As Integer Dim d Dim e As Integer Dim f...

I am currently trying to send multiple e-mails from an Access2000 database via Outlook2000. I can get the outlook message up with all the names in the correct place but my problem is that it takes about 10 seconds to check the addresses and underline them before I can can send the message...

I'm using the following code to send multiple reports from Access 2000. The problem I have is that I want to use Outlook Express instead of Outlook. Outlook Express is my default e-mail and works ok when your using SendObject. But for this code it's opening Outlook. How do I declare Outlook...

I am using the code below to send bulk e-mails. This code works fine, but what I want to do now is create the mailing list from a query that contains parameter criteria and it keep coming up with and error message saying 'Too few parameters. Expected 1'. Can anyone help me understand why it's...

Is there any way that I can have the long date on a report showing the 'st' 'rd' or 'th'. ie. 22nd May 2001, or 1st May 2001 etc. Thanks in advance