Convert time as text to datetime
I've got a stupid table that I have to work with (and no, I can't change it) that stores times of certain events as text (example: '10:25 pm' or '3:02 am'). This table has an actual date to work with, which is essentially just the date with no time component. Know what I'm going to ask yet? You...
View Answer
| May 15 2008 11:53 AM GMT
| asked by
VentureFree
Microsoft Access, DateTime
MS Access - Email from form - VAR email receipients
Hello,I have an access dbase and I need to email records (usually one at a time) to different receipients. The receipient name is part of the form and I have a table that lists the name and e-mail address. I am hoping to click a cmd button that will e-mail that individual the record on view. I...
Answer Question
| May 13 2008 6:26 PM GMT
| asked by
Asuasol
Microsoft Access
Microsoft Access
I have created an Iff statement where it will compare two fields and return the bigger number. The problem is that instead of compare the numbers as a whole, it compares them digit for digit. Result is that it will return a value of 150 instead of the bigger value of 1040, because the second digit...
View Answer
| May 13 2008 8:06 AM GMT
| asked by
Jaco
Microsoft Access
MS Access ActiveX Control
I am using a MS Form where I am trying to fill in a couple of date fields from a Calendar I inserted using ActiveX controls. How do I go about doing that?Thanks,Asuasol
View Answer
| May 12 2008 6:50 PM GMT
| asked by
Asuasol
Microsoft Access, ActiveX, MS Access
Combined Address
I have one tblContacts that has "Home" and "Work" address included within it, I also have an option button 1="Work" and 2="Home". I need to prepare a mailling report, but only for the defaut address.Someone suggested that I create a calculated field. I tried this but all that it is doing is pulling...
Answer Question
| May 12 2008 5:29 PM GMT
| asked by
Thuzinec
SQL, Query, Microsoft Access
Net Present Value
In an Access Form, I want to be able to have five values in text boxes and use those five values along with another value in the form, the return rate, to produce the Net Present Value
Answer Question
| May 12 2008 4:41 PM GMT
| asked by
Mattylar12
Financial Functions, Microsoft Access
Open Import window via code in MS Access
Within a MS Access application, I would like to have the window that is opened when you select: File | Get External Data | Import via code.
View Answer
| May 9 2008 3:14 PM GMT
| asked by
Rjwilcox
Database, MS Access, VBA
Split Databases - BE Structural Changes Version: 2007 (12.0)
Can I make structural changes to the BE database without affecting the users? i.e. the relationships, proprieties Also, why do you have to put the FE on the users computer, can't you put their copy of the FE on the network, under a folder just for that user?
View Answer
| May 6 2008 8:23 PM GMT
| asked by
Thuzinec
Microsoft Access, Access 2007, Database
Save Access 2007 format as 2000 format with VBA
how can i save the curent database as a 2000 format with vba
View Answer
| May 6 2008 10:23 AM GMT
| asked by
Dave b
VBA, Access 2007, Access 2000
Printing the contents property of an EXCEL file
I have an Excel spreadsheet that has 92 macros and many queries with a Data Connection to Access.I can view the contents of the Excel file in a narrow window. Does anyone know how to print the contents so I can read the full contents?
Answer Question
| May 5 2008 6:21 PM GMT
| asked by
SharieL
Microsoft Excel, Microsoft Access, Excel macros
Deletion of Macros when doing a repair & compact
We are experiencing a problem of a number of macros being deleted after performing a repair & compact. Could this be a space problem or could it be a problem with how the environment is set up--what do you think could be the problem?
Answer Question
| May 5 2008 6:14 PM GMT
| asked by
SharieL
Macros, Repair and Compact, Microsoft Access
Using shell execute from Visual Basic
How can I use the function Shell Execute in Visual Basic Code. I am running MsAccess. I want to use the Shell execute command ro run sqlloader command which loads data into an Oracle table. Would benice to have an example of this. /Roland
View Answer
| May 1 2008 5:34 AM GMT
| asked by
Rolandsk
Visual Basic, Microsoft Access, SQL Loader
access 07 help
i have a database in accses o7 that i wont to share over a network and allow users to log in on any system so that they can update or view the database'forms'and reports..please help
View Answer
| Apr 30 2008 1:18 PM GMT
| asked by
Joe260986
Access 2007, Microsoft Access, Database
How Can i restrict the user to insert next record
Hai all, I have a requirement that , i have to display the data from a table in the subform in a datasheet view mode. I should validate the fileds in such a way that i can restrict the user to insert a next record when the one of the fields in the previous record is null. And also i should pop...
Answer Question
| Apr 30 2008 11:23 AM GMT
| asked by
VBAccess
VBA, Access 2000, Microsoft Access
MS ACCESS 2007 mass email list?
I was wondering is there a way to create a mass email from a query or table that would send out in MS OUTLOOK?I know of a way of extracting a table and importing it into OUTLOOK but my boss wants a more efficient way.
View Answer
| Apr 29 2008 12:42 AM GMT
| asked by
Itguy1509
Microsoft Office 2007, Access 2007, Microsoft Access
Limiting characters in memo field
In Access how do I restrict the number of characters a user can enter into a memo field?
Answer Question
| Apr 29 2008 1:36 AM GMT
| asked by
Olddog
Microsoft Access
How to pass a Whereclause from a form to another form’s subform in Access 2000?
In FormA, I have a start_date and end_date fields for users to select the date range. The start_date and end_date will pass to FormB.subform where the subform is a continous form to display the records after filtered by the date range. My question is: how can I pass the date range to the subform...
View Answer
| Apr 23 2008 2:28 AM GMT
| asked by
Wonder19
Microsoft Access
Flickering subform in Access
Hi,I have a continuous subform that, upon opening the database, flickers constantly. This flickering can be stopped either by alt-tabbing away from Access and back again or by hitting F9. The main form has a button that changes the source object of the subframe to a different continuous subform,...
Answer Question
| Apr 22 2008 3:23 PM GMT
| asked by
Mickeymongoose123
Database, Microsoft Access
Migrating from MS Access to SQL Server Express
I've just installed SQL Server Express and I want to create a local instance. I would like to use SQL Server to do my analysis in running queries instead of Microsoft Access. I want to import my tables from Access to SQL Server Express. How can I migrate from MS Access to SQL Server?
View Answer
| Apr 18 2008 1:01 PM GMT
| asked by
SQL Server Ask the Experts
SQL Server migration, SQL Server Express Edition, Microsoft Access
Microsoft Access Printing graphic hell
HiThis is a weird one.I have a report that prints embedded Access graphics - from a table. When I originally designed it, each time I went to print - no graphics appeared - then almost overnight - they started to print and I've had no trouble since - until today... when I started adding more images...
Answer Question
| Apr 10 2008 9:00 AM GMT
| asked by
Elgoober
Printing, Microsoft Access
