Microsoft Access / VBA Forum

Hello, I have a currency field on my form. The default formats for this field are dollar, euro. There is no pound symbol.....How do i put in a currency format, having the pound sign. Any help will be appreciated. thanks and regards Nanda

On one of my users desktops I have setup multiple icons to open Access applications (Access 2k). In the target line I have specified the path to msaccess.exe, the path of the system.mdw and the path to the ..mdb. The icons do not always work. Occasionally he will get the error message "Couldn't find file 'System.mdw'. This file is required...

Has anyone ever created a shared calendar within Access? It would be similar to MS Outlook, but clearly not as in-depth. I would need to use it for employees to enter their availability so managers can assign projects accordingly. As well, it would be nice if it actually LOOKED like a calendar. Do you recommend the ActiveX Calendar Control?

Hi, I have created a sub-form Roles. In my course form the user selects the roles assigned to the course. 0ne-to-many. One course many roles. Then I created a report based on the Course form and role Sub form. I brought the sub=form into the report and it has the correct values, but it does not have the same look and feel as the other...

Is there a max number of records that you can import into an Access 2000 database? Is there a max size of an Access 2000 database?

If you want to visit each item in an Array, you have two alternatives: Use a For Each..Next loop, using a Variant to retrieve each value in turn. Use a For...Next loop, looping from the Lower Bound to the Upper Bound of the Array. For Each...Next seems simpler because you need not worry about retrieving the Lower and Upper Bounds- the...

Please can anyone tell me how I can create a macro to save the results of a query as an excel file? The query is called Student List and I would like to save it to "My Documents". We have had some problems with our database crashing. We would therefore like another way to have access to basic student data and thought we automatically save...

I have a textbox that takes user input, and depending on what the user inputs i want to perform a formula. I know the code for Java, but not for VBA IE textbox1 = 0 switch(Me.textbox1) { case 1: a+b =c break; case 2:

I'm trying to use an ActiveX treeview control. I was trying to declare it in VBA and discovered that there was no option for declaring a variable as MsComctlLib.TreeView. I'm assuming that this is a reference problem, but I can't find a reference that specifically says for the treeview and I can't find online what reference it requires. I also...

I have a table that contains a bunch of pictures. When the user selects a particular image in a form, I need a way to extract the selected bitmap image (stored in an OLE Object table field) to the file system so the user can do stuff with "somePicture.bmp", for example. Is there an easy way to do this? Thanks in advance.

Hi, I wonder if someone knows where I am going wrong below. I have a continuous form and two labels where only one would be visible depending on the checkbox being checked or not. Below is the code. Visibility is not adhering to the record checkbox value. Screenshot also below. Any ideas? Private Sub Form_Current() Dim db As...

When I open my form nothing is selected in the list box. After making a selection it stays highlighted. I have been trying to get it back to the "nothing selected" state, but with no luck. I have tried repainting, requery, etc. Thanks for any help, ShyGuy

I am currently developing a new database, and somehow the breakpoint (F8) doesn't not work on this particular database. The breakpoint feature in my other database works fine. Is there a settings within MSAccess 2010 that I need to turn on? For example, I am assigning a date to my global variable and displaying it in the report on load, but...

HI, I am running a few modules of VBA code. In the middle of running the code crashes as Access reaches its max size of 2GB; but, if I compress the database at that point it is only 200MB. How can i compact the database regularly in the interval regards atks

Hello All, I need a report in Access 2007 to show a dynamic image on every page. I have a table, and I store image's path in a cell in each of the rows. In 2003, I was able to do that using VB, the following code worked: Private Sub Detail_Format(Cancel As Integer, FormatCount As Integer) Me!.Picture = Me!

Could you please advise whether it is possible to delete records in suborm. When I highlight whole record it won't let me do it. I've chcecked all properties and it should allow to delete records.. Main form is Purchase Order2 and Subform Name is PO1 Subform, Thanks

I have a continuous bound form on a FE stored on desktop of each user PC. The BE sits on a local network drive. I have the default record locking to "No Locks" and Open Database Using Record Level locking. All appears to work well, but periodically (several times a day) a user will get the message "Could not update; currently locked" (no...

I need to be able to add a record directly into a table using vba. The table is not the same table that is being used on my current form. Basically I want to have a question with a list box containing possible answers. Do a loop to capture these multiple responses and instead of storing them in a single field, separated by commas, store each...

Hi I'm trying to figure out how to center forms on a page I have a form built with some tabbed pages, and I'm playing with the form properties, but it always displays top and left and not centered Thanks Jerry

I am trying to check and see if the user selects an item in the cbobox and if not it will display them a message but it gives me an error saying "argument not optional" I have tried the following snippets but neither one works can someone help me with this? thanks in advance If Me.cboBeverages="" Or Me.cboDoughnuts = "" Then MsgBox "A...

Is there a simple way to send SMTP email from Access VBA? Mike m charney at dunlap hospital dot org

Hi there, I am very new to Access so apologies if any of this is obvious/not clear. I am creating a data collection tool for health care employees to complete. It consists of a number of forms they will fill in. One of my forms relates to a goal based measure that the employee will fill in each time they meet with the patient (each...

Is it possible to export a report from Access to Excel and keep all the formmating. i.e. Lines, boxes etc... Or do you need to create an excel template and then use a macro or some VB code to run an access query to generate the excel sheet with the pre-defined formatting? Thanks in advance.

Just been having this problem when Exporting a query. DoCmd.TransferText acExportDelim, "GenMESR Export Specification", "qryGenMESRExport", Environ$("TEMP") & "\MESR.CSV", False I get the error 3011 cannot find object 'MESR.CSV' Tried using OutputTo, which netted "database or object is read-only". Googled this group to find KB article...

I recently started a job at a medical staffing company, a database used to keep information was built by a lady there who has very limited Access experience (even less than me) They run Access2k3, on WinXP desktops The files and DB reside on the corporate server. She complains that in the mornings the first person who opens the DB locks...