Interacting with Website
Is it possible in VBA to simulate the click of a button on a webpage? We have a main supplier who we have a log-in and password for online. I can create the internet explorer window in access and can create the string for the relevant search for a product but the site keeps asking for me to log-in, which only requi... 9 Feb 2010 23:00
Access 2010. New, Improved, and Gone
I was looking for something on Access 2010 and came across this link. http://technet.microsoft.com/en-us/library/cc179181%28office.14%29.aspx. It lists some of the changes coming to 2010. Gone: These might not affect many. But for the few...best be prepared. 1) MSCal. There's a new calendar control in 201... 12 Feb 2010 17:56
Why couldn't exit the MS ACCESS program
Couldn't exit out the ms access program after process one of the procedure call and need to kill it by using the Task Manger. Without calling that procedure it doesn't have that problem. The procedure call is look something like this Sub AutoFillNewRecord(F As Form) Dim RS As Object, C As Control Dim F... 9 Feb 2010 08:20
Need some SQL help.....
Hi Everyone, I am trying to run a form of comparative analysis between two sets of tables to see (quickly) if there is a reason to inspect them more closely. I am basing this on a query rowcount. In one database the fields I need to tally up are in the one table making this very easy with the use of a correlated... 11 Feb 2010 00:39
error on new record...
Hello, I am using Access 2007 with SQL Server 2005 data - all the latest updates. I am creating a disconnected ado recordset to bind to the form. I've always used unbound forms, but this contract requires bound forms. The table has 4 fields, 3 are required and have Allow Null set to false. The form I'... 7 Feb 2010 15:20
Keyboard Language - Why my input language automatic changed from English to other languages.
Someone had created an application on access 2003, there were one main menu and within the main menu user need to click on different datat entry form. One of the form when the user click on it, the input language automatic changed to other language intead of English which this doesn't happen on the others form. ... 7 Feb 2010 11:58
ACC2010; Live web applications
Now that ACC2010 has been around for a few months, there should be quite a number of public web apps (at least demo) generated from it. I am not talking about videos how to do it (I watched a few ones), but live web pages. Can we have here the URLs of some of them? txs ... 9 Feb 2010 19:40
How to change the caption of a field in a SubForm
Dear reader, I have a SubForm in a Report. Now I need to change the caption of a field in a SubForm. The question is now how to reach the filed in the SubForm. Events of the SubForm are not active by opening the Report (does not work) and referring to the field in the report with: Report!ReportNam... 6 Feb 2010 12:58
Value of Sum() or Count() for empty recordset
I have a continuous form, used as a subform of another, that has a currency field named ProfitTaken. In the footer I have a Text Box with ControlSource of =Sum([ProfitTaken]) This works fine when the Form has at least one record. However when there are no records I would like to display that value 0 (zero). Th... 5 Feb 2010 09:22
"Object name exists" error
Hey guys, It has been a couple of years since I have coded in MS Access and I have hit a snag early on that I can't quite remember what to do! I am running Access 2003 (file in 2000 format) and using DAO. I want to copy the tabledefs from one database (dbSource below) into my current database (db below). I am tr... 4 Feb 2010 12:16