Description:
MS Windows' relational database system, Access.
|
|
|
YTD Subquery is not including December why?
|
| |
I created a query with a subquery to sum the hours worked by period (i.e., month) and then YTD hours next to the month hours. However, it's not entirely working for me and it's driving me crazy. The query gives me by Dept and period the ytd hours in the field labeled "YTDHours" One final glitch remains:... more »
|
|
Select form based on unbound text box
|
| |
Please Help I have created a form that has only an Unbound Text Box and a Control Button In addition I have created many forms each with a different purpose I wish to create an interface for the user to open the selected form by entering the form name in the unbound text box and pressing the Control Button... more »
|
|
Global vars in a A2010 web form?
|
| |
I'm not near the computer that has A2010 but I was wondering...how does on set a global var for a form? In VBA, at the form's top level we migh have Option Explicit Option Database Dim lngNum As Long and lngNum would be available throughout. Is there a similar method for a web form?
|
|
strange effect on certain textbox's
|
| |
Hi, When i add values on a for i have been using the following syntax: = Me("txtbox-6-1") + Me("txtbox-19-1") the result is inconsistant. for example: if Me("txtbox-6-1") = 1000 and Me("txtbox-19-1") = 100 the value should be 1100 but in some fields i am getting 1000100 as if i were asking for:... more »
|
|
Access 2010 vids
|
| |
There aren't any books out yet on A2010 so learning seems to be by trial by error, at least in my case. There are some vids on YouTube that provide some valuble information. Here's my initial list. I assume there will be more vids coming out (hint hint Albert) that will help us out learn this new upgrade.... more »
|
|
New features of Access 2010
|
| |
I have been looking for information summarizing/detailing what is new in Access 2010. I recently found this. Fairly high level but may be useful to someone. [link]
|
|
Question about CurrentDb usage
|
| |
Using A2003. I'm just about to start major modifications on a mdb created in 2003. There is a lot of this type of code structure (below) throughout the mdb wherever a recordset or querydef is referenced. "dbs" is dim-ed globally as Database in a module. My question is: does dbs need to be set and closed after every usage of... more »
|
|
A2010 macro builder and a message box
|
| |
Thanks to Albert I was able to look at a help file. It took some doing because the hsx viewer told me MS Help 2.x runtime wasn't available. So I had do dl something from Microsoft, in this case VB.Net, to get the required runtime files. I didn't explore them much so I may be asking a question that is... more »
|
|
Store User ID and Password in Linked Sharepoint Table?
|
| |
I need to connect to a SharePoint List in another domain from Microsoft Access 2007. When I click on the table it prompts me to put in my user ID and password. I always check the "Remember Password" box, but it never does. How can I store my user ID and password in this linked table? Thanks in advance,... more »
|
|
Help in A2010
|
| |
I created an app from a template. It appears VBA isn't desired like a macro. In form Main of the Issues project the macro had something like If IsNull(CurrentWebUser(0)) then Stop Macro Endif I'd highlight CurrentWebUser and hit F1 and get nothing. Searching for CurrentWebUser got nothing. How does one get help topics on some new topics in A2010?... more »
|
|
|