Search results

Hi all, I am working on a system that has a back end (on the server) and 6 front ends (all identical, one on each of the client pc's). This means that whenever I make a change to the front end, the updated version of the Front End has to be copied + setup on all 6 client machines. This also...

With regards to the following simplified code: *- Start Code With rst .AddNew !strName = "Joe Bloggs" ? .Update .Bookmark = .LastModified End With *- End Code I am simply trying to add a record to a table. The line with the question mark throws the...

Hi, I have a form that is a datasheet view of all the fields in a table. What I would like to achieve is to have the user being able to select which fields they want displayed (eg from a list displaying all the fields) and then only those fields get displayed in my datasheet form. I thought...

I have a database with images stored externally (with only the paths stored in the database). I want to create a button that would open a picture with the user's default picture viewer (eg. Ms Photo Editor, Ms Paint, Photoshop etc.). Is there anyway that I can simulate the double click of a jpg...

Hi, I am developing a database in Access XP. I have been coding away all day. I did a compact and repair and then closed access. Later on when I tried to open up my database again it crashed access on startup. It does it every time now. About the same time the default form should be displayed...

Hi, I have been looking into MSACCESS security for the first time today. I have made a little test database that I open with a shortcut that looks like this: "C:\Program Files\Microsoft Office\Office10\MSACCESS.EXE" /wrkgrp "C:\Database\test.mdw" "C:\Database\test.mdb" That is working fine...

Hi, I am attempting to create a word document from VBA code in Access. I am having a problem with Normal.doc when running my code. If I delete normal.dot my code works fine and the document is created ok the first time I run it. Every time after, I usually get a error stating "Normal.dot...

I have a datasheet, and upon the user double clicking in one of the fields of a record, the code is meant to open a form (based on the same underlying table), and open at the record that the user clicked in. ** START CODE Dim db As Database Set db = CurrentDb Dim rst As Recordset Set...

Hi, I am working on a database system that I want to integrate with the MYOB accounting package. I would love to be able to generate an invoice in Myob from VBA code run from within my database, with all the relevent information for the invoice being sent from my code. Also, when a customer...

Hi, I have recently split my database. I am just testing my frontend out on my pc and it all works from within the form views, but I go into project manager and click on one of the link tables to open it, the database crashes without any error message! Does anybody know what this could be...

Hi, I recently split a database for the first time. I have 3 workstations running Access 2002 (XP), and 2 running 97. The backend was created in Access 2002. The 2 Access 97 front ends won't work with the back end. Should I just convert the backend to Access97 format and all will be ok? Or...

Hi, I have a form with 2 list boxes. In one box is a list of all motels (the left box). The user can then select any or all of the motels in the left text box and include them in the second list box (the right one). The motels in the second list box will then be used to filter a report. To...

Hi, I have a report, and every time I open it for preview it is set to print out black and White instead of color, no matter how many times I change it to color. It won't save the color setting. Why is this so? Is there a setting and/or code that I can use so that the user doesn't have to...

Hi, I have been working on the coding of a form all day, and all of a sudden none of the code behind my form works at all, and it now won't let me view the code in the code window. I tried going into the code window from another view and switching to this form but the form is no longer listed...

Is it possible to change the text in a label on a report in the Report_Open event procedure?

Hi, I have a simple multi-select list box. I can select multiple items from the list box. But when I double click on an item in the list box, I want to be able to bring up another form showing the record that relates to the Name in the list box. All I need is to be able to detect a double...

Hi, I have a text box on the screen, whose text is then taken as a string and made the Message body of an email message. Here is the code: doCmd.Sendobject, acSendNoObject,,,"joebloggs@bloggs.net",,,"EMAIL SUBJECT", Me.MyTextBox.Text If I type some text into my text box and then hit enter, I...

Hi, My database has a picture link field that holds the path of a jpg image. (e.g. "C:\project\images\pic1.jpg"). I have a report that has code that pulls the image from the path and displays it in a Image Frame on the report (Me![Image_Frame].Picture = Image_Path_Variable). This works fine...

Hi all, I have the following code (taken from a post found in the search facility): Dim appOutl As Object Dim MyNameSpace As Object Dim myemail As Object Set appOutl = CreateObject("Outlook.Application") Set MyNameSpace = appOutl.getNameSpace("MAPI") Set myemail = appOutl.CreateItem(0)...

Hi, I have an annoying problem that I have literally spent hours trying to fix. I have a single form that is used as a reports menu. Within it, I have a combo box with the names of schools in it. When I choose a school, a corresponding list box shows the students of that school. I can then...