Search results

Don't know what's happening. I tried to put the last update on another thread! Jon.

Glad to help Chris, good luck on your course. As a parting shot I'd use - If rst.Recordcount > 0 then Display the data in Excel Else Present an error/information message for the user End If This will catch the empty Recordset. Jon.

K, The following code pulls in a Recordset from a databse held in the U:\ drive based on the SQL at line 1. Line 2 reserves the variable xlSht as an Object and line 3 defines that Object (xlSht) as the Current Sheet in Excel. Line 4 moves the pointer to the beginning of the Recordset rst. Line...

Doc Man, thanks for your explanation - I am in scenario 2. I'm stuck with the distance problem and office politics denies me use of anything but Access 97. I was just curious of the overheads I was placing on the WAN as I'm building an argument for a more suitable software and your explanation...

We use Outlook which has the ability to 'talk to' Access or vice versa. I have some code at the office which enables Access to import from your Inbox information from an eform. It does this by first identifying the eforms from either the name of the eform or by identifying some text in the...

If you put the intended value into a variable derived from a table or hardcoded such as Dim strBenefits as String Select Case [Benefits]![EE Covg] Case "S" strBenefits = "EE" Case "F" strBenefits = "Fam "Case "1" strBenefits = "EE +1 Case "2" strBenefits = EE/Kids Case "W"...

What email software are you using? Jon.

You could also create several mde files - one for each level of functionality.

Try using FileCopy <source filepath> , <destination filepath and name> You would need to set up a second database or VB exe file to take care of the copying and ensure that no users were logged into the source file or it just won't work. Jon.

I think if you move the closing parentheses you would lose the syntax error - If ([Benefits]![EE Covg])="S" Then [Benefits]![Med Mon Rate]= [Medical Rates]![EE] ElseIf ([Benefits]![EE Covg])="F" Then [Benefits]![Med Mon Rate]= [Medical Rates]![Fam] ElseIf ([Benefits]![EE Covg])="1" Then...

Doc Man, I'm stuck with Access and VB at the moment. When I set an index on a field on a remote server using VBA from my home server it takes quite a while. I'd like to think that my VBA command is sent to the remote server which then acts on the command and returns confirmation to the home...

Thanks Autoeng, you've opened my eyes to a few features I hadn't come across. I'll try what you suggest and cross my fingers. Jon.

Try the site Rich refers to for more details but basically you need to tell Excel that you wish to use DAO you do this by accessing the VB toolbar in Excel and opening the code editor, which is where you type the VBA. click Tools on the menu bar and from the list select References click...

You can write a query in VBA for using SQL. The syntax would be something like - Dim dbs As Database Dim rst As Recordset Set Db = OpenDatabase("U:\My_Database.mdb") Set rst = Db.OpenRecordset("SELECT * FROM tblPost") This puts the query results into rst You have to set a reference to...

I regularly have a situation where a database locks up in need of repair but when I try to repair from my base Access tells me it is unable to repair because my base is using the database. I only have one copy of Access open and no other users are logged in. I try a reboot od my machine and this...

What you say about more than one change to a single record on different servers is correct. We currently find about 40 of these cases each evening out of 3000 or so amendments. I'd love to use a single database solution but not possible with Access in our situation and no chance of a more...

Do all your users have access to each server or are they limited to their home server? I have a situation with 1500 or so users over 20 servers. I have placed an identical copy of the database on each server, sent ourt a VB frontend and overnight run a tool that picks up any...

I'm controlling a database which has copies on remote servers. Each night a make table query is run to xfer the updated table out to te remote servers. I then set indexes on this table via VBA. The table contains 230,000 records and as such it takes a while to set the indexes. The time is not a...