I know you can "fiddle" a lot with date formats can you do anything with the currency format?
I don't think this is possible but just in case here goes:
I have a report where I'd like to h...
In Access I have three different forms.
frm_enter_person is a data entry form to enter details about a person
frm_lookup_person is a form that populates a list of people in the database ba...
I am getting "Not enough space on temporary disk" error message when I try to save a change to a rather large table. I have plenty of RAM and HD. Where do I increase the temporary disk space?
Have a user that is opening a database, getting a macro security warning. When they open it, the database locks up. It opens for other users.
The macro security is set to medium, if you try...
MS Access 2000.
DWMX
Hello. I am having problems when I'm trying to query for an EndDate that is >=NOW.
Fields: {sponsorHPFeatured; sponsorStartDate; sponsorEndDate}.
I am trying ...
I want to use VBA code to open a specific pdf file at a given location in response to a user's request.
According to info on the Adobe site, this can be achieved with the following code:
Acr...
I currently use the code shown below to open an embedded Word document.
Sometimes it works perfectly; opening the document in Word in full screen (that's what I want).
Other times it just ...
I've been trying to compose a VBA Select Statement in Code in Access 2007 without Success. I have been trying very simple queries and from all of online examples, It's always either complainin...
I am creating a form that will allow users to view a summary of trading activity by month. I created a query which takes the user input (year, sector, min trade size) and returns the sums gro...
I need some help asap, if possible...
I am working on creating queries to output data into excel files. The query provides multiple groups of data (all numbers). I need to be able to provid...
I have two columns that I need to total together as a value for one field. NB_CON and COI_CON are the two columns. Any ideas? Thanks
=DSum("NB_CON","COI_CON","tblActivity","Date_Added Bet...
I'm looking at solutions to send HTML-formatted emails via MS Access.
I do not have Outlook reference but do have access to an SMTP server.
Is there a way of doing this? If so, could you...
Only one of 3 workstations get this error running an Access process: "Description: The request for procedure 'tblInTrans' failed because 'tblIntrans' is a table object. Source: Microsoft OLE ...
I am currently trying to learn what an ERD is for an Ecommerce business. Does anyone have any ideas how to go about finding one or more examples of an Ecommerce ERD so I could reference it to ...
I am trying to add an autonumber type field in a table with over 18,000 records. I have done this several times before with even larger tables with over 100,000 records with no problems but ha...
I am hoping to programatically merge PDF files and add bookmarks using itextsharp.dll or itextdonet.dll.
The problem I'm having is that I can't even add a reference to either dll.
Can ...
I'm getting this message when I try to open the DB, it is access 2000 the database is a little big.
Can anyone please help me there is very important data in it, but keep in mind I'm not mu...
Hello Experts!
I have a 3 column combo box based on a table.
Before a user makes a selection, all 3 columns are displayed.
After a user makes a selection, only 1 column is displayed...
I have an Access 2003 database and I want all text to be entered to be in capital letters. I know I can put UCase in a query but is there some way that in the tables it just automatically goes...
Hey,
Camn someone telp clairfy this query? Its a pretty massive query and would be good if someone could tell me in English whats going on? I have left out quite a few values from the select ...
Does any one know how to Delete a record in VBA Code..for Example...
DoCmd.DoMenuItem acFormBar, acEditMenu, 8, , acMenuVer70
DoCmd.DoMenuItem acFormBar, acEditMenu, 6, , acMenuVer70
Wi...
Hello,
I am using microsoft access 2000, and I created database "wholesale" in wich
I have form "Invoice" with next columns:
"ItemNumber"; "Stock"; "Quantity"; "Price"; "Total"
"Qua...
I have a field in my table that is called OrderNo. This order number is based on todays date. Only the user has to look at a table to figure out what todays date is in Julien and thn they ad...
i need information about Network Cards,i mean which one is for Regular Phone Cables and Which one or Rj45,please help me out and what is 10/100bps(maybe)..help me out
(copied unresolved question) 2000 SP3 machines with Access xp SP3 on a workgroupe network. When some users double click on the db from Windows Explorer the database won't open. If they open ...
