Search results

Hi, I'm not sure you can open a workspace from mapbasic, (although you might it's been a long time since I used it) but as a .WOR File is just a collection of Map basic commands you could just call them all from your VBA routine. If you open your .WOR in notepad you can see the commands and...

Nothing as of yet its just a function in a module so far, so im just running the code from the compiler.

I have Now been Able to export Ms Access Table Create The Points From the Eastings and Northings and add a background Raster Map from Access. I'll Post the Code and I have added some Info/Breakdown Points that should help you all get started at Automated Mapping! Private Function...

Right Guys here’s what i've got so far. (I’m self taught so my methods may be messy) I didn't use the shell way, I registered the MapInfo Reference OLE automation Object. You can then use all of the functions contained in there. This code will open any Data Table from access and load it...

I'm also trying to do something like this..I can go the opposite way and import from access into mapInfo then create the points. I was going to start using mapBasic (the language that comes with mapInfo) to automate the process so you would just need a way to open mapInfo from Access. Any...

Cheers for all the help i think im goning to stick with the decimal option.

Cheers for the help.... Ive just realised though that you can just set the number field to decimal and then set the size of the field.. durrrrrgh! lol

Hello, I have a problem with a database that is full of data. It is used to enter a reference number and then the DB generates an Autonumber as a unique ID and primary key. the problem is the people that issue the original reference number have changed from a 9 digit number to a 10 digit...

Cheers chergh Registered User That worked a treat

Here is the full code Private Sub Command44_Click() Dim objExcel As Object DoCmd.SetWarnings False Set objExcel = CreateObject("Excel.Application") objExcel.Workbooks.Open FileName:="N:\Highways\AIU\General Data\Safety Camera Tables\REPORTS\SPEED MONITORING\2008 Data\C2DataDump.xls" _ ...

I am manipulating an excel spreadsheet from my access database. I am having problems stopping excel prompt when I delete data in the spread sheet. I have setwarnings to false in access but that doesn't seem to effect Excel and I have also used application.displayalerts = False But it...

It has worked but it is a bit messy I have had to add a Timer loop in there otherwise it sends the keys too fast: Private Sub Form_Current() Dim T1 As Variant Dim T2 As Variant WebBrowser6.navigate...

I was thinking these lines my self but after you have logged in once it doesn't come up again which would create and error. Although it wouldn't take much to handle that error. But is there no part of the function itself that takes the username/Password. You would think it would be something...

I found the If you just record yourself doing it with a macro in excel it will create the code for you then just drop it in Access

I have added a webBrowser control to one of my forms to allow people to get extra information from a sister web page. Everytime it loads the standard domain logins popup. Is there a way to pass the username and password to this popup through VBA? Cheers!

Cheers matey Great help!

Can someone explain how to change printers when i Print a report. I have been playing with Set Application.Printer = Application.Printers("Myprinters") But i'm not sure if i am calling this correct can you just add a DoCmd.Print after ? Cheers

Not had chance to look but thaks for the help i will let you know if it works:D

Heres the main code. Private Sub OLEPSok1_Click() Dim strSQLhistory As String Dim YearFilter As Variant YearFilter = DMin("Year", "qryYear%change") - 1 strSQLhistory = "Delete * FROM tblCasualtyHistory WHERE PeriodStartDate >31/12/" & [YearFilter] & " And Comment is null;"...

I have actually tried all those. In fact in my code i dont use the date, a variable is lookup from somewhere else i just put that in so it makes more sense on here