Browse by Tags

In Access 2007 VBA, how would I use ranges/choices in conditions such as If...Then?

If intVar could possible be an integer 1,2,3...10, how could I check for that in an If...Then structure. IOW, is it possible to do something like this: If intVar = [1,2,3] Then blah Or If intVar = [3-5] Then blah With strings? If strVar = ["X","Y","Z"] Then blah Or If strVar...

Posted to Access Coding/Macros (Forum) by microsoft on 05-03-2010
Why does MS Access 2007 ask for a password for any database I try to open?

Experts! I have a issue with my Access install.... I'm not sure where to start, it may just be that its Friday at 4:15 :)...... but Access was working fine up until today. After that, every time he tries to open a database, its asking for a user ID and password. We ran the repair on Office, and we...

Posted to Access (Forum) by microsoft on 03-12-2010
hide fields unless paticular option is selected in combo box

What i have is a form filled out by a user and when they select a paticular option in a drop down box i want to have it display additional fields hidden otherwise. Almost like an if then kind of thing i just have no clue how to write that in VB.

Posted to Access Forms (Forum) by microsoft on 02-21-2010
Access - Format datatype in Table to have IP Address format

In Access, how does one create a data type in the format property so when entering data, the user is forced to comply with the format ###.###.###.###? What would be the format? I'm assuming its a formula I have to give.

Posted to Access (Forum) by microsoft on 02-15-2010
Access search between different forms

I am working with an access table. I am trying to get the "cleaning" column to automatically populate by adding the "Laste cleaned" and "Frequency". How can I execute this?

Posted to Access (Forum) by microsoft on 02-14-2010
Microsoft Office Spreadsheet 9.0 control in Access - problem

I have loaded this control twice and also reloaded Access entirely. I still encounter the same error message. I activate a NEW MDB program and create a NEW FORM. From the toolbox' long list of available controls I choose the MS Office Spreadsheet 9.0 control and apply it to the new form. I run the...

Posted to Access (Forum) by microsoft on 12-27-2009
Why do I get the following message when I click on Switchboard Manger; >Method AccessUser DataDir of object Wizhook failed<?

I've created a database using Access 2007. Every time I've wanted to make modifications to the default switchboard I've just clicked on Switchboard Manger-- the wizard is activated and I've have had no problems making the modifications. Yesterday I clicked on Switchboard Manager to make...

Posted to Access (Forum) by microsoft on 12-01-2009
Unhide Access 2007 database

How do you hide / unhide an Access 2007 database? Haven't been able to find any info. about this in the MS "documentation".

Posted to Access (Forum) by microsoft on 10-05-2009
How to scroll through data using the mouse wheel in Access 2007

Hello, We recently upgraded to Office 2007 from 2003. Evidently our employees were previosuly able to use the mouse scroll wheel to scroll through data in a particular Access database they use. They now say they are unable to do so. Is there a way to allow the use of the mouse scroll wheel to scroll...

Posted to Access (Forum) by microsoft on 08-21-2009
Running Append/Delete Query

I have a database built in Access 2007 with two tables. This database is split. The back-end holds two tables. One is (tblEmployees) employee information name, age physicals and employee address. The second table (tblEmergencyContacts) is Emergency Contact Information. Many employees have multiply...

Posted to Access (Forum) by microsoft on 08-15-2009

Page 1 of 4 (36 items) 1 2 3 4 Next >