I am trying to evaluate if when the value is passed in from a form. If the first 2 Characters are not "ST" then to use a different colunm for the result.
thx.
Hi:
I have a MS Word 2003 table contain a descriptions of an over than 30000 items.
Each item description is in one particular table, and have the following properties: NOMENCLATURE, ,STOCK ...
There was a similar question that was answered using CDO method.
Unfortunately, in our environment and in our project, we must use MS Outlook as the email needs to be amended by the user.
Bu...
The attached mdb file works to open a query with multiple criteria from a listbox.
I am trying to adapt this to another database -- could someone help with a few questions?
Instead of a num...
When I open in Access 2007 a database I created in Access 2003 I get a message: "Your Microsoft Access database or project contains a missing or broken reference to the file 'srchui.dll' versi...
I have an access database that uses linked sql tables for its databases. What I would like to do is to have a popup form with a command button that writes the current record from a linked tab...
I am pretty new to Access, but I have a main form with a subform. Whenever I open the form, the cursor defaults to a the first field on the subform, and I have to manually select the first fi...
I have an Access mdb front end, which is linked to sql server tables via ODBC. I'd like to leverage sql server stored procedures to improve the performance, but I must maintain the front en...
Hi experts,
I am currently making a database which has the option to open up .pdf files which correspond to reference number and contain extra details on them. However, I am running into the ...
Hello,
i will try to explain this the best i can. i have to tables that i want to link up by the Job Number field.
one of the tables (Job history) has the Job Number as a string
the other...
I have a table with 11 fields:
ID
MemberName
TYPE
MemberNumber
MBDITM
Route
filler1
filler2
filler3
Status
AccountNumber
There are about 1500 records when there are only supposed...
I have a main form with a Proposal number and a subform with products. When I move to a new record in the main form it generates a new Proposal number
Private Sub Form_BeforeInsert(Cancel ...
Hi.
Can I force Access to use dot for decimal numbers?
I want to currency
6000,20
to be shown as always
6000.20
If regional settings is changed(setting "," instead of "."), Access da...
There are a few places in an Access DB where the users are getting an overflow error (ie., because the declared ID is greater than the capabilities of an Integer field).
I'm tempted to do ...
I'm trying to get the selected value from a combo box and transfer the value to to a string in visual basic. I keep getting the error Invalid use of a null.
I have tried passing text from ...
I 'm working on a project that requires calculating patient days by month. Problem is there are some patients that are in the hospital for several months. For instance, 1 patient may be admitt...
I know how to run a sql query in vba but i cannot figure out how to present the query results in a message box as that is preferred over the default datasheet window that Access pops up with t...
Hello,
I have created some images in Photoshop to be used on my buttons in an Access 2007 front end (these are BMP's b/c jpg's don't work on buttons). I have also created images for labels...
Simple question, I want to know how can I import a number of picture (more than 100+) into the access OLE Object. Does it got any VBA or function I can use ?
Thanks.
I have Excel 2003 vba code that creates a workbook, creates 3 sheets in the workbook and populates those 3 sheets via 3 queries in an Access Db. It works great but I'd really like to populat...
Terminal Server:
Intel xeon 2.27 processor
4 gb ram
Windows 2008 Standard
MsAccess 2003
We have been operating remote desktop over our LAN in administrative mode running a MsAccess a...
Hi,
I have an access database which has started to produce an error. On the machines form of the attached database, it audits any changes you make. It does this by calling a function from t...
printing a word document through MS Access 2003 vba using a specific printer chosen by user from the print dialog..
This is the code I have, can't figure where I am going wrong or is there ...
Hello experts,
I have an access database that I would like to reference a few SQL 2005 tables. However, what I found is that I can actually modify the link tables and it actually modify wh...
How can I include a carriage return or line feed in the caption of a label via code?
I've already tried:
& chr(10) &
& chr(13) &
