Search results

Malcy, Try this ' Define variables strSQL = "[lngConId] = " & Me.txtConId & " And [lngExp] = " & Me.cboExpType ' Verify that there is not already a relevant entry in tblExpenditure varExp = DLookup("lngExpId", "tblExpenditure", strSQL) Might work Take Care Carl

Cass, If I'm right, you want the look of the report to change based on a value in a recordset (query/table). Example. If Field1="Hello" you might want the header to be hidden but if Field1="Goodbye" you might want the header to be visible? Let me know if this is what you want. If I've got your...

I'm a little bit confused about what you are trying to do. Are you trying to set properties for the whole application, the whole sheet or just row 1... Application.Rows("1:1").Select If you're trying to format a range in the current sheet, I would use... With xlSheet...

Mmmm Hi mate, I think it might be the layout of your If statement. You haven't started an If block ... If Me.ABSENCE_REASON.Value = "H" Then MsgBox "holiday has been selected" ...but you've still used an End If. This should give you a nice error. Here's how I'd do this. Private Sub...

Exporting to Excel Hayley, In my previous job (Management Information - I'm a DBA now), I used to do this sort of thing everyday. The key to making well presented excel spreadsheets from your Access table data is embedding Excel VBA in your Access Functions/Subs. To do this you must set a...

Could you just drop (or delete) the old table and make a new one with the new data? It sounds like the 'live' data is stored in another database. Is it an Access database? You might be able to copy the new table across and replace this historic one. Let's know a few more details. Where is the...

I've got a motorola V3. I make no excuses. It came free with my contract. I have to say, I'm not overly impressed with it but it will do. Plus points. The screen is very good in both size and quality. The battery life is good and the phone charges very quickly. It's very, very thin. Minus...

Hi there. I think you have to put a '!' at the end of the sheet name eg Range = "DrawingSheet!" in your Docmd.TransferSpreadsheet statement Hope this works for you.

Hello again, The code looks for all excel files in the chosen folder and it doesn't need to know how many excel files there are (.LookIn = myFolder .FileName = "*.xls"). If you need to be selective eg after you have imported all of the existing spreadsheets you might want to bring new ones in...

Hello there. I would probably do something like this... Start the Import... Wizard (Right Click on the database window and select Import...). Navigate to where your file lives (Remember to change the the 'Files of Type' to Text Files) Select your file and click on import. Go through tke...

Hello there. I am assuming a couple of things here. That you have many work books and each 1 has only 1 worksheet and you are confident that only the right sort of spreadsheets are in the folder. The first thing you need to do is figure out how many excel spreadsheets are in the folder. Then...

Hello again The_Doc_Man. Thanks for persuing this. The app uses the tabledef collection to determine what tables exist in the database. The tables themselves aren't opened until a retrieval is performed. As far as I can tell, the problem is a database level. The BE databases are MS Access. I...

Thanks The_Doc_Man. Looks like it's going to be XP early next year. Right. The SMS package wasn't clean because a package had been built on it, a very similar package, to update Mdacs? Then a second package was built on the same machine, without the machine being cleansed. The Tech Wizards say...

Hey The_Doc_Man, thanks for taking the time. My Sys Admin are currently running around their room in wizards outfits, waving their mistletoe staffs, chanting incantations at a server and therefore unavailable for comment. You do raise some interesting points. This wasn't a clean SMS delivery...

Thanks Yellow. Just tried compacting. No change. Then I tried creating a new database and importing all the tables. Still no joy. Then I tried converting to different versions of Access again no joy. I'm still stumped. I am now thinking it's either the combination of the client/server or the...

Hello all. This is a cry for help. Here's the scene. Our Agency has a very simple retrieval tool written in Access 2000. The client is on the local PC and the back end is on a server. The back end consists of 8 databases (one for each year) and the contain records of all transactions (around 3...

I open pdfs in two different ways... Application.FollowHyperlink FileName (Filename is specified path) or Call Shell("C:\Program Files\Adobe\Acrobat 6.0\Reader\AcroRd32.exe " & FileName, vbMaximizedFocus) As you can see the second needs the path to Acrobat reader which may not be in the...