Recent content by StefanOl

Dear Sir > rainman89 That might be a better idea, to do it on exit, thanks a lot for the tip > vbaInet The reason is that when I work with the ms access client the ms access client file itself (the one on the desktop) grows from 9 MB to 1.9 GB. I suspect it is some "recover" mode in ms...

Dear Sir or Madame Is the a System call in VBA that do the same thing or simillar as the "Compact and Repair" that you can do manually in the Access menue system ? I would like to have the ms access client to do this every time it starts. Regards Stefan

Dear Sir or Madame I used Microsoft SQL Server Management Studio (and SQL express) to create a database and then I "imported" it into MS access via linked tables. This works very well, i can write and read data, I can change the tables and column names in the SQL Management Studio and...

Dear all Well, (lower case) k have always meant 1000, it is a SI prefix, meaning 1000 http://en.wikipedia.org/wiki/SI_prefix Therefore 1 kb/B have been, are and will always be 1000 bytes If the industry do not want to mess it up even more then it should stick to SI prefix, that is, 1...

Dear Sir or Madame We have an application called focal point that use http/soap/xml interface Is there a wonderful magic way to have ms access 2007 to connect a xml API based database ? ConnectToThisXMLServer(Http, User, Password) And viola just everything starts to work, that is ms...

Dear Sir Thanks a lot, DoEvents works briliant The code ended up like this Private Sub SetStatus(Txt As String) StatusList.AddItem Txt StatusList.Selected(StatusList.ListCount - 1) = False DoEvents StatusList.Selected(StatusList.ListCount - 1) = False End Sub The StatusList.Selected...

Dear Sir or Madame I have a listbox on my form which is used to show "progress" and status messages. However the listbox is not showing the updates while the VBA code is running but only afterwards (when XP got back the control). In C/C++ I made a quick Sleep(10) to make it happend but how...

Dear Sir Thanks a lot for your tip, however I got it working by avoiding adressing the combobox in a XXXX_BeforeUpdate function until everything have settled by using a boolean flag, why it is so I do not know, but it works now Regards

Dear Sir or Madame I have an form with a number of comboxes and I want to store a reference to these comboxes so I can manipulate them in various functions. I have an array declared like this Dim ProjectList(3, 11) As ComboBox However ms asscess generates an error "Run-time error...

Dear Madame I am using the menues "External Data" and then "PDF or XPS" button in ms access. I made a workaround by setting "can shrink" and "Can grow" to "No" in the sub report and now it does nto cut the text in the pdf document. Feels a little strange but I can live with it. Regards

Dear Sir or Madame I am getting strange formatting errors and erranous formatting when I create pdf docuemnt from my report. I have tried to change the box size in the report and font but it seems not to help. The field in the database is of the type memo, I have reentered the text into...

Hi Yes, it works very well Thanks a lot Adam Regards

Hi I have these lines of code Set rstRs = dbsNorthwind.OpenRecordset(strSQL, dbOpenDynaset, dbSeeChanges) While rstRs.EOF = False If rstRs![assigned apm] Is Nothing Then APMName = "" Else APMName = rstRs![assigned apm] End If...

Thanks a lot for the tips, both namliam and LPurvis, it works now Thanks for the welcome namliam Regards

Dear Sir or Madame I have a query and a form with some Basic cde behind it. I want from the basic "execute" a query and travestate the result and have been experimenting with QueryDef but have not got it working. My first question is, is it the right way to use QueryDef to do this type of...