Hello -
I am trying to open an ADO recordset using a parameter query and am having problems getting it to work. At this point, it is becoming apparent to me that I need another set of eyes t...
I need to convert a text field to a number format so I can obtain a sum of the field (COST). How would I show that in my query?
Creating a dynamic field called Overall Balance. Looking at one field for a "C" and another for the month. If there is a "C" and the month is = x, then put the value of the current balance o...
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...
Hello,
I have a function where a query is exported by a user but one of the fields is a memo field and only the first 255 chars are making it into the Excel document. I am just using the st...
Using google maps with microsoft access. Anyone ever use this or understand this:
http://www.issociate.de/board/post/268098/Using_Google_Maps_In_MS_Access.html
I was good up until this p...
I imagine there is probably something simple that I'm
missing, but I can't for the life of me get this to work.
I'm trying to import a text file "EXT_MEMBERS.TXT" into my Access 2000 data...
I have MS Access as the front end with tables from an SQL database linked into the access file and these act as datasource for the various queries which are displayed on the click of buttons o...
I have an Access database that connects to an Oracle one. In the Oracle database, there's a table "doxlib" that I want to use to store various things (documents, photos of contacts, etc). In i...
Hi
I'm trying to parse comma delimited text into a table. The text in question has a number of fields, but i only want to import certain fields.
Eg.
counter,box,gap,pos,lgap,tgap et...
Hi
I have a procedure in Access which starts with the code below.
If there is an attachment on each email I want to save it to the same folder as
my Access database is in. How would I do ...
I have the following:
=IF(DATE="","OK",
IF(DATE<25,"MONDAY"
,IF(DATE<35,"TUESDAY",
IF(DATE<45,"WEDNESDAY
",IF(DATE<75,"THURSDAY"
,IF(DATE<88,"FRIDAY"
,IF(DATE<92,"SATURDAY"
,"WEEKE...
I need help with code sample to get the max(system_creation_date) where the acct_nbr in Tbale 1 = the acc_nbr in table 2. That data needs to be inserted into another table. Asingle row should ...
I have two subforms that I am trying to synchronize and it's not happening. I am wondering if you could help please.
Subform 1 is called frmCampaignsSub (continuous form)
Subform 2 is call...
I have a VB module in MS Access that generates a MsgBox using the text stored in a table by the user. Since you can't really modify the size of a MsgBox and I don't want to use HTML, I was won...
I want a field to display a different color font depending on the value in the field. I know this is simple but I can't get it to work. I have a field called "status" when the value is "open" ...
I get an error -2147217900 (80040e14) run-time error. The changes you requested to the table were not successful because they would create duplicate values in the index, primary key, or relat...
Hi,
I accidentally changed the property of one of my tables in Access to Hidden and now I have no idea how to "undo" that property because I can no longer see the table. Advice?
There seems to be no default way to not display any ribbon (you can hide all except the home ribbon using the access options) in Access 2007.
I don't have the time just now to learn how t...
I am running Windows 2000 and Access 2000. I have built a database that resides on a shared location on a novell server. For some users, the database runs as efficiently for them as it does ...
I have inherited an MS Acess database that utilizes a form for entering new/existing data. The unbound text box fields work fine if the users use the tab key while entering new data, but if t...
I am using Access and VBA to create an XML Document that will post to an IP for the purpose of faxing documents. I have the VB code written to accomplish this but my question is relating to....
I have a number of TextBoxes that should contain currency values. How do I restrict the user from entering non numeric values?
I am exporting contents of tblSample to Excel for automatic totalling, formatting, and printing. I am doing this with a command button on a form. The first time I execute the printing (open th...
I am trying to run a pass-through query in access with a variable that a user enters in a form. I can't seem to get this to work. Can somebody please help? The variable should be where the 121...
