| |
thread by: ramaswamynanda |
last post Jan 20 '16 by: zmbd
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
|
thread by: Bill Short |
last post Nov 13 '05 by: Rick Brandt
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...
|
thread by: Teri B |
last post Oct 26 '23 by: NeoPa
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...
|
thread by: apartain |
last post Feb 4 '10 by: NeoPa
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?
|
thread by: candid14 |
last post Sep 3 '06 by: PEB
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?
|
thread by: ADezii |
last post Oct 7 '07 by: ADezii
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...
|
thread by: Carl |
last post Nov 12 '05 by: Stewart Allen
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...
|
| |
thread by: Jollywg |
last post Apr 6 '08 by: ADezii
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:
|
thread by: Seth Schrock |
last post Dec 26 '12 by: Seth Schrock
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...
|
thread by: ezappsrUS |
last post Jun 13 '23 by: NeoPa
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...
|
thread by: deko |
last post Nov 13 '05 by: Stephen Lebans
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.
|
thread by: Shyguy |
last post Nov 12 '05 by: For example John Smith
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
|
thread by: benchpolo |
last post Aug 24 '12 by: NeoPa
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...
|
thread by: atksamy |
last post Dec 15 '10 by: NeoPa
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
|
thread by: Eugene |
last post Mar 16 '07 by: Allen Browne
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!
|
| |
thread by: MEGDZIA |
last post Nov 16 '08 by: mshmyob
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
|
thread by: prknsutton |
last post Jan 19 '10 by: nico5038
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...
|
thread by: Craggy |
last post Nov 14 '07 by: ADezii
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...
|
thread by: jerry.ranch |
last post Jan 12 '06 by: Wayne Morgan
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
|
thread by: cluce |
last post Oct 24 '07 by: Jim Doherty
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...
|
thread by: Mike Charney |
last post May 10 '06 by: tcosmas
Is there a simple way to send SMTP email from Access VBA?
Mike
m charney at dunlap hospital dot org
|
thread by: nia12 |
last post Nov 1 '23 by: NeoPa
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...
|
thread by: ConnollyS |
last post Dec 10 '07 by: ConnollyS
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.
|
| |
thread by: Trevor Best |
last post Nov 12 '05 by: Wayne Morgan
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...
|
thread by: kaleolani65 |
last post Feb 15 '07 by: NeoPa
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...
|