ASP.NET, SQL Server, WPF, C#, VB.NET

I am trying to import a dbf file into my Access DB using the following: 
 
DoCmd.TransferDatabase acImport, "dBase 5.0", "C:\temp\member.dbf" 
 
I get an error message indicating that the path is not valid.  The file 
 
exists exactly as specified and I can import the file manually.  Any ideas? 
 
Your help is appreciated in advance.

I print letters from my access database using words mail merge feature. I can 
 
easily open word documents from access with a command button. however I want 
 
to know if it is possible to somehow tell word which database and table to 
 
link to. Otherwise people have to use the mail merge wizard to select the 
 
proper table and they always have trouble.  I don't know if its possible or 
 
if i have to do some code in the word document itself. any help is 
 
appreciated. thanks 
 
keith

Thanks to those who provided me guidance to transale code to text in the 
 
form.  I have the same requirements in generating report.  I used the Report 
 
Wizard to create report from a table.  The field (jobclass) that contains the 
 
code still shown as number 1,2,3 in the report as it is generated. 
 
Wonder if I can write some code to change each record's code as text ? 
 
For example change 1 to manager, 2 to supervisor, 3 to operator, etc. 
 
if yes, where it should be such that the repor ...

Hi, 
 
Is there a way - object property - which you can query in VBA to get the 
 
name of the procedure that is running when the error occurred.  I can see 
 
that you can get the GUID.  I want the friendly name if it exists. 
 
Thanks.

I'm using Access 2000.  How can I run a batch file from VBA? 
 
Thanks! 
 
Alan B. Densky

Hi, I'm using the Navigation Button at the bottom of the form to browse 
 
record in a table.  In the table, I have various flag and option and it is 
 
currently simply displaying them as a numeric number.  I'd like to translate 
 
them into a meaningful text.   This means that I've to intercept the record 
 
and translate the number into the text appropriate to the data. 
 
For example.  I have a table "MyData" with a field "Active" which contains 
 
the following displayed in a form "frmShowD ...

Hi, 
 
Like Colin before me, I need to open PDF documents in a form using a command 
 
button and based on a variable ID number. I've put in the code that worked 
 
for Cloin but it's not working for me. This is it below: 
 
Dim strFileName As String 
 
strFileName = "G:\Service Contracts\Declarations\" & Me.SerialNo & ".pdf" 
 
Application.FollowHyperlink strFileSpec 
 
I think it might be because of the hyperlink section of his code which I'm 
 
not understanding correctly. If Colin or anyone  ...

Highest rate for all type / brand 
 
24-Hrs +91 9810577227 Puri

I'm having a TOUGH time trying to get this going... 
 
And what makes it so aggravating is that I'm sure it's something simple..... 
 
I'm just not familiar enough with Access VBA, Modules, etc to do it. 
 
After  lots of reading on this board......it looks like the SHELL command is 
 
what's needed.....but I can't figure out exactly how to implement it so that 
 
it will execute when clicking a button on a form. 
 
I'm needing to copy all the files in a specfic directory  to another 
 
director ...

Hi I've been banging my head with this for some time. 
 
I'm converting Joe Celko's nested sets into Access, and I have it 
 
working, but it's so inelegant, I'm convinced there's got to be a 
 
better solution.  Basically a nested set is a hierarchical 
 
representation for relational databases.  There's not much need to 
 
understand other than each record has two field named 'left' and 
 
'right' which determine where the record falls in a hierarchy and that 
 
Element ID is a primary key.  L ...

Starting from a dao.recordset - dbdynaset, I got some trouble with the error 
 
message 'too many transactions are nested' each time I try to modify my 
 
active record more than four times. 
 
The modify subroutine starts from the click event on a unbound form. 
 
It has the following VBA Code 
 
rs.edit, rs(0) = activeform.txt_Name, rs.update. 
 
Till now, the error is tackled with the following routine. After 'rs.update': 
 
set rs_2= rs, set rs = nothing, set rs = rs_2, set rs_2= nothing 
 
 ...

Hello, 
 
'--- 
 
Open "c:\test.txt" For Output As #1    ' Open file for output. 
 
Write #1, "blabla" 
 
Close #1 
 
'--- 
 
Why doesn't this work, it worked before? 
 
Error message: (in Dutch) 
 
Fout 54 tijdens uitvoering: 
 
Ongeldige bestandsmodus 
 
Please help. 
 
Thanks, 
 
Hans

I need to have a database that includes customers, products, supplers and 
 
shippers. I found a supplier database and a customer database, but not one 
 
with all 4 tables included. Can you tell how to add a table to the suppliers 
 
database that would link to a table with customers? We are useing Office 2003.

This post is not about any specific issue but about building the Application 
 
itself. Please have patience to read the tale of an ametuer "programmer(?)". 
 
Please help if it sounds meaningful. 
 
Three months ago, when I was first exposed to Access, I was amazed to see 
 
the ease with which one can build databases. I was hooked and started by 
 
building my own Application. Learning VBA further enhanced the functionality 
 
of my db. 
 
The problem now is: 
 
The code I wrote initially was  ...

Where does msgbox title fit? 
 
If (Eval("[Forms]![attendance]![Qualification ID] Is Null")) Then 
 
If (MsgBox "message." & vbCrLf & "more message?", 4) = 6) Then 
 
DoCmd.... 
 
or do I have this all wrong?

Hi All 
 
Please forgive cross-posting, also posted in 
 
'microsoft.public.access.modulescoding'. 
 
I have 'inherited' a part complete Access 2000 database which has in it the 
 
module shown below. The idea is, I think, to take a number of days and a 
 
start date then give the finish date excluding weekends and bank holidays. 
 
The problem is that while it is excluding weekends it does not appear to be 
 
looping through the dates in the table tbl_BankHols and excluding any dates 
 
in ther ...

I am creating a database for our IT dept to replace our paper schedules with 
 
an online version.  What I need to create is a way to bring an incomplete 
 
schedule back up so the operator on the shift can finish the schedule out, 
 
(example would be when the operator breaks for lunch and someone else comes 
 
in and logs into his pc while he is out, which would close the schedule 
 
databse.) 
 
My idea is to create a table that is populated by the values of the primary 
 
keys for the schedu ...

Is there any way of offering the User to set a default printer for an MDB 
 
file without bothering Windows settings ? Also by extension, can the User be 
 
given an option to choose a specific printer for any Report ? 
 
The idea is, 
 
Once the User sets his options, his/her preferences have to be saved until 
 
the User wishes to change the same and any Report with a Specific Printer 
 
option will go to that printer only and others to the default printer of the 
 
database, without bothering ...

My application is stored on network and it connects to SQL server 2000. It 
 
runs fine if accessing small piece of data. But for batch process it hangs up 
 
after 3-4 minuts. It runs fine from some workstation and hangs on others. All 
 
workstation are WIN XP SP2. Application is written in Access 2002. All 
 
workstation has ACCESS 2002 installed. 
 
I use ADO to connect SQL database.

Hello, 
 
I have a database with certain startup options for the end user. What I 
 
would like is for the database to prompt for a password ONLY IF the shift key 
 
is used to try and bypass the startup options, so that only an authorized 
 
person with the password can see the background of the database. If I simply 
 
set a database password from the Tools menu, it asks for that password with 
 
the startup options as well, and I actually locked myself out of a database 
 
that way! So there  ...

Hi, 
 
I have a rather simplistic problem that I can't find a solution to! I have a 
 
form that I want to maximize every time it opens (which I have achieved 
 
through DoCmd.Maximize in the Form_Load event), but I also want that all the 
 
controls in the form, staying positioned relative to each other, center 
 
themselves horizontally on the form once it is resized. Maybe I can set a 
 
property that always makes them stay in the horizontal center, which is also 
 
great. How could I accomplish this? 
 
Thank you! 
 
Kriti

I have the folowing code to open an Excel file from a module in access: 
 
Filename = Dir("Q:\Furnace Files" & "\*.csv") 
 
Do While Filename <> "" 
 
filepath = "Q:\Furnace Files\" & Filename 
 
Length = Len(Filename) - 4 
 
Set xlApp = CreateObject("Excel.Application") 
 
Set excelworkbook = xlApp.Workbooks.Open(filepath) 
 
excelworkbook.Application.Visible = True 
 
excelworkbook.Application.Windows(Filename).Visible = True 
 
FinishTemp = 300            'temp that it is okay to remove pa ...

I am using Access 2003. 
 
I am having a problem in developing a full PM program in Access.  Does anyone 
 
know where I might find a template for this type of program?  Or where I 
 
might find a good reference for developing a preventative maintenance 
 
program.? 
 
Thank you - Aurora

I really need some help!  I am trying to send a record to Word through a 
 
table in Access.  The user enters information on a form and clicks a button 
 
to run a make-table query and export the information to Word.  I've been at 
 
this for what seems like forever and it's just not working.  My knowledge on 
 
coding is very limited so I try to see what others have done.  I'm afraid now 
 
that I am just so confused that I don't know where to go.  And - I still 
 
haven't gotten to automating  ...

I have a module in Access that opens an Excel file and does some calculations 
 
on the data but I need to know the number of rows to loop through for my 
 
ForNext loop.  Can you tell me how to figure out the number of rows?  Thanks.